osmosis.defi Table: fact_pool_fee_day Type: View
The table is an daily summary of fees accumulated each pool within Osmosis
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_ID | NUMBER | The block height the block was recorded at. |
| BLOCK_DATE | DATE | The date and time at which the block began. |
| POOL_ID | TEXT | Identifier for the pool within the module |
| CURRENCY | TEXT | The currency the fee was paid in |
| FEES | FLOAT | The decimal adjusted amount of the fee paid |
| FEES_USD | FLOAT | The USD amount of the fee paid |
| FEE_TYPE | TEXT | The type of fee paid. Will be either ‘swap’ or ‘exit’ |
| FACT_POOL_FEE_DAY_ID | TEXT | |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ |