Table Details
| Property | Value |
|---|---|
| Table Name | ethereum.nfts.sudoswap_trades |
| Table Status | Production-Ready |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| order_match_type | VARCHAR(4) | How the order was fulfilled. BUY for a direct purchase at list price; ACCEPT_BID for a seller accepting an existing bid. |
| pool_address | VARCHAR(42) | Address of the EIP-1167 SettlementPool clone that holds the user’s USDC collateral. |
| token_address | VARCHAR(16777216) | Contract address of the token. For EVM chains, native currency (e.g. ETH, MATIC) is represented as the zero address (0x0000000000000000000000000000000000000000). For Solana, this is the mint address. |
| token_symbol | VARCHAR(16777216) | Ticker symbol of the token (e.g. “USDC”, “WETH”). |
| token_ids | ARRAY | Array of NFT token IDs transferred in this trade. Multiple IDs indicate a batch swap of several NFTs in a single transaction. |
| eth_total_raw | NUMBER(38,0) | Total ETH amount for this Sudoswap trade in wei (not decimal-adjusted). Sum of all ETH transferred for the full batch of NFTs. |
| eth_total_volume | FLOAT | Total ETH amount for this Sudoswap trade (decimal-adjusted). Equal to eth_total_raw / 1e18. |
| usd_total_volume | FLOAT | Total USD value of this Sudoswap trade, computed as eth_total_volume * usd_exchange_rate. |
| eth_unit_price_raw | NUMBER(38,6) | ETH price per individual NFT in this trade in wei (not decimal-adjusted). |
| eth_unit_price | FLOAT | ETH price per individual NFT in this trade (decimal-adjusted). Equal to eth_total_volume / count(token_ids). |
| usd_unit_price | FLOAT | USD price per individual NFT in this trade, computed as eth_unit_price * usd_exchange_rate. |
| usd_exchange_rate | VARCHAR(16777216) | USD price per unit of the token at the time of the event, used to compute usd_amount. Sourced from Allium’s hourly price feed. |
| transaction_hash | VARCHAR(66) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. |
| 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. |
| _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. |