Blockchain Coverage
Project and protocol coverage is available at each chain’s respective NFT trades page.Sample Query
NFT Volume Across Blockchains.select
date(block_timestamp) as date,
chain,
sum(usd_price) as usd_volume
from crosschain.nfts.trades
where block_timestamp >= current_timestamp - interval '90 days'
group by all
Table Columns
- EVM / Common
- Solana Only
- Bitcoin Only
- Sui Only
| Column Name | Description |
|---|---|
| chain | The blockchain where the NFT trade was executed |
| marketplace | Marketplace of the nft trade, e.g. opensea |
| protocol | The protocol of the marketplace determined by the smart contract used, e.g. wyvern or seaport |
| order_match_type | Type of sales. Registered as BUY for direct purchase and ACCEPT_BID for bids accepted. |
| trade_type | Type of trade. SINGLE_TRADE for single token sales or BUNDLE_TRADE when more than 1 token is sold in a transaction. |
| buyer_address | Address of the buyer. |
| seller_address | Address of the seller. |
| token_standard | Type of token traded in the transaction. null for BTC. |
| token_address | Token contract of the NFT in the trade. null for BTC, collection_mint for SOL |
| token_name | Name of the token traded. collection_name for SOL & BTC |
| token_symbol | Symbol of the token traded. collection_symbol for SOL, null for BTC |
| token_id | Token ID of the NFT traded. token_mint for SOL, inscription_id for BTC |
| item_quantity | Quantity of the item traded. For ERC721 tokens, the value is null. While for ERC1155 tokens, the value can be more than 1. |
| currency_address | Token address of the currency used for this trade. currency_mint for SOL |
| currency_symbol | Token symbol of the currency used for the trade. |
| raw_price | Raw price of the NFT trade (unnormalised) |
| price | Price of the NFT (normalised) |
| usd_price | USD value of the trade. The USD value of the trade is calculated by multiplying the hourly exchange rate of the currency (e.g. ETH) with the price oracle data source from exchanges |
| agg_fees | Sum of the fees paid by the NFT buyer and the seller. |
| buyer_fees | Fees paid by the NFT buyer. It might be “unimplemented” if we haven’t parse the fees for that protocol yet. Otherwise, it will be a json with 9 columns. “creator” fees are the ones paid to the nft creator (royalties); “platform” fees are paid to the marketplace; “total” fees are the sum of both fees Use this syntax to access a specific fee:buyer_fees[‘usd_total’]::double. And don’t worry about the unimplemented ones, they will become null |
| seller_fees | Fees paid by the NFT seller |
| aggregator_name | Name of the aggregator use for the trade. Will be empty is the trade did not involve the use of aggregators. |
| aggregator_address | Contract address of the aggregator used for the trade. |
| extra_fields | Extra fields such as fee details |
| transaction_hash | Transaction hash for this trade. txn_id for SOL |
| block_timestamp | The timestamp of the block that the corresponding transaction of this trade. |
| block_number | The block number that the corresponding transaction of this trade belongs to. block_slot for SOL |
| block_hash | The block hash that the corresponding transaction of this trade belongs to. |
| unique_id | Unique id generated for this trade. |
| Column Name | Description |
|---|---|
| token_metadata | Address of the token metadata account. Its main goal is to attach additional data to Fungible or Non-Fungible Tokens on Solana. |
| is_cnft | Boolean indicator on whether the NFT is a cNFT (compressed NFT). |
| merkle_tree | cNFT data: The account that contains the Merkle tree, initialized by create_tree. |
| leaf_index | cNFT data: The index of the leaf node in the Merkle tree. Can be retrieved from off-chain data store. |
| asset_id | Unified asset id compatible with Digital Assets Standards |
| signer | Address of the 1st signer of the transaction |
| block_height | Block height when the trade occurred. |
| txn_index | The index of the transaction within the block |
| instruction_index | The index of the instruction within the transaction |
| inner_instruction_index | The index of the inner instruction within the instruction |
| outer_program_id | The program ID that called to initiate the trade, e.g. NFT aggregators |
| Column Name | Description |
|---|---|
| _nft_recipient | Pubkey of the party receiving the NFT. May be different from buyer_address |
| _sales_proceeds_recipient | Pubkey of the party receiving the funds. May be different from seller_address |
| raw_sales_proceeds | Sales proceeds of the trade in satoshis |
| sales_proceeds | Sales proceeds of the trade normalized |
| usd_sales_proceeds | USD value of the sales proceeds |
| inscription_id | inscription id, composed of the genesis transaction hash with a i0 suffix to represent the first inscription in the tx |
| inscription_name | The inscription name, if available. |
| inscription_number | The inscription number, sometimes known as index, if available |
| content_type | Content type of the inscription |
| content_tag | Content tag, which is a reclassification of the raw content_type field to make it easy to analyze. |
| content_length | Number of bytes of the inscription content |
| content_protocol | (For json inscriptions with a p key) The protocol of the inscription, derived with json_content['p'] |
| content_parsed | (For textual inscriptions) The parsed content of the inscription, could be a utf-8 string or a json object |
| is_brc20 | Derived with content_protocol = 'brc-20'. To be deprecated for is_token + content_protocol |
| is_token | Used to identify token-like standards. Derived with content_protocol = 'brc-20' or 'orc-20' or 'orc20' |
| token_tick | The tick of the token-like inscription. Derived with content_parsed['tick'] |
| token_amt | The amout specified in the token-like inscription. Derived with content_parsed['amt'] |
| sats_per_token_tick | Satoshis per token-like amount. Derived with satoshi of the trade / token_amt |
| usd_per_token_tick | USD per token-like amount. Derived with USD of the trade / token_amt |
| domain_protocol | Domain name protocol used to parse the content |
| domain_name | the domain name (portion before the . ) |
| domain_namespace | the domain namespace (portion after the . ) |
| domain_valid | true/false - domains are invalid if they are not the first or are unstable inscriptions |
| domain_meta | the metadata of the domain op, such as about, rev, avatar fields. |
| is_domain | true/false - whether the domain name/namespace fit the requirements of sns/bitmap protocols. Malformed/illegal formats of inscriptions are removed here. There may be some edge cases because sns allows text inscriptions which have lots of noise. |
| sat_types | An array of (tuple-of-rarities), with each tuple representing the rare sats traits of a traded sat |
| sat_types_amounts | An array of (tuple-of-rarities), with each tuple representing the number of sats of the indicated rarity |
| is_rune | Indicates whether the trade is for Runes |
| rune_id | Unique identifier for the Rune |
| rune_symbol | The symbol for the Rune |
| spaced_rune | The name of the Rune |
| raw_rune_amount | The raw amount of the Rune traded (unnormalised) |
| sats_per_rune | The price per Rune in satoshis |
| usd_per_rune | The USD price per Rune |
| rune_number | The numeric unique identifier for the Rune |
| etching_block_timestamp | The timestamp of the block when the Rune was first “etched”, i.e. created or minted |
| genesis_fee | Genesis fee of the inscription when it was inscribed |
| satoshi_timestamp | The timestamp of the satoshi when it was mined. |
| Column Name | Description |
|---|---|
| marketplace | Marketplace where this trade occurred. e.g. tradeport |
| protocol | Protocol that was used for this trade e.g. orderbyte |
| package_id | Package ID of the protocol that was used for this trade. |
| event_type | Event type of the protocol that was used for this trade. |
| order_match_type | Type of sales. Registered as ‘BUY’ for direct purchase and ‘ACCEPT_BID’ for bids accepeted. |
| trade_type | Type of trade. SINGLE_TRADE for single token sale or BUNDLE_TRADE when more than 1 token is sold in a transaction |
| buyer_address | Address of the buyer. |
| seller_address | Address of the seller. |
| nft_id | object_id of the NFT. |
| nft_name | Name of the NFT collection. |
| collection_id | ID of the NFT collection. |
| nft_extra_fields | Extra fields of the NFT. |
| coin_type | Type of the currency used in the trade. |
| raw_price | The price of the NFT in the currency used to purchase (not divided by the number of decimals). |
| price | ’raw_price’ divided by the number of decimals of the currency |
| usd_price | The USD price of the NFTs in this trade. |
| extra_fields | Extra fields of the trade. |
| transaction_block_digest | The block digest of the transaction that contains the trade. |
| checkpoint_timestamp | The timestamp of the checkpoint that contains the trade. |
| checkpoint_sequence | The sequence of the checkpoint that contains the trade. |
| checkpoint_digest | The digest of the checkpoint that contains the trade. |
| unique_id | Unique ID of each trade. |