Nansen Query Documentation
Search…
⌃K
🗃

NFTs

Normalized tables for NFT sales, transfers, and mints.
Note that the schema for NFT data might change to reflect developments in the NFT space, such as new market places, auction types, etc. Each change will be noted in the documentation.
NFT datasets are organized by the chain the smart contract is deployed on.

NFT Lists

Table of all NFT project and addresses, table name: nft_list_enriched
Field name
Data Type
Description
project_id
STRING
Most of the time, the token address, except for projects like art blocks which projects share the same token address
nof_tokens_circulating
STRING
Address of the NFT
deployed_at
TIMESTAMP
Contract deployment time
name
STRING
Name of the NFT collection

NFT Balance

Table of daily NFT balances by address, table name: nft_balances
Field name
Data Type
Description
address
STRING
Address of the wallet
project_id
STRING
Project ID representing the NFT collection
eth_spent
FLOAT
Amount of ETH spent buying NFTs
eth_spent_unsold
FLOAT
Amount of ETH spent on unsold NFTs remaining in the wallet
eth_revenue
FLOAT
Amount of ETH received from sale of NFTs
nft_purchased
NUMERIC
Number of NFTs purchased
nft_sales
NUMERIC
Number of NFTs sold
nft_balance
NUMERIC
Remaining NFT balance for this collection
estimated_value
FLOAT
Estimated value of wallet balance

NFT Sales

Table name nft_sales_enriched_on_$chain
Field name
Data Type
Description
transaction_hash
STRING
Hash of the NFT transaction
transaction_from_address
STRING
The from value of the transaction
transaction_to_address
STRING
The to value of the transaction
block_timestamp
TIMESTAMP
Timestamp of the transaction block
token_address
STRING
The NFT Token address
project_id
STRING
The Project ID for the collection, used to differentiate collections that share the same token_address
from_address
STRING
NFT sale from address
to_address
STRING
NFT sales to address
price_eth
FLOAT
The price of the transaction in ETH
price_base
FLOAT
Price of the transaction in the base currency
payment_token
STRING
The payment token
payment_token_amount
FLOAT
The amount in payment token
nof_tokens
NUMERIC
Number of tokens transfered
transaction_fee
FLOAT
The transaction fee
platform
STRING
The platform where the transaction happened (if applicable)
transfers
RECORD
Repeated record field for NFTs in the transaction
transfers.token_address
STRING
The NFT token address
transfers.project_id
STRING
The NFT project ID
transfers.token_id
STRING
Specific ID of the NFT
transfers.nof_tokens
NUMERIC
Number of tokens sold
collection_name
STRING
The name of the NFT collection
not_wash_trade
BOOLEAN
True if not a suspected wash trade

NFT Transfers

Table name nft_transfers_all_with_context_on_$chain
Field name
Data Type
Description
transaction_hash
STRING
Hash of the transaction
block_timestamp
TIMESTAMP
Timestamp of the block
token_address
STRING
Token address of the NFT
project_id
STRING
The Project ID for the collection, used to differentiate collections that share the same token_address
name
STRING
Name of the collection
token_id
STRING
The ID of the token transferred
transaction_from_address
STRING
From address of the transaction
transaction_to_address
STRING
To address of the transaction
from_address
STRING
The NFT transfer from address
to_address
STRING
The NFT transfer to address
price_eth
STRING
The price in ETH of the transfer
nof_tokens
NUMERIC
The number of tokens transfered
platform
STRING
The platform used, if any

NFT Floor Price (Estimated)

The estimated floor price for each collection with historical data. For now on ethereum only. Table name nft_sales_floor_estimate_on_ethereum
Field name
Data Type
Description
project_id
STRING
Project ID of the NFT collection
collection_name
FLOAT
Name of the NFT collection
block_timestamp
FLOAT
Block timestamp of sale, can be repeated if multiple sales in the same block.
floor_price
FLOAT
The floor price at the block timestamp, multiple sales in the same block can have different floor prices based on the price of sale.

NFT Price & Volume Overview

Table of NFT price and volume data, table name nft_price_estimates
Field name
Data Type
Description
project_id
STRING
Project ID of the NFT collection
median_price_7_days
FLOAT
Median price over the last 7 days (if available)
median_price_24_hours
FLOAT
Median price over the last 24 hours (if available)
median_price_manual
FLOAT
Manually calculated median price if no data is available over the last 7 days
volume_7_days
FLOAT
Transaction volume in the last 7 days
volume_24_hours
FLOAT
Transaction volume in the last 24 hours
transactions_7_days
INTEGER
Number of transactions in the last 7 days
transactions_24_hours
INTEGER
Number of transaction in the last 24 hours