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