Skip to main content
Schema: ink.nado Table: ez_account_stats Type: View

​
What

Subaccount level table showing aggregated total activity across the Nado exchange.

​
Columns

Column NameData TypeDescription
SUBACCOUNTTEXTIndependent Nado account of trader with its own margin, balance, positions, and trades. Any wallet can open an arbitrary number of these. Risk is not carried over from subaccount to subaccount.
TRADERTEXTThe wallet address of the trader, there can be multiple subaccounts associated with a trader.
FIRST_TRADE_TIMESTAMPTIMESTAMP_NTZThe block timestamp of this subaccounts first trade.
LAST_TRADE_TIMESTAMPTIMESTAMP_NTZThe block timestamp of this subaccounts most recent trade.
ACCOUNT_AGENUMBERThe age of the account in days.
TRADE_COUNTNUMBERThe total amount of trades executed by the account
TRADE_COUNT_RANKNUMBERThe rank against all accounts based on trade count volume.
TRADE_COUNT_24HNUMBERThe total amount of trades made in the last 24 hours.
TRADE_COUNT_RANK_24HNUMBERThe rank against all accounts based on trade count volume in the last 24 hours.
PERP_TRADE_COUNTNUMBERThe total amount of perpetual trades executed by the account
SPOT_TRADE_COUNTNUMBERThe total amount of spot trades executed by the account
LONG_COUNTNUMBERThe total amount of buys/longs on the account.
SHORT_COUNTNUMBERThe total amount of sell/shorts on the account.
TOTAL_USD_VOLUMEFLOATThe total USD denominated volume of the account.
TOTAL_USD_VOLUME_RANKNUMBERThe rank against all accounts based on total usd volume on the account.
TOTAL_USD_VOLUME_24HFLOATThe total USD denominated volume of the account in the last 24 hours.
TOTAL_USD_VOLUME_RANK_24HNUMBERThe rank against all accounts based on the total USD denominated volume of the account in the last 24 hours.
AVG_USD_TRADE_SIZEFLOATThe average trade size in USD.
TOTAL_FEE_AMOUNTFLOATThe total amount of trading fees paid by the account.
TOTAL_BASE_DELTA_AMOUNTFLOATThe total base delta amount of the account.
TOTAL_QUOTE_DELTA_AMOUNTFLOATThe total quote delta amount of the account.
TOTAL_LIQUIDATION_AMOUNTFLOATThe total liquidation amount of the account.
TOTAL_LIQUIDATION_AMOUNT_QUOTEFLOATTo liquidate a position, there must be a payment (transfer) between the liquidator and the position holder. This done in the quote currency, USDT0. Payments are signed as positive, meaning you received the USDT0, or negative, meaning you paid. For perpetual liquidations, users should expect to see a (+) USDT0 payment. They will see a (-) USDT0 payment for borrowers since they need to pay the user for buying their borrow.
TOTAL_LIQUIDATION_COUNTNUMBERThe total count of liquidation accounts on the account.
EZ_ACCOUNT_STATS_IDTEXTPrimary key - unique identifier for each row ensuring data integrity. Format: Usually VARCHAR containing composite key generated using MD5 hash of the relevant columns. Example: MD5(blocknumber, txhash, trace_index) Usage: Deduplication in incremental loads Join operations for data quality checks Troubleshooting specific records Important: Implementation varies by table - check table-specific documentation.
INSERTED_TIMESTAMPTIMESTAMP_NTZUTC timestamp when the record was first added to the Flipside database. Format: TIMESTAMP_NTZ Use Cases: Data freshness monitoring Incremental processing markers Debugging data pipeline issues SLA tracking Query Example:
MODIFIED_TIMESTAMPTIMESTAMP_NTZUTC timestamp of the most recent update to this record. Format: TIMESTAMP_NTZ Triggers for Updates: Data corrections Enrichment additions Reprocessing for accuracy Schema migrations Monitoring Usage: