| SUBACCOUNT | TEXT | Independent Blitz 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. |
| TRADER | TEXT | The wallet address of the trader, there can be multiple subaccounts associated with a trader. |
| FIRST_TRADE_TIMESTAMP | TIMESTAMP_NTZ | The block timestamp of this subaccounts first trade. |
| LAST_TRADE_TIMESTAMP | TIMESTAMP_NTZ | The block timestamp of this subaccounts most recent trade. |
| ACCOUNT_AGE | NUMBER | The age of the account in days. |
| TRADE_COUNT | NUMBER | The total amount of trades executed by the account |
| TRADE_COUNT_RANK | NUMBER | The rank against all accounts based on trade count volume. |
| TRADE_COUNT_24H | NUMBER | The total amount of trades made in the last 24 hours. |
| TRADE_COUNT_RANK_24H | NUMBER | The rank against all accounts based on trade count volume in the last 24 hours. |
| PERP_TRADE_COUNT | NUMBER | The total amount of perpetual trades executed by the account |
| SPOT_TRADE_COUNT | NUMBER | The total amount of spot trades executed by the account |
| LONG_COUNT | NUMBER | The total amount of buys/longs on the account. |
| SHORT_COUNT | NUMBER | The total amount of sell/shorts on the account. |
| TOTAL_USD_VOLUME | FLOAT | The total USD denominated volume of the account. |
| TOTAL_USD_VOLUME_RANK | NUMBER | The rank against all accounts based on total usd volume on the account. |
| TOTAL_USD_VOLUME_24H | FLOAT | The total USD denominated volume of the account in the last 24 hours. |
| TOTAL_USD_VOLUME_RANK_24H | NUMBER | The rank against all accounts based on the total USD denominated volume of the account in the last 24 hours. |
| AVG_USD_TRADE_SIZE | FLOAT | The average trade size in USD. |
| TOTAL_FEE_AMOUNT | FLOAT | The total amount of trading fees paid by the account. |
| TOTAL_BASE_DELTA_AMOUNT | FLOAT | The total base delta amount of the account. |
| TOTAL_QUOTE_DELTA_AMOUNT | FLOAT | The total quote delta amount of the account. |
| TOTAL_LIQUIDATION_AMOUNT | FLOAT | The total liquidation amount of the account. |
| TOTAL_LIQUIDATION_AMOUNT_QUOTE | FLOAT | To liquidate a position, there must be a payment (transfer) between the liquidator and the position holder. This done in the quote currency, USDC. Payments are signed as positive, meaning you received the USDC, or negative, meaning you paid. For perpetual liquidations, users should expect to see a (+) USDC payment. They will see a (-) USDC payment for borrowers since they need to pay the user for buying their borrow. |
| TOTAL_LIQUIDATION_COUNT | NUMBER | The total count of liquidation accounts on the account. |
| EZ_ACCOUNT_STATS_ID | TEXT | The unique identifier for each row in the table. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |
