NFT Sales
Column | Type | Description |
|---|---|---|
tx_id | TEXT | ID for the transaction. |
block_height | NUMBER | The block height the block was recorded at. |
block_timestamp | TIMESTAMP_NTZ | The date and time for when the block was written. |
marketplace | TEXT | Contract address for the marketplace where the transaction occurred. Flow uses a general-purpose contract at `A.4eb8a10cb9f87357.NFTStorefront` for a significant number of sales. This column does not necessarily indicate the website or specific platform on which the sale occurred. |
nft_collection | TEXT | The contract address or ID for the NFT Collection. |
nft_id | TEXT | The id of the NFT, usually a number. |
buyer | TEXT | The party in the transaction purchasing the asset, this is an account address. |
seller | TEXT | The party in the transaction selling the asset, this is an account address. |
price | FLOAT | The price of the asset, in the currency specified in the table. |
currency | TEXT | The contract address refering to the currency used in the transaction. This may or may not relate to a token in the prices table, depending on the marketplace or transaction. |
tx_succeeded | BOOLEAN | Transaction status, if it succeeded or failed. |
tokenflow | ARRAY | An array of events tracking the flow of tokens, in event_index order, for a transaction. This is constructed from the following events within a transaction: `TokensDeposited`, `TokensWithdrawn`, `ForwardedDeposit`. |
counterparties | ARRAY | An array containing the addresses interacted with during the tokenflow of the transaction. This contains all payers and recipients of tokens within the transaction. |
dbt Docs
dbt Docs
Full Documentation for Core NFT Sales
Last modified 8mo ago