Skip to main content

​
Tables

​
XStore_HoldingsRemoved_event

NFT holding removal events from NFTX v1 vaults on Ethereum, tracking specific NFT token IDs removed from vault inventory. Used to analyze vault composition changes and NFT redemption activity.
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_vaultIdSTRINGUnique identifier for a vault within the protocol. Numeric string representation.
in_idSTRINGUnique identifier for the position, record, or entity within the protocol. Numeric string representation.
in_idaddressremovedlog_indexin_vaultIdblock_numberblock_timestamptransaction_hash
85190xbe54738723cea167a76ad5421b50caa49692e7b7false11315115012562020-12-22T05:08:50.000Z0x2ef0b7fea5d309152876f753e55987a906b2fa36e5f27491f6e5819e10430317
40460xbe54738723cea167a76ad5421b50caa49692e7b7false12915115011902020-12-22T04:54:28.000Z0xc703d435de139c3d8f2608761066c979427ee4e2b0474794dd41d893c8a8e2db
40460xbe54738723cea167a76ad5421b50caa49692e7b7false4015115013192020-12-22T05:24:28.000Z0x0ecf49c9a71dd22f97361a5d431bdae239f0dbe50ea73c562b340fd25b207b33
Query with partition filter
SELECT *
FROM `tt-contracts.nftx_v1_ethereum.XStore_HoldingsRemoved_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100