ronin

Tables

ERC1155_TransferBatch_event

TransferBatch events from ERC-1155 (Multi-Token Standard) contracts containing operator, sender, recipient, and arrays of token IDs with corresponding quantities for batch transfers. Used for tracking multi-token movements including mints, burns, and transfers in gaming assets, collectibles, and semi-fungible tokens.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_operator`	`STRING`	Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_ids`	`ARRAY<STRING>`	Array of token identifiers involved in the batch operation. Numeric strings representing token IDs, which may be sequential integers for fungible positions or large integers for ERC-1155 token types.
`in_values`	`ARRAY<STRING>`	Array of token quantities transferred in the batch operation corresponding to the token IDs in in_ids. Numeric strings representing amounts, with precision and scale determined by the specific token contract implementation.

Sample Data

in_to	in_ids	address	in_from	removed	in_values	log_index	in_operator	block_number	block_timestamp	transaction_hash
0x173175f00d6a86013b838d5f7c4a9deea803e33b	[“1099511627776”,“1116691496960”,“1176821039104”]	0x12b707c3d2786570cfdc3a998a085b62acdba4b3	0x0000000000000000000000000000000000000000	false	[“138”,“27”,“57”]	34	0x65e133756d621c0a0f5bb052ba7297b61efb66e9	38496654	2024-09-26T05:45:12.000Z	0x58b21c8afd835a3b2e621df925c24e6418688240328a03be0835fe8bc2926e60
0x0fb4b68aecd90672fda1fb81ec5441900db92d5b	[“1112396529664”,“1116691496960”,“1172526071808”]	0x12b707c3d2786570cfdc3a998a085b62acdba4b3	0x0000000000000000000000000000000000000000	false	[“121”,“24”,“49”]	101	0x65e133756d621c0a0f5bb052ba7297b61efb66e9	38494682	2024-09-26T04:06:36.000Z	0x6e4e058a406de2bf6e407c90b68223a7898fcb35255d458b5c53da4b30e433f0
0x0e925ef2c39846c2ac361f000604281f6b7cb963	[“1099511627776”,“1103806595072”,“1116691496960”,“1120986464256”,“1176821039104”]	0x12b707c3d2786570cfdc3a998a085b62acdba4b3	0x0000000000000000000000000000000000000000	false	[“13”,“13”,“13”,“41”,“31”]	161	0x65e133756d621c0a0f5bb052ba7297b61efb66e9	38491309	2024-09-26T01:17:56.000Z	0xfa60fd4735d57a0323df346337305770078b2d91af723b2876958d569bfc70ee

Example Query

Query with partition filter

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

ERC1155_TransferSingle_event

ERC-1155 (Multi Token Standard) single token transfer events emitted when one token ID is transferred between addresses. Contains operator, sender, recipient, token ID, and transfer amount for tracking individual NFT and semi-fungible token movements within multi-token contracts.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_operator`	`STRING`	Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_id	in_to	address	in_from	removed	in_amount	in_operator	block_number	block_timestamp	transaction_hash
1004001	0x36b628e771b0ca12a135e0a7b8e0394f99dce95b	0xc25970724f032af21d801978c73653c440cf787c	0x30a5ba643174ae60d811b39c133868bc5a79e7b5	false	1	0x36b628e771b0ca12a135e0a7b8e0394f99dce95b	24937179	2023-06-13T06:30:11.000Z	0x1c4fb6da99405b09ac1fba4690e0179d11406c80a5052fca39325104e7c1afbc
1004004	0x36b628e771b0ca12a135e0a7b8e0394f99dce95b	0xc25970724f032af21d801978c73653c440cf787c	0x214fe054269defaea84c71108177d6206a16a9c9	false	1	0x36b628e771b0ca12a135e0a7b8e0394f99dce95b	24949071	2023-06-13T16:24:47.000Z	0x0f15edd4ebf7339063d8ed234c2bf338b23dea7d425d91d6635ebe4494fbef65
1004004	0x36b628e771b0ca12a135e0a7b8e0394f99dce95b	0xc25970724f032af21d801978c73653c440cf787c	0x1b5f476aed9e09a0e3bf9c2279ab42d7dfb783d4	false	1	0x36b628e771b0ca12a135e0a7b8e0394f99dce95b	24932773	2023-06-13T02:49:53.000Z	0x615a4627c4872f3027a8064b98ae045a19ffe9455593d83e744372399ceaeb6d

Example Query

Query with partition filter

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

ERC20_Transfer_event

ERC-20 token transfer events decoded from transaction logs, containing sender address, recipient address, and token amount. Primary source for tracking fungible token flows and wallet holdings across EVM-compatible blockchains.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	block_number	block_timestamp	transaction_hash
0x32950db2a7164ae833121501c797d79e7b79d74c	false	17569504	2022-09-28T09:47:57.000Z	0x3d01495d36241f256c200287612ae76cfd54ac9058d74b9c64117e11b5726c32
0x32950db2a7164ae833121501c797d79e7b79d74c	false	17568639	2022-09-28T09:04:08.000Z	0x18458d9ed3cd7da9955dd17232e8996c281c5002c9f203417b8f824cbafc9315
0x32950db2a7164ae833121501c797d79e7b79d74c	false	17562424	2022-09-28T03:51:13.000Z	0x1d41f724d77415a3e28422d910447a140b02245d1a10e9b50cf5f20cb200a575

Example Query

Query with partition filter

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

ERC721_Transfer_event

Non-fungible token (NFT) transfer events emitted by ERC-721 compliant smart contracts, capturing the movement of unique tokens between addresses. Contains sender, recipient, token ID, and contract address for tracking NFT ownership changes and marketplace activity across chains.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x97a9107c1793bc407d6f527b77e7fff4d812bece	false	0	15675136	2022-07-24T00:06:16.000Z	0x737b8e11b1e0c371d16066907171aa0509656b788208e12670408e565d6c967e
0xa8754b9fa15fc18bb59458815510e40a12cd2014	false	0	15675392	2022-07-24T00:19:04.000Z	0x013ec5e60a1b56763ee31817735bbc4d6de84313af054d7f5d7bfc621aba9fbf
0xc99a6a985ed2cac1ef41640596c5a5f9f4e19ef5	false	7	15675904	2022-07-24T00:44:40.000Z	0x4c9d408772b67fe81b316199bdecd1de6334930ebddf4b722806491034b74939

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ERC1155_TransferBatch_event

ERC1155_TransferSingle_event

ERC20_Transfer_event

ERC721_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ERC1155_TransferBatch_event

​ERC1155_TransferSingle_event

​ERC20_Transfer_event

​ERC721_Transfer_event

Tables

ERC1155_TransferBatch_event

ERC1155_TransferSingle_event

ERC20_Transfer_event

ERC721_Transfer_event