Skip to main content

Tables

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
3402823669209384634633746074317682114560x4a90ba04d34a98058bf8176c601fa372842ecd9e0xddead819fa3e2bea0c2e33ab71204240ebc0739e0x0000000000000000000000000000000000000000false100x4162207c13b4d97f93b1701a78265832acdb1fe823719522020-07-26T07:25:50.000Z0x8ddd6c0d2ebac71ca9c054a4b9409b62cf6562c78a2b29a56f251745941c2178
6805647338418769269267492148635364229120x4a90ba04d34a98058bf8176c601fa372842ecd9e0xddead819fa3e2bea0c2e33ab71204240ebc0739e0x0000000000000000000000000000000000000000false110x4162207c13b4d97f93b1701a78265832acdb1fe823719522020-07-26T07:25:50.000Z0x8ddd6c0d2ebac71ca9c054a4b9409b62cf6562c78a2b29a56f251745941c2178
6805647338418769269267492148635364229120x34ef922bf7f2193a2f3535fb877dbfb167915af40xddead819fa3e2bea0c2e33ab71204240ebc0739e0x0000000000000000000000000000000000000000false110x4162207c13b4d97f93b1701a78265832acdb1fe823902912020-07-26T17:56:16.000Z0x6f9bfdffb55c6aadec72124260aaa9a0e4e902145012016f7114c8d2e1ae590e
Query with partition filter
SELECT *
FROM `tt-contracts.polygon_v1_polygon.ERC1155_TransferSingle_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
0x969cbd9439207c2ff6732c63fdb8c48fb2b8ce680xf556faf23fc2feefa33ee6db2d1ee4c70e5345130x56d6d11df2aa6a0dbc5569a56c9299fcdb418911false06628344342020-08-06T08:23:42.000Z0xb0a746907530cf3d6abc79e69b9fefe4746185ca26c559dcfb0405eed5451555
0x3fad9ab6e95f22fdf8b646623d282b71374106420xf556faf23fc2feefa33ee6db2d1ee4c70e5345130x56d6d11df2aa6a0dbc5569a56c9299fcdb418911false032228375062020-08-06T10:09:18.000Z0xee4ea6f973b82790323e40f1d1cccd07ae83e558197eeffc6bb7ce2cb39667c1
0x08928ea95a6d400e782282a97e32265c0740cef40xf556faf23fc2feefa33ee6db2d1ee4c70e5345130x56d6d11df2aa6a0dbc5569a56c9299fcdb418911false04228259432020-08-06T03:31:48.000Z0x3f674148b13b61e1ce7772eb2c7ddd88d8e07e72783ac3d969815d5b826dc787
Query with partition filter
SELECT *
FROM `tt-contracts.polygon_v1_polygon.ERC721_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100