celo

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.
`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.
`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.
`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.
`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.
`size`	`INT64`	Block size in bytes. Represents the total serialized size of the block data structure.
`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.
`epochSnarkData`	`STRUCT<bitmap STRING, signature STRING>`	Celo-specific cryptographic proof data used for epoch transitions and validator set changes. Null for most blocks; populated only at epoch boundaries.
`randomness`	`STRUCT<committed STRING, revealed STRING>`	Celo-specific randomness values used for validator selection and other on-chain operations requiring cryptographic randomness. Contains both the committed hash from the previous block and the revealed value for the current block.
`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.
`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.
`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_beacon_block_root`	`STRING`	Root hash of the parent beacon chain block for post-merge consensus verification. 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.
`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.
`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.
`transactions_root`	`STRING`	Merkle root hash of all transactions included in the block. 66-character hex string including 0x prefix.
`withdrawals_root`	`STRING`	Merkle root hash of all validator withdrawals in the block. 66-character hex string including 0x prefix.

Sample Data

size	miner	number	gas_used	gas_limit	timestamp	block_hash	extra_data	logs_bloom	randomness	state_root	parent_hash	receipts_root	base_fee_per_gas	total_difficulty	transaction_count	transactions_root
852	0x2d2c321a47eda8b1d9b43c2a6d5e978b60bcd0b1	9127796	327268	20000000	2021-10-02T23:04:21.000Z	0x92339170f2b0d91e505e3038ce85dede3b3aaff420f541f1a5f615b05e31b8ac	0xd883010302846765746888676f312e31362e34856c696e757800000000000000f8ccc0c080b841c040294ea97c53e4dfb3cb8f30c6fa6fdc5b26add010f06da7c51277a7ecb41729f9b313019c58ccd180f96d9ea63cdae597fc327dc5b9b00efa029b996baf1201f8418e1579bbbfd7588f17e5feedbf1cbfb0f04f03bac16ab2b9c0aef78868973596bed0a4af76c77b4f635a18111342d6236cb2474f8f7f687dfbf399af7b722f0180f8418e1fffffffffffffffffffffffffffb09bddd9052f1dd28389046edf054e75e3b7700cc59dfa8df773c79884a48078a33134cd894485fe895620a3459fe4020080	0x00000000000200000000000080000000000800000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000002000200000a04003000000000000000000000000000000000000004000000020404000000000000000800000000000000000000000000000040001000204880000000000000000000000008000000000000080000000000000000000000000000000000000000000008000000000000000000000000800000000000000000000000000000000000000080080000000000001000000000400000000000080000000080000000000000400000000000000000000000000000000000	{“revealed”:“0x008955932041d46f062d082ce920bf135e9e3bafecaf0e9277b1958f852aa9b0”,“committed”:“0x9dd8f57c522f96886892d41b3fcf1c6483c2e79b75386ebfdb0abf1cfb67c314”}	0xe53c5af4f39868ab3a7ec4448d276984a2bea42729cfcce8a526ce068431397c	0xd31304eb45a63de62bf7095b2e0c9bc464a575e95fe6334448e2e0143c75c1aa	0x6933a16269d26f63db4cbf10ac83d70cb54e69d1f1718e47014ab9b7961ec5de	100000000	9127797	1	0x753c86492b30c26c195a2038935d669d75b8b9b0477ff5494e91b4e94e14c9d2
852	0xdff75a3b93fd9ead6922ca5269c2db0a104d3d05	9127768	327268	20000000	2021-10-02T23:02:01.000Z	0x466501990af94963abc18590a423afcaa2c87552e46226d1f23a5faf4af870d6	0xd883010302846765746888676f312e31362e34856c696e757800000000000000f8ccc0c080b841e3e48f355e4e1ddae215d9ecceacd1c78299b47136e1082d7166f5cc9d0c68427357ad12aed76302da2ee754338735f607bb62fc0258c7b121a9e75c1b17dc4e00f8418e377bf99dfd5d6677649def1f8cfeb04b5213d7f70688d2050b52204c727f843c477668adb38b12353273d076a5651a57a1c4fb0849a9410e11c7dde8d08a8180f8418e3fffffffffffffffffffffffffffb0075405e427375b84c76119ecc6bab71e0a07fb346b1d5cbd074ab15bab802340a865353b17868b37451aeaabd7f15a8080	0x00000000000200000000000080000000000800000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000002000200000a04003000000000000000000000000000000000000004000000020404000000000000000800000000000000000000000000000040001000204880000000000000000000000008000000000000080000000000000000000000000000000000000000000008000000000000000000000000800000000000000000000000000000000000000080080000000000001000000000400000000000080000000080000000000000400000000000000000000000000000000000	{“revealed”:“0x0934b8fd3694718ab73130c7e0ddda96eb8868016c26a55f6a04d250766bbb5c”,“committed”:“0xbcf329de5e76f2501d38c6813b1d801dedf1537fcf4757f0d31f9dc84803a5ba”}	0xd45931439769cbf429391e6fa21d31eb14878cb8c5e968e70d2d4ab4b4e672a2	0x3ad68edc609a42f63d434b29f8cf09d5cab7c62ee9703402d6677f331a8775be	0x36153ab59d96f288f36b923f75580b3bbd2fd99efe34e4bb503555e60ae48700	100000000	9127769	1	0x9ed4eb325f7010f9a47793c94e43723a6b1dc6b9d8309d37608caa443fa6c830
1097	0x03de9dfa6c808e96bd8b99c2208fcdc18fb94df1	9124787	503715	20000000	2021-10-02T18:53:36.000Z	0xd3a40c1d29edcca368d1f35cae05a3d763be94557d3ea3171785538f2c93423f	0xd883010302846765746888676f312e31362e38856c696e757800000000000000f8ccc0c080b84134cb1dfab70fef42ad217653f8b3a068f0a8833d7f8300fcf80213f51b31940503de030d7cba9be366025bc5be74e64d9173ccca444c7050f08f69dfb27d384801f8418e176bfbd97f1def7f20bf97d51b7bb09e4133b76e5c408b07aa5476fd6a903ab4edce6dd08701d546e679968f763c549d3bda1ff3ce95c38a5bb4966a82098180f8418e3fffffffffffffffffffffffffffb05e2c020e3539fbf07f42f315988f5c90aba2d15d6785e7298e7490f5e18137f785c7ae102c26338c21ece1e3484c018080	0x00800000000200000000200080000000000820000000000000000000000000000000000000000000000000000000000800400000000000000000000000000000000000000002000200000a04003000000000000000000000000000000000000004000000020404000000400000008c00000000000000000000000000000040001000204880000000001000000000000808000000000000080000000000000000000000000000000100000000000008000000000000000000000000800000000000000000200000000000000000000080080000000000001000000000400000000000080000000080000000000000400000000000000000000000000000000000	{“revealed”:“0xfc403f90ef34891c2088b8c48fca940665a144e2f7fd11a5eaabda8f833d16f5”,“committed”:“0x688c34467312891d3678500c5f893fbb4fe3d7a2736e1070bdb82438dc852245”}	0x18e9875047b8c61d32b3e72322a0f3e98f47503ff8be56d26fe4978579c32fcc	0x1dd4a1fd48879401d51eeee351f161971b99eba4736e08873c1d0fc3306a1aee	0x5191332e900885632dac4dfe7bc79eda3efb096c61b1e7f834be9ab578e49379	100000000	9124788	2	0x491d9c4375131eaa92a91539dc55ecb84d1563b01bba49575f10873d4474b018

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.celo.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.
`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.
`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.
`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.
`address`	`STRING`	Contract address that emitted the event log. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

data	topics	address	removed	log_index	block_hash	block_number	block_timestamp	transaction_hash	transaction_index
0xbee6374645a755d2b44c372bb353c121a8826d9c909efb84ce9588d0f4482a20bee6374645a755d2b44c372bb353c121a8826d9c909efb84ce9588d0f4482a200000000000000000000000000000000000000000000000000000000000000005	[“0x74bbc026808dcba59692d6a8bb20596849ca718e10e2432c6cdf48af865bc5d9”,“0x0000000000000000000000000000000000000000000000000000000000000091”,“0x000000000000000000000000071c3f1bc3046c693c3abbc03a87ca9a30e43be2”]	0x377530cda84dfb2673bf4d145dcf0c4d7fdcb5b6	false	4	0xa77ac5190480065d5366dfff607c1ce117626ef9ffa8bb5129adeaa59ddbf874	20013866	2023-06-26T00:00:02.000Z	0x7616b542b3bb3b969950a4f55216ffd81ae4c92f542faa2477a1b70bc73ad49a	2
0xb78ee83d0560b4f4340fb8b6e7ef111eface90e2d4501fd042d53de55774b3b2b78ee83d0560b4f4340fb8b6e7ef111eface90e2d4501fd042d53de55774b3b20000000000000000000000000000000000000000000000000000000000000005	[“0x74bbc026808dcba59692d6a8bb20596849ca718e10e2432c6cdf48af865bc5d9”,“0x0000000000000000000000000000000000000000000000000000000000000091”,“0x000000000000000000000000071c3f1bc3046c693c3abbc03a87ca9a30e43be2”]	0x377530cda84dfb2673bf4d145dcf0c4d7fdcb5b6	false	0	0xa77ac5190480065d5366dfff607c1ce117626ef9ffa8bb5129adeaa59ddbf874	20013866	2023-06-26T00:00:02.000Z	0x145ef18e23b32f10d9ce40abad1ef2cb42cef345c126d74539d2b1d258f5289a	0
0x000000000000000000000000000000000000000000000001bab39a75c1ddd862	[“0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef”,“0x00000000000000000000000043d72ff17701b2da814620735c39c620ce0ea4a1”,“0x000000000000000000000000528380849e7780d13a6aeb5d013d895835c2003f”]	0x62b8b11039fcfe5ab0c56e502b1c372a3d2a9c7a	false	9	0xa77ac5190480065d5366dfff607c1ce117626ef9ffa8bb5129adeaa59ddbf874	20013866	2023-06-26T00:00:02.000Z	0xa797217f96b38eb21d1e1354b72d49cdfcb9887c035463400fdb413f2fe467f4	4

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.celo.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
`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.
`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.
`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.
`error`	`STRING`	Error message returned when transaction execution fails. Empty when execution succeeds.
`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.
`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`	`FLOAT64`	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.
`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.
`gas`	`INT64`	Maximum gas units allocated for the transaction execution.
`gas_used`	`NUMERIC`	Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer indicating the sequential order of transactions in the block.
`revert_reason`	`STRING`	Human-readable explanation for why a transaction or call reverted during execution. Empty when execution succeeds.
`status`	`BOOL`	Success indicator for the operation. Boolean value where true indicates successful execution and false indicates failure.

Sample Data

input	value	output	status	trace_id	to_address	trace_type	block_number	from_address	block_timestamp	transaction_hash
0x	20000000000000000	0x	true	CALL_0x6c6d34f573339710151f86dc1787bd01017710c59e4f85ec7f1960b53af7e926_0	0x22c996765babb6b2201ca0e93bf4bd58a89879d6	CALL	26628141	0x117cb4dc467db53cd2301ed07fc4afe069fdc560	2024-07-12T19:25:05.000Z	0x6c6d34f573339710151f86dc1787bd01017710c59e4f85ec7f1960b53af7e926
0x	3355811593400941000	0x	true	CALL_0x1e7884ef8f7e5b0b7a245009954577940b3fc594610f81f6ae634a529ac561f5_0	0x2a36cce700d1f242901c3b200c465480b833195c	CALL	26625837	0xb1456be86083864d696f65ba33f01044490e9ba4	2024-07-12T16:13:04.000Z	0x1e7884ef8f7e5b0b7a245009954577940b3fc594610f81f6ae634a529ac561f5
0x	182218888000000000	0x	true	CALL_0xe38b211a771b06cb86c7c506212837a3b85dc89f7bcec40cb867ef4d94c6b699_0	0x5b6310da7720a9fefad9ed1fe3ed78047e011473	CALL	26626549	0x733b7f8acc311a5feeac1ac19c528757d5c280c3	2024-07-12T17:12:24.000Z	0xe38b211a771b06cb86c7c506212837a3b85dc89f7bcec40cb867ef4d94c6b699

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.celo.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
`chain_id`	`INT64`	Numeric identifier for the blockchain network. Integer value that uniquely identifies the blockchain according to EIP-155 chain ID standard.
`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.
`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.
`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.
`gateway_fee`	`NUMERIC`	Fee paid to the payment gateway for processing this transaction, denominated in the fee currency. Typically zero for standard transactions; non-zero when using Celo’s payment gateway infrastructure for fiat on-ramps.
`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.
`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.
`mint`	`NUMERIC`	Amount of native currency minted and credited to the transaction sender. Denominated in the smallest unit of the blockchain’s native currency.
`value`	`STRING`	Amount transferred in the transaction or operation. Denominated in the smallest unit of the blockchain’s native currency.
`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.
`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.
`eth_compatible`	`BOOL`	Indicates whether transaction uses standard Ethereum formatting and signature scheme. False for Celo-native transactions that support alternative fee currencies or gateway fees.
`fee_currency`	`STRING`	Alternative token address used to pay transaction fees on Celo, enabling gas payment in stablecoins instead of native CELO. Null when fees are paid in native CELO (most common case).
`gateway_fee_recipient`	`STRING`	Address that receives the gateway fee paid for this transaction. Celo-specific field, typically null when no gateway fee is charged.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`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.
`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.
`v`	`INT64`	ECDSA signature component v from the transaction signature. Integer value used for signature verification and public key recovery.
`source_hash`	`STRING`	Unique identifier for Layer 2 deposit transactions originating from Layer 1. 66-character hex string including 0x prefix.
`receipt_status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true indicates successful execution and false indicates failure.
`receipt_base_fee`	`INT64`	Base fee per gas unit for the block in which this transaction was included, denominated in wei. This field is null for pre-EIP-1559 transactions on Celo.
`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_l1_blob_base_fee`	`INT64`	Base fee per gas unit for EIP-4844 blob data on Layer 1. Denominated in wei.
`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_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_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_base_fee_scalar`	`NUMERIC`	Scaling factor applied to the Layer 1 base fee component in Layer 2 transaction fee calculations.
`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_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_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_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	value	gas_price	block_hash	to_address	block_number	from_address	eth_compatible	receipt_status	block_timestamp	receipt_gas_used	transaction_hash	transaction_index	receipt_logs_bloom	receipt_transaction_index	receipt_cumulative_gas_used	receipt_effective_gas_price
0x38f0569aaad998156a8847e618b826b91d47431d8195b6d28946460312a23633	0x48dbe608f56c823de3070009cc54cf1ded3b59637c1a6e4ae93e5d85d226f874	84475	21000	0x	22162	14105279400000000000	11000000000	0x618a6baaf1ee176f39f6ca3fa81ccf0d71bada607bea1ddd85e0129886f35ea2	0x7db8fe77310d0c0b77abee1301216a93e8b347ec	23822804	0xd1d8042ad72c1e22320708e1553f2dd09ca96fba	true	true	2024-02-01T10:39:17.000Z	21000	0xc36abbbc1f13f6cf6c9fdfaf18967752abb70b972f3226b24fef67239c7db14a	35	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	35	2870298	11000000000
0x3af6dd1b71b74d318f40c06352aea0525a4972a5f52fc646073faf28d72754f0	0x59a7607aaaf7bbddec8b2459c95510368b604490bba063a12c3e6fa9b3a100af	84476	21000	0x	1	1955429307292385189	7575000000	0xd9733470a8b9890ce4d00e7a6c21f1d6b62e1c67d05bc53a19eed4bfc7ac388b	0x41af694bc32e4c0c01cf28264ffdf31fe58310a0	23821136	0x4f925613da46472a7bf19be94d5398198e03c080	true	true	2024-02-01T08:20:17.000Z	21000	0x50dd3ae5a00245b3bb5f25c348d2198b26ba2fe282fb0ccf8395528ddc4476a1	33	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	33	3705779	7575000000
0xb974aa4a384abce42202a8845a328dc50b875aa3e594ade4c8d4506306a69cfc	0x6b78273dff19d0baf2e7f143e2c20b19c9b2389ee168236cbd846fc44257826c	84476	21000	0x	0	55578380000000000000	10000000000	0xa89dc2e1f001d0956c16b310063aa3ee8a3c09a98af307c0f176fa9af8afc05d	0x0d0707963952f2fba59dd06f2b425ace40b492fe	23822589	0x11ac527c28cd588c2f94e261e7602a265ba49929	false	true	2024-02-01T10:21:22.000Z	21000	0xf0dc3a0b7faafebfcc7c19b296b61bcfbb0a1af7fa65c0702368e31756093923	32	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	32	3127504	10000000000

Example Query

Query with partition filter

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