| FACT_POOL_BLOCK_STATISTICS_ID | TEXT | The surrogate key for the table. Will be unique and is used as a foreign key in other tables |
| DAY | DATE | The timestamp in day for the recorded of the block fee |
| ADD_ASSET_LIQUIDITY_VOLUME | NUMBER | How much asset liquidity has been added to the pool at this time for this pool |
| ADD_LIQUIDITY_COUNT | NUMBER | The count of add liquidity transactions |
| ADD_LIQUIDITY_VOLUME | NUMBER | The asset volume of liquidity added to the pool |
| ADD_RUNE_LIQUIDITY_VOLUME | NUMBER | |
| ASSET | TEXT | Asset name or pool name |
| ASSET_DEPTH | NUMBER | The current pool depth, which is the total Rune pooled in the asset |
| ASSET_PRICE | NUMBER | The asset price in RUNE for this day |
| ASSET_PRICE_USD | FLOAT | The asset price in USD |
| AVERAGE_SLIP | NUMBER | The average slip point for this block within the day |
| IMPERMANENT_LOSS_PROTECTION_PAID | NUMBER | The total impermanent loss protection paid for this pool on this day |
| RUNE_DEPTH | NUMBER | The pool depth |
| STATUS | TEXT | The pool status, which is active or not |
| SWAP_COUNT | NUMBER | Total swap transactions count |
| SWAP_VOLUME | NUMBER | Total swap volume |
| TO_ASSET_AVERAGE_SLIP | NUMBER | If the transaction is from Rune to Asset, the average slip point |
| TO_ASSET_COUNT | NUMBER | How many swaps happen from Rune to Asset |
| TO_ASSET_FEES | NUMBER | The total swap fees paid to transfer from Rune to Asset |
| TO_ASSET_VOLUME | NUMBER | The total volume transferred from Rune to Asset |
| TO_RUNE_AVERAGE_SLIP | NUMBER | If the transaction is from Asset to Rune, the average slip point |
| TO_RUNE_COUNT | NUMBER | How many swaps happen from Asset to Rune |
| TO_RUNE_FEES | NUMBER | The total swap fees paid to transfer from Asset to Rune |
| TO_RUNE_VOLUME | NUMBER | The total volume transferred from Asset to Rune |
| TOTALFEES | NUMBER | The total fees paid for the swaps |
| 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 addresses for this pool |
| UNITS | NUMBER | The swap units |
| WITHDRAW_ASSET_VOLUME | NUMBER | How many assets get withdrawn from the liquidity pools |
| WITHDRAW_COUNT | NUMBER | How many times the withdraw events happens |
| WITHDRAW_RUNE_VOLUME | NUMBER | How many rune volume get withdrawn from the pool |
| WITHDRAW_VOLUME | NUMBER | How many asset volume get withdrawn from the pool |
| TOTAL_STAKE | NUMBER | |
| DEPTH_PRODUCT | NUMBER | |
| SYNTH_UNITS | NUMBER | |
| POOL_UNITS | NUMBER | |
| LIQUIDITY_UNIT_VALUE_INDEX | FLOAT | |
| PREV_LIQUIDITY_UNIT_VALUE_INDEX | FLOAT | |
| _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. |
