ethereum

Tables

beacon_validators

Ethereum Beacon Chain validator state records tracking each validator’s lifecycle, including activation/exit epochs, balances, slashing status, and withdrawal credentials. Used for analyzing staking participation, validator exits, and rewards accrual across proof-of-stake consensus.

Columns

Column	Type	Description
`slot_timestamp`	`TIMESTAMP`	Timestamp when the beacon chain slot containing this validator state snapshot was proposed. Recorded at slot granularity, typically every 12 seconds on Ethereum’s beacon chain.
`slot_number`	`INT64`	Beacon chain slot number when this validator state snapshot was recorded. Slots occur every 12 seconds on Ethereum’s consensus layer.
`status`	`STRING`	Success indicator for the operation. Boolean value where true indicates successful execution and false indicates failure.
`balance`	`STRING`	Current balance of the validator in gwei (1 ETH = 1 billion gwei), shown as a string-encoded integer. Balance reduces to zero after withdrawal completion, while active validators typically maintain balances above 32 billion gwei.
`index`	`INT64`	Unique sequential identifier assigned to each validator in the Ethereum Beacon Chain. Immutable integer assigned at validator registration, used as the primary reference for tracking validator lifecycle and performance.
`validator_pubkey`	`STRING`	BLS (Boneh-Lynn-Shacham) public key uniquely identifying this Ethereum beacon chain validator. Hex-encoded, 0x-prefixed 96-character string used for validator attestations and block proposals.
`validator_withdrawal_credentials`	`STRING`	Cryptographic credentials that authorize withdrawal of the validator’s stake, encoded as a 0x-prefixed 66-character hex string. Determines the withdrawal address for validators with 0x01 prefix or requires BLS credentials for 0x00 prefix legacy validators.
`withdrawal_address`	`STRING`	Ethereum address authorized to receive staked ETH withdrawals from this validator. Null for validators using legacy BLS withdrawal credentials (0x00 prefix) that haven’t migrated to execution layer withdrawals (0x01 prefix).
`validator_effective_balance`	`STRING`	Validator’s balance counted toward staking duties and rewards, capped at 32 ETH (32000000000 Gwei). Balance above this threshold does not increase validator power but can be withdrawn.
`validator_slashed`	`BOOL`	Boolean flag indicating whether the validator has been penalized (slashed) for malicious behavior such as double-signing or contradictory attestations. When true, the validator has been slashed and will have reduced stake and face withdrawal delays.
`validator_activation_eligibility_epoch`	`STRING`	Epoch number when the validator became eligible for activation on the Beacon Chain. Represented as a string-encoded integer, typically set before the validator_activation_epoch.
`validator_activation_epoch`	`STRING`	Epoch number when the validator became active and started participating in consensus. Stored as string representation of the epoch integer, commonly seen values range from genesis (0) to tens of thousands.
`validator_exit_epoch`	`STRING`	Epoch number when the validator initiated exit from the beacon chain. Represented as a string-encoded integer, with typical values indicating the validator’s withdrawal timeline relative to activation epoch.
`validator_withdrawable_epoch`	`STRING`	Epoch number when the validator’s full balance becomes eligible for withdrawal from the Beacon Chain. Null until the validator initiates an exit, then set to 256 epochs after the exit epoch.

Sample Data

index	status	slot_number	slot_timestamp	validator_pubkey	validator_slashed	withdrawal_address	validator_exit_epoch	validator_activation_epoch	validator_withdrawable_epoch	validator_withdrawal_credentials	validator_activation_eligibility_epoch
21841	withdrawal_done	9277198	2024-06-11T23:59:59.000Z	0x8cc5c7e11e10570b322fc18500ef70047f1c72583d7aefafcf5edfb0bc9d5416a5b4ad06b816f4ee5391030d95233b08	false	0x174da907db087f85e8d43b6e2af755260f900810	102415	239	102671	0x010000000000000000000000174da907db087f85e8d43b6e2af755260f900810	41
21844	withdrawal_done	9277198	2024-06-11T23:59:59.000Z	0x95efc0b60f8fef2c6228bca2213c8d32f2dd76b72a12a1b434dbee8442ed26d201abaae648bc5616a6558686a438ffae	false	0x174da907db087f85e8d43b6e2af755260f900810	102415	240	102671	0x010000000000000000000000174da907db087f85e8d43b6e2af755260f900810	41
21843	withdrawal_done	9277198	2024-06-11T23:59:59.000Z	0x873176f25ed64123456b7cf4b62a6dc73bfcd4f99a2a89b42fe15a0acf507fa40120bbf4388ea5c2d392994837fe4292	false	0x174da907db087f85e8d43b6e2af755260f900810	102415	240	102671	0x010000000000000000000000174da907db087f85e8d43b6e2af755260f900810	41

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.ethereum.beacon_validators`
WHERE slot_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

blocks

Block header data containing sequential numbering, cryptographic hashes linking to parent blocks, timestamps, and consensus metadata. Primary source for blockchain state verification and chain navigation.

Columns

Column	Type	Description
`timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone.
`number`	`INT64`	Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`transaction_count`	`INT64`	Number of transactions included in the block.
`gas_limit`	`INT64`	Maximum gas allowed to be consumed by all transactions in the block. Measured in gas units, representing the computational capacity limit set for block execution.
`gas_used`	`INT64`	Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
`blob_gas_used`	`INT64`	Total gas consumed by blob transactions in the block. Measured in blob gas units, representing the data availability cost for EIP-4844 blob-carrying transactions.
`excess_blob_gas`	`INT64`	Cumulative blob gas exceeding the target per block, used to adjust future blob gas pricing. Measured in blob gas units as defined by EIP-4844.
`base_fee_per_gas`	`INT64`	Minimum fee per gas unit required for transaction inclusion in the block. Measured in wei, representing the base cost dynamically adjusted by the network’s fee mechanism.
`miner`	`STRING`	Address of the block producer who created the block. Hex-encoded, 0x-prefixed, 42-character string.
`parent_hash`	`STRING`	Hash of the parent block in the blockchain. 66-character hex string including 0x prefix.
`nonce`	`STRING`	Sequential counter for transactions or operations from an account. Increments by 1 for each new transaction to prevent replay attacks and ensure transaction ordering.
`sha3_uncles`	`STRING`	Keccak-256 hash of the RLP-encoded list of uncle block headers. 66-character hex string including 0x prefix.
`logs_bloom`	`STRING`	Bloom filter for efficient event log querying within the block. 512-character hex string (including 0x prefix) representing a probabilistic data structure for testing event presence.
`transactions_root`	`STRING`	Merkle root hash of all transactions included in the block. 66-character hex string including 0x prefix.
`state_root`	`STRING`	Merkle root hash representing the complete state of the blockchain after block execution. 66-character hex string including 0x prefix.
`receipts_root`	`STRING`	Merkle root hash of all transaction receipts in the block. 66-character hex string including 0x prefix.
`difficulty`	`INT64`	Mining difficulty target for the block. Integer value representing the computational effort required to produce the block, with 0 indicating proof-of-stake consensus and higher values indicating proof-of-work difficulty.
`total_difficulty`	`NUMERIC`	Cumulative sum of block difficulty from genesis to the current block. Numeric value representing the total computational work expended on the chain up to and including this block.
`size`	`INT64`	Block size in bytes. Represents the total serialized size of the block data structure.
`extra_data`	`STRING`	Arbitrary data field included in the block by the block producer. Hex-encoded string format, typically containing miner software version, pool information, or chain-specific metadata.
`parent_beacon_block_root`	`STRING`	Root hash of the parent beacon chain block for post-merge consensus verification. 66-character hex string including 0x prefix.
`mix_hash`	`STRING`	Hash value used in proof-of-work mining or consensus verification. 66-character hex string including 0x prefix.
`uncles`	`ARRAY<STRING>`	List of uncle block hashes included in the block. Empty array for chains not supporting uncle blocks in their consensus mechanism.
`withdrawals`	`ARRAY<STRUCT<address STRING, amount NUMERIC, index INT64, validator_index INT64>>`	List of validator withdrawal records included in the block. Each withdrawal contains recipient address, amount withdrawn, withdrawal index, and validator index for proof-of-stake consensus mechanisms.
`withdrawals_root`	`STRING`	Merkle root hash of all validator withdrawals in the block. 66-character hex string including 0x prefix.

Sample Data

size	miner	nonce	number	uncles	gas_used	mix_hash	gas_limit	timestamp	block_hash	difficulty	extra_data	logs_bloom	state_root	parent_hash	sha3_uncles	withdrawals	receipts_root	total_difficulty	transaction_count	transactions_root
768	0xa5a57098907037cd613d46c2c2ca3e65752d906e	0x9d01fb2fe75882c2	170034	[]	42000	0x0118d998261452313139475cd9f5bd6177e2001b5478fc5bb96113a0cebf6666	3141592	2015-08-31T21:55:11.000Z	0x62732a53bf6ba039d30a3f3d8d90992ac56b6cc92936c253f0c296b9b3bf6344	7473899908832	0xd783010100844765746887676f312e342e32856c696e7578	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x7858547617d6bb98ce18a0ca8692db2db08e15436878410812fa2ce787a54889	0x7108f86ceb08ad7cea295afe84e0a4fd54e3f331be238873cde5cf359ca424f0	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	[{“index”:null,“amount”:null,“address”:null,“validator_index”:null}]	0x5dae2600f356f485409b0688c13ca219a2ba72bb38e51ed66d7253ac95e3a7e1	542113489057292153	2	0x4dcb2125dfb85c1007a499ed9120a86eddd24cf599f6c15e011af7335b8f7f8b
769	0xec98b7a32a91f21203e7db60feabda1edd7ef5bb	0x669f50d70b599394	169201	[]	42000	0x2fbb33b25c6d82102cd34fc662fb7dd60695f4c7a3661adfcf2a08acf13a4324	3141592	2015-08-31T16:58:59.000Z	0x15d892aac8b2b2382ae32ae9ed0751307d62a6a9ee7df3145b613a1efc43ffc9	7269475963891	0xd783010100844765746887676f312e342e32856c696e7578	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x0cd3b7ec064fae50701e6e6747e6c1ac9299fa0488f49af7982307347a358a43	0x8213b2d4ccb55db7390db44913d64df4aba6c6c44942364c72ccefdfb5f5a4d9	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	[{“index”:null,“amount”:null,“address”:null,“validator_index”:null}]	0xe7d7dfa3cbcbeded7bf9957f75193ec323714b12f169086c704bd3e52c52a8a4	535978538117119975	2	0xbb7ef1a5fec438c1b864af603a1eb9f03de0025c3c8c29de9d137caf0236fcc1
769	0x8c24e2d312b92e1ff7a2f23490219c1d0bffefd8	0x400a7de71360622a	170057	[]	42000	0xccc74565c044472e154eae95b25e57de76fc1e43b3cfa5b3defb45a1f49e17f1	3141592	2015-08-31T22:03:03.000Z	0x1b4f73f4251f034fbbdc806c235997eb9810b28ad4b3c9cb13c5c2e3f04d77a0	7470230952154	0x476574682f76312e302e322f77696e646f77732f676f312e342e32	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x13e77c82a19a5dcdac4a7725b1ee81c4958d1a75608bee37c007294e717c290b	0x75b253fbedd51e39800ac08bcf3bd96661e1f929e01f2f314374fd4d5aadc540	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	[{“index”:null,“amount”:null,“address”:null,“validator_index”:null}]	0x404f24dec11a47b7828d400326510cc971c13a89669fee4fe4bcc23646cd1ca8	542285300963867781	2	0x04434af7b270d862619c3bf0c2f89f62478af62d08a8d5545842a2e1d5491649

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.ethereum.blocks`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

logs

Event logs emitted by smart contracts during transaction execution, containing indexed topics for efficient filtering and ABI-encoded data payloads. Primary source for tracking contract interactions, token transfers, and state changes across blockchain networks.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_number`	`INT64`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event log within its containing block. Zero-indexed integer indicating the sequential order of logs emitted in the block.
`address`	`STRING`	Contract address that emitted the event log. Hex-encoded, 0x-prefixed, 42-character string.
`data`	`STRING`	ABI-encoded event or transaction data. Hex-encoded string including 0x prefix.
`topics`	`ARRAY<STRING>`	Indexed event parameters from the emitted log. Array of 66-character hex strings including 0x prefix, where the first element is the event signature hash and subsequent elements are indexed parameters.
`removed`	`BOOL`	Indicates whether the log was removed due to a chain reorganization.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.

Sample Data

data	topics	address	removed	log_index	block_hash	block_number	block_timestamp	transaction_hash	transaction_index
0x	[“0xcc494284735b76f0235b8a507abc67ce930b369dac12b8a45e49510ccee0abe5”]	0x7de5aba7de728950c92c57d08e20d4077161f12f	false	0	0x15fc382d16c78118db572480dc5aa5108c65a9d7987d96ac43d404e3b50b7302	734976	2015-12-23T08:57:02.000Z	0x82c6a8d72c6cfe7bce6c4a7f5fe872f3c6ccef23960473ddf6afc9e91bef8734	0
0x	[“0xcc494284735b76f0235b8a507abc67ce930b369dac12b8a45e49510ccee0abe5”]	0x7de5aba7de728950c92c57d08e20d4077161f12f	false	1	0x15fc382d16c78118db572480dc5aa5108c65a9d7987d96ac43d404e3b50b7302	734976	2015-12-23T08:57:02.000Z	0xcbe5be1dcd02e89158690de63f20ed94acc81a88eb7c8b1035407c8b06b4e80d	1
0x	[“0xcc494284735b76f0235b8a507abc67ce930b369dac12b8a45e49510ccee0abe5”]	0x7de5aba7de728950c92c57d08e20d4077161f12f	false	1	0x81d071cc7c8192a58e8742299cea1baba082dae535c39d5308e72e06f06803fb	735232	2015-12-23T10:08:39.000Z	0x4bdf690b1fcc7fc289c211459743c08e2a7da63d97cbdee5b053b40c7190adb6	2

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.ethereum.logs`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

state_diff

Account-level state changes from Ethereum transactions showing before and after values for balances, nonces, and storage slots. Used for analyzing transaction effects, account activity patterns, and reconstructing historical state transitions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_number`	`INT64`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`output`	`STRING`	Return data from the smart contract execution or call. Hex-encoded string starting with 0x, containing the function’s return value in ABI-encoded format.
`trace`	`JSON`	Internal execution trace data capturing the call stack and operations performed during transaction execution. Typically null or empty for standard transactions; populated for complex contract interactions requiring detailed debugging information.
`vm_trace`	`JSON`	JSON-encoded virtual machine execution trace capturing detailed step-by-step EVM operations during transaction execution. Null for most transactions; populated only when deep trace analysis is enabled.
`address`	`STRING`	Contract address that emitted the event log. Hex-encoded, 0x-prefixed, 42-character string.
`balance_from`	`FLOAT64`	Account’s ETH balance before the transaction, denominated in wei (smallest ETH unit). Null when the account did not exist prior to this transaction.
`balance_to`	`FLOAT64`	Account ETH balance after the transaction executed, denominated in wei (10^-18 ETH). Null when the address is only referenced in contract storage changes without a balance modification.
`nonce_from`	`INT64`	The nonce value of the address before the state change occurred during transaction execution. Null when the address is receiving ETH without initiating a transaction (e.g., mining reward recipient or transaction recipient).
`nonce_to`	`INT64`	Transaction nonce value for the account after the state change was applied. Increments with each transaction sent from this address; null for contract addresses receiving funds without executing code.
`storage_address`	`STRING`	Storage slot location within a smart contract that was modified during transaction execution. Null when account-level state changes (balance/nonce) occur without storage modifications.
`storage_from`	`FLOAT64`	Value of a contract storage slot before the transaction executed. Null when no storage changes occurred at this address; populated when storage state modifications are captured in the state diff.
`storage_to`	`FLOAT64`	Storage slot value after the transaction execution for the contract at storage_address. Null when no storage changes occurred for this account in the transaction.

Sample Data

trace	output	address	nonce_to	vm_trace	balance_to	nonce_from	balance_from	block_number	block_timestamp	transaction_hash
[]	0x	0x0072b39a690420c618009fb4cce7b46b2406b5ce	1377	null	9656815947214354000	1376	9663422487214354000	8755298	2019-10-17T00:00:10.000Z	0x941584eaf8c9a92bc0d930cc9e866d67c58e70beab651d34f4967d66d76de999
[]	0x	0x009da4e443aaf4ca53e344b6975bb9e990f0e6ae	8594	null	8267366304627743000	8593	8270996304627743000	8755298	2019-10-17T00:00:10.000Z	0x19316f3ffa912dd7bebf7c1cf04d87d4e5b028c0a09b8827248b7fc3ac699a37
[]	0x0000000000000000000000000000000000000000000000000000000000000001	0x042b66f61c97670baf8e9d96e2e87a51e7226524	7482	null	8715060422000000000	7481	8716686217000000000	8755298	2019-10-17T00:00:10.000Z	0x2d31f6e8299fe51259cf93b73b5e08bc6fbeba504d080eda0046b0788d26b2e6

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.ethereum.state_diff`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

traces

Individual transaction execution steps recording internal operations, including contract calls, value transfers, and gas consumption. Used for analyzing complex transaction flows and debugging smart contract interactions.

Columns

Column	Type	Description
`from_address`	`STRING`	Address that initiated the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`gas`	`INT64`	Maximum gas units allocated for the transaction execution.
`gas_used`	`INT64`	Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
`to_address`	`STRING`	Address receiving the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`input`	`STRING`	Calldata or transaction payload sent with the call or transaction. Hex-encoded string starting with 0x, containing the function signature and encoded parameters for smart contract interactions.
`value`	`FLOAT64`	Amount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
`trace_type`	`STRING`	Type of trace operation executed within the transaction. Common values include CALL for contract calls, CREATE for contract deployments, DELEGATECALL for delegate calls, STATICCALL for static calls, and SELFDESTRUCT for contract destruction operations.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_number`	`INT64`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`trace_address`	`STRING`	Hierarchical position of the trace within the transaction’s execution tree. Comma-separated string of zero-indexed integers representing the depth and order of nested calls.
`output`	`STRING`	Return data from the smart contract execution or call. Hex-encoded string starting with 0x, containing the function’s return value in ABI-encoded format.
`error`	`STRING`	Error message returned when transaction execution fails. Empty when execution succeeds.
`revert_reason`	`STRING`	Human-readable explanation for why a transaction or call reverted during execution. Empty when execution succeeds.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`trace_id`	`STRING`	Unique identifier for the trace operation within a transaction. Composite string combining the trace type and transaction hash, with optional trace address appended to distinguish between multiple operations of the same type.
`status`	`BOOL`	Success indicator for the operation. Boolean value where true indicates successful execution and false indicates failure.

Sample Data

gas	input	value	status	trace_id	to_address	trace_type	block_number	from_address	trace_address	block_timestamp	transaction_hash	transaction_index
2300	0x	19579157080000000000	true	CALL_0x9733f04d082290953afff3bce13419e67f5686e9ef4c3435eacacc165c550fad_1	0x303e33b483b5df3148cb2eaa1c17c486531ddf31	CALL	3530941	0xaa1a6e3e6ef20068f7f8d8c835d2d22fd5116444	1	2017-04-14T00:00:27.000Z	0x9733f04d082290953afff3bce13419e67f5686e9ef4c3435eacacc165c550fad	26
2300	0x	1069398440000000000	true	CALL_0x83e314ea215228c49f071fb06d8526f001a1836e18b3bf6a7afb6444951204d5_0	0x32be343b94f860124dc4fee278fdcbd38c102d88	CALL	3530941	0x209c4784ab1e8183cf58ca33cb740efbf3fc18ef	0	2017-04-14T00:00:27.000Z	0x83e314ea215228c49f071fb06d8526f001a1836e18b3bf6a7afb6444951204d5	22
2300	0x	6267972090000000000	true	CALL_0x7246601714e2c98e06ccf10d122b7e2487a7008681ec563ef90ff6aafad78348_0	0x32be343b94f860124dc4fee278fdcbd38c102d88	CALL	3530941	0x209c4784ab1e8183cf58ca33cb740efbf3fc18ef	0	2017-04-14T00:00:27.000Z	0x7246601714e2c98e06ccf10d122b7e2487a7008681ec563ef90ff6aafad78348	20

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.ethereum.traces`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

transactions

Transaction records containing signed operations that modify blockchain state. Primary source for tracking value transfers, contract interactions, and account state changes across the network.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, microsecond precision.
`block_number`	`INT64`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`from_address`	`STRING`	Address that initiated the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
`gas`	`INT64`	Maximum gas units allocated for the transaction execution.
`gas_price`	`INT64`	Price per unit of gas for the transaction. Integer value denominated in the smallest unit of the blockchain’s native currency (wei for EVM chains).
`nonce`	`INT64`	Sequential counter for transactions or operations from an account. Increments by 1 for each new transaction to prevent replay attacks and ensure transaction ordering.
`input`	`STRING`	Calldata or transaction payload sent with the call or transaction. Hex-encoded string starting with 0x, containing the function signature and encoded parameters for smart contract interactions.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`max_fee_per_gas`	`INT64`	Maximum gas price per unit willing to be paid for transaction execution. Integer value denominated in wei for EVM chains, specified by the transaction sender as part of EIP-1559 fee market transactions.
`max_priority_fee_per_gas`	`INT64`	Maximum tip per gas unit offered to validators for transaction priority. Integer value denominated in wei for EVM chains, specified by the transaction sender in EIP-1559 transactions to incentivize faster inclusion.
`transaction_type`	`INT64`	EIP-2718 transaction type indicator. Integer value representing the transaction format: 0 for legacy, 1 for EIP-2930 access list, 2 for EIP-1559 fee market, 3 for EIP-4844 blob transactions.
`receipt_type`	`INT64`	Transaction encoding format identifier from EIP-2718. Integer value indicating the transaction type returned in the receipt.
`receipt_effective_gas_price`	`INT64`	Actual gas price paid per unit for transaction execution. Integer value denominated in wei.
`receipt_blob_gas_price`	`INT64`	Actual price per unit of blob gas paid for EIP-4844 blob transactions. Integer value denominated in wei.
`receipt_cumulative_gas_used`	`INT64`	Total gas consumed by all transactions in the block up to and including this transaction. Integer value representing the cumulative sum of gas used, incrementing with each transaction in sequential order.
`receipt_gas_used`	`INT64`	Gas units consumed by this specific transaction.
`receipt_blob_gas_used`	`INT64`	Gas units consumed for blob data storage in EIP-4844 transactions. Integer value representing the amount of gas specifically used for posting blob data, separate from execution gas.
`receipt_contract_address`	`STRING`	Contract address created by the transaction when deploying a new smart contract. Hex-encoded, 0x-prefixed, 42-character string. Null for all non-deployment transactions.
`receipt_status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true indicates successful execution and false indicates failure.
`receipt_logs_bloom`	`STRING`	Bloom filter for efficiently querying event logs emitted by the transaction. 512-character hex string including 0x prefix, representing a 256-byte bit array used for probabilistic matching of log topics and addresses.
`receipt_transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`v`	`STRING`	ECDSA signature component v from the transaction signature. Integer value used for signature verification and public key recovery.
`r`	`STRING`	ECDSA signature component r from the transaction signature. 66-character hex string including 0x prefix.
`s`	`STRING`	ECDSA signature component s from the transaction signature. 66-character hex string including 0x prefix.
`chain_id`	`INT64`	Numeric identifier for the blockchain network. Integer value that uniquely identifies the blockchain according to EIP-155 chain ID standard.
`blob_versioned_hashes`	`ARRAY<STRING>`	Array of commitment hashes for EIP-4844 blob data attached to the transaction. Each hash is a 66-character hex string including 0x prefix that references blob data stored separately from the transaction.
`max_fee_per_blob_gas`	`INT64`	Maximum gas price per unit willing to be paid for blob data in EIP-4844 transactions. Integer value denominated in wei, specified by the transaction sender to limit the cost of posting blob data separately from transaction execution.
`access_list`	`ARRAY<STRUCT<address STRING, storageKeys ARRAY<STRING>>>`	List of addresses and storage keys accessed during EIP-2930 access list transactions. Array of structs containing contract addresses and their associated storage slot keys that the transaction declares it will access.

Sample Data

r	s	v	gas	input	nonce	chain_id	gas_price	block_hash	to_address	access_list	block_number	from_address	receipt_status	block_timestamp	receipt_gas_used	transaction_hash	transaction_index	receipt_logs_bloom	blob_versioned_hashes	receipt_transaction_index	receipt_cumulative_gas_used	receipt_effective_gas_price
0x4832f772e32a740baf1ba68b24be2f8d2ca301c1b19e92c5f0c5252904b6e7ca	0x55065a10cfdce11e1a384d5f7fcb09ef2a8b3bcbfa78128f6e784f8f56d5de6e	0x26	250000	0xa9059cbb000000000000000000000000f18d49b8f5b0224215b5ef6a48e3578ef8f6598c00000000000000000000000000000000000000000000000975e4f9c3d4f00000	424378	1	28000000000	0x001e0767fe832b05881dd120f34bc05c158cbe6b6cbea87305a5e4012071c528	0xc944e90c64b2c07662a292be6244bdf05cda44a7	[]	12930622	0x503828976d22510aad0201ac7ec88293211d23da	true	2021-07-31T02:10:17.000Z	51642	0x4e4be3c1b90fa1670f6b073ad9354c80c0bc8b9c240d68da95405acd442974c5	297	0x00000000000000000000000000200200000000000000000000000008000000000000000000000000000000000000000000000000000000000000002000000000000000000100000000000008000000000000000000000000000000000000000000000000000000000000000000000000200000000000000040000010000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000	[]	297	13183838	28000000000
0x202035f8305ef276b1d784b26cbc40e918e1776d9a1c865e03adcee9a94a35d	0x354a763883231103e00297bf88d65f319a85c2868d3dc743a685482928531c4a	0x26	67008	0xa9059cbb000000000000000000000000583017fee9af9c8c73bb07b5fea1775bebc4965c00000000000000000000000000000000000000000000000000000799e3f6e800	2248734	1	34000000000	0x001e0767fe832b05881dd120f34bc05c158cbe6b6cbea87305a5e4012071c528	0x607f4c5bb672230e8672085532f7e901544a7375	[]	12930622	0xe93381fb4c4f14bda253907b18fad305d799241a	true	2021-07-31T02:10:17.000Z	39208	0x8fb6c293fd92e0fe972439e28eeb4d45ee0f1620532a29260be03002d76fc6cd	206	0x00000000000000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000010000000000000000000000000000000000000000000008000000000000000000000000000000000000001000000000000000000000024000000000000000000000000000000010000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000002000000000008000000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000	[]	206	7674784	34000000000
0xe8ad271f270806b3def75618624f9d88f97b8d054be2c26836f8079cce136ea9	0x65e036a2edf5f1fc1f1e1a68a89132180b64c0d4dfd287174e830feed8cf66a6	0x26	500000	0xa9059cbb00000000000000000000000063a4086fb207c761341c30c376e9d45df5ddb5340000000000000000000000000000000000000000000000000b1a2bc2ec500000	125142	1	27594600000	0x001e0767fe832b05881dd120f34bc05c158cbe6b6cbea87305a5e4012071c528	0x514910771af9ca656af840dff83e8264ecf986ca	[]	12930622	0xc6bed363b30df7f35b601a5547fe56cd31ec63da	true	2021-07-31T02:10:17.000Z	34977	0xb15643ed70a9f4320c2662de050ac5130b585249f589ad95733edc5168a90266	310	0x00000000000000000000000000001000008000001000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000000000040000008000000001000000000040000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000004800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	[]	310	13795986	27594600000

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.ethereum.transactions`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

uncle_blocks

Uncle block records from Ethereum’s proof-of-work era, representing valid blocks that were mined but not included in the canonical chain. Used for analyzing miner competition, network propagation delays, and historical block production patterns before The Merge.

Columns

Column	Type	Description
`timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone.
`number`	`INT64`	Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`transaction_count`	`INT64`	Number of transactions included in the block.
`gas_limit`	`INT64`	Maximum gas allowed to be consumed by all transactions in the block. Measured in gas units, representing the computational capacity limit set for block execution.
`gas_used`	`INT64`	Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
`base_fee_per_gas`	`INT64`	Minimum fee per gas unit required for transaction inclusion in the block. Measured in wei, representing the base cost dynamically adjusted by the network’s fee mechanism.
`miner`	`STRING`	Address of the block producer who created the block. Hex-encoded, 0x-prefixed, 42-character string.
`parent_hash`	`STRING`	Hash of the parent block in the blockchain. 66-character hex string including 0x prefix.
`nonce`	`STRING`	Sequential counter for transactions or operations from an account. Increments by 1 for each new transaction to prevent replay attacks and ensure transaction ordering.
`sha3_uncles`	`STRING`	Keccak-256 hash of the RLP-encoded list of uncle block headers. 66-character hex string including 0x prefix.
`logs_bloom`	`STRING`	Bloom filter for efficient event log querying within the block. 512-character hex string (including 0x prefix) representing a probabilistic data structure for testing event presence.
`transactions_root`	`STRING`	Merkle root hash of all transactions included in the block. 66-character hex string including 0x prefix.
`state_root`	`STRING`	Merkle root hash representing the complete state of the blockchain after block execution. 66-character hex string including 0x prefix.
`receipts_root`	`STRING`	Merkle root hash of all transaction receipts in the block. 66-character hex string including 0x prefix.
`difficulty`	`INT64`	Mining difficulty target for the block. Integer value representing the computational effort required to produce the block, with 0 indicating proof-of-stake consensus and higher values indicating proof-of-work difficulty.
`total_difficulty`	`NUMERIC`	Cumulative sum of block difficulty from genesis to the current block. Numeric value representing the total computational work expended on the chain up to and including this block.
`size`	`INT64`	Block size in bytes. Represents the total serialized size of the block data structure.
`extra_data`	`STRING`	Arbitrary data field included in the block by the block producer. Hex-encoded string format, typically containing miner software version, pool information, or chain-specific metadata.
`mix_hash`	`STRING`	Hash value used in proof-of-work mining or consensus verification. 66-character hex string including 0x prefix.
`block_number`	`INT64`	Sequential number of the block in the blockchain. Starts at 0 for the genesis block and increments by 1 for each subsequent block.
`uncle_index`	`INT64`	Position of this uncle block within its parent block’s list of uncles, starting from 0. Always 0 in the samples, indicating the first or only uncle referenced by the including block.

Sample Data

size	miner	nonce	number	gas_used	mix_hash	gas_limit	timestamp	block_hash	difficulty	extra_data	logs_bloom	state_root	parent_hash	sha3_uncles	block_number	receipts_root	total_difficulty	transactions_root
533	0x940e88bc5e42db757c551c635dec86361ccc576d	0xc70fd85438317ec3	1960565	738294	0xb9e1fa152750bf6aeee1260099f1c46f6c20682f1c409959fcd87b9db6d3456f	4712388	2016-07-27T08:19:35.000Z	0x40bb0d68b0806717b9617991b25a8b3615d63e03bccb7ff369fa6c4570d93254	49190052612361	0x426c6f6b20627920536e617878	0x00000000040000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000	0x7bd6a3754597aa0d245a0900066307cdce4f9d2d9dd20a6bdad6cf2ba533166b	0x31a958ca01e6f5c2491beafdeb280089de1947f52e48f01774d651c0993bba7c	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	1960569	0x88ca1069e920a22504db2728dabb19265b23382809feae1db71c7003a8e5099e	41875801741290621089	0xaeb37baf37a0efbd4c4dbeb3ad48603add2f34c5523e79c4d47b631ddcc874df
541	0xa341dd9d70c3fe8c9b7091d67a7544d33c697721	0xbc70d0c003b30ea6	1961721	177969	0x8ae123642136ab2ce9225121bc80231891f7eb9b7786aeb91bc7c796e8c41a04	4707783	2016-07-27T12:39:51.000Z	0xb0ae3daf6231e656f9e6eed459aa50e32c63dd14fd01f759b7b0099d51a0df41	51388969348566	0x6574682e657a706f6f6c2e6363207573206d61696e	0x00000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000200000000008000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000000000000000000001000040000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000100400000000000000002	0xf1a2e45343787f1d614edb66d0e64f985e17a329aed905469b0fea5a666d19a3	0x0384a3ec1decc8e450d63da26745c818a39edf607fdde00aab8272479b8f34ab	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	1961723	0x63c3d154d7a97e38766748511bf33226e1a4bdba61a211d0ac62f811324cabaf	41934408514078983068	0x287b3c22c9f29ed743b2b9a7ecfa01f84dd4b735e845df25828ed47bd5a4ee7d
546	0x3763e6e1228bfeab94191c856412d1bb0a8e6996	0x7c1bb64a35cf3e09	1961838	264544	0x0b8972a08882f13c99fe8cdd5f93c87dd4118d0eb991eba2f882b5b12990e891	4712379	2016-07-27T13:01:53.000Z	0x2e731a7b74aed3971cf725192614caac007f19403df39f8f628fca0c22579f0c	52222821376869	0x4f70656e457468657265756d506f6f6c2f506f6f6c546f2e4265	0x00000000000000020000000000020000000000000000000000000000000000000000000000000000000000000000400000000000000000000040000000202000000000000000000000000000000000000100000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000001000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000	0x00f1639c178992dc7c6212c2ce3da5912a60223bad4e41efa250b4aa40dbb24a	0x4b192daf408c3e3f661240d6cd1391568deaf1ec2e0d0da8c8039f3766e9241b	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	1961840	0x6883e28e15223b8f84c292684815d88361f82ac4dedbbbce068c1ac3e26d5bd0	41940482389109504339	0xe02bee2f1dfada45aaacc7e980f34ca2f234f2a3a3facfa3e602171aebaa437c

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.ethereum.uncle_blocks`
WHERE timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

beacon_validators

blocks

logs

state_diff

traces

transactions

uncle_blocks

​Tables

​beacon_validators

​blocks

​logs

​state_diff

​traces

​transactions

​uncle_blocks

Tables

beacon_validators

blocks

logs

state_diff

traces

transactions

uncle_blocks