ETH Data Model
Current version : MCDW v1.2 (Mar 2024)
Migration to MCDW v1.2 data model 13-Mar-2024
To get access to the data see Accessing Token Flow data guides
Blocks
| Column | Data Type | Layer | Nullable | Definition |
|---|---|---|---|---|
base_fee_per_gas | bigint | RAW | YES | Minimum multiplier for used gas in order to include a transaction in a block. NULL for blocks before London hard fork. |
block_hash | char(66) | RAW | NO | Hash of the block content (KECCAK-256). Unique for every block. |
block_number | char(66) | RAW | NO | Number of the block. Numbering is incremental, starting at 0 (Genesis) with new blocks added at the end of the chain. |
block_timestamp | timestamp | RAW | NO | Timestamp of the block. Unique for every block and inherited by calls, events, transactions and diffs happening in the same block. |
difficulty | bigint | RAW | YES | Amount of effort required to mine a new block, set by the network - used in PoW consensus, not used for PoS consensus (after the Shanghai hard fork). |
excess_blob_gas | integer | RAW | NO | Running total of excess data gas consumed on chain since EIP-4844 was activated. If the total amount of data gas is below the target, excess_blob_gas is capped at zero. |
gas_limit | bigint | RAW | NO | Maximum amount of gas that can be included in the block, set by the network, expressed in gas units. |
gas_used | bigint | RAW | NO | Amount of gas actually consumed by the block execution, expressed in gas units. |
miner | char(42) | RAW | NO | Address of the miner (for the PoW consensus mechanism) or validator (for the PoS consensus). The receiver of gas and other fees related to creation of the block. |
processed | boolean | TECH | NO | Technical field. Defines processing status of a block by the decoding ETL process. |
size | integer | RAW | NO | Size of the block in bytes. |
tx_count | bigint | RAW | NO | Count of transactions included in the block, successful or reverted. For empty blocks, tx_count = 0 |
uncles | JSON | RAW | NO | Array of uncles' hashes. Empty array if block has no uncles. |
withdrawals | JSON | RAW | YES | Array of block header Ether withdrawals. For every withdrawal : * address - address of the withdrawal receiver; * amount - hexadecimal representation of the withdrawal amount (in wei) * index - withdrawal index * validator_index; |
Calls
| Column | Data Type | Layer | Nullable | Definition |
|---|---|---|---|---|
abi_inferred | boolean | TECH | YES | Flags whether the function semantics used for decoding was taken from the called contract's ABI (False) or it was inferred from other contracts (True). |
arguments | JSON | DECODED | YES | List of function arguments as key:value pairs as decoded by Token Flow processes (ABI or inferred from similar functions). Contains call_data if decoding was unsuccessful. |
block_number | char(66) | RAW | NO | Number of the block. Numbering is incremental, starting at 0 (Genesis) with new blocks added at the end of the chain. |
block_timestamp | timestamp | RAW | NO | Timestamp of the block. Unique for every block and inherited by calls, events, transactions and diffs happening in the same block. |
call_depth | mediumint | TECH | NO | Depth of the call in the transaction execution tree, incremental, starting at 0 for top level calls (call_path='0_2_1' depth= 3 means three level down in the execution tree). |
call_id | text | TECH | NO | Technical field. Identifier of the call, constructed by concatenating block id, transaction index and call path. |
call_path | text | TECH | NO | Position of the call in the transaction execution tree: * empty string for top level calls (call_depth = 0) * concatenation call_path of the parent call and number of the sub call, starting at 0 (call_path='0_2_1' means second subcall of third subcall of first subcall in a transaction) |
call_type | text | RAW | NO | Possible call types.Possible call types. Can take one of the following values: * CALL - standard function call * CALLCODE - allows a contract to invoke a function from another contract while maintaining the context of the calling contract. Replaced by DELEGATECALL due to security concerns. * DELEGATECALL - executes the code of the called contract in the context of calling contract operating on its storage. * STATICCALL - function call that is not allowed to change the storage. * CREATE - deployment of a new contract (CALL_DATA contains the contract code and constructor arguments). * SELFDESTRUCT - contract destruction call. |
call_value | decimal(38,0) | RAW | NO | Ether amount transferred, in WEI. Division by 10^18 to obtain Ether amount. 0 if no Ether transfer happened. |
created_address | char(42) | RAW | YES | Created address in the case of 'CREATE' call. Empty for any other call type. |
exception_error | text | RAW | YES | Error description for failed calls, as generated by the Ethereum Virtual Machine. Empty for successful calls. |
executed | boolean | RAW | NO | Flags successfully executed (true) or failed (false) calls. |
from_address | char(42) | RAW | NO | Address of the call sender (calling address): * externally owned address for top level calls; * smart contract address for any other call. |
from_name | text | DECODED | YES | Name of the call sender (calling address) as decoded by Token Flow processes (ABI or inferred from similar functions). Contains calling address if not found. |
function_name | text | DECODED | YES | Name of the function, decoded by Token Flow processes (ABI or inferred from similar functions). Contains function_signature if decoding was unsuccessful. |
function_signature | char(10) | RAW | YES | Binary signature of the called function. 0x in case of pure Ether transfers. |
gas_limit | bigint | RAW | NO | Gas staked by the function call before its execution. Maximum amount that can be used before the function call is reverted, expressed in gas units. |
gas_refund | bigint | RAW | NO | Gas amount returned after the function call execution, expressed in gas units. |
gas_used | bigint | RAW | NO | Gas used by the execution of a specific function within a smart contract, expressed in gas units. |
order_index | mediumint | TECH | NO | Technical field. Sequence of actions (call, events, diffs) that happened in a block. |
outputs | JSON | DECODED | YES | List of function outputs as key:value pairs, as decoded by Token Flow processes (ABI or inferred from similar functions). Key is the output name and value is the decoded value. Contains a single output_data argument if decoding was unsuccessful. |
decoded | boolean | TECH | NO | Technical field. Defines processing status of a block by the decoding ETL process. |
revert_reason | text | RAW | YES | Error description for reverted calls, as provided by the smart contract. Empty for successful calls. |
reverted | boolean | RAW | NO | Flags persistent (false) or reverted (true) calls. Reverted diffs can originate from technical failures (code errors), gas limits (more gas needed than was staked) or contract logic. |
to_address | char(42) | RAW | NO | Address of the call receiver (called address): * EOA or smart contract address for pure Ether transfer; * Smart contract address for function calls; * Address used as code library when call_type = ‘DELECATECALL’ |
to_name | text | DECODED | YES | Name of the call receiver (called address) as decoded by Token Flow processes (ABI or inferred from similar functions). Contains called address if decoding was unsuccessful. |
tx_hash | char(66) | RAW | NO | Hash of the transaction (KECCAK-256). Unique for every transaction. |
Events
| Column | Data Type | Layer | Nullable | Definition |
|---|---|---|---|---|
abi_inferred | boolean | TECH | YES | Flags whether the function semantics used for decoding was taken from the called contract's ABI (False) or it was inferred from other contracts (True). |
block_number | char(66) | RAW | NO | Number of the block. Numbering is incremental, starting at 0 (Genesis) with new blocks added at the end of the chain. |
block_timestamp | timestamp | RAW | NO | Timestamp of the block. Unique for every block and inherited by calls, events, transactions and diffs happening in the same block. |
call_id | text | TECH | NO | Technical field. Identifier of the call, constructed by concatenating block id, transaction index and call path. |
contract_address | char(42) | RAW | NO | Smart contract address that emitted the event. For DELEGATECALLS, events are emitted by calling contracts and the ABI is defined by the called contract. |
contract_name | text | DECODED | YES | Name of the smart contract that generated the event, as decoded by Token Flow processes (ABI or inferred). Contains contract address if not found. |
event_id | text | TECH | NO | Technical field. Identifier of the event, constructed by concatenating block_id and order_index, separated by underscores. |
event_name | text | DECODED | YES | Name of the event, as decoded by Token Flow processes (ABI or inferred from similar functions). Contains event_signature if not found. |
event_signature | char(66) | RAW | NO | Raw hexadecimal indexed content of the event (topic 0). |
implementation | char(42) | RAW | NO | Smart contract address that provides the event semantics (ABI) - called contract for DELEGATECALLS or calling contract for the rest of the call types. |
log_index | mediumint | RAW | NO | Index of the successful event within a block, stating at 0. Reverted events are not stored on-chain and do not have log_index (empty) |
order_index | mediumint | TECH | NO | Technical field. Sequence of actions (call, events, diffs) that happened in a block. |
parameters | JSON | DECODED | YES | List of event parameters as key:value pairs, as decoded by Token Flow processes (ABI or inferred from similar functions). Key is the output name and value is the decoded value. Contains 'topic_parameter_1-3' and 'data_parameter_0-n' argument if decoding was unsuccessful. |
decoded | boolean | TECH | NO | Technical field. Defines processing status of a block by the decoding ETL process. |
reverted | boolean | RAW | NO | Flags persistent (false) or reverted (true) calls. Reverted diffs can originate from technical failures (code errors), gas limits (more gas needed than was staked) or contract logic. |
tx_hash | char(66) | RAW | NO | Hash of the transaction (KECCAK-256). Unique for every transaction. |
Transactions
| Column | Data Type | Layer | Nullable | Definition |
|---|---|---|---|---|
block_number | char(66) | RAW | NO | Number of the block. Numbering is incremental, starting at 0 (Genesis) with new blocks added at the end of the chain. |
block_timestamp | timestamp | RAW | NO | Timestamp of the block. Unique for every block and inherited by calls, events, transactions and diffs happening in the same block. |
exception_error | text | RAW | YES | Error description for failed transactions, as generated by the Ethereum Virtual Machine. Empty for successful transactions. |
from_address | char(42) | RAW | NO | Address of the transaction sender (calling address). It is always an Externally Owned Address. |
from_name | text | DECODED | YES | Name of the transaction sender (calling address) as decoded by Token Flow processes (ABI or inferred from similar functions). Contains calling address if not found. |
function_signature | char(10) | RAW | YES | Binary signature of the called function. 0x in case of pure Ether transfers. |
gas_limit | bigint | RAW | NO | Gas staked by the transaction before its execution. Maximum amount that can be used before the transaction is reverted, expressed in gas units. |
gas_price | bigint | RAW | NO | Ether amount the transaction sender is willing to pay per unit of gas as a fee to the miner. |
gas_refund | bigint | RAW | NO | Gas amount returned after the transaction execution, expressed in gas units. |
gas_used | bigint | RAW | NO | Gas used by the execution of a transaction, expressed in gas units. |
max_fee_per_blob_gas | bigint | RAW | YES | Gas "tip" included in the transaction to additionally incentivise miners. |
max_fee_per_gas | bigint | RAW | YES | Maximum fee the transaction sender is willing to pay for the gas (base fee + priority fee). |
max_priority_fee_per_gas | bigint | RAW | YES | Maximum amount of gas paid for the blobs of data stored on-chain. |
nonce | bigint | RAW | NO | Sender counter of signed transactions, used to avoid sending the same transaction twice. |
processed | boolean | TECH | NO | Technical field. Defines processing status of a block by the decoding ETL process. |
revert_reason | text | RAW | YES | Error description for reverted transactions, as provided by the smart contract. Empty for successful transactions. |
reverted | boolean | RAW | NO | Flags persistent (false) or reverted (true) calls. Reverted diffs can originate from technical failures (code errors), gas limits (more gas needed than was staked) or contract logic. |
to_address | char(42) | RAW | NO | Address of the transaction receiver (called address): * EOA or smart contract address for pure Ether transfer; * Smart contract address for function calls; |
to_name | text | DECODED | YES | Name of the transaction receiver (called address) as decoded by Token Flow processes (ABI or inferred from similar functions). Contains called address if decoding was unsuccessful. |
tx_hash | char(66) | RAW | NO | Hash of the transaction (KECCAK-256). Unique for every transaction. |
tx_index | bigint | RAW | NO | Index of the transactions within a block, starting at 0. |
tx_type | integer | RAW | NO | Transaction type. Can take one of the following values: 0 - legacy transactions that use the transaction format existing before typed transactions were introduced 1 - transactions introduced in EIP-2930 (accessList parameter) 2 - transactions introduced in EIP-1559, London hardfork 3 - transactions introduced in EIP-4844, Dencun hardfork |
tx_value | decimal(38,0) | RAW | NO | Ether amount transferred, in WEI. Value must be divided by 10^18 to obtain Ether amount. 0 if no Ether transfer happened. |
blob_versioned_hashes | json | RAW | YES | List of versioned blob hashes linked to this transaction (EIP-4844) |
Transient_storage_diffs
| Column Name | Data Type | Layer | Nullable | Definition |
|---|---|---|---|---|
block_number | char(66) | RAW | NO | Number of the block. Numbering is incremental, starting at 0 (Genesis) with new blocks added at the end of the chain. |
block_timestamp | timestamp | RAW | NO | Timestamp of the block. Unique for every block and inherited by calls, events, transactions and diffs happening in the same block. |
call_id | text | TECH | NO | Technical field. Identifier of the call, constructed by concatenating block id, transaction index and call path. |
contract | char(42) | RAW | NO | Smart contract address that the change applies to. |
contract_name | text | DECODED | YES | Name of the smart contract that the change applies to, as decoded by Token Flow processes (ABI or inferred). Contains contract address if not found. |
curr_value | text | DECODED | YES | Decoded storage value after the change. |
decoded | boolean | TECH | NO | Technical field. Flags the success (true) or failure (false) of the decoding process. |
hashmap_keys | JSON | RAW | NO | Array of keys used for addressing the hashmap. |
implementation | char(42) | RAW | NO | Implementation address of the contract in case of proxy or implementation pattern. |
location | text | DECODED | YES | Pre-hashed memory location, as decoded by Token Flow processes (ABI or inferred). Includes the variable name and keys used for mappings. |
order_index | mediumint | TECH | NO | Technical field. Sequence of actions (call, events, diffs) that happened in a block. |
prev_value | text | DECODED | YES | Decoded storage value before the change. |
reverted | boolean | RAW | NO | Flags persistent (false) or reverted (true) calls. Reverted diffs can originate from technical failures (code errors), gas limits (more gas needed than was staked) or contract logic. |
slot | text | RAW | YES | Memory slot number. Sequential position of the variable in the smart contract code. |
transient_storage_diff_id | text | TECH | NO | Technical field. Identifier of the storage_diff, constructed by concatenating block id, order index and sequential number in a single diff (starting from 0) |
structs | JSON | DECODED | NO | Names of structures defined in the smart contract code. |
tx_hash | char(66) | RAW | NO | Hash of the transaction (KECCAK-256). Unique for every transaction. |
variable | text | DECODED | YES | Name of the variable, as decoded by Token Flow processes (ABI or inferred). |
variable_type | text | DECODED | YES | Decoded variable type. Can take one of the following values: * SIMPLE - simple variable that uses one memory slot * MAPPING - hashmap with a single key * MULTI MAPPING - hashmap with multiple keys * OTHER - other variable types |
Storage_diffs
| Column Name | Data Type | Layer | Nullable | Definition |
|---|---|---|---|---|
block_number | char(66) | RAW | NO | Number of the block. Numbering is incremental, starting at 0 (Genesis) with new blocks added at the end of the chain. |
block_timestamp | timestamp | RAW | NO | Timestamp of the block. Unique for every block and inherited by calls, events, transactions and diffs happening in the same block. |
call_id | text | TECH | NO | Technical field. Identifier of the call, constructed by concatenating block id, transaction index and call path. |
contract | char(42) | RAW | NO | Smart contract address that the change applies to. |
contract_name | text | DECODED | YES | Name of the smart contract that the change applies to, as decoded by Token Flow processes (ABI or inferred). Contains contract address if not found. |
curr_value | text | DECODED | YES | Decoded storage value after the change. |
decoded | boolean | TECH | NO | Technical field. Flags the success (true) or failure (false) of the decoding process. |
hashmap_keys | JSON | RAW | NO | Array of keys used for addressing the hashmap. |
implementation | char(42) | RAW | NO | Implementation address of the contract in case of proxy or implementation pattern. |
location | text | DECODED | YES | Pre-hashed memory location, as decoded by Token Flow processes (ABI or inferred). Includes the variable name and keys used for mappings. |
order_index | mediumint | TECH | NO | Technical field. Sequence of actions (call, events, diffs) that happened in a block. |
prev_value | text | DECODED | YES | Decoded storage value before the change. |
reverted | boolean | RAW | NO | Flags persistent (false) or reverted (true) calls. Reverted diffs can originate from technical failures (code errors), gas limits (more gas needed than was staked) or contract logic. |
slot | text | RAW | YES | Memory slot number. Sequential position of the variable in the smart contract code. |
storage_diff_id | text | TECH | NO | Technical field. Identifier of the storage_diff, constructed by concatenating block id, order index and sequential number in a single diff (starting from 0) |
structs | JSON | DECODED | NO | Names of structures defined in the smart contract code. |
tx_hash | char(66) | RAW | NO | Hash of the transaction (KECCAK-256). Unique for every transaction. |
variable | text | DECODED | YES | Name of the variable, as decoded by Token Flow processes (ABI or inferred). |
variable_type | text | DECODED | YES | Decoded variable type. Can take one of the following values: * SIMPLE - simple variable that uses one memory slot * MAPPING - hashmap with a single key * MULTI MAPPING - hashmap with multiple keys * OTHER - other variable types |
State_diffs
| Column | Data Type | Layer | Nullable | Definition |
|---|---|---|---|---|
address | char(42) | RAW | NO | Blockchain address that the change applies to. |
block_number | char(66) | RAW | NO | Number of the block. Numbering is incremental, starting at 0 (Genesis) with new blocks added at the end of the chain. |
block_timestamp | timestamp | RAW | NO | Timestamp of the block. Unique for every block and inherited by calls, events, transactions and diffs happening in the same block. |
call_id | text | TECH | NO | Technical field. Identifier of the call, constructed by concatenating block id, transaction index and call path. Empty if the state diff originated in the block. |
curr_value | char(66) | RAW | NO | State field value after the change. |
order_index | mediumint | TECH | NO | Technical field. Sequence of actions (call, events, diffs) that happened in a block. |
prev_value | char(66) | RAW | NO | State field value before the change. |
reason | text | DECODED | NO | Reason for the state change. This field should be used in combination with state_field. |
reverted | boolean | RAW | NO | Flags persistent (false) or reverted (true) calls. Reverted diffs can originate from technical failures (code errors), gas limits (more gas needed than was staked) or contract logic. |
state_diff_id | text | TECH | NO | Technical field. Identifier of the state_diff, constructed by concatenating the block id and order index, separated by underscores. |
state_field | text | DECODED | NO | Name of the state field that is being changed. |
tx_hash | char(66) | RAW | NO | Hash of the transaction (KECCAK-256). Unique for every transaction. Empty if the state diff originated in the block. |
Transfers
| Column | Data Type | Layer | Nullable | Definition |
|---|---|---|---|---|
block_timestamp | timestamp | RAW | NO | Timestamp of the block. Unique for every block and inherited by calls, events, transactions and diffs happening in the same block. |
block_number | bigint | RAW | NO | Number of the block. Numbering is incremental, starting at 0 (Genesis) with new blocks added at the end of the chain. |
tx_hash | char(66) | RAW | NO | Hash of the transaction (KECCAK-256). Unique for every transaction. |
tx_sender | char(42) | RAW | NO | Address of the transaction sender (calling address). It is always an Externally Owned Address. |
tx_receiver | char(42) | RAW | NO | Address of the transaction receiver (called address): * EOA or smart contract address for pure Ether transfer; * Smart contract address for function calls; |
tx_function_name | text | DECODED | YES | Name of the function at the transaction top level, decoded by Token Flow processes (ABI or inferred from similar functions). Contains function_signature if decoding was unsuccessful. |
call_path | text | RAW | NO | Position of the call in the transaction execution tree: * empty for top level calls * concatenation call_path of the parent call and number of the sub call, starting at 0 (call_path='0_2_1' means second subcall of third subcall of first subcall in a transaction) |
token_address | chr(42) | RAW | NO | Address of the Ethereum contract associated with the token. |
token_symbol | text | DECODED | NO | Symbol or ticker symbol of the token, which is a short alphanumeric code representing the token. |
token_name | text | DECODED | NO | Full name or title of the token. It provides a more descriptive name for the token beyond its symbol. |
token_standard | text | DECODED | YES | Token standard or protocol that the token adheres to. Currently supported: ERC20, ERC721, ERC1155, ERC4626. NULL if token standard could not me recognized. |
token_decimals | int | DECODED | NO | Number of decimal places the token uses (scaling factor). |
function_name | text | DECODED | NO | Name of the function that the initiated the transfer, decoded by Token Flow processes (ABI or inferred from similar functions). Contains function_signature if decoding was unsuccessful. |
sender | char(42) | RAW | NO | Address of the transfer sender. |
receiver | char(42) | RAW | NO | Address of the transfer receiver. |
amount | decimal(38,0) | DECODED | NO | Token amount transferred. For Ether it is in WEI. |
dec_amount | double | DECODED | NO | Transferred amount scaled with token decimals. |
token_id | text | DECODED | NO | Identifier of the token for fungible tokens. |
gas_used | bigint | RAW | NO | Gas amount actually used by the transfer, expressed in gas units. |
order_index | bigint | TECH | NO | Technical field. Sequence of actions (call, events, diffs) that happened in a block and can be used for proper ordering of the transfers in the block. |
Tokens
| Column | Data Type | Layer | Nullable | Definition |
|---|---|---|---|---|
token_address | char(42) | RAW | NO | Address of the Ethereum contract associated with the token. |
token_standard | text | DECODED | NO | Token standard or protocol that the token adheres to. Currently supported: ERC20, ERC721, ERC1155, ERC4626. NULL if token standard could not me recognized. |
token_symbol | text | DECODED | YES | Symbol or ticker symbol of the token, which is a short alphanumeric code representing the token. |
token_name | text | DECODED | NO | Full name or title of the token. It provides a more descriptive name for the token beyond its symbol. |
token_decimals | int(11) | DECODED | NO | Number of decimal places the token uses (scaling factor). |
Last updated