base

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
0x010a0937ac78308ecb640b141601c80948fffd7f	[“68433587369416982758047159139419331737789391054572732736396176651748149724916”,“100572353784612650925514971226333922103075076037970023462759946212993203896467”]	0xc9c98965297bc527861c898329ee280632b76e18	0x0000000000000000000000000000000000000000	false	[“500000000”,“500000000”]	163	0x010a0937ac78308ecb640b141601c80948fffd7f	21166780	2024-10-16T23:55:07.000Z	0x434f4ac7150df188f9de3500ecd125c441bc2159cda564c9548a43069148089f
0x32e52896663de88a65c2d94917b006404415a89f	[“68433587369416982758047159139419331737789391054572732736396176651748149724916”,“100572353784612650925514971226333922103075076037970023462759946212993203896467”]	0xc9c98965297bc527861c898329ee280632b76e18	0x010a0937ac78308ecb640b141601c80948fffd7f	false	[“0”,“0”]	166	0x010a0937ac78308ecb640b141601c80948fffd7f	21166780	2024-10-16T23:55:07.000Z	0x434f4ac7150df188f9de3500ecd125c441bc2159cda564c9548a43069148089f
0x0000000000000000000000000000000000000000	[“23746596624851731995009619945792176484147255966004091186984145435251050819428”,“23745251413891947178924496828395954426392791900634847362247037235766197554775”]	0xc9c98965297bc527861c898329ee280632b76e18	0x058d479418a8a7709683d6abc89cbfe3e80825e3	false	[“4114000000000000000”,“4114000000000000000”]	45	0x058d479418a8a7709683d6abc89cbfe3e80825e3	21141456	2024-10-16T09:50:59.000Z	0x1a5a93fd4bfb79370978d1d6bba720aecabb0328d3a28e2db13b254e855491d0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.base.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
0	0x2e1f31aa62143817201632d808c3ce9fc5e17209	0x0004210e95d1422eabcd62982cbd70f4a6c15217	0x0000000000000000000000000000000000000000	false	1	264	0xaceb0de9f3efab3c50bf4dc6b14706f119e39dd8	17055369	2024-07-13T19:48:05.000Z	0xb1a8604c7f8831e63274135bbe68c1f116f7a9f87feba41c48ca24beae1ea16e
0	0x21886f89d2e8947a1f157d9ee7e0d6ad816f3504	0x002d50409cd7672857ce382aa01cccc9215a57cf	0x0000000000000000000000000000000000000000	false	1	221	0xaceb0de9f3efab3c50bf4dc6b14706f119e39dd8	17050680	2024-07-13T17:11:47.000Z	0x480b0ad44c3cb028e72e836ff3fadb6d0ccf52a256d85526eafb614e421ae795
1	0x91ea0eb3215b0c5b133b5f3382ec9afcf4a075dd	0x003f62a86fe410e596631aa863786c2cc888ec6a	0x0000000000000000000000000000000000000000	false	1	314	0x91ea0eb3215b0c5b133b5f3382ec9afcf4a075dd	17029059	2024-07-13T05:11:05.000Z	0xf3965f6145869ac40227ed5c15f656f98ffec02137ce775d712949e4da9809f6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.base.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_src`	`STRING`	Address of the account from which tokens or assets are being withdrawn or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_dst`	`STRING`	Address of the account receiving tokens or assets in the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_wad`	`STRING`	Token amount denominated in WAD units. String-encoded integer representing value with 18 decimal places of precision.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x991fc265f163fc33328fbd2b7c8aa9b77840ed42	false	14	9200527	2024-01-14T00:00:01.000Z	0xfd294e818f1bc4b6bed90f1ab4c6c4eb94f5bace0e3742c75bd4160a5ffaddc2
0x061a883e8c2feffb4f3ea42046abd4be88e1333f	false	15	9200529	2024-01-14T00:00:05.000Z	0xf40d8c7ba7288b132ca402234ab98c3d838f34540af63d619eaa803e82113bcd
0xff8b2a1adedb994c4357b9470497d4ef1671fb8a	false	15	9200530	2024-01-14T00:00:07.000Z	0x0016c995b771ac87034c5e1f19e5f867e03f74ee9a783dbdb4fcacae6acb818d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.base.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
0x443e2a2c9f15d99ec8ec944ee257b2925296a83b	0x931f3a41078725e85c8fc0bf8204f277d3ccbd11	0x7fe0efe75c9b6e1c2e2d17328105dfbb90a74618	false	193	18624	12847411	2024-04-07T10:02:49.000Z	0x4a80cfe5e8d60abe2865340986a06c50be6a35152749abfa683cad8f28071c99
0x2f142f9f52af0845b7b8b1353e349ca1cb8efe92	0x5a284d2923c1bdff23290ec820aa6d230314959f	0x50d5ebd514f30bb691cf77cd5e2f899f122d508e	false	175	992	12863221	2024-04-07T18:49:49.000Z	0xd250e94d5dbec672a08334133d705b3a79b92f568a1fd940cdf07972301d814b
0x0000000000000000000000000000000000000000	0x286ce4278213bf7b561763ebcf2342bb94e52858	0x651a827922e37f28adcbabb083d6cb5ad47cbd0f	false	75	5002	12854273	2024-04-07T13:51:33.000Z	0x568956369a36cc6604849de10b17d348917e7550721b567596dbddaf0911bb1b

Example Query

Query with partition filter

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