celo

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
0x1ef170d53c54470fd0fd27619a54b42da6f4e0f4	[“31305977756726338638630463883722675453956”]	0x16ba53b74c234c870c61efc04cd418b8f2865959	0x0000000000000000000000000000000000000000	false	[“1”]	125	0xd64827b10f019eb2a45e407c785231fe969d7805	30220951	2025-02-05T17:59:01.000Z	0x924b4b2492a8e457999c5232913600b6255f8c36eed490230af8aba24ea52860
0x4654a70c7c13ac3004819b881dc450e8a1a2dc2e	[“31305977756726338638630463883722675453957”]	0x16ba53b74c234c870c61efc04cd418b8f2865959	0x0000000000000000000000000000000000000000	false	[“1”]	84	0xd64827b10f019eb2a45e407c785231fe969d7805	30221654	2025-02-05T18:57:45.000Z	0x82e2e6c60df685eed704cfa8b4af491db924d7474cac27bc2da5d4dc7fcda51a
0x4aceeb7bf9ec8104cc2379f1e8d648ee47249fcb	[“31305977756726338638630463883722675453954”]	0x16ba53b74c234c870c61efc04cd418b8f2865959	0x0000000000000000000000000000000000000000	false	[“1”]	225	0xd64827b10f019eb2a45e407c785231fe969d7805	30214598	2025-02-05T09:09:35.000Z	0x5844948d852247287e1fbf686e608fae6a508cbd007577bcc7d4a3b5d1bc65d7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.celo.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	log_index	in_operator	block_number	block_timestamp	transaction_hash
215100	0xfb6d5faa665783f4e4a1f5b198797c4d39478f13	0xc291846a587cf00a7cc4af0bc4eedbc9c3340c36	0x0000000000000000000000000000000000000000	false	1	20	0xfb6d5faa665783f4e4a1f5b198797c4d39478f13	15997279	2022-11-05T13:19:54.000Z	0x1272205c321fea63e948ac0443fa462423c1c8d3499278fee5902a718a21208a
0	0x6e732a286e5f4014c214d1c60d0a86b474c16f9f	0x85764548e8f9211d55409c21b8791318d03a1712	0x0000000000000000000000000000000000000000	false	1	4	0x6e732a286e5f4014c214d1c60d0a86b474c16f9f	22296553	2023-11-05T02:29:23.000Z	0xe4ccdae07399a6a7122b7138bc0dc2b5d70f3ed5da4c8c957667745598e5faf6
0	0x6e732a286e5f4014c214d1c60d0a86b474c16f9f	0x85764548e8f9211d55409c21b8791318d03a1712	0x0000000000000000000000000000000000000000	false	1	6	0x6e732a286e5f4014c214d1c60d0a86b474c16f9f	22296572	2023-11-05T02:30:58.000Z	0xd6c049287a0633fa3ecf054571dfdd877072804a9ccf22b13bbf07799a6c03ba

Example Query

Query with partition filter

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

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0xd26efe150d59def6f94a11cb1a6ccda41b68436d	0x765de816845861e75a25fca122bb6898b8b1282a	0x4073c297738f2424885569afafe5b77f5adebcd8	false	193554591150816	5	6795712	2021-05-21T00:00:00.000Z	0x1d5dc0bcf0be382f625632eef27c6fdbe399161dccd359d452285ffd11e4fad3
0x4073c297738f2424885569afafe5b77f5adebcd8	0x765de816845861e75a25fca122bb6898b8b1282a	0x5d6b1bf04d52452e91e2fbd50a15de52adf9c318	false	750000000000000000	3	6795712	2021-05-21T00:00:00.000Z	0x1d5dc0bcf0be382f625632eef27c6fdbe399161dccd359d452285ffd11e4fad3
0xd533ca259b330c7a88f74e000a3faea2d63b7972	0x765de816845861e75a25fca122bb6898b8b1282a	0x4073c297738f2424885569afafe5b77f5adebcd8	false	48388647787704	4	6795712	2021-05-21T00:00:00.000Z	0x1d5dc0bcf0be382f625632eef27c6fdbe399161dccd359d452285ffd11e4fad3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.celo.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
0x918146359264c492bd6934071c6bd31c854edbc3	false	10	17992134	2023-03-01T00:00:03.000Z	0xb8736ebfa63aa26c22009e5084b4417ea716d7b0a26572b0008e54febda2e68e
0x918146359264c492bd6934071c6bd31c854edbc3	false	5	17992134	2023-03-01T00:00:03.000Z	0xb8736ebfa63aa26c22009e5084b4417ea716d7b0a26572b0008e54febda2e68e
0x471ece3750da237f93b8e339c536989b8978a438	false	8	17992134	2023-03-01T00:00:03.000Z	0xb8736ebfa63aa26c22009e5084b4417ea716d7b0a26572b0008e54febda2e68e

Example Query

Query with partition filter

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