avalanche

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
0x1a20f41e36c7c69670dc5b90ee71d6ea09fc2ecc	[“9237”,“9133”,“8734”,“8547”,“8524”]	0x5dfae9ff7f132a584375a4bd3694ddc60af1082f	0x0000000000000000000000000000000000000000	false	[“1”,“1”,“1”,“1”,“1”]	12	0x1a20f41e36c7c69670dc5b90ee71d6ea09fc2ecc	14234686	2022-05-03T21:26:42.000Z	0xfdd51f4a2e29124a5d7622358d6c208a112f26fb016cc0ae1efa3e584fd6323f
0x2610862b07b2998c6cbb8c56fbfcea8c94bb8ffe	[“202200”]	0x6b43ad7890cfb4810d5e0d2d74dbf02186203555	0x2fef6742d30c81c518d7742d5c7ae6723f64a79c	false	[“42”]	76	0x2610862b07b2998c6cbb8c56fbfcea8c94bb8ffe	14227495	2022-05-03T17:17:46.000Z	0xe0f6ddf08cc8a8a15f39f9e92928eb347a29de6189ef9b31d4c62fb2f6efeb7c
0x2fef6742d30c81c518d7742d5c7ae6723f64a79c	[“202200”]	0xbdd1a503d211b8bea904dce9d27cd03ab9d1626f	0x0000000000000000000000000000000000000000	false	[“42”]	77	0x2610862b07b2998c6cbb8c56fbfcea8c94bb8ffe	14227495	2022-05-03T17:17:46.000Z	0xe0f6ddf08cc8a8a15f39f9e92928eb347a29de6189ef9b31d4c62fb2f6efeb7c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.avalanche.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
56	0x0000000000000000000000000000000000000000	0x59b13e0905ec72f1c457b9b151836aea7ad00028	0x05dc467b8173a6c4e8fb222df4e6b3a80b9d1673	false	249510	89	0x204a496f2a06de5d83aa966671088137282b3a0c	19434455	2022-09-02T07:21:38.000Z	0x7850b6422af5f8d89432c4b4d931f35b4123727eac68996001ce82d35fec9bb1
56	0x0000000000000000000000000000000000000000	0x59b13e0905ec72f1c457b9b151836aea7ad00028	0x9964b3b39a82847f066d4422ab7db517da9afbd4	false	1000	3	0x204a496f2a06de5d83aa966671088137282b3a0c	19435082	2022-09-02T07:42:36.000Z	0x938541adb8776db8ba8a0f6328edbc2ea1552fcaae5baab89c1fe414d8b297ea
56	0x0000000000000000000000000000000000000000	0x59b13e0905ec72f1c457b9b151836aea7ad00028	0x0614aa715d390a95fb8aa330ceef704c2e28d736	false	23000	8	0x204a496f2a06de5d83aa966671088137282b3a0c	19437328	2022-09-02T08:58:13.000Z	0x2d79073e497b6e51b7c16bd19e027166360f0dac57cac5bbabc9b76d5637bb8e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.avalanche.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	log_index	block_number	block_timestamp	transaction_hash
0x001e68282d52dcaba3749291bac33a9678073d01	false	15	32288153	2023-07-07T09:04:45.000Z	0xa73439cfa6ba27541fbf75af36d1a8200bb2e283c9ae2ca63af442b994d2b418
0x001e68282d52dcaba3749291bac33a9678073d01	false	43	32288153	2023-07-07T09:04:45.000Z	0xa73439cfa6ba27541fbf75af36d1a8200bb2e283c9ae2ca63af442b994d2b418
0x001e68282d52dcaba3749291bac33a9678073d01	false	33	32288153	2023-07-07T09:04:45.000Z	0xa73439cfa6ba27541fbf75af36d1a8200bb2e283c9ae2ca63af442b994d2b418

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.avalanche.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
0xe1c8f3d529bea8e3fa1fac5b416335a2f998ee1c	false	3	770424	2021-03-26T19:55:11.000Z	0x000bc4966701605f6fee26435d034af3ab3acc26d4fdffc33a6c9334e452537c
0x60781c2586d68229fde47564546784ab3faca982	false	0	770424	2021-03-26T19:55:11.000Z	0x000bc4966701605f6fee26435d034af3ab3acc26d4fdffc33a6c9334e452537c
0x60781c2586d68229fde47564546784ab3faca982	false	1	770424	2021-03-26T19:55:11.000Z	0x000bc4966701605f6fee26435d034af3ab3acc26d4fdffc33a6c9334e452537c

Example Query

Query with partition filter

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