berachain

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

Sample Data

size	miner	nonce	number	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
779	0x03daa833f0994d877a52d3841975c685d131ec7c	0x0000000000000000	1977870	5251645	0x36f9d8ad3a237a6ff3f7af2d33e1b8f0e862310bee2870159d53213fe81c8ea4	30000000	2025-03-06T11:35:27.000Z	0x14264618cd5dca0c7d7749a8a24f32c8e64de70453923b6896df3b2e60ee96e3	0xd883010e0d846765746888676f312e32332e34856c696e7578	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0xaa197e78b71b693dba8190df4b6bfca89777b86b9974ba4b927065967d408391	0x10a7156e212f89809472ee0b35682911c1d174d6bd76c00bf2b996dcad42f6a2	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xd7d5ac0af61372e22aa2d9a7797276bd922887477e640b19a42f4747e18077a4	9	0xdaaca84d096cebe9194d542b918abce37bc8e2d9cc85d5be4d6a9c947552a6ef	1	0x80f83682336dae7c54fa7ca0c5ba26e9fe574606f328964558658cc534d4d042	0x0a082bc85e3b02dfcc7e2362246e51aa396798f3c24c25faf7bc6b95bc900e17
779	0x03daa833f0994d877a52d3841975c685d131ec7c	0x0000000000000000	1999816	2523362	0xd790db9fd5bf35125e396ad253f35541639a3e5fe40023e6b6ada10431d50bd8	30000000	2025-03-06T23:21:44.000Z	0x5469e4af7feea98771a6fadb0e91f80e195708261addb2a75c3614ed8649a52f	0xd883010e0d846765746888676f312e32332e34856c696e7578	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x6b30d8874ec0e96316d6462958d8dd49e3dfebd467a8b8770f33d3f3200aaa05	0x2192f2bb4b6d4354d2ab5f49cec4857dc44d93673a1cb0b149c16bb16782f7e9	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x717683955f704dca51731fb7840a2a7d6c84987e915422395abd944908c79998	10	0xdaaca84d096cebe9194d542b918abce37bc8e2d9cc85d5be4d6a9c947552a6ef	1	0xe1f026ef6186ea6e9959c0b56152a4c9a1848d17cc4e60997e222c56e334e1e1	0x1d5bd7904b1d5942ce7864bf937cf473f845f808826bfadbbe0e61c7e7efd194
902	0x03daa833f0994d877a52d3841975c685d131ec7c	0x0000000000000000	1971684	1387567	0x96f26118de75b549fa8a395cb9cd427090ac020d8b39d2a4b3d087f7511b69b1	30000000	2025-03-06T08:15:38.000Z	0x95613288b6b29d3c55dc050b19ce42c7e7910f493f064f813050a50501626445	0xd883010e0d846765746888676f312e32332e34856c696e7578	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x7234ef0b95e253f00d84b4a528689e602ef1ea09e022b34c6f6c3694826c8d73	0x4b8c64b0eff4f834fe87a9248a62108b8a353a8e8adcd1f3cedb30143979fa33	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xf40d66334efb2e6a087c587640988264fa99fe9b14513d7745a937df1e33b60c	156	0xdaaca84d096cebe9194d542b918abce37bc8e2d9cc85d5be4d6a9c947552a6ef	2	0x1736dd6649506d24722f65a19a9feb90f028e11bc4b46127eac63248c3c61fc0	0xc0188d20b79103722ef6601a0ce245b3f96bd4b854ba1908bfdd9f9f64fc93f7

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.berachain.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.
`address`	`STRING`	Contract address that emitted the event log. Hex-encoded, 0x-prefixed, 42-character string.
`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.
`data`	`STRING`	ABI-encoded event or transaction data. Hex-encoded string including 0x prefix.
`block_hash`	`STRING`	Unique identifier for the block. 66-character hex string including 0x prefix.
`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.
`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.
`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
0x000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000008bf3776fc66c4da9cc19d9afc81ccac55e1805bc000000000000000000000000fcd03e33391e6e7b4a148f53f43a672879764c820000000000000000000000000000000000000000000000000026eae5f8da5f4e0000000000000000000000000000000000000000000000025cf530df0125a000	[“0x92ceb067a9883c85aba061e46b9edf505a0d6e81927c4b966ebed543a5221787”]	0xe59d098c36916397cc14ab42bb0f00093bda9f04	false	86	0x0001a404032d3518faa4e474b7bbbc79189044ba84e96fea87080c266061d95b	5643445	2025-05-29T03:07:24.000Z	0x226f0664cc995879661268c7a8f676d11fe969c2a29112d5d671e0f3a7715a95	12
0x0000000000000000000000000000000000000000000000000c69407ba6a1c9b2	[“0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef”,“0x000000000000000000000000802b65b5d9016621e66003aed0b16615093f328b”,“0x000000000000000000000000a6956e09a67c9e0d70dc47d6eb438e134823c439”]	0x6969696969696969696969696969696969696969	false	14	0x0003a731773a9018e25ff948484aa5f8c15f5ab86c764f328f5b5f1ce27ff16e	5646080	2025-05-29T04:34:22.000Z	0x707e610216e58bdeb87a398e9a479dff66639554edc55d4592eaa9432b727337	4
0x00000000000000000000000000000035a02cf6ad7900f6c6843e5b76ac764b8e	[“0xde88a922e0d3b88b24e9623efeb464919c6bf9f66857a65e2bfcf2ce87a9433d”]	0x39b08ccbdfd9b0d3c45f1fd02e9b57b44c88ed71	false	61	0x0003a731773a9018e25ff948484aa5f8c15f5ab86c764f328f5b5f1ce27ff16e	5646080	2025-05-29T04:34:22.000Z	0x88b9ff7c3bc3df653faec39df03f9aad79da41d49cbcd82274825edc217d630a	7

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.berachain.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`	`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	gas_used	trace_id	to_address	trace_type	block_number	from_address	block_timestamp	transaction_hash	transaction_index
21000	0x	0	true	21000	CALL_0xc6707617d422e33040d4609ecd1d109b783d31c20b2c7c1efe13e358971282b2_	0xc1e98de47ae70b84cc8ca49df80295142710178e	CALL	4570003	0xc1e98de47ae70b84cc8ca49df80295142710178e	2025-05-04T15:33:37.000Z	0xc6707617d422e33040d4609ecd1d109b783d31c20b2c7c1efe13e358971282b2	21
21000	0x	0	true	21000	CALL_0x86cb9ff722bc88f3a3b001b25a7ac769cf057cea6d618da4de4757c10cef93ee_	0x2961c20f9ef2c5def3b2ab7c1c49f90e71b4319d	CALL	4584720	0x2961c20f9ef2c5def3b2ab7c1c49f90e71b4319d	2025-05-04T23:45:43.000Z	0x86cb9ff722bc88f3a3b001b25a7ac769cf057cea6d618da4de4757c10cef93ee	28
42000	0x	3320100000000000000	true	21000	CALL_0xd6cee374469d52ffd0ad75bfc3c5bd895e4b3d9f870a6ea41ab1fefa8fac1632_	0xc4553c71768654733481c7ec5d189254704be0f3	CALL	4553786	0x305833cadd13a6d7febc6619304a6943a9a1ed22	2025-05-04T06:32:06.000Z	0xd6cee374469d52ffd0ad75bfc3c5bd895e4b3d9f870a6ea41ab1fefa8fac1632	23

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.berachain.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.
`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.
`chain_id`	`INT64`	Numeric identifier for the blockchain network. Integer value that uniquely identifies the blockchain according to EIP-155 chain ID standard.
`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.
`gas`	`INT64`	Maximum gas units allocated for the transaction execution.
`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.
`to_address`	`STRING`	Address receiving the transaction or internal operation. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`STRING`	Amount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
`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.
`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.
`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.
`v`	`INT64`	ECDSA signature component v from the transaction signature. Integer value used for signature verification and public key recovery.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.
`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.
`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).
`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`	`NUMERIC`	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.
`receipt_type`	`INT64`	Transaction encoding format identifier from EIP-2718. Integer value indicating the transaction type returned in the receipt.
`receipt_status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true indicates successful execution and false indicates failure.
`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_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.
`receipt_gas_used`	`INT64`	Gas units consumed by this specific transaction.
`receipt_effective_gas_price`	`INT64`	Actual gas price paid per unit for transaction execution. Integer value denominated in wei.
`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.

Sample Data

r	s	gas	input	nonce	value	chain_id	gas_price	block_hash	to_address	block_number	from_address	receipt_type	receipt_status	block_timestamp	max_fee_per_gas	receipt_gas_used	transaction_hash	transaction_type	transaction_index	receipt_logs_bloom	blob_versioned_hashes	max_priority_fee_per_gas	receipt_transaction_index	receipt_cumulative_gas_used	receipt_effective_gas_price
0xa725994673906de1e1761da10902d83e8d8e6ead9659caf68c4d254e208ddd5	0x7215cf793c39934ea5542d323064bd7d29207fddd3f336c6e2d6e2955fcedd85	1000000	0x	32976	1173150000000000000000	80094	60100000000	0x08ec2f4f310f0eee42fb8d2f0f091f0810c303205ccec9b74c6d87a04db58140	0x7d585bdc88a12275d6f3f388a0d2234ecd04854d	3674181	0x6c6b81083498cfa033b8ac20e36e4a98abe44f30	2	true	2025-04-14T02:31:28.000Z	60100000000	21000	0x9e47ca00cf7908c9f46acf421653dfdbd6a63fad2f972905f4514cf38add9d49	2	0	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	[]	60100000000	0	21000	60100000000
0xe4ce178ec816fb1ef0da4caa3acc91a48060d3b225c3e6625a76f933cbc190b4	0x7d531e6e30cf64c2dfe530373498412e1875d7462e5bfbe413e83a7cdf1046ea	101324	0x	549167	0	80094	833	0x8f75e3baff7818d0f3544adc1c8e736ad1af5be9b3f7d91c73d4a2de0c36df3b	0x82a53a111a1f798230ebeb9f3b45e9c39ca2204d	3704221	0x82a53a111a1f798230ebeb9f3b45e9c39ca2204d	2	true	2025-04-14T19:07:06.000Z	1520	21000	0xe1f01fd7991c7fb2fba5bfe0f4e4233ca8f3febcf8c40eab50510196f2761214	2	17	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	[]	50	17	13465514	833
0xb6f65ae05ba8266ea81808f2d6d39b0e118215917a34e2ae0a5431a13ec46180	0x5ed0472fc51de3c9f3286e99a9d600422cea909c7889a30ad83083d7857ad5e6	110687	0x	355184	0	80094	906340	0x2cf0f882d04d8067ee16a57f6a0807e783e88ec25001be28f34a023f85b95f71	0xe2bc6dd0ce239460e3ebe90b27b72404406b7c1e	3694275	0xe2bc6dd0ce239460e3ebe90b27b72404406b7c1e	2	true	2025-04-14T13:42:30.000Z	1868306	21000	0x5f4e38e282569e48fe136d04d1cf6664e1fc59a3b463874a5d86e06db74fcb42	2	18	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	[]	50	18	9905871	906340

Example Query

Query with partition filter

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