Skip to main content
The EVM normalizer suite covers the core data types produced by Ethereum-compatible chains. Each normalizer maps a single entity type to a single output table with a fixed column schema.

​
BlocksNormalizer

Entity: blocks | Output table: blocks
ColumnTypeDescription
chain_nameSTRINGBlockchain name
heightUINT64Block number
block_hashSTRINGBlock hash (hex)
block_parent_hashSTRINGParent block hash (hex)
nonceUINT64Block nonce
transactions_rootSTRINGTransactions trie root (hex)
state_rootSTRINGState trie root (hex)
miner_addressSTRINGMiner/validator address (hex)
difficultySTRINGBlock difficulty (big integer)
total_difficultySTRINGCumulative difficulty (big integer)
sizeUINT64Block size in bytes
extra_dataSTRINGExtra data field (hex)
gas_limitUINT64Gas limit
gas_usedUINT64Gas used
signed_atTIMESTAMPBlock timestamp (ISO 8601)
transaction_countUINT32Number of transactions
base_fee_per_gasSTRINGEIP-1559 base fee (big integer)
withdrawals_rootSTRINGWithdrawals trie root (hex)
logs_bloomSTRINGBloom filter (hex)
blob_gas_usedUINT64EIP-4844 blob gas used
excess_blob_gasUINT64EIP-4844 excess blob gas
parent_beacon_block_rootSTRINGBeacon chain parent root (hex)

​
TracesNormalizer

Entity: traces | Output table: traces
ColumnTypeDescription
block_heightUINT64Block number
block_hashSTRINGBlock hash (hex)
block_signed_atTIMESTAMPBlock timestamp
chain_nameSTRINGBlockchain name
tx_hashSTRINGTransaction hash (hex)
tx_offsetUINT32Transaction index in block
from_addressSTRINGCaller address (hex)
to_addressSTRINGCallee address (hex)
valueSTRINGETH value transferred (big integer)
method_idSTRING4-byte function selector (hex)
input_dataSTRINGCall input data (hex)
output_dataSTRINGCall output data (hex)
trace_typeSTRINGTrace type (call, create, suicide)
call_typeSTRINGCall type (call, delegatecall, staticcall)
gas_limitUINT64Gas limit for this call
gas_usedUINT64Gas used by this call
subtracesUINT32Number of child traces
trace_addressJSONPosition in trace tree (e.g., [0,1,2])
errorSTRINGError message if failed
statusSTRINGExecution status
trace_idSTRINGUnique trace identifier

​
TransactionsNormalizer

Entity: transactions | Output table: transactions
ColumnTypeDescription
block_heightUINT64Block number
block_hashSTRINGBlock hash (hex)
block_signed_atTIMESTAMPBlock timestamp
chain_nameSTRINGBlockchain name
tx_hashSTRINGTransaction hash (hex)
nonceUINT64Sender’s nonce
tx_offsetUINT32Transaction index in block
from_addressSTRINGSender address (hex)
to_addressSTRINGRecipient address (hex)
valueSTRINGETH value (big integer)
gas_limitUINT64Gas limit
gas_priceSTRINGGas price (big integer)
input_dataSTRINGTransaction input data (hex)
max_fee_per_gasSTRINGEIP-1559 max fee (big integer)
max_priority_fee_per_gasSTRINGEIP-1559 max priority fee (big integer)
receipt_statusSTRINGTransaction receipt status
typeSTRINGTransaction type
blob_versioned_hashesJSONEIP-4844 blob hashes (JSON array)
access_listJSONEIP-2930 access list (JSON array)

​
LogsNormalizer

Entity: logs (alias: log) | Output table: logs
ColumnTypeDescription
block_heightUINT64Block number
block_signed_atTIMESTAMPBlock timestamp
block_hashSTRINGBlock hash (hex)
block_parent_hashSTRINGParent block hash (hex)
chain_nameSTRINGBlockchain name
miner_addressSTRINGMiner address (hex)
gas_usedUINT64Block gas used
gas_limitUINT64Block gas limit
tx_hashSTRINGTransaction hash (hex)
tx_offsetUINT32Transaction index
log_offsetUINT32Log index within transaction
contract_addressSTRINGEmitting contract (hex)
raw_log_dataSTRINGLog data field (hex)
raw_log_topicsJSONLog topics array (JSON of hex strings)

​
ReceiptsNormalizer

Entity: receipts | Output table: receipts
ColumnTypeDescription
block_heightUINT64Block number
block_hashSTRINGBlock hash (hex)
block_signed_atTIMESTAMPBlock timestamp
chain_nameSTRINGBlockchain name
receipt_root_hashSTRINGReceipts trie root (hex)
tx_hashSTRINGTransaction hash (hex)
tx_offsetUINT32Transaction index
receipt_statusUINT32Receipt status (0=fail, 1=success)
output_dataSTRINGReturn data (hex)
receipt_gas_usedUINT64Gas used by transaction
receipt_cumulative_gas_usedUINT64Cumulative gas used in block
receipt_effective_gas_priceSTRINGEffective gas price (big integer)
receipt_blob_gas_usedUINT64EIP-4844 blob gas used
receipt_blob_gas_priceSTRINGEIP-4844 blob gas price
receipt_state_rootSTRINGPost-tx state root (hex)
receipt_contract_addressSTRINGCreated contract address (hex)

​
TransfersNormalizer

Entity: transfers (alias: transfer) | Output table: transfers
ColumnTypeDescription
block_heightUINT64Block number
block_signed_atTIMESTAMPBlock timestamp
chain_nameSTRINGBlockchain name
tx_hashSTRINGTransaction hash (hex)
tx_offsetUINT32Transaction index
log_offsetUINT32Log index
contract_addressSTRINGToken contract address (hex)
from_addressSTRINGSender address (hex)
to_addressSTRINGRecipient address (hex)
token_idSTRINGNFT token ID (big integer)
amountSTRINGTransfer amount (big integer)

​
SwapsNormalizer

Entity: swaps | Output table: swaps
ColumnTypeDescription
chain_nameSTRINGBlockchain name
block_signed_atTIMESTAMPBlock timestamp (ISO 8601)
block_heightUINT64Block number
block_hashSTRINGBlock hash (hex)
tx_hashSTRINGTransaction hash (hex)
log_offsetUINT32Log index within transaction
tx_offsetUINT32Transaction index within block
pair_addressSTRINGDEX pair contract address (hex)
topic0STRINGEvent signature hash (hex)
topic1STRINGIndexed parameter 1 (hex)
topic2STRINGIndexed parameter 2 (hex)
topic3STRINGIndexed parameter 3 (hex)
data_rawSTRINGComplete raw log data (hex)
protocolSTRINGProtocol name (e.g., “uniswap_v2”)
removedBOOLEANRemoved flag (chain reorganization)
token0STRINGToken0 address (hex)
token1STRINGToken1 address (hex)
reserve0STRINGReserve0 from Sync event (Uniswap V2)
reserve1STRINGReserve1 from Sync event (Uniswap V2)