gravityalpha

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

Sample Data

size	miner	nonce	number	uncles	gas_used	mix_hash	gas_limit	send_root	timestamp	block_hash	difficulty	extra_data	logs_bloom	send_count	state_root	parent_hash	sha3_uncles	withdrawals	receipts_root	l1_block_number	base_fee_per_gas	total_difficulty	transaction_count	transactions_root
874	0xa4b000000000000000000073657175656e636572	0x0000000000000022	8847	[]	44504	0x00000000000000020000000001343a9600000000000000140000000000000000	1125899906842624	0x66ebeb4df5c6cd5dbf4efa57ab8b4a7b78157d08ab725382b5ec0c5df8378991	2024-06-29T21:40:52.000Z	0xe65b7dc8641be243a7e413458cb874c75006468d0384d9be78df16a2d02d0a4c	1	0x66ebeb4df5c6cd5dbf4efa57ab8b4a7b78157d08ab725382b5ec0c5df8378991	0x00001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000040000000000000000400000000000000000000000000000000000000000000000000000000010100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000020000000000000000800000001000000000000000000000000200000020000	2	0x7e932409659c5c260164d15d8bc1e31ef089a6a278e201a4fdf0b038c2130715	0xf61a646271d4975fee5fc5ee083ed8263eb2f2c7bcac80948baf4557c84f5e5b	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	[]	0xc37db78e053c2728bf4457ebc6157fcef85184bfe93077679075344954195d3b	20200086	10000000	8848	2	0x725a0aae7799ef1e4572a3791a73d0201925c4a25c392a9d7b3885e5c84222e3
874	0xa4b000000000000000000073657175656e636572	0x0000000000000022	8846	[]	44504	0x00000000000000020000000001343a9600000000000000140000000000000000	1125899906842624	0x66ebeb4df5c6cd5dbf4efa57ab8b4a7b78157d08ab725382b5ec0c5df8378991	2024-06-29T21:40:52.000Z	0xf61a646271d4975fee5fc5ee083ed8263eb2f2c7bcac80948baf4557c84f5e5b	1	0x66ebeb4df5c6cd5dbf4efa57ab8b4a7b78157d08ab725382b5ec0c5df8378991	0x00001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000040000000000000000400000000000000000000000000000000000000000000000000000000010100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000020000000000000000800000001000000000000000000000000200000020000	2	0xc9c718193258abfeee1ab00a3c3150565669d5f10ec4c73d747f477c4541791a	0xb954cfd5c138595bb2a23e68a8a64cb3095379e3b352e0710f4ba35d409a014b	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	[]	0x56709fe1ce21ca3609fe723bb58218518f323a1bd14a4e2ccd168badaabda0e4	20200086	10000000	8847	2	0x85cd3c7d49e5419e8f91716f6a0c4b20bbef5b09fa439c66021416fff0b8ad6f
877	0xa4b000000000000000000073657175656e636572	0x0000000000000022	8475	[]	56756	0x00000000000000020000000001342a3700000000000000140000000000000000	1125899906842624	0x66ebeb4df5c6cd5dbf4efa57ab8b4a7b78157d08ab725382b5ec0c5df8378991	2024-06-29T07:37:00.000Z	0x6321f620cd8a00fe72bbb9f7a3368b9faf640276ddd0174e6c6d27622f24a64b	1	0x66ebeb4df5c6cd5dbf4efa57ab8b4a7b78157d08ab725382b5ec0c5df8378991	0x00000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000002020000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000010000000000000000000100000000000000000000000000000000000000400000000000000000000000040000000000000000000000000004200000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	2	0x2e5a072d14ee2b357243c93ff45bc709e1678ce5783316b881adf0033dbeaa88	0xcda4ca403bb7c435af782dee620c3da053ef6435f92426fd1b58b86cb77b8a14	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	[]	0x733b7af2ee49e46cbc0bf64e4c3a9380d1178a0e447d9c8a55fe1f9e2cae1faa	20195895	10000000	8476	2	0x6dec1c4ded991ff0199418ecc57cb44b4d476b668ce28da7cc41271c640a65db

Example Query

Query with partition filter

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

logs

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

Columns

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

Sample Data

data	topics	address	removed	block_hash	block_number	block_timestamp	transaction_hash	transaction_index
0x	[“0x7c793cced5743dc5f531bbe2bfb5a9fa3f40adef29231e6ab165c08a29e3dd89”,“0x200e374320a16ee86af97c0f36b0492a5b04d14d66244b4a7221b950e9321bcc”]	0x000000000000000000000000000000000000006e	false	0xa5f02699a0fa1934e4c3081c796739535bdfb130bce2fcf4a9c9dedf39dc972e	1101429	2024-08-21T14:02:13.000Z	0x200e374320a16ee86af97c0f36b0492a5b04d14d66244b4a7221b950e9321bcc	1
0x	[“0x7c793cced5743dc5f531bbe2bfb5a9fa3f40adef29231e6ab165c08a29e3dd89”,“0xda141bf0cc82f89d4cdbf85c91c9572d6dc49c03a7392652ac4736742f66fdf7”]	0x000000000000000000000000000000000000006e	false	0xe243f9ec8e95d702c864cb4c99cabc96aeba303d0aa00f0bce9cace19b557bce	1069974	2024-08-21T08:55:10.000Z	0xda141bf0cc82f89d4cdbf85c91c9572d6dc49c03a7392652ac4736742f66fdf7	1
0x	[“0x7c793cced5743dc5f531bbe2bfb5a9fa3f40adef29231e6ab165c08a29e3dd89”,“0x598511b9be601ae8f35c53e4b5504652f390edf7a4cd278c58978615fbc639f0”]	0x000000000000000000000000000000000000006e	false	0xd32a2564d31f161864b2f4eba5a4195078e719ae8533889ba5ee899c64acd8d9	1038044	2024-08-21T03:22:21.000Z	0x598511b9be601ae8f35c53e4b5504652f390edf7a4cd278c58978615fbc639f0	1

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.gravityalpha.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.
`status`	`BOOL`	Success indicator for the operation. Boolean value where true indicates successful execution and false indicates failure.
`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`	`BIGNUMERIC`	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`	`INT64`	Amount of gas consumed by the execution. Measured in gas units, representing the computational resources used to process the operation.
`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.
`before_evm_transfers`	`ARRAY<STRUCT<purpose STRING,` from`STRING,`to `STRING, value STRING>>`	Array of native currency transfers that occurred before the trace operation executed. Each transfer includes a purpose label, source address, destination address, and transfer amount in the smallest unit of the native currency.
`after_evm_transfers`	`ARRAY<STRUCT<purpose STRING,` from`STRING,`to `STRING, value STRING>>`	Array of native currency transfers that occurred after the trace operation executed. Each transfer includes a purpose label, source address, destination address, and transfer amount in the smallest unit of the native currency.

Sample Data

gas	input	status	gas_used	trace_id	to_address	trace_type	block_number	from_address	block_timestamp	transaction_hash	transaction_index	after_evm_transfers	before_evm_transfers
3123321	0x3161b7f60000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000a100000000000000000000000000000000000000000000000a8668649fb691d49d0000000000000000000000000000000000000000000000000000003cb30206490000000000000000000000000000000000000000000000000000000000000010	true	10872	DELEGATECALL_0xc8091b4da2656febbed435d5ed08ca4ceed0b27b1beefbfb8f18830bda6b297c_0	0x4ee2f9b7cf3a68966c370f3eb2c16613d3235245	DELEGATECALL	9656	0x3c2269811836af69497e5f486a85d7316753cf62	2024-07-01T03:45:10.000Z	0xc8091b4da2656febbed435d5ed08ca4ceed0b27b1beefbfb8f18830bda6b297c	7	[]	[]
3123321	0x3161b7f600000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000007300000000000000000000000000000000000000000000001265d2bfe822a33584000000000000000000000000000000000000000000000000000000018d4866ec0000000000000000000000000000000000000000000000000000000000000010	true	10872	DELEGATECALL_0xee9b2979a23b541867bff97aac951975c77955bc6a7113a36220cae287db4000_0	0x4ee2f9b7cf3a68966c370f3eb2c16613d3235245	DELEGATECALL	9757	0x3c2269811836af69497e5f486a85d7316753cf62	2024-07-01T07:25:08.000Z	0xee9b2979a23b541867bff97aac951975c77955bc6a7113a36220cae287db4000	7	[]	[]
3123309	0x3161b7f600000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000010100000000000000000000000000000000000000000007eb3717a5711b2735a08b00000000000000000000000000000000000000000000000000000000023186000000000000000000000000000000000000000000000000000000000000000010	true	10872	DELEGATECALL_0x19831cade2d38a956e7c42f22389249e1186fcff8890d722496857fc1bc01fcb_0	0x4ee2f9b7cf3a68966c370f3eb2c16613d3235245	DELEGATECALL	9861	0x3c2269811836af69497e5f486a85d7316753cf62	2024-07-01T11:05:07.000Z	0x19831cade2d38a956e7c42f22389249e1186fcff8890d722496857fc1bc01fcb	7	[]	[]

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.gravityalpha.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_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.
`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.
`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.
`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.
`beneficiary`	`STRING`	Address designated to receive miner or validator rewards for including this transaction in a block. Null for most transaction types on this chain.
`deposit_value`	`STRING`	Amount of ETH (in wei) deposited from L1 in cross-layer deposit transactions. Null for standard L2 transactions; populated for L1-to-L2 bridge operations.
`l1_base_fee`	`INT64`	Base fee per gas on the L1 (Ethereum mainnet) at the time this L2 transaction was processed. Denominated in wei; null for non-L2 transactions or where L1 data is unavailable.
`ticket_id`	`STRING`	Identifier for cross-chain message tickets in Layer 2 rollup architectures. Null for standard transactions; populated for deposit or withdrawal operations that reference a specific ticket.
`submission_fee_refund`	`STRING`	Fee amount refunded to the submission fee payer for unused gas in cross-chain transactions. Typically populated in layer-2 or rollup transactions when actual execution costs less than the maximum submission fee paid.
`max_submission_fee`	`STRING`	Maximum fee paid to submit the L2 transaction to the L1 chain, used in cross-layer messaging protocols. Null for standard L2 transactions that don’t involve L1 submission.
`max_refund`	`STRING`	Maximum gas refund value for cross-chain transactions on Layer 2 networks. Typically null for standard transactions; populated for bridge deposits and rollup-specific operations.
`refund_to`	`STRING`	Address designated to receive refund for excess submission fees in cross-chain deposit transactions. Null for standard transactions; populated for L1-to-L2 deposits on Arbitrum-based chains.
`request_id`	`STRING`	Unique identifier for retryable transaction requests on Arbitrum-based Layer 2 chains.
`retry_data`	`STRING`	Encoded data payload for cross-chain transaction retries on layer-2 networks. Null for standard transactions and system-level operations like the sampled block attribute updates.
`retry_to`	`STRING`	Address designated to receive any retry attempt for a failed cross-chain transaction, primarily used in Layer 2 rollup architectures. Null for standard transactions and system-level operations as shown in samples.
`retry_value`	`STRING`	Amount of ETH to be transferred with the retry transaction on Arbitrum-based chains. Specified in wei as a string; null for non-retry transactions.
`deposit_receipt_version`	`STRING`	Version identifier for Layer 2 deposit transaction receipts. Integer value used to track the schema or protocol version of deposit receipts.
`mint`	`STRING`	Amount of native currency minted and credited to the transaction sender. Denominated in the smallest unit of the blockchain’s native currency.
`source_hash`	`STRING`	Unique identifier for Layer 2 deposit transactions originating from Layer 1. 66-character hex string including 0x prefix.
`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_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_l1_gas_used`	`INT64`	Gas units consumed on Layer 1 for the transaction on Layer 2 rollup chains.
`receipt_type`	`INT64`	Transaction encoding format identifier from EIP-2718. Integer value indicating the transaction type returned in the receipt.
`receipt_l1_block_number`	`INT64`	Layer 1 block number associated with this transaction on the underlying settlement chain. References the Ethereum mainnet block for cross-chain transaction tracking.
`receipt_deposit_nonce`	`STRING`	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_version`	`STRING`	Version identifier for deposit transactions bridging from Layer 1 to Layer 2. Null for standard transactions; populated only for cross-chain deposit events.
`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	input	chain_id	block_hash	to_address	access_list	block_number	from_address	receipt_type	receipt_status	block_timestamp	transaction_hash	transaction_type	receipt_logs_bloom	receipt_l1_block_number	receipt_effective_gas_price
0x0	0x0	0x6bf6a42d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016628640000000000000000000000000000000000000000000000000000000005deb4730000000000000000000000000000000000000000000000000000000000000000	1625	0xc978a17e7e6ae09804d526fc4825f20a8df4dd0a67cd5bb87377aa764ba0d40e	0x00000000000000000000000000000000000a4b05	[{“address”:null,“storage_keys”:[]}]	98481267	0x00000000000000000000000000000000000a4b05	106	true	2025-09-30T00:28:28.000Z	0xe4ebf43c06fd87b8d52f59236ea3582e7a769b52fa832485e96956cbf60e3691	106	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	23472228	1800000000000
0x0	0x0	0x6bf6a42d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016642d60000000000000000000000000000000000000000000000000000000005e2b0520000000000000000000000000000000000000000000000000000000000000001	1625	0x8ed462fc2b9b16f057c82a21c0b8c5fe57d50c8865e20f03b97e7bd606a6c7a9	0x00000000000000000000000000000000000a4b05	[{“address”:null,“storage_keys”:[]}]	98742354	0x00000000000000000000000000000000000a4b05	106	true	2025-09-30T23:11:01.000Z	0xc0b852629851acf1f0c81ccae7e2aefd916bc019b76e7dd72af6f4d13aca382b	106	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	23478998	1800000000000
0x0	0x0	0x6bf6a42d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001662e440000000000000000000000000000000000000000000000000000000005dfb11a0000000000000000000000000000000000000000000000000000000000000001	1625	0x480ab39d545c6c6e7c3c77148642c2c64cc5574b7f8acba38eb10a39eac3aa36	0x00000000000000000000000000000000000a4b05	[{“address”:null,“storage_keys”:[]}]	98545946	0x00000000000000000000000000000000000a4b05	106	true	2025-09-30T05:30:38.000Z	0xa646d967529f7fa60ae5c0a335ef75cae175551b3a620124d014d50a0e15b896	106	0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	23473732	1800000000000

Example Query

Query with partition filter

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