soneium

Tables

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
`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.
`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.
`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.
`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.
`block_hash`	`STRING`	Unique identifier for the block. 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.
`miner`	`STRING`	Address of the block producer who created the block. Hex-encoded, 0x-prefixed, 42-character string.
`mix_hash`	`STRING`	Hash value used in proof-of-work mining or consensus verification. 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.
`number`	`INT64`	Sequential block number indicating the position of the block in the blockchain. Increments by 1 for each new block in the chain.
`parent_hash`	`STRING`	Hash of the parent block in the blockchain. 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.
`sha3_uncles`	`STRING`	Keccak-256 hash of the RLP-encoded list of uncle block headers. 66-character hex string including 0x prefix.
`size`	`INT64`	Block size in bytes. Represents the total serialized size of the block data structure.
`state_root`	`STRING`	Merkle root hash representing the complete state of the blockchain after block execution. 66-character hex string including 0x prefix.
`timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone.
`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.
`transaction_count`	`INT64`	Number of transactions included in the block.
`transactions_root`	`STRING`	Merkle root hash of all transactions included in the block. 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_root`	`STRING`	Merkle root hash of all validator withdrawals in the block. 66-character hex string including 0x prefix.
`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.
`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.
`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.

Sample Data

size	miner	nonce	number	uncles	gas_used	mix_hash	gas_limit	timestamp	block_hash	extra_data	logs_bloom	state_root	parent_hash	sha3_uncles	receipts_root	base_fee_per_gas	withdrawals_root	transaction_count	transactions_root	parent_beacon_block_root
839	0x4200000000000000000000000000000000000011	0x0000000000000000	414084	[]	43878	0xbb96e4771ed9ab52f82828fa740eccf03309373a9a354ce9335390d73c2cc2bb	60000000	2024-12-12T00:21:59.000Z	0xaf0c842c75be9eb4f88c0cf72fc0d5f76a95cb9e541d05274272f926885075b6	0x	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x177f9a0e8e69afa40700e013bb07d4809c1688082bea59e1fbd0eeb216fb4b8a	0xee914655f04d3723a2897b95d037d8eff267a8c9d09efd77cb4b4aac2841ffb5	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xf33e881e72cd810f81c89fded327053d8c0feb7fc152e0c7b3e4aa52a67e1803	251	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	1	0xce12dba4864f8f1ed6f3f4dd331127fad29b9451e29a6fdd16d8d93611e9f88f	0x0840bdade640234819848668facb91685161c42c3e72f4f35a89238f0bbb79d5
839	0x4200000000000000000000000000000000000011	0x0000000000000000	414085	[]	43878	0xbb96e4771ed9ab52f82828fa740eccf03309373a9a354ce9335390d73c2cc2bb	60000000	2024-12-12T00:22:01.000Z	0x8024e6a453f05ad0de247cf3857b726ea517fb9a0577ec178795ab26ad0375a1	0x	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x6fc59f396f5d83d5dcc604dc94e4d62c5c04cc17e3c80507a7f8f5124c877786	0xaf0c842c75be9eb4f88c0cf72fc0d5f76a95cb9e541d05274272f926885075b6	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x4555c3f07581ac7d379aa9ae3a3ac32f0cca153ee4427a38b3ae6e6fb3adacfd	251	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	1	0xb1ebcdda865b4b84ff70a5fe4659006d44a2d066e1252072c25bf319c401c47e	0x0840bdade640234819848668facb91685161c42c3e72f4f35a89238f0bbb79d5
839	0x4200000000000000000000000000000000000011	0x0000000000000000	414086	[]	43878	0xbb96e4771ed9ab52f82828fa740eccf03309373a9a354ce9335390d73c2cc2bb	60000000	2024-12-12T00:22:03.000Z	0x95030ad4f0cf4691e1cd7d9dce07af81b205838018666be491dbf166e7ef3440	0x	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0xe2605d28fba78569966a66f6c154318be406d19d2fe18dee5dd420ecbbde4121	0x8024e6a453f05ad0de247cf3857b726ea517fb9a0577ec178795ab26ad0375a1	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xd5dce865877e9d85b6ffbd680bc244ec83514da05af3e98168842746c8ceb563	251	0x56e81f171bcc55a6ff8345e692c0f86e5b48e01b996cadc001622fb5e363b421	1	0xcd7254925ad8b8d05c7d85e0427eef712e35a766b5ca5b4fa29f2eebf3c16cee	0x0840bdade640234819848668facb91685161c42c3e72f4f35a89238f0bbb79d5

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.soneium.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.
`signature`	`STRING`	# Canonical Column Description: signature

Cryptographic signature authorizing the operation. Hex-encoded string format, typically 130-132 characters including 0x prefix for signed transactions and operations. | | 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. | | 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. | | 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. | | address | STRING | Contract address that emitted the event log. Hex-encoded, 0x-prefixed, 42-character string. | | removed | BOOL | Indicates whether the log was removed due to a chain reorganization. |

Sample Data

data	topics	address	removed	log_index	block_hash	block_number	block_timestamp	transaction_hash	transaction_index
0x0000000000000000000000000000000000000000000000003c456f7d63858000ffffffffffffffffffffffffffffffffffffffffffffffffffffc3ab0ed37e26000000000000000000000000000000000000000001002dfeaee4836b4493c773000000000000000000000000000000000000000000000289c77d085f8e725a55fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffe4ed0	[“0xc42079f94a6350d7e6235f29174924f928cc2ac818eb64fed8004e115fbcca67”,“0x000000000000000000000000652e53c6a4fe39b6b30426d9c96376a105c89a95”,“0x0000000000000000000000009c8feb2dc5b1ad0892507b4808aa140fa46da526”]	0xb44795454376c7127f89b1cc0d56f403e70ca952	false	60	0x872b7c996e05e790436dcc11e04dc2c89161fd3bcb161c0df1c46c15f11cf300	2573429	2025-01-31T00:00:09.000Z	0xb75d4f64db2948c39fe6cfa54bd2159203be2af08c48e9a3e2ccfd2ca687e625	18
0x000000000000000000000000000000000000000000000000273f130440ce0000ffffffffffffffffffffffffffffffffffffffffffffffffda2590e4f6fefbd00000000000000000000000000000000000000000fb7a6c747cdbd7551992ceb6000000000000000000000000000000000000000004c88733e4fbdf085145c58ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffe9b	[“0xc42079f94a6350d7e6235f29174924f928cc2ac818eb64fed8004e115fbcca67”,“0x0000000000000000000000000dc73fe1341365929ed8a89dd47097a9fdd254d0”,“0x000000000000000000000000563b246e4e8916e4857405c4fd0c2c9d8570fd31”]	0x7c17a5e98cb692f1b481da5b99936243e289ec05	false	71	0x872b7c996e05e790436dcc11e04dc2c89161fd3bcb161c0df1c46c15f11cf300	2573429	2025-01-31T00:00:09.000Z	0x4eb9328aee6b041a157c6c8f7a1a267c3efcf26dac3a1ccceaead3358a6ef249	21
0x0000000000000000000000000000000000000000000000007f4d0ae63ca88000ffffffffffffffffffffffffffffffffffffffffffffffff8537c4a16a96b0500000000000000000000000000000000000000000fb7a6c7c66bdf790e3b59575000000000000000000000000000000000000000004c88733e4fbdf085145c58ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffe9b	[“0xc42079f94a6350d7e6235f29174924f928cc2ac818eb64fed8004e115fbcca67”,“0x0000000000000000000000000dc73fe1341365929ed8a89dd47097a9fdd254d0”,“0x000000000000000000000000f469c4139c7ec494984887c8a379bd81a8683256”]	0x7c17a5e98cb692f1b481da5b99936243e289ec05	false	38	0x872b7c996e05e790436dcc11e04dc2c89161fd3bcb161c0df1c46c15f11cf300	2573429	2025-01-31T00:00:09.000Z	0x44d57e6bc432f21340e10f47c1506ae637c21b9c6ee3ce6e675307db9045f2d5	12

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.soneium.logs`
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`	`BIGNUMERIC`	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	status	gas_used	trace_id	to_address	trace_type	block_number	from_address	block_timestamp	transaction_hash
1000000	0x440a5e2000000558000c5fc5000000000000000200000000674dbf630000000001453ef9000000000000000000000000000000000000000000000000000000049126db2e00000000000000000000000000000000000000000000000000000004741676a3e4bdc54f468bbd286b5503acca5e45112d68b191475be068be29943334d043df0000000000000000000000006776be80dbada6a02b5f2095cf13734ac303b8d1	true	43950	CALL_0x008957703955d544a3569abc4def29c47fccccb99d0f53ebdb7e69b7bfd26e1b_	0x4200000000000000000000000000000000000015	CALL	6913	0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001	2024-12-02T14:09:37.000Z	0x008957703955d544a3569abc4def29c47fccccb99d0f53ebdb7e69b7bfd26e1b
1000000	0x440a5e2000000558000c5fc5000000000000000400000000674dd28f00000000014540900000000000000000000000000000000000000000000000000000000868c0c1e300000000000000000000000000000000000000000000000000000001f3e2b33df40930a6eb405c07fdfdfd8df31202428b6aa1217fc48c96a38ea090d29aee700000000000000000000000006776be80dbada6a02b5f2095cf13734ac303b8d1	true	43950	CALL_0x0221a7ec5d0dbea950fa999c8c8b0af815d3133a95b9e4ca220fe07347645170_	0x4200000000000000000000000000000000000015	CALL	9370	0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001	2024-12-02T15:31:31.000Z	0x0221a7ec5d0dbea950fa999c8c8b0af815d3133a95b9e4ca220fe07347645170
1000000	0x440a5e2000000558000c5fc5000000000000000000000000674d8f1b0000000001453afd0000000000000000000000000000000000000000000000000000000325af7b7200000000000000000000000000000000000000000000000000000001f3e2b33d9d3fa62d152fed6fb28c5d1c58fa8ab1152a8650cec86b9718a87c9860da06a90000000000000000000000006776be80dbada6a02b5f2095cf13734ac303b8d1	true	55138	CALL_0x0400cb09f38957c3f49eb42e52bbd3fc57fcd7d2ade6de04b21edd4dcd4197ff_	0x4200000000000000000000000000000000000015	CALL	702	0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001	2024-12-02T10:42:35.000Z	0x0400cb09f38957c3f49eb42e52bbd3fc57fcd7d2ade6de04b21edd4dcd4197ff

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.soneium.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_hash`	`STRING`	Unique identifier for the block. 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.
`deposit_receipt_version`	`INT64`	Version identifier for Layer 2 deposit transaction receipts. Integer value used to track the schema or protocol version of deposit receipts.
`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_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).
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.
`mint`	`NUMERIC`	Amount of native currency minted and credited to the transaction sender. Denominated in the smallest unit of the blockchain’s native currency.
`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.
`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.
`source_hash`	`STRING`	Unique identifier for Layer 2 deposit transactions originating from Layer 1. 66-character hex string including 0x prefix.
`to_address`	`STRING`	Address receiving the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`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.
`v`	`INT64`	ECDSA signature component v from the transaction signature. Integer value used for signature verification and public key recovery.
`value`	`STRING`	Amount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
`chain_id`	`INT64`	Numeric identifier for the blockchain network. Integer value that uniquely identifies the blockchain according to EIP-155 chain ID standard.
`max_fee_per_gas`	`NUMERIC`	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`	`NUMERIC`	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.
`y_parity`	`INT64`	ECDSA signature parity indicator for EIP-2718 typed transactions. Binary value (0 or 1) representing the y-coordinate parity of the public key recovery point.
`access_list`	`ARRAY<STRUCT<address STRING, storage_keys 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.
`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_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_deposit_nonce`	`INT64`	Sequential counter for Layer 2 deposit transactions originating from Layer 1. Increments by 1 for each new deposit to prevent replay attacks and ensure transaction ordering for cross-chain deposits.
`receipt_deposit_receipt_version`	`INT64`	Version identifier for deposit transaction receipts on Layer 2 blockchains.
`receipt_effective_gas_price`	`INT64`	Actual gas price paid per unit for transaction execution. Integer value denominated in wei.
`receipt_gas_used`	`INT64`	Gas units consumed by this specific transaction.
`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_status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true indicates successful execution and false indicates failure.
`receipt_transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`receipt_type`	`INT64`	Transaction encoding format identifier from EIP-2718. Integer value indicating the transaction type returned in the receipt.
`receipt_l1_fee`	`INT64`	Fee paid for publishing the transaction data to Layer 1. Denominated in the smallest unit of the blockchain’s native currency.
`receipt_l1_fee_scalar`	`NUMERIC`	Scaling factor applied to Layer 1 fee calculations for Layer 2 transaction data publishing costs.
`receipt_l1_base_fee_scalar`	`NUMERIC`	Scaling factor applied to the Layer 1 base fee component in Layer 2 transaction fee calculations.
`receipt_l1_gas_price`	`INT64`	Price per gas unit paid on Layer 1 for publishing Layer 2 transaction data. Denominated in wei.
`receipt_l1_gas_used`	`INT64`	Gas units consumed on Layer 1 for the transaction on Layer 2 rollup chains.
`receipt_l1_blob_base_fee`	`INT64`	Base fee per gas unit for EIP-4844 blob data on Layer 1. Denominated in wei.
`receipt_l1_blob_base_fee_scalar`	`NUMERIC`	Scaling factor applied to the Layer 1 blob base fee component in Layer 2 transaction fee calculations for EIP-4844 blob transactions.
`receipt_da_footprint_gas_scalar`	`INT64`	Scaling factor applied to the data availability footprint gas calculation for Layer 2 transaction data publishing costs.

Sample Data

r	s	gas	input	nonce	block_hash	to_address	access_list	source_hash	block_number	from_address	receipt_type	receipt_status	block_timestamp	receipt_gas_used	transaction_hash	transaction_type	receipt_logs_bloom	receipt_deposit_nonce	deposit_receipt_version	receipt_cumulative_gas_used	receipt_deposit_receipt_version
0x0	0x0	1000000	0x440a5e2000001521000d0e2f00000000000000000000000067957b6b00000000014b310f00000000000000000000000000000000000000000000000000000000ed80f8960000000000000000000000000000000000000000000000000000000000c4a99769f5652e450d9257e8a4c5beadbb9da49d79126fea42cb3cea486f414f73990e0000000000000000000000006776be80dbada6a02b5f2095cf13734ac303b8d1	2357506	0x5a4a43b69cc92d492f0b1db07215085abd2ab0bfee3b2b7b9bfe8ce857a34568	0x4200000000000000000000000000000000000015	[{“address”:null,“storage_keys”:[]}]	0x39b1297f86b42f0daf4c3e1e290ad5e4bdaa638c4e6de4299e5ebee1a339498f	2357507	0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001	126	true	2025-01-26T00:02:45.000Z	55102	0x9922488541317c49f8817ff47b3d62890c9ad88f93cf3461e07c9e62eeff3522	126	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	2357506	1	55102	1
0x0	0x0	1000000	0x440a5e2000001521000d0e2f00000000000000000000000067957cf700000000014b313000000000000000000000000000000000000000000000000000000000fc817173000000000000000000000000000000000000000000000000000000000162646696f211fdb796806bd306cd60375baf61e02d581a17ba5e82e1984413239b26340000000000000000000000006776be80dbada6a02b5f2095cf13734ac303b8d1	2357704	0xc31a3e4681fe5a95f3d5fc732e434b61837c83f120dcb79a9b205893c126a719	0x4200000000000000000000000000000000000015	[{“address”:null,“storage_keys”:[]}]	0xbfd2a6cfab67830b2dda3780c372a6821650090fb7cfa686e932a1e1f924f93c	2357705	0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001	126	true	2025-01-26T00:09:21.000Z	55114	0x5756c8b7fbbe7448b59171a3d410a473f8c911347b6e648b51dfa132923ff4d2	126	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	2357704	1	55114	1
0x0	0x0	1000000	0x440a5e2000001521000d0e2f00000000000000000000000067957d3f00000000014b31360000000000000000000000000000000000000000000000000000000109ecf6e400000000000000000000000000000000000000000000000000000000012339d15e020a80d613363f85ad6bf1d75fddb4dc743cbfc1fe8a1058361664e8eb5fec0000000000000000000000006776be80dbada6a02b5f2095cf13734ac303b8d1	2357740	0x6749c0e5ecaa26b7bf474969f14a1af3b1b17939494d8840c8cf66d725c20073	0x4200000000000000000000000000000000000015	[{“address”:null,“storage_keys”:[]}]	0xbe336917ce75a5a36bb155e5639b034b7330e514d4a2eb8b78054125400b6ba9	2357741	0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001	126	true	2025-01-26T00:10:33.000Z	55126	0x32cb33641fc0e431b9b9fe03e0412721f034dea074ae48044dd3c418d76e47b3	126	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	2357740	1	55126	1

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

blocks

logs

traces

transactions

Metrics

Primitives

Contracts

Blockchain

​Tables

​blocks

​logs

​traces

​transactions

Tables

blocks

logs

traces

transactions