ronin

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.
`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.

Sample Data

size	miner	nonce	number	uncles	gas_used	mix_hash	gas_limit	timestamp	block_hash	difficulty	extra_data	logs_bloom	state_root	parent_hash	sha3_uncles	receipts_root	total_difficulty	transaction_count	transactions_root
1280	0x210744c64eea863cf0f972e5aebc683b98fb1984	0x0000000000000000	14321420	[]	244617	0x0000000000000000000000000000000000000000000000000000000000000000	100000000	2022-06-06T21:05:46.000Z	0x7312dc495e59eaefded752151b3c51cb8416c989e0e9d3d46b7c9353d6b51a8c	7	0xd883020300846765746888676f312e31352e35856c696e75780000000000000018a8ab4e63236d6b3da05ef1d36d7473040c465404d4d9b25cf9945d4a731b2f1a7e4aa30a75a5273945c70ab8783e606e5305dde662a97cdd8ad249439aa46501	0x00002000180000800000000000000000400048000000000000000000000000000000000000000000002000000000000000000000000000000000000000400008000000000000000000008008020000000002400000000000000000000000000100000000020008000000000000000000002000002001000000000010000000000000000000000002000000002000000000000000000000000000000000000000000000000000002000400000000000000000000000000000000000000000000000000802000000000000000000000000000000000000000000000000000000000000000000000002400000000000000000000000000000000000000000000000	0x0c1743130c64b844529e2c514264ad843d3621073ba425e6cca0978f5e515884	0x16389ec93c528770c9ee8dc5a0c78f1e75f6430e6d23c88b7ee330b040c5e016	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0xe2564abe25c89a4de55a89b2bd837cd1a7e1fc26e27947e7ffb9bd71a2fa7f99	99295539	4	0x6d2cfcfbdcc3970bc4d1e7e07c025c419aacb62b2064ac031dff4c6c14cd9940
1536	0x210744c64eea863cf0f972e5aebc683b98fb1984	0x0000000000000000	14320627	[]	299796	0x0000000000000000000000000000000000000000000000000000000000000000	100000000	2022-06-06T20:26:07.000Z	0x1dcc46ee682c247a9d2181c76731149d35d5c0eb64ac31f1d202aec9be806b1c	7	0xd883020300846765746888676f312e31352e35856c696e75780000000000000024041c3a7f62b1db02257e417df5d26ae1e33920a51c3f33fa11dfc8af6753410c5868751730692a3cdcf22665dff3af619be74cf335c4144cadbfa2858d32cf01	0x00042000100000000080000000000000000000000000000000000000008000000000000000000040000040000000000000000000000000080000080000000008400000000020000000008008020002000002120010000000000000000000000000000000020008400000000000800800000000002000000000000010000000000000000000000000000080002000000000000000000000100000000100000000000002000040000800400400000020000000000001000000000000020000000000000002000000000000000000000000000000000000000000000000000020000000000000001002000000000000000000000000000000000000010000000000	0xa4f7b50b4559d3f8d411177d4fe8245831232d8791f406afe413286e01274bc6	0x7a8c3840b9167e4833b6dcd3685cd9cb1fb73ff0b09c5cf385007e483b33c6f6	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x1e377bdff31072566061ac121f3f9b43e624c6dbb4aa03d0179fd67eac63200d	99289988	4	0xa0ffddc5c374fb5edda19c55b291a44baa1203eacc82d61674f17f83ea67523b
1536	0x210744c64eea863cf0f972e5aebc683b98fb1984	0x0000000000000000	14306684	[]	286896	0x0000000000000000000000000000000000000000000000000000000000000000	100000000	2022-06-06T08:48:58.000Z	0xf70e187c9a96c2214f1867c7dc00c26230679c01fc51100bbaeb1d03a816e335	7	0xd883020300846765746888676f312e31352e35856c696e757800000000000000c14b088cec9de02be2c24c846463cd523afaeff3dfb7abff5738012ad438b339619fc929b95cc434e5cd40e457691e825b106e5d1f9a646dbb5c9af78e9bebe500	0x00042002100000000000000000000000000000000000000000002000000000000008000010000000000040000020000000000000000000000000000000000008000080000000000000108008020040004002000000000000000040000000000000000000020000000200000000000800000000002000001000000010000000000000000000001000100002000210000000000000000800000000000100000000010000000004000000400400000000000000100000000000000000020400000000000002000000000000000000000000000000000080000010000000000020000000000000001002000000000000000000000000000000000000000000000000	0xf3b015d6cc610046c6027440172099cce922a3cbc36e0b84080233d6bf044ff4	0xb432fb45ffd52b7f41f26041a40a2a7ff76d3d7e4421b43629aacb4141ba003c	0x1dcc4de8dec75d7aab85b567b6ccd41ad312451b948a7413f0a142fd40d49347	0x7e50620fafd2a0dc018451c9b6a9828b286b800fda29ccafd6bb494b32e38790	99192387	4	0xe81194cf0ff1fd04d00dfabf2ef5d86865b3adb504246eb89ccb44c5f499b5d9

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.ronin.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	log_index	block_hash	block_number	block_timestamp	transaction_hash
0x	[“0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef”,“0x0000000000000000000000004f29e10c1daf8636c30b3dfcfa0f126275576822”,“0x0000000000000000000000008e78f95908048c3ddccd8b5b7766b02c6cb79796”,“0x00000000000000000000000000000000000000000000000000000000008ccee2”]	0x32950db2a7164ae833121501c797d79e7b79d74c	false	4	0xdc72332133febb5fb27c068cb7512c1e9235d520100d385a6891acb80cec5a88	19545344	2022-12-07T00:22:13.000Z	0xbbdcf0853af527a64ebda6429dd8307d909cb3bf70b4cd5a4324d1965490d6da
0x	[“0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef”,“0x0000000000000000000000004f29e10c1daf8636c30b3dfcfa0f126275576822”,“0x0000000000000000000000008e78f95908048c3ddccd8b5b7766b02c6cb79796”,“0x000000000000000000000000000000000000000000000000000000000009afdd”]	0x32950db2a7164ae833121501c797d79e7b79d74c	false	1	0xdc72332133febb5fb27c068cb7512c1e9235d520100d385a6891acb80cec5a88	19545344	2022-12-07T00:22:13.000Z	0xbbdcf0853af527a64ebda6429dd8307d909cb3bf70b4cd5a4324d1965490d6da
0x	[“0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef”,“0x0000000000000000000000004f29e10c1daf8636c30b3dfcfa0f126275576822”,“0x0000000000000000000000008e78f95908048c3ddccd8b5b7766b02c6cb79796”,“0x000000000000000000000000000000000000000000000000000000000009b018”]	0x32950db2a7164ae833121501c797d79e7b79d74c	false	2	0xdc72332133febb5fb27c068cb7512c1e9235d520100d385a6891acb80cec5a88	19545344	2022-12-07T00:22:13.000Z	0xbbdcf0853af527a64ebda6429dd8307d909cb3bf70b4cd5a4324d1965490d6da

Example Query

Query with partition filter

SELECT *
FROM `tt-blockchain.ronin.logs`
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`	`STRING`	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.
`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.
`expired_time`	`INT64`	Expiration timestamp for sponsored transactions on Ronin, indicating when payer authorization expires. Always null for standard user-paid transactions.
`payer`	`STRING`	Address authorized to pay gas fees for this transaction. This field is specific to Ronin’s sponsored transaction mechanism and is null for standard transactions.
`payer_s`	`STRING`	ECDSA signature component (s-value) from the secondary payer who sponsored the transaction’s gas fees. Null for non-sponsored transactions on Ronin; populated only when a separate address pays gas on behalf of the sender.
`payer_v`	`STRING`	ECDSA signature recovery identifier for the optional payer in Ronin’s sponsored transaction feature. Null for standard transactions where sender pays their own gas fees.
`payer_r`	`STRING`	ECDSA signature component r from the fee payer’s authorization in Ronin’s sponsored transaction model. Null for standard transactions where the sender pays their own fees.
`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_type`	`INT64`	Transaction encoding format identifier from EIP-2718. Integer value indicating the transaction type returned in the receipt.
`receipt_payer`	`STRING`	Address of the entity that paid transaction fees on Ronin chain when using sponsored transactions. Null for standard transactions where the sender pays their own gas fees.

Sample Data

r	s	v	gas	input	nonce	value	gas_price	block_hash	to_address	access_list	block_number	from_address	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
0x35eba41791daf743117e4553aef0f63c1feaa4332b01bc8d2946664de6326c0f	0x1f50733321c87ea743bad14ec3d173296a52f6184cee055adb026b1179bb112c	27	80000	0x3171130900000000000000000000000056ecc712fb2145bb1aca2485cb65e2bd14d92071	192	0	20000000000	0x61257c4c2a3a65d9270c366e9181c7cb36aec4676417de1e6c889b53283c0d1e	0x9d3936dbd9a794ee31ef9f13814233d435bd806c	[{“address”:null,“storage_keys”:[]}]	34867032	0x56ecc712fb2145bb1aca2485cb65e2bd14d92071	true	2024-05-23T03:01:15.000Z	63310	0x7b9acfdb93f288aaa4bb6c0db078f682c6e8f043163f373a4cebfcad4587757d	6	0x00000000000000000000000008040000000000000000000000000000000000000000000020000080000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000200000000000200000000000000000000000000002000000000000000000000000000000000000040004000000000000000010000000000000000000000000000000000000000000000000200008000000000000000000000000000000000000100000000000000000000000000000000000010000000000200000	6	280259	20000000000
0xc632d91d381122e3960c6ee6e98efdfc4ecff7575a3c59ad53572ddea5436b63	0x476587c6ae928da7d38f3294fca38df8b7e2b969f4520e1ada955dd9ce63d7ae	4075	397824	0x95a4ec00000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000010455243313135355f45584348414e4745000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000384b93af3e9000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000001bc16d674ec8000000000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000002a00000000000000000000000000000000000000000000000000000000000000000c5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a4700000000000000000000000004a708b593efecff5c828a556ece6d8887e82c9960000000000000000000000004a708b593efecff5c828a556ece6d8887e82c99600000000000000000000000000000000000000000000000000000000000001c0000000000000000000000000beef110d2db74563c28d12593b8db06f423bc9ea0000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000200000000000000000000000002286d77425ae3287335ff28b264109225ed6991000000000000000000000000000000000000000000000077000100000001000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000066767a2a000000000000000000000000e514d9deb7966c8be0ca922de8a064264ea6bcd400000000000000000000000000000000000000000000000000000000664d9baa0000000000000000000000000000000000000000000000001bc16d674ec8000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000c5d2460186f7233c927e7db2dcc703c0e500b653ca82273b7bfad8045d85a4700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004132504981911301616a42651311b12a48399b11b75a9e44082beb6e64e09e678b36a4f769b582128f3a976a0229b665167aee867e03399c908ede94455555772b1b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	131	2000000000000000000	20000000000	0x0f41a31824f866970ee939fcd5957cb136efcd8e60bc1de96987b6e78eceba6e	0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3	[{“address”:null,“storage_keys”:[]}]	34868395	0x4a708b593efecff5c828a556ece6d8887e82c996	true	2024-05-23T04:09:24.000Z	235556	0x819ef4e9628b10ab0d4883aff156f89d840f2b42c4f0f2a37172282d819e7338	12	0x00000000000000000000000080000000000000000000000040000000000000202000000002000000000000000000000000000000000000020000000000002000000000000000000000000800100000000000000000000000000000000000000000000400000000000000000000000001000000000000000000000200000000000000000000000000020010000000000000000000000000000880000000000000000000000000000000000040000000000000800000000000000200000000000008000000000000000000001000000000000000000008002000800010000000000000400000000000000032800000000000002000000000000000080000000000	12	687792	20000000000
0xd8aaa386b46083417c39606b1d4bea2bc46deef92c8d9ff55c6810095aca5a43	0x6c530b45342d879726acb206e12323d659d95e8df841b059c4b83cc01666ca	4075	135936	0x42842e0e0000000000000000000000001b7f0ad7133f058a5391f4f13111b143521ce8230000000000000000000000000ff3e887e169d58168b0c427b084b7a45ad886e4000000000000000000000000000000000000000000000000000000000000193e	630	0	20000000000	0x18e012862bff6225519370f640690ed9237e8fa4f70a6f3df4a72ab7661dee2d	0x56d4e6ce96f850bdc1dfd086ac1c19a1e2d5b5c5	[{“address”:null,“storage_keys”:[]}]	34882285	0x1b7f0ad7133f058a5391f4f13111b143521ce823	true	2024-05-23T15:44:00.000Z	87216	0xdb61899e5b31ff687a5f4ab5733efa121c13c40ddb4f30da44e2f163729c869f	9	0x00000000200000000000400000000000000000000000000000000000000020008000000000000000000000000000000000000000000000000000100000000000000010000000000000000008001000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000010000000000000000000000000000100000001001800000800004000000000000000000000000000040004000000000000000080000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000	9	366014	20000000000

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

blocks

logs

transactions

Metrics

Primitives

Contracts

Blockchain

​Tables

​blocks

​logs

​transactions

Tables

blocks

logs

transactions