| FACT_DAILY_POOL_STATS_ID | TEXT | The surrogate key for the table. Will be unique and is used as a foreign key in other tables |
| DAY | DATE | The unique transaction id |
| POOL_NAME | TEXT | Name of the pool — also asset name in other tables |
| SYSTEM_REWARDS | FLOAT | The total daily system rewards in RUNE to the pool |
| SYSTEM_REWARDS_USD | FLOAT | The total daily system rewards in USD to the pool |
| ASSET_LIQUIDITY | FLOAT | The total asset liquidity for this pool |
| ASSET_PRICE | NUMBER | Current asset price |
| ASSET_PRICE_USD | FLOAT | Current asset price in USD |
| RUNE_LIQUIDITY | FLOAT | The total RUNE liquidity for this pool |
| RUNE_PRICE | FLOAT | Current RUNE price |
| RUNE_PRICE_USD | FLOAT | Current RUNE price in USD |
| ADD_LIQUIDITY_COUNT | NUMBER | How many times to add liquidity to the pool |
| ADD_ASSET_LIQUIDITY | FLOAT | The total amount of asset liquidity added to the pool |
| ADD_ASSET_LIQUIDITY_USD | FLOAT | The total amount in usd of asset liquidity added to the pool |
| ADD_RUNE_LIQUIDITY | FLOAT | The total amount of RUNE liquidity added to the pool |
| ADD_RUNE_LIQUIDITY_USD | FLOAT | The total amount in usd of RUNE liquidity added to the pool |
| WITHDRAW_COUNT | NUMBER | Time to withdraw from the pool |
| WITHDRAW_ASSET_LIQUIDITY | FLOAT | The total amount of asset withdrawn from the pool |
| WITHDRAW_ASSET_LIQUIDITY_USD | FLOAT | The total amount in USD of asset withdrawn from the pool |
| WITHDRAW_RUNE_LIQUIDITY | FLOAT | The total amount of RUNE withdrawn from the pool |
| WITHDRAW_RUNE_LIQUIDITY_USD | FLOAT | The total amount in USD of RUNE withdrawn from the pool |
| IL_PROTECTION_PAID | FLOAT | Impermanent loss protection cost paid to the network |
| IL_PROTECTION_PAID_USD | FLOAT | Impermanent loss protection cost in USD paid to the network |
| AVERAGE_SLIP | NUMBER | Average slippage |
| TO_ASSET_AVERAGE_SLIP | NUMBER | When swap from RUNE to Asset, the average slippage |
| TO_RUNE_AVERAGE_SLIP | NUMBER | When swap from Asset to RUNE, the average slippage |
| SWAP_COUNT | NUMBER | Total number of swaps |
| TO_ASSET_SWAP_COUNT | NUMBER | Total number of swaps from RUNE TO Asset |
| TO_RUNE_SWAP_COUNT | NUMBER | Total number of swaps from Asset TO RUNE |
| SWAP_VOLUME_RUNE | FLOAT | The swap amount of RUNE |
| SWAP_VOLUME_RUNE_USD | FLOAT | The swap amount of RUNE in USD |
| TO_ASSET_SWAP_VOLUME | FLOAT | The swap volume from RUNE to Asset |
| TO_RUNE_SWAP_VOLUME | FLOAT | The swap volume from Asset to RUNE |
| TOTAL_SWAP_FEES_RUNE | FLOAT | Total swap fees in RUNE |
| TOTAL_SWAP_FEES_USD | FLOAT | Total swap fees in USD |
| TOTAL_ASSET_SWAP_FEES | FLOAT | Total asset swap fees in asset |
| TOTAL_ASSET_RUNE_FEES | FLOAT | Total asset swap fees in RUNE |
| UNIQUE_MEMBER_COUNT | NUMBER | All memberships with a rune address. Take the member from rune and asset and then subtract the balance = 0 then get the results |
| UNIQUE_SWAPPER_COUNT | NUMBER | The unique swap address for this pool |
| LIQUIDITY_UNITS | NUMBER | The amount of units for the liquidity in the pool |
| _AUDIT_RUN_ID | TEXT | |
| 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. |
