ethereum

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
0xc40b51598a1c20afc5ea6f130c8447eae445c613	[]	0x8d53afbeb62c18917b5f71385d52e8ba87669794	0x0000000000000000000000000000000000000000	false	[]	3	0x0000000000000000000000000000000000000000	18014213	2023-08-28T16:04:23.000Z	0xc16741c7bf160611ac973a8f8fc6641ead30da041e577545c02242be6428c09c
0x0b9020d4e32990d67559b1317c7bf0c15d6eb88f	[“0”]	0xdd6e7ff87ce5e19f7856280a24f1eec612947248	0x0961482b4efaa73e69c07568c742a716d2fbcf46	false	[“5310727893518518518518”]	447	0x0b9020d4e32990d67559b1317c7bf0c15d6eb88f	18016529	2023-08-28T23:51:11.000Z	0xb02bfde88b9920ff63fd151d5cecdacb732fe1701a555dfa4e8a1c0c00086154
0x0b9020d4e32990d67559b1317c7bf0c15d6eb88f	[“0”]	0xdd6e7ff87ce5e19f7856280a24f1eec612947248	0xc10960ddbfc177106dc37af242e04d710635b6c0	false	[“844522222222222222222”]	312	0x0b9020d4e32990d67559b1317c7bf0c15d6eb88f	18010811	2023-08-28T04:39:23.000Z	0xe5741d46067915a93c12f4bd0102420f8188caea9a05aaccf287c017a5c81217

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ethereum.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
97996233987066249833295893272629448503	0xb9f38580eaafd0b8b2803deadc4a1c93ff5513bf	0x01f596a445873de2796596a1a80142d220a4cac9	0x0000000000000000000000000000000000000000	false	1	74	0x457044dff5886a9eb9365015704e1b747f384194	12234386	2021-04-13T22:13:53.000Z	0xa8d4ee2816dd3901dd828f3f04788b21427cc118276067e9dbd9267f7d37c210
1	0x0d09aa156710865f9ffc9084a48a84f28bf6f1db	0x085f8d8922dfeacbed279575578f608c6985ac8b	0x7cabb73f5b840b245ec2528751445da1f6dd7eee	false	1	211	0x4fee7b061c97c9c496b01dbce9cdb10c02f0a0be	12229003	2021-04-13T02:18:40.000Z	0x26273d05a303fb41f3921f9f5422e3ac9b680e99ca712ccedb0a38912850ba57
1	0x7d63002e11607bd1eb954b5f7664485305910ba6	0x0bb7c1d061b56907a2444beb0db5e5289679dee9	0x27e6826f8e6b2c15b223e2fcd78eb93bfed7a206	false	5	240	0x4fee7b061c97c9c496b01dbce9cdb10c02f0a0be	12231529	2021-04-13T11:40:25.000Z	0xbce97146cebb005713a7c1fe9ecd79f06632beaebe3d31a6ccdec5974358852c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ethereum.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
0x3f5ce5fbfe3e9af3971dd833d26ba9b5c936f0be	0x0000000000085d4780b73119b644ae5ecd22b376	0xd0460e3d9ecc32ef4bb1ad6416729d80f35aa129	false	2137580608400000000000	114	8787968	2019-10-22T03:49:19.000Z	0x700770a03899bc0a2197f11668ba8952f044fc3ca0e983449e51194ab4a6484a
0x21c0ff0d7df61c8f8c18631bdde315d778ea02db	0x0000000000085d4780b73119b644ae5ecd22b376	0x1e62e1b83647bd41e505b1fb0d54a96729ab310d	false	400000000000000000000	0	8791040	2019-10-22T15:25:36.000Z	0x963dad2e83e17087bd8dcfd3d15e51e41a81db8673387a6aa959cb84da3e73de
0xfc05d554b7313a6213d1d0e2f131aa19834c3217	0x0000000000085d4780b73119b644ae5ecd22b376	0xfbb1b73c4f0bda4f67dca266ce6ef42f520fbb98	false	50000000000000000000	8	8792064	2019-10-22T19:13:47.000Z	0x9b5586132f2a1940f9b7cd82462b0decc73f628c4496b4ec871c304fe8cb8448

Example Query

Query with partition filter

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

in_to	address	in_from	removed	log_index	in_tokenId	block_number	block_timestamp	transaction_hash
0xc8e302737ac30317c76166635c3591ef12c59690	0x9980b3aa61114b07a7604ffdc7c7d04bb6d8d735	0x602f51dcbeda58dc247fe73f1800d3e4fc2115bb	false	770	611	17275904	2023-05-17T00:47:23.000Z	0xcf06fc85922561da24af37052f93a8ee6339808e564cb5f171b9046ca37822ce
0x8252df1d8b29057d1afe3062bf5a64d503152bc8	0xb7f7f6c52f2e2fdb1963eab30438024864c313f6	0xd79b937791724e47f193f67162b92cdfbf7abdfd	false	319	4424	17276160	2023-05-17T01:39:47.000Z	0x7b3e893519bc697ac343f96d19fa4f208b430f2665c6936c6dfb84136fe0c4fc
0x5aa4910d42cbadddc50866a44dca63738a4c30f7	0x34cadc2ff14d57d6c3f806b5d798c6a27642af2e	0x9675b063aa16736a218299c089b63b0b2e20fc20	false	266	2692	17276928	2023-05-17T04:15:47.000Z	0xf2740754e3253e80f49cb1f70169fffd684011844cac99a2c020afbb029445b1

Example Query

Query with partition filter

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