opbnb

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	transaction_count	transactions_root
1280	0x4200000000000000000000000000000000000011	0x0000000000000000	8052057	[]	239093	0x0000000000000000000000000000000000000000000000000000000000000000	100000000	2023-11-12T16:16:20.000Z	0x181e59f846ef97789eb23f50d78aab5100d5e9576bd458025e892e17889289b1	0x	0x00000000000000000002000000000000000800000000000000000000002000000000000800000000000000000000010000000008000000000000040000000000000000000000000040000008000000004000000000000000000000000000000000000000000200000000000000000000000000000000000000000010040000000000008000000000000000000000000000000000000000100000000000000000000000000000000000400000080000000000000000000000000000000000000000000002000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000080000000000000000200	0xe6a13b0ae3c0a861432828320cc4f7a1fabc7243eaa22884a8ab3cfd281d8511	0x56d50ab944b9075d872beff7f5574f2b557ad11de43c5bc3cee24fe8b5a5bfc3	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x6842c4c8f0df87ba3b13961ad1dfd3a79b0448dc6acdb10b191667731ef62054	8	3	0x1df5b7e821cba345d399ff777cf18df79b3e18161b4c7c723fd78f9e88fc5100
1280	0x4200000000000000000000000000000000000011	0x0000000000000000	8049929	[]	252617	0x0000000000000000000000000000000000000000000000000000000000000000	100000000	2023-11-12T15:40:52.000Z	0x7c3016d4eb12907c17ee9148b6812ca55ddb4f475613da135ee3558633846691	0x	0x00000000000000000000000000000000000000000000000100008000000000000000000000000010000000000000000000000000001000000000000000000800000000000000000040000008000000008000000000000000000000000000000000000000000000000004000000000000000000000000000000000010040000100000000000000000000000000000000000000000000000100000000400000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000002000000000000000000000000100000000000000000000000000000010004100	0x27e51c3336c018f32380b129f646e5090bc4db9fa4d9c126022287953561cc9a	0x8632a59f978a1f8f1815900599c132a2a59e3ba6fe76c69d4c7ad5a1c0da2909	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x2d2f0bdfb5ee87f81991af2cce52ed54aa9558810bdbbefa831509800929e407	8	3	0x897e29703a91830e14238cbec054d70c01baf8ac7a5e34e4b1157379fd11e3ca
1280	0x4200000000000000000000000000000000000011	0x0000000000000000	8050037	[]	252605	0x0000000000000000000000000000000000000000000000000000000000000000	100000000	2023-11-12T15:42:40.000Z	0x15f8b4da46dacc8d210484531f07b4eb50d13f90b5cc1c9c2fbe2f11c43e66e7	0x	0x00000000000000000000000000000000000000000000000020000000000010000000008000000000000000000000000000000000000000000000000000000000000000000000000040000008000000000000000000000000100000000000000000000000000000000000000000000100000000000000000000000010040000000000000000000000000000000000000000000400000000500000000400000000000000000000000000000000000000000000000000000020000000000000000000000002004000000000000000000400000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000004100	0xf16d1e7714ae4a99b4e984a87658a74547bb85263c97d9c155ac0e6db19b4f72	0x47424f6c873dc407b407f7c13764cc4dbbe63ee7d4d403553b80bf7576b43524	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xd390884ede882ea494759c7eacc57992b06734599e2ca2a2203e582e2fe867da	8	3	0x94e830cfae9732f3eb0d1bf49a5c15a03080af8156ad413ce7b3c1a600e388ef

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.opbnb.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
0xb292b3ae5dff9f7574b2e86dbba0d6edc2b40673e69162dc515e88a455610385000000000000000000000000baea759f0c1c3bab65b954b37fe4741909f897220000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000012000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000002000000000000000000000000961a98999f14e8c5e69bdd4ee0826d6e0c556a0d0000000000000000000000000000000000000000000000000000000000029d2200000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002386f26fc10000000000000000000000000000abb4f853f36860af385fba4fb8729dbbc48460e7	[“0x9d9af8e38d66c62e2c12f0225249fd9d721c54b83f48d9352c97c6cacdcb6f31”,“0x000000000000000000000000abb4f853f36860af385fba4fb8729dbbc48460e7”,“0x00000000000000000000000010a8c9065692dffd48df1935e67a2744667fd9d0”]	0x00000000000000adc04c56bf30ac9d3c0aaf14dc	false	7	0xf7b8794ba736089aac85a92c90ef503ffdf007e8fa9da3a55853f788121a18ed	10974976	2023-12-16T12:11:39.000Z	0xc98a88ddfc124beb8a370e66f27b28235efe77d64f09f3318d8a2b6ef1dcba4f	7
0x6ca49757027ab16f05417dea23c446ae401ef590b8543ef6ce00f11d5461408f000000000000000000000000444efcb9f92ff3f5a003144342e5ed49585d332d0000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000012000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000002000000000000000000000000961a98999f14e8c5e69bdd4ee0826d6e0c556a0d000000000000000000000000000000000000000000000000000000000002c1d400000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002386f26fc10000000000000000000000000000abb4f853f36860af385fba4fb8729dbbc48460e7	[“0x9d9af8e38d66c62e2c12f0225249fd9d721c54b83f48d9352c97c6cacdcb6f31”,“0x000000000000000000000000abb4f853f36860af385fba4fb8729dbbc48460e7”,“0x00000000000000000000000010a8c9065692dffd48df1935e67a2744667fd9d0”]	0x00000000000000adc04c56bf30ac9d3c0aaf14dc	false	3	0x23fc27578a2191f24fba71a4ea42b054698b2c9bd934c62600f8fc4249badc5b	10938902	2023-12-16T02:10:25.000Z	0xed4ff5a8834daf311c25c9651346cec764ff4d65cf23bb9d80ed74944690bbac	3
0x28b76c2fe3cda86118077f2754ce92d91c7162c9149b493d110ead204f87dea8000000000000000000000000444efcb9f92ff3f5a003144342e5ed49585d332d0000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000012000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000002000000000000000000000000961a98999f14e8c5e69bdd4ee0826d6e0c556a0d000000000000000000000000000000000000000000000000000000000002c87600000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002386f26fc10000000000000000000000000000abb4f853f36860af385fba4fb8729dbbc48460e7	[“0x9d9af8e38d66c62e2c12f0225249fd9d721c54b83f48d9352c97c6cacdcb6f31”,“0x000000000000000000000000abb4f853f36860af385fba4fb8729dbbc48460e7”,“0x00000000000000000000000010a8c9065692dffd48df1935e67a2744667fd9d0”]	0x00000000000000adc04c56bf30ac9d3c0aaf14dc	false	19	0xe988f069d265ff228cae6cde0ae0360b1400338b66db1f1e9dda57cf81128dcb	10938916	2023-12-16T02:10:39.000Z	0x70e925727c020d1b4b3667e2f154e66a6153ab8ae612b2f89ca655770d0da59a	13

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.opbnb.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`	`NUMERIC`	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
52441	0x	13794417090333701	true	CALL_0x1e7908c7380dd7478d611fe531becc6257043453da005fecb19b80730ebee4ce_6	0xa108799c49c550c6d1b7ece6c032b648c0947cb2	CALL	1855918	0xb3a737c3940287abbfd831086f0f24868d3e6fc4	6	2023-09-01T23:07:21.000Z	0x1e7908c7380dd7478d611fe531becc6257043453da005fecb19b80730ebee4ce	1
2383	0x	2500000000000000	true	CALL_0x393363c3a70c86835819b04bc2d4a5add9ade2972ae28bc4530a6994321a75f4_0	0xa784022d7bf0d91a01bbbeee21cf647e2f5df28e	CALL	1832267	0xf0f5b8c7cf0a7b33f4e712c10e684d8d560feb7c	0	2023-09-01T16:33:10.000Z	0x393363c3a70c86835819b04bc2d4a5add9ade2972ae28bc4530a6994321a75f4	1
98072	0x	2500000000000000	true	CALL_0x51cacd89a15735cb36bdba852f6d0043283d4620e43379490ccb5d1d72e0ada4_0	0xa784022d7bf0d91a01bbbeee21cf647e2f5df28e	CALL	1829874	0xf0f5b8c7cf0a7b33f4e712c10e684d8d560feb7c	0	2023-09-01T15:53:17.000Z	0x51cacd89a15735cb36bdba852f6d0043283d4620e43379490ccb5d1d72e0ada4	2

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.opbnb.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	v	gas	input	nonce	chain_id	gas_price	block_hash	to_address	access_list	block_number	from_address	receipt_l1_fee	receipt_status	block_timestamp	receipt_gas_used	transaction_hash	transaction_index	receipt_logs_bloom	receipt_l1_gas_used	receipt_l1_gas_price	receipt_l1_fee_scalar	receipt_transaction_index	receipt_cumulative_gas_used	receipt_effective_gas_price
0x77aef98782b55c66f922d83ed12069e73550a84e432842c73616c6efa384b3b5	0x6c6bc048e7962ae2e3b250d4af9699020c0990c983cd380501d34becbe59084a	444	367187	0x57b5daac0000000000000000000000004200000000000000000000000000000000000006000000000000000000000000000000000000000000000000000e35fa931a00000000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000025600000000000000000000000000000000000000000000000000000000000000005decdadf750b87984dcf2f004c1cc71997193dc6000104455431f1000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000020000000000000000000000000f5c49144812c14de191f358328c0f1f3e5858e320000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000000200000000000000000000000042000000000000000000000000000000000000060000000000000000000000009e5aac1ba1a2e6aed6b32689dfcf62a509ca96f35decdadf750b87984dcf2f004c1cc71997193dc6000104455431f1000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000002000000000000000000000000089536aa99263927c3ba720d20a9ac56b958b74e1000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000020000000000000000000000009e5aac1ba1a2e6aed6b32689dfcf62a509ca96f3000000000000000000000000420000000000000000000000000000000000000600000000000000000000	252	204	16	0xca78b0707b6d33eb89d37f241185411515858b88762a247f3e5ea5a9da499b07	0x862d72ec947b0054c6c98cced4c140a05b9ec8db	[{“address”:null,“storage_keys”:[]}]	3677073	0xf7faff5c982ce9049bd13f3a82fe2aa429ed45df	42860751621888	true	2023-09-23T00:59:56.000Z	293376	0xae71b087c11ca5cea5f7de3d7e5f6b250c46b7f8dc0882c16bf5a8dc9e2cb247	1	0x00200000000000000000000080001000000802000000000001040000000000000000000000000000000000100000000020000000000200000000020000200800088000000000000000010008000040a00000000000000000000000000000000000000004100000000000000000042000000000000000000000000010000000000000000000000000000000000008000000000000002000080000004000088000020000000008000000000000000000000000000000000000000000000000000800000002000000000000000008000000000000400000001000000008008000000010000200000000000000000000000000000000000000000000000000000000	8608	4979176536	1	1	357401	16
0x3bcfdc311eee4fb79a3d7a03976ba53c03a5ff2491a68302146ff2f2ae561ea4	0xbd1ba01038ed13881d0e6a21ed7ce9e7802a986b4d0927489f614a027c72be2	444	10000000	0xcbc14e02f03a19d275ef62f05e5deb963859462c01e164c910f6d51973935d202d31f3fa8e3fb7c680fd01e0	537	204	5000000	0xc352817f58156aff76661897b4577db37a9ce4f64d5412a80f5ce5ca9f5be624	0x81d70ef88511d5c6552249f9bde184a8cf4ff1ce	[{“address”:null,“storage_keys”:[]}]	3753955	0xc3f38c378b994b0e75227cb5d1787ff78c467558	16839120826040	true	2023-09-23T22:21:18.000Z	163584	0xfbe139e62627547c1b9c242023a2b0bd01f28a811407fb64abefcc76c1f3bc07	1	0x00200000000000000000000080000000000800000000000001040001000000000000000000000000000000100000000020000000000200000000000000000800008000000000000000000808000000a08000000000000000000000000000000000000000100000000000000000000000000000000000000000000010000000000000000000200000000000000000000000028000002000080000004000008000400000000000000000000000000000000000000000010000000000000000000000000002080000000000000000400000000000000000001000000000000000000000000000000000000000800000000020000000000000000000000000000000	4484	3755379310	1	1	214085	5000000
0x4e3197e032d1df5db94518417dea8d789723324bae4f8e1094a0dba5a3c313ad	0x45f69e4246d41492ceca1f6e5b3960e7f6595783efc24d1cb9c1e61d20787b6a	443	574430	0x78343aed00000000000000000000000000000000000000000000000796e3ea3f8ab00000000000000000000000000000365a176fec4214dc6b34852ba9ba83c1525097d100000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000001cadc35d7118000000000000000000000000000000000000000000000000000000000000016ea000000000000000000000000000000000000000000000000000000000000001bc8857e423640efda6a7e880515e241c7a8f6a3cd260d3c7d9eb8ec0d4260c0071bc1e07d0ec2e8f273bf441fbf96451381bb2a6c95f0b1719cc4945dd3dd01830000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000e04f000000000000000000000000000000000000000000000000000000000000e04e000000000000000000000000000000000000000000000000000000000000e04c000000000000000000000000000000000000000000000000000000000000e045	3861	204	1000000	0x783e11fb24de546c031536affafbc292cc7b07a2f435a4798929b4d26f33d933	0x8a2d6f2264354f3200c73aad7a7f0e475e48a89d	[{“address”:null,“storage_keys”:[]}]	3685833	0x365a176fec4214dc6b34852ba9ba83c1525097d1	26981023906188	true	2023-09-23T03:25:56.000Z	425984	0xffc531f87bc6bb691e10acea1ac25ee162c6d557cba0468dd713295fa9d95314	1	0x000080000000000000000000000000000000100000000018000000000600000000000000010000000000000000000000000000000000000000000200002000000000000000000400000000480120000000000000000000000000000000000000000000000a0000000000000000000800080000000400000210000010000000000000000100000000040000000000000002004000000000000000000000200000020000040000004400000100000100800000000800000000000000000000000000000002000000000000200000000000000006200000000000000000000020000010400809000000000001000000000000004000004000000000020000000000	6876	3923941813	1	1	472897	1000000

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.opbnb.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