Token Flow Insights: Ethereum Data Warehouse beta

Full detailed history of the Ethereum blockchain.

Description:

The database contains full detailed history of Ethereum at the RAW level.
This is a Beta Version provided under the Terms of Service linked below and cannot be used for any production-grade solutions.

The Ethereum Data Warehouse includes:

– blocks information – BLOCKS:
– BLOCK
– TIMESTAMP
– MINER
– GAS_LIMIT / GAS_USED
– TX_COUNT
– BASE_FEE_PER_GAS (for post EIP-1559 blocks)

– transactions with gas data and revert reasons – TRANSACTIONS:
– TIMESTAMP
– TX_HASH
– FROM_ADDRESS / TO_ADDRESS
– TX_VALUE
– CALL_DATA / RETURN_VALUE
– GAS_LIMIT / GAS_PRICE / GAS_USED / GAS_REFUND
– EXCEPTION_ERROR / REVERT_REASON
– MAX_FEE_PER_GAS / MAX_PRIORITY_FEE_PER_GAS (for post EIP-1559 blocks)

– internal calls (also reverted ones) – CALLS:
– TIMESTAMP
– TX_HASH
– CALL_ID
– CALL_TYPE
– FROM_ADDRESS / TO_ADDRESS
– CALL_VALUE
– CALL_DATA / RETURN_VALUE
– CALL_GAS / GAS_USED

– events with relation to calls (also reverted ones) – EVENTS:
– TIMESTAMP
– TX_HASH
– LOG_INDEX
– CALL_ID
– CONTRACT
– LOG_DATA
– TOPIC0 / TOPIC1 / TOPIC2 / TOPIC3

– all state changes, incl. balance, nonce, storageRoot, codeHash – STATE_DIFFS:
– TIMESTAMP
– TX_HASH
– CALL_ID
– ADDRESS
– STATE_FIELD / REASON
– PREV_VALUE / CURR_VALUE

– all storage changes with pre-hashed keys – STORAGE_DIFFS:
– TIMESTAMP
– TX_HASH
– CALL_ID
– CONTRACT
– LOCATION
– PREV_VALUE / CURR_VALUE

– all storage reads (facts of accessing a contract storage) – STORAGE_READS:
– TIMESTAMP
– TX_HASH
– CALL_ID
– CONTRACT
– LOCATION
– VALUE

The detailed data model with tables, columns and relations is available via the Documentation link below.

We recommend using at least Medium size warehouse for querying.

About the Provider:

Contextualized data and analytics for the blockchain ecosystem.

Visit the provider’s website for more information

 

Get access to the Token Flow Insights: Ethereum Data Warehouse beta Listing in Snowflake

SIGN UP FOR A SNOWFLAKE FREE TRIAL

Already a Snowflake customer?
Access this listing directly from your Snowflake account.

LOGIN