Skip to main content

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_operatorSTRINGAddress authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_idsARRAY<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_valuesARRAY<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.
in_toin_idsaddressin_fromremovedin_valueslog_indexin_operatorblock_numberblock_timestamptransaction_hash
0x0000000000000000000000000000000000000000[“55432834365715440554672810958946349841611718977445116247615876555338080760100”,“102802033807090288736667906651075808371625736397748470527462416488391991856143”]0x4d97dcd97ec945f40cf65f87097ace5ea04760450xd91e80cf2e7be2e162c6513ced06f1dd0da35296false[“60000000”,“60000000”]3080xd91e80cf2e7be2e162c6513ced06f1dd0da35296660038422024-12-28T00:00:00.000Z0xdad95ef454f0f999f3145e546ad44a17eb82685d14c9dea2b6537b7652e2d519
0x0000000000000000000000000000000000000000[“21678216225487973526804977855895622426800255930641449554839164336032353007661”,“68625939051253896415844769011922944355276853024680068106899140956609350934097”]0x4d97dcd97ec945f40cf65f87097ace5ea04760450xd91e80cf2e7be2e162c6513ced06f1dd0da35296false[“108000000”,“108000000”]3080xd91e80cf2e7be2e162c6513ced06f1dd0da35296660038432024-12-28T00:00:02.000Z0xe9fe187dd2d83458c1639906ac8ca6af50efd14adf4aebf7a68754fd0bcba2e7
0x0000000000000000000000000000000000000000[“28179090282093807467382718742019031223670663540080991208934067870223690983973”,“21560999676613730302298565094638249415341536557838919732526107094464087708917”]0x4d97dcd97ec945f40cf65f87097ace5ea04760450xd91e80cf2e7be2e162c6513ced06f1dd0da35296false[“32920000”,“32920000”]3430xd91e80cf2e7be2e162c6513ced06f1dd0da35296660038432024-12-28T00:00:02.000Z0xaf43774d5054df4657fa4eb38deb699e43690a539f3be04bdbdc46129c0e60c7
Query with partition filter
SELECT *
FROM `tt-contracts.polygon.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_operatorSTRINGAddress authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_idSTRINGUnique identifier for the position, record, or entity within the protocol. Numeric string representation.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_idin_toaddressin_fromremovedin_amountlog_indexin_operatorblock_numberblock_timestamptransaction_hash
00x00000000e485a18756226ee01e087c8fd294d21f0x17bfff322ccd5140b21d0abac7a89becdcf00a350x0000000000000000000000000000000000000000false12030x00000000e485a18756226ee01e087c8fd294d21f273677882022-04-20T16:09:38.000Z0xc85dfa9cf29498137a33eb249660391306c7150f3a124987319e9d089153db3f
00x00000002f32c0886ee65d68059fbdb76ef6a69960x17bfff322ccd5140b21d0abac7a89becdcf00a350x0000000000000000000000000000000000000000false13050x00000002f32c0886ee65d68059fbdb76ef6a6996273650252022-04-20T14:28:03.000Z0xcc787c2ef25bcf7a420b6ef397004574a0b6aeaf8f31029870667b978cf4f930
00x00000005e410dab96580b41ef0cc1eca34c7c6c40x17bfff322ccd5140b21d0abac7a89becdcf00a350x0000000000000000000000000000000000000000false12250x00000005e410dab96580b41ef0cc1eca34c7c6c4273632722022-04-20T13:21:21.000Z0xf9beb625bbca5766c3111de7388a0e8ff304a3f9bd198504400dd006eac64000
Query with partition filter
SELECT *
FROM `tt-contracts.polygon.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_toaddressin_fromremovedin_valuelog_indexblock_numberblock_timestamptransaction_hash
0xd66226ef30ad9381bc1c1ac33ffde4a4315fc0980x00000000000000000000000000000000000010100xebea6273c16fc8b94bf580a2644b0faa5527c741false705500000000000000274539803272024-02-26T12:57:03.000Z0x4ba0bfcf2ef4bb9a8f724d262b763f6e004ce25bf6ce36fd82924434d547f73f
0x4d0dd46c7f2c492b666d42c6f63e9406740beeca0x00000000000000000000000000000000000010100x8bdea4fae531432176471e074c96c36570529ea4false31819500000000000000223539922342024-02-26T20:12:59.000Z0xf49d25a1584c5bd477872806d96268d2cd3fa0e3daba86d4218b5ccb279cf4f2
0x00000000000000000000000000000000000000000x0000000000004946c0e9f43f4dee607b0ef1fa1c0xc75b82997113542ce385420b01d8da709361acd6false985539617342024-02-26T01:50:24.000Z0x97ca448e3804bc51852301dabb210c635e66b26bd7b7bc370b9d3c4fb8009bae
Query with partition filter
SELECT *
FROM `tt-contracts.polygon.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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenIdSTRINGUnique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
in_toaddressin_fromremovedlog_indexin_tokenIdblock_numberblock_timestamptransaction_hash
0x831753dd7087cac61ab5644b308642cc1c33dc13false590556532021-01-02T00:00:08.000Z0xd22a6fc2bd63a59e5ac3d85b85d756441643eae095ada9e92fa031ef80fa82ab
0x7ceb23fd6bc0add59e62ac25578270cff1b9f619false890556532021-01-02T00:00:08.000Z0xd22a6fc2bd63a59e5ac3d85b85d756441643eae095ada9e92fa031ef80fa82ab
0xb33eaad8d922b1083446dc23f610c2567fb5180ffalse290556532021-01-02T00:00:08.000Z0xd22a6fc2bd63a59e5ac3d85b85d756441643eae095ada9e92fa031ef80fa82ab
Query with partition filter
SELECT *
FROM `tt-contracts.polygon.ERC721_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100