> ## Documentation Index > Fetch the complete documentation index at: https://docs.allium.so/llms.txt > Use this file to discover all available pages before exploring further. # Trades With Wash Trading Flags ### Table Details | Property | Value | | ------------------- | ----------------------------------------------------------------------- | | Table Name | `bitcoin.nfts.trades_with_wash_trading_flags` | | Table Status | Production-Ready | | Unique Key | `block_timestamp`, `unique_id` | | Clustering Key(s) | `block_timestamp::date` | | Search Optimization | `transaction_hash`, `inscription_id`, `buyer_address`, `seller_address` | ### Table Columns | Column Name | Data Type | Description | | ------------------------------- | ------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | marketplace | VARCHAR(134217728) | Name of the NFT marketplace where this trade occurred (e.g. `opensea`, `blur`, `x2y2`, `looksrare`, `rarible`). | | protocol | VARCHAR(134217728) | Specific version or variant of the protocol (e.g. `uniswap_v3`, `aave_v2`, `stargate_v2`). Qualifies the `project` field with version information. | | trade\_type | VARCHAR(134217728) | Scope of the trade. `SINGLE_TRADE` for a single NFT, `BUNDLE_TRADE` when multiple NFTs are sold together in one transaction. | | order\_match\_type | VARCHAR(134217728) | How the order was fulfilled. `BUY` for a direct purchase at list price; `ACCEPT_BID` for a seller accepting an existing bid. | | buyer\_address | VARCHAR(130) | Address of the buyer in this NFT trade. | | seller\_address | VARCHAR(130) | Address of the seller in this NFT trade. | | \_nft\_recipient | VARCHAR(130) | Internal column tracking the final NFT recipient address after all transfer hops in a trade settlement. | | \_sales\_proceeds\_recipient | VARCHAR(130) | Internal column tracking the address that ultimately received the sales proceeds (may differ from seller if royalties or splits apply). | | currency\_address | VARCHAR(42) | Contract address of the currency used to pay for the NFT. Native currency (e.g. ETH) is represented as the zero address. | | currency\_symbol | VARCHAR(134217728) | Symbol of the currency used to pay for the NFT (e.g. `ETH`, `WETH`, `USDC`). | | raw\_gas\_fee | VARCHAR(134217728) | Raw miner fee paid for this transaction in satoshis (pre-decimal normalization). | | gas\_fee | FLOAT | Miner fee paid for this transaction in BTC. | | usd\_gas\_fee | FLOAT | USD value of the miner fee paid for this transaction. | | raw\_sales\_proceeds | VARCHAR(134217728) | Sales proceeds in the payment token's smallest unit (not decimal-adjusted). | | sales\_proceeds | FLOAT | Sales proceeds decimal-adjusted to the payment token's human-readable unit. | | usd\_sales\_proceeds | FLOAT | USD value of the sales proceeds at the time of the trade. | | raw\_price | VARCHAR(134217728) | Price paid for the NFT in the currency's smallest unit (not decimal-adjusted). | | price | FLOAT | Price per unit of the asset at the time of this event, in USD or in the quote token's units depending on context. | | usd\_price | FLOAT | USD value of the NFT trade at the time of the transaction. | | 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. | | 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. | | item\_quantity | VARCHAR(134217728) | Number of NFT items transferred in this trade. Always 1 for ERC-721; may be greater than 1 for ERC-1155 bundle trades. | | inscription\_id | VARCHAR(73) | ID of the inscription. | | inscription\_name | VARCHAR(134217728) | Human-readable name of the inscription (e.g. for Ordinals or similar protocols). | | inscription\_number | VARCHAR(134217728) | Ordinal inscription number assigned at time of inscription. Lower numbers are earlier inscriptions. | | collection\_name | VARCHAR(134217728) | Name of the collection | | collection\_slug | VARCHAR(134217728) | Canonical slug identifier for the NFT collection (e.g. noderunners, bitcoin-frogs). | | content\_type | VARCHAR(134217728) | MIME type of the inscription content (e.g. `text/plain`, `image/png`, `application/json`). | | content\_tag | VARCHAR(134217728) | High-level content category tag for the inscription (e.g. `image`, `text`, `brc20`, `domain`). | | content\_length | NUMBER(38,0) | Byte length of the inscription content. | | content\_protocol | VARCHAR(134217728) | Protocol under which this inscription was created (e.g. `ordinals`, `brc20`, `runes`). | | content\_parsed | VARIANT | Parsed content of the inscription as a JSON object, for structured protocols like BRC-20 or domain registrations. | | is\_brc20 | BOOLEAN | True if this inscription follows the BRC-20 fungible token standard. | | is\_token | BOOLEAN | True if this inscription represents a fungible token (BRC-20 or similar). | | token\_tick | VARCHAR(134217728) | Ticker symbol of the BRC-20 token inscribed (e.g. `ordi`, `sats`). | | token\_amt | VARCHAR(134217728) | Amount of BRC-20 tokens transferred or minted in this inscription operation. | | 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 price per unit of this BRC-20 token at the time of the trade. | | domain\_protocol | VARCHAR(134217728) | Protocol under which this domain name was registered (e.g. `ens`, `.sats`, `.bitmap`). | | domain\_name | VARCHAR(134217728) | The domain name string registered in this inscription. | | domain\_namespace | VARCHAR(134217728) | Top-level namespace of the domain (e.g. `.eth`, `.sats`, `.bitmap`). | | domain\_valid | BOOLEAN | True if this domain registration is valid per the protocol's rules. | | domain\_meta | VARCHAR(134217728) | JSON metadata attached to this domain registration (resolver, TTL, records). | | is\_domain | BOOLEAN | True if this inscription is a domain name registration. | | sat\_types | VARIANT | Array of satoshi type classifications for the sats in this UTXO (e.g. `uncommon`, `rare`, `epic`). | | sat\_types\_amounts | VARIANT | Array of amounts corresponding to each sat type in `sat_types`. | | is\_rune | BOOLEAN | True if this transaction involves a Runes protocol transfer or etching. | | rune\_id | VARCHAR(134217728) | Canonical identifier for a Rune, formatted as : (e.g. 840000:3). | | rune\_symbol | VARCHAR(134217728) | Unicode symbol character assigned to this Rune at etching time. | | spaced\_rune | VARCHAR(134217728) | Human-readable Rune name with spacers inserted at configured positions (e.g. UNCOMMON•GOODS). | | raw\_rune\_amount | VARCHAR(134217728) | Amount of Runes transferred, in the Rune's smallest divisible unit. | | rune\_amount | FLOAT | Rune amount decimal-adjusted by the Rune's divisibility. | | sats\_per\_rune | VARCHAR(134217728) | Price in satoshis per unit of this Rune at the time of trade. | | usd\_per\_rune | FLOAT | USD price per unit of this Rune at the time of trade. | | rune\_number | VARCHAR(134217728) | Sequential integer assigned to this Rune in the order it was etched, starting from 0. | | etching\_block\_timestamp | TIMESTAMP\_NTZ(9) | Timestamp of the block in which this Rune was etched (created). | | genesis\_fee | NUMBER(38,0) | Fee paid in satoshis to etch (create) this Rune or inscription. | | satoshi\_timestamp | TIMESTAMP\_NTZ(9) | Timestamp encoded in the satoshi's ordinal number, representing when this sat was mined. | | transaction\_hash | VARCHAR(66) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. | | transaction\_index | NUMBER(38,0) | Zero-based position of the transaction within its block. The first transaction in a block has index 0. | | block\_timestamp | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block that contains this record. | | block\_number | NUMBER(38,0) | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block. | | block\_hash | VARCHAR(66) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. | | unique\_id | VARCHAR(134217728) | Allium's deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. | | \_metadata\_updated\_at | TIMESTAMP\_NTZ(9) | When the stablecoin metadata was last updated. | | wash\_trading\_score | NUMBER(13,2) | Wash trading score calculated with behaviours-related to wash trading. | | wash\_trading\_level | VARCHAR(134217728) | Wash trading level is divided into five different levels from very low to very high - 'very low' if wash\_trading\_score = 0 'low' if wash\_trading\_score 4 | | extra\_fields | VARIANT | Protocol-specific fields as a JSON object. Keys: transfer\_uuid (transfer identifier, uint128 as varchar, from the event). | | \_created\_at | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database. | | \_updated\_at | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database. | | \_upstream\_created\_at | TIMESTAMP\_NTZ(9) | Timestamp when the upstream intermediate record feeding this row was first created. | | \_upstream\_updated\_at | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the most recent update to the upstream model that feeds this record. | | \_changed\_since\_full\_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |