| platform | VARCHAR(134217728) | The platform used to faciliate the mint. NULL for standard mints |
| protocol | VARCHAR(134217728) | The protocol of the platform. |
| trade_type | VARCHAR(134217728) | Type of trade. SINGLE_TRADE for single token mint or BUNDLE_TRADE when more than 1 token is minted in a transaction. |
| order_match_type | VARCHAR(134217728) | Type of order. |
| buyer_address | VARCHAR(130) | Pubkey of the buyer, defined as the party sending the funds |
| seller_address | VARCHAR(130) | Pubkey of the seller, defined as the party sending the NFT |
| _nft_recipient | VARCHAR(130) | Pubkey of the party receiving the NFT. May be different from buyer_address |
| _sales_proceeds_recipient | VARCHAR(130) | Pubkey of the party receiving the funds. May be different from seller_address |
| currency_address | VARCHAR(42) | Address of the currency used in the mint. |
| currency_symbol | VARCHAR(134217728) | Symbol of the currency used in the mint. |
| raw_gas_fee | VARCHAR(134217728) | Gas fee of the trade in satoshis. For multi-transaction batch mints, this would be the sum of the following components:1. gas fee any common transactions divided by size of batch mints2. gas fee of the individual reveal txn |
| gas_fee | FLOAT | Gas fee of the trade normalized |
| usd_gas_fee | FLOAT | USD value of the gas fee |
| raw_price | VARCHAR(134217728) | Price of the NFT in number of satoshis. (includes fees) |
| price | FLOAT | Price of the NFT normalized by dividing raw_price by the number of decimals. (includes fees) |
| usd_price | FLOAT | USD price paid for the NFTs in this mint. The USD value of the mint is calculated by multiplying the hourly exchange rate of the currency (e.g. BTC) with the price oracle data source from exchanges. |
| buyer_fees | VARIANT | 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 feesUse 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 | VARIANT | Fees paid by the NFT seller. Similar in structure to buyer_fees |
| agg_fees | VARIANT | Sum of the fees paid by the NFT buyer and the seller. Similar in structure to buyer_fees |
| raw_fee | VARCHAR(134217728) | Raw marketplace or protocol fee in satoshis. |
| fee | FLOAT | Fee tier of the liquidity pool, expressed in hundredths of a basis point (e.g. 3000 = 0.3%). Paid by traders to liquidity providers on each swap. |
| usd_fee | FLOAT | USD value of the marketplace or protocol fee. |
| total_mint_quantity | VARCHAR(134217728) | Total number of mints at the transaction level for a batch mint. total_mint_quantity = sum(item_quantity at the same txn_id) |
| item_quantity | VARCHAR(134217728) | Number of mints at the row level, associated with the movement of a single utxo. In some cases, 2 inscriptions can be in the same utxo, resulting in a bundle trade. |
| inscription_id | VARCHAR(73) | inscription id, composed of the genesis transaction hash with a i0 suffix to represent the first inscription in the tx |
| inscription_name | VARCHAR(134217728) | The inscription name, if available. |
| inscription_number | VARCHAR(134217728) | The inscription number, sometimes known as index, if available |
| collection_name | VARCHAR(134217728) | The collection name, if available. |
| collection_slug | VARCHAR(134217728) | The collection slug, if available. The collection slug is a human-readable, unique identifier. |
| content_type | VARCHAR(134217728) | Content type of the inscription |
| content_tag | VARCHAR(134217728) | Content tag, which is a reclassification of the raw content_type field to make it easy to analyze. |
| content_length | NUMBER(38,0) | Number of bytes of the inscription content |
| content_protocol | VARCHAR(134217728) | (For json inscriptions with a p key)The protocol of the inscription, derived with json_content[‘p’] |
| content_parsed | VARIANT | (For textual inscriptions) The parsed content of the inscription, could be a utf-8 string or a json object |
| is_brc20 | BOOLEAN | Derived with content_protocol = ‘brc-20’. To be deprecated for is_token + content_protocol |
| is_token | BOOLEAN | Used to identify token-like standards.Derived with content_protocol = ‘brc-20’ or ‘orc-20’ or ‘orc20’ |
| token_tick | VARCHAR(134217728) | The tick of the token-like inscription. Derived with content_parsed[‘tick’] |
| token_amt | VARCHAR(134217728) | The amout specified in the token-like inscription. Derived with content_parsed[‘amt’] |
| sats_per_token_tick | VARCHAR(134217728) | Price in satoshis per unit of this BRC-20 token at the time of the trade. |
| usd_per_token_tick | FLOAT | USD per token-like amount. Only valid for launchpad mints.Derived with USD of the launch / token_amt |
| domain_protocol | VARCHAR(134217728) | Protocol under which this domain name was registered (e.g. ens, .sats, .bitmap). |
| domain_name | VARCHAR(134217728) | the domain name (portion before the . ) |
| domain_namespace | VARCHAR(134217728) | the domain namespace (portion after the . ) |
| domain_valid | BOOLEAN | true/false - domains are invalid if they are not the first or are unstable inscriptions |
| domain_meta | VARCHAR(134217728) | the metadata of the domain op, such as about, rev, avatar fields. |
| is_domain | BOOLEAN | 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. |
| genesis_fee | VARCHAR(134217728) | Genesis fee of the inscription when it was inscribed. If there are multiple inscriptions created in the tx, this number is divided by the total number of inscriptions created in the transaction. |
| satoshi_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the satoshi when it was mined. |
| transaction_hash | VARCHAR(66) | Transaction hash of where this mint occurred. |
| transaction_index | NUMBER(38,0) | Index of the transaction within the block |
| block_timestamp | TIMESTAMP_NTZ(9) | Block timestamp of the mint. |
| block_number | NUMBER(38,0) | Block number of the mint. |
| block_hash | VARCHAR(66) | Block hash of the mint. |
| unique_id | VARCHAR(134217728) | Unique ID of this mint. |
| _metadata_updated_at | TIMESTAMP_NTZ(9) | When the stablecoin metadata was last updated. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |
