nftx_v2_ethereum

Tables

Vault_Minted_event

NFT deposit events from NFTX V2 vaults on Ethereum, recording when users deposit NFTs to mint fungible vault tokens. Tracks deposited NFT IDs, recipient addresses, and vault contracts for analyzing vault composition and minting 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_nftIds`	`ARRAY<STRING>`	Array of NFT token identifiers being swapped or transferred in the operation. String-encoded integers representing unique token IDs within the NFT collection.
`in_amounts`	`ARRAY<STRING>`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_nftIds	log_index	in_amounts	block_number	block_timestamp	transaction_hash
0x0000000000b6339756c69614d183670ba8b25507	0x4330b9b4313b682472804c39dc33636d11e14ab6	false	[“129”]	527	[]	14658261	2022-04-26T05:07:19.000Z	0xfb9197b0b37e7495fd986cb1b5506a011ad24600d37f948cf8351d5c800e69db
0x00000003a567e3002f04d5d3db1abf0f94c43d11	0xe094b124dbff6e6a1905c4ee1c8dd65a805eb7a5	false	[“12251”]	20	[“1”]	14658486	2022-04-26T06:01:41.000Z	0xce576af65ec504e8cbcccee4b594d41b8ba5efff4526e984ed51f604af09b2a1
0x000000cb542d62d08e24a93e88bca116302f7dab	0xa79b1db8907fd89aaf17cb54fab919beccfb5254	false	[“745”]	30	[“1”]	14658009	2022-04-26T04:15:30.000Z	0xd552c0925d190b89c1ea88ac85dba87044578bbab1526504c013a6783c6ead88

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.nftx_v2_ethereum.Vault_Minted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Vault_Redeemed_event

NFT redemption events from NFTX V2 vaults on Ethereum, recording when users withdraw specific NFTs by burning vault tokens. Contains recipient addresses, redeemed token IDs, and vault contract addresses for tracking NFT exits from fractionalized pools.

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_nftIds`	`ARRAY<STRING>`	Array of NFT token identifiers being swapped or transferred in the operation. String-encoded integers representing unique token IDs within the NFT collection.
`in_specificIds`	`ARRAY<STRING>`	Array of NFT token IDs that were specifically requested for redemption from the NFTX vault. When populated, indicates a targeted redemption; when empty, indicates a random redemption from the vault’s holdings.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_nftIds	log_index	block_number	in_specificIds	block_timestamp	transaction_hash
0x07c9493c935c11cb877da6bfd47b84822fb3897d	0x03b1a9e8bc6cbe4beaeeac277a042a584fe0af59	false	[“752”,“485”]	264	14502743	[“752”,“485”]	2022-04-01T21:18:25.000Z	0x9797f8818d0beef64347e4b1d8eb7c8f8442cfcc3826a1eae5d85d528cbdd305
0xfa39d97ad1b8b6b42331a9d0317b8c8c21495af5	0x03b1a9e8bc6cbe4beaeeac277a042a584fe0af59	false	[“129”,“7166”]	539	14502599	[“129”,“7166”]	2022-04-01T20:46:25.000Z	0x3e5c326407e5dcb65ead9e49cfb66c942b764910f0ef536eb022bff0bfb4b82e
0x865a13a4c8373d115dd099c7ef02330e3fb4ec97	0x056187e89d8a22cda88698a75448aa8ff8a5bda4	false	[“6568”,“6668”]	416	14498270	[“6568”,“6668”]	2022-04-01T04:40:52.000Z	0xbef98e8595b786424867e4fab653127cadac76dcb79beaa51178903a8b89012d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.nftx_v2_ethereum.Vault_Redeemed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Vault_Swapped_event

NFT swap events from NFTX V2 vaults on Ethereum, recording specific NFT token IDs exchanged between depositors and redeemers. Tracks vault-to-vault or vault-to-user NFT swaps for analyzing collection liquidity and trading patterns.

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_nftIds`	`ARRAY<STRING>`	Array of NFT token identifiers being swapped or transferred in the operation. String-encoded integers representing unique token IDs within the NFT collection.
`in_amounts`	`ARRAY<STRING>`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).
`in_specificIds`	`ARRAY<STRING>`	NFT token IDs that were specifically requested to be withdrawn from the NFTX vault during the swap transaction. These values match the in_redeemedIds, indicating targeted selection rather than random redemption from the vault’s inventory.
`in_redeemedIds`	`ARRAY<STRING>`	NFT token IDs being redeemed from the NFTX vault in this swap transaction. Array of numeric strings representing the specific NFTs withdrawn from the vault pool.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_nftIds	log_index	in_amounts	block_number	in_redeemedIds	in_specificIds	block_timestamp	transaction_hash
0xa7ef08585b7188bcc140053b039933620bf7e04f	0xa4251ea8a5e71d3f10e3dc224f073bc8a61b4bcd	false	[“210”]	120	[]	14013959	[“22”]	[“22”]	2022-01-16T02:59:25.000Z	0x6816910e190cc28d521f9504bc6bed2e8a047a4d01068bb4d48875f2156e7563
0xdc2462fb375bde1454017293eace4df1a58f57e0	0xdcdc1c1cc33aa817cbdbe8f5e2390bf7cc43dc4b	false	[“25397”,“25401”,“25400”,“25398”]	247	[]	14013592	[“6635”,“7784”,“8743”,“12601”]	[“6635”,“7784”,“8743”,“12601”]	2022-01-16T01:36:02.000Z	0x81c7516a38e601cdba71a137d4b01ff7e198391a470bc23e3c4c223e508e7b53
0x5b37b7777f13a8659a10ee84e9102b049272eda5	0xf0fe1a87abf12099b77352bdcc10f5a87067b290	false	[“5511”,“5394”,“3728”]	710	[]	14017394	[“1425”,“6328”,“6325”]	[“1425”,“6328”,“6325”]	2022-01-16T15:35:13.000Z	0x99439c4d6a4c504e6795b7a7c473a3716ac6db13729a3e8b41e19ef127107977

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.nftx_v2_ethereum.Vault_Swapped_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

VaultFactory_NewFeeDistributor_event

Fee distributor contract updates for NFTX v2 protocol on Ethereum, tracking when the protocol changes its fee distribution mechanism. Used for analyzing protocol governance changes and fee routing configuration history.

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_oldDistributor`	`STRING`	Contract address of the previous fee distributor being replaced in this NFTX v2 VaultFactory update. Value is 0x0000000000000000000000000000000000000000 for initial distributor assignments.
`in_newDistributor`	`STRING`	Contract address of the newly assigned NFTX fee distributor contract for the vault factory. This address replaces the previous distributor and handles fee distribution logic for NFTX v2 vaults.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newDistributor	in_oldDistributor
0xbe86f647b167567525ccaafcd6f881f1ee558216	false	5	12675821	2021-06-21T05:40:53.000Z	0xbfd111211c1519e9feef6c347327606b4e542a02bdbf892f20c2eac73a37fccd	0x7ae9d7ee8489cad7afc84111b8b185ee594ae090	0x0000000000000000000000000000000000000000
0xbe86f647b167567525ccaafcd6f881f1ee558216	false	210	13516737	2021-10-30T05:53:32.000Z	0x9b0e1d55e4af182057e12a95f48ad01ea8b5e3a7226dcada69bbe379af308743	0xfd8a76dc204e461db5da4f38687adc9cc5ae4a86	0x7ae9d7ee8489cad7afc84111b8b185ee594ae090

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.nftx_v2_ethereum.VaultFactory_NewFeeDistributor_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

VaultFactory_NewVault_event

NFT vault creation events from NFTX V2 protocol on Ethereum, linking vault IDs to their underlying NFT collection addresses and deployed vault contract addresses. Tracks when new vaults are initialized for fractionalized NFT collections.

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_vaultAddress`	`STRING`	Contract address of the newly created NFTX vault on Ethereum. Hex-encoded, 0x-prefixed 40-character string representing the vault’s deployed smart contract.
`in_assetAddress`	`STRING`	Contract address of the asset token involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_vaultId	block_number	block_timestamp	in_assetAddress	in_vaultAddress	transaction_hash
0xbe86f647b167567525ccaafcd6f881f1ee558216	false	127	585	15164499	2022-07-18T04:33:32.000Z	0x356e1363897033759181727e4bff12396c51a7e0	0x6e946833aa67eaf849927817f25f0d2f04064499	0xd93f58c9635035ce4fa855184a34126a4009f0e768eaddf026eddb924ff7b6d5
0xbe86f647b167567525ccaafcd6f881f1ee558216	false	592	586	15166928	2022-07-18T13:32:59.000Z	0x809d8f2b12454fc07408d2479cf6dc701ecd5a9f	0x64be093cf4ab72d6af0fcb4d5bced335817bc5af	0x0dcd2afba54984942599446a36d291906da8914f539490d1b36e478cc9939c55
0xbe86f647b167567525ccaafcd6f881f1ee558216	false	314	386	14376523	2022-03-13T05:38:38.000Z	0x5aeb2a703323f69b20f397bcb7b38610ec37237b	0x0b9a59d28869e6e52ae86c1289bc39f63ba92d50	0x3eb7488e64cf08a8e4a3f55605efe2f010f307cfdd91b4ed0c3171decc61f013

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.nftx_v2_ethereum.VaultFactory_NewVault_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

Vault_Minted_event

Vault_Redeemed_event

Vault_Swapped_event

VaultFactory_NewFeeDistributor_event

VaultFactory_NewVault_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Vault_Minted_event

​Vault_Redeemed_event

​Vault_Swapped_event

​VaultFactory_NewFeeDistributor_event

​VaultFactory_NewVault_event

Tables

Vault_Minted_event

Vault_Redeemed_event

Vault_Swapped_event

VaultFactory_NewFeeDistributor_event

VaultFactory_NewVault_event