> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# nftx_v1_ethereum

> Tables in tt-contracts.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.

<Accordion title="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.                                            |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.nftx_v1_ethereum.XStore_HoldingsRemoved_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***