NFTs
Trades
The NFT Trades table aggregates ERC721 and ERC1155 token sales from popular NFT marketplaces and protocols.
Our current NFT trades model supports single-currency trades (trades involving either one ERC20 token or ETH alone), which constitute most of the current NFT trades.
Coverage:
Protocol | Marketplace |
---|---|
seaport | opensea, magiceden, unlabeled, mintify, okx |
Table Columns
Unique Key: unique_id
Column Name | Data Type | Description |
---|---|---|
marketplace | varchar | Marketplace where the trade occurred |
protocol | varchar | Protocol used for the trade |
order_match_type | varchar | Type of order match: ‘ACCEPT_BID’ or ‘BUY’ |
trade_type | varchar | Type of trade: ‘SINGLE_TRADE’ or ‘BUNDLE_TRADE’ |
buyer_address | varchar(42) | Address of the buyer |
seller_address | varchar(42) | Address of the seller |
token_standard | varchar | Token standard of the NFT (e.g., ERC721, ERC1155) |
token_address | varchar(42) | Contract address of the NFT collection |
token_id | varchar | ID of the NFT traded |
token_name | varchar | Name of the NFT collection |
token_symbol | varchar | Symbol of the NFT collection |
item_quantity | varchar | Number of NFTs bought |
currency_address | varchar(42) | Address of the currency used in the trade (zero address for native tokens) |
currency_symbol | varchar | Symbol of the currency used in the trade |
raw_price | varchar | Price of the NFT in the original currency (not divided by decimals) |
price | float | ’raw_price’ divided by the number of decimals of the currency |
usd_price | float | USD price of the NFTs in this trade |
agg_fees | variant | Aggregated fees information including creator, platform, and total fees |
buyer_fees | variant | Fees paid by the buyer |
seller_fees | variant | Fees paid by the seller |
aggregator_name | varchar | Name of the aggregator used for the trade (if applicable) |
aggregator_address | varchar(42) | Contract address of the aggregator used for the trade (if applicable) |
extra_fields | variant | Additional information specific to the trade or protocol |
transaction_hash | varchar(66) | Transaction hash of this trade |
block_timestamp | timestamp_ntz(9) | Timestamp of the block when the trade occurred |
block_number | bigint | Number of the block when the trade occurred |
block_hash | varchar(66) | Hash of the block when the trade occurred |
unique_id | varchar | Unique identifier for each trade |
_created_at | timestamp_ntz(9) | Timestamp of when this record was created |
_updated_at | timestamp_ntz(9) | Timestamp of when this record was last updated |
_helper_nft_tokens__updated_at | timestamp_ntz(9) | Timestamp of when the NFT metadata was last updated |
_changed_since_full_refresh | boolean | Whether this record has changed since the last full refresh |