nftx_v1_ethereum

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.

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_vaultId`	`STRING`	Unique identifier for a vault within the protocol. Numeric string representation.
`in_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.

Sample Data

in_id	address	removed	log_index	in_vaultId	block_number	block_timestamp	transaction_hash
8519	0xbe54738723cea167a76ad5421b50caa49692e7b7	false	113	15	11501256	2020-12-22T05:08:50.000Z	0x2ef0b7fea5d309152876f753e55987a906b2fa36e5f27491f6e5819e10430317
4046	0xbe54738723cea167a76ad5421b50caa49692e7b7	false	129	15	11501190	2020-12-22T04:54:28.000Z	0xc703d435de139c3d8f2608761066c979427ee4e2b0474794dd41d893c8a8e2db
4046	0xbe54738723cea167a76ad5421b50caa49692e7b7	false	40	15	11501319	2020-12-22T05:24:28.000Z	0x0ecf49c9a71dd22f97361a5d431bdae239f0dbe50ea73c562b340fd25b207b33

Example Query

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

⌘I

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

XStore_HoldingsRemoved_event

​Tables

​XStore_HoldingsRemoved_event

Tables

XStore_HoldingsRemoved_event