fantom

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
0x18468ef37051d08355c7a52d4cdbed50a5bfd75e	[“1”]	0x2f05e799c61b600c65238a9df060caba63db8e78	0x0000000000000000000000000000000000000000	false	[“1”]	123	0x2f05e799c61b600c65238a9df060caba63db8e78	49164819	2022-10-14T16:45:43.000Z	0xb4c0c42bd56dc27e510539fff35f104f4560a9e71520ddb48590d38f0c205c18
0xf77997d6314791da9828275c289122e47554130b	[“1”]	0x2f05e799c61b600c65238a9df060caba63db8e78	0x0000000000000000000000000000000000000000	false	[“1”]	1	0x2f05e799c61b600c65238a9df060caba63db8e78	49176856	2022-10-14T20:32:16.000Z	0xda0e42e2aaeee3d3ff19c136c4732b74d9b8a2147c99f0fc383fb76c3ba24052
0xab88170aa3d24b1f6c1b37ffba5d3d2c4382afa2	[“1”]	0x2f05e799c61b600c65238a9df060caba63db8e78	0x0000000000000000000000000000000000000000	false	[“1”]	11	0x2f05e799c61b600c65238a9df060caba63db8e78	49163565	2022-10-14T16:23:16.000Z	0xd1ce1f73944bf40368e171e951cdb88369e450437c8ca9ef6c11b577d87ee098

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.fantom.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_to	address	in_from	removed	in_amount	log_index	in_operator	block_number	block_timestamp	transaction_hash
0x0198db21cc1ca21bc8cb01d72c19ceaf3afbfdc2	0xd1986bb56dd33f8851ed13621d251814dcb3553e	0x0000000000000000000000000000000000000000	false	1	112	0x0198db21cc1ca21bc8cb01d72c19ceaf3afbfdc2	44758034	2022-08-12T16:16:02.000Z	0x8e653066d2820981fdf4b2404abdd2e1f5571e5a339930bc87b2914a343509c8
0x02881e97bc6c1b268d5797c608276e8675bde3f7	0xd1986bb56dd33f8851ed13621d251814dcb3553e	0x0000000000000000000000000000000000000000	false	1	1	0x02881e97bc6c1b268d5797c608276e8675bde3f7	44757541	2022-08-12T16:06:47.000Z	0x91df4e17b573dbfe0406c4b08572583b4d916f69edd15f7a2447fb71423dd3e9
0x02bfd87fb5b3a7a2e643c0af9a72e88e0f868077	0xd1986bb56dd33f8851ed13621d251814dcb3553e	0x0000000000000000000000000000000000000000	false	1	64	0x02bfd87fb5b3a7a2e643c0af9a72e88e0f868077	44757289	2022-08-12T16:01:06.000Z	0xe7c3729c462f586ec7bba1b6593c0c2db54fd1afab33c65e39de19e086230858

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.fantom.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
0x2ab5c606a5aa2352f8072b9e2e8a213033e2c4c9	false	11	53415169	2023-01-08T04:47:06.000Z	0xe7b2e401d0105e51bab2358fcd8a2b28681ea68b72751d5a92bb61917ce61ed5
0x77fa9d9d4ef0b3862c6f5b279ce0fa576888bc31	false	11	53408001	2023-01-08T01:14:10.000Z	0xbf02b94c3201f4c0315f854d0310df39f02e6a5cf62b52d130cce39b410eace1
0x946d51c2919a6abd401ba0f16e3d3647cf245b19	false	43	53426434	2023-01-08T10:20:03.000Z	0x6570c0575f0406339d49001e96fb5ea164030c1f9dcda4c5cbb60fd888665f8f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.fantom.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
0x44e314190d9e4ce6d4c0903459204f8e21ff940a	false	0	54934045	2023-02-02T18:25:04.000Z	0xa7deb097b15fd60a6bbaf6f88936db80c81abf6e6fe63d9a04aec2bcd12134b5
0x5cc61a78f164885776aa610fb0fe1257df78e59b	false	2	54934045	2023-02-02T18:25:04.000Z	0xa7deb097b15fd60a6bbaf6f88936db80c81abf6e6fe63d9a04aec2bcd12134b5
0x04068da6c83afcfa0e13ba15a6696662335d5b75	false	2	54909600	2023-02-02T10:27:12.000Z	0x26166a5993e1a1f9092f4e71d32df62107912b862597db075c7498636c48b7d0

Example Query

Query with partition filter

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