| marketplace | VARCHAR(134217728) | Marketplace where this trade occurred. |
| protocol | VARCHAR(134217728) | Protocol that was used for this trade e.g. tensorswap vs tensorswap_cnft |
| aggregator_name | VARCHAR(134217728) | Name of the aggregator, if the trade was routed through an aggregator. |
| aggregator_address | VARCHAR(44) | Address of the aggregator, if the trade was routed through an aggregator. |
| order_match_type | VARCHAR(134217728) | ACCEPT_BID or BUY |
| trade_type | VARCHAR(134217728) | SINGLE_TRADE or BUNDLE_TRADE |
| buyer_address | VARCHAR(44) | Address of the buyer. |
| seller_address | VARCHAR(44) | Address of the seller. |
| from_token_account | VARCHAR(44) | NFT Token Account sending NFT. |
| to_token_account | VARCHAR(44) | NFT Token Account receiving NFT. |
| token_standard | VARCHAR(134217728) | Token standard. |
| item_quantity | NUMBER(38,0) | Number of NFTs bought. |
| token_mint | VARCHAR(44) | Token Mint Data. |
| token_metadata | VARCHAR(44) | Token Metadata. Its main goal is to attach additional data to Fungible or Non-Fungible Tokens on Solana. |
| is_cnft | BOOLEAN | Boolean indicator on whether the NFT is a cNFT (compressed NFT). |
| merkle_tree | VARCHAR(44) | cNFT data: The account that contains the Merkle tree, initialized by create_tree. |
| leaf_index | NUMBER(38,0) | cNFT data: The index of the leaf node in the Merkle tree. Can be retrieved from off-chain data store. |
| asset_id | VARCHAR(44) | Identifier for an asset. On Stellar, this is the issuer:code composite identifier for non-native assets. On other chains, may be a contract address or other unique key. |
| name | VARCHAR(134217728) | Market display name. |
| symbol | VARCHAR(134217728) | Ticker symbol of this token or asset. Short alias for token_symbol used in tables that preserve the original blockchain field naming convention. |
| collection_mint | VARCHAR(44) | Address of the collection mint |
| collection_name | VARCHAR(134217728) | Name of the collection |
| collection_symbol | VARCHAR(134217728) | Symbol of the collection |
| currency_mint | VARCHAR(44) | Address of the currency used in the trade. |
| currency_symbol | VARCHAR(134217728) | Symbol of the currency used in the trade. |
| raw_price | VARCHAR(134217728) | The price of the NFT in the currency used to purchase (not divided by the number of decimals). |
| price | FLOAT | ’raw_price’ divided by the number of decimals of the currency |
| usd_price | FLOAT | USD price paid for the NFTs in this trade. |
| raw_fees | VARCHAR(134217728) | Raw amount of fees paid for the NFTs in this trade. |
| fees | FLOAT | Fees paid for the NFTs in this trade. |
| usd_fees | FLOAT | USD value of fees for this trade. |
| buyer_fees | VARIANT | The fees paid by the buyer. |
| seller_fees | VARIANT | The fees paid by the seller. |
| agg_fees | VARIANT | The aggregate fees of the trade. |
| extra_fields | VARIANT | Protocol-specific fields as a JSON object. Keys: transfer_uuid (transfer identifier, uint128 as varchar, from the event). |
| signer | VARCHAR(44) | Transaction Signer. |
| block_slot | NUMBER(38,0) | Block number when the trade occurred. |
| block_height | NUMBER(38,0) | Block height when the trade occurred. |
| block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of when the trade occurred. |
| block_hash | VARCHAR(44) | Block hash of when the trade occurred. |
| txn_id | VARCHAR(88) | Transaction ID of this trade. |
| txn_index | NUMBER(38,0) | Transaction Index. |
| instruction_index | NUMBER(38,0) | Instruction Index of the transaction. |
| inner_instruction_index | NUMBER(38,0) | Zero-based position of this inner instruction within its parent instruction’s inner instructions array. -1 for top-level instructions that are not inner instructions. |
| outer_program_id | VARCHAR(44) | Program ID of the outermost instruction that invoked this inner instruction on Solana |
| _metadata_updated_at | TIMESTAMP_NTZ(9) | When the stablecoin metadata was last updated. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| unique_id | VARCHAR(134217728) | Unique ID of each trade. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
