> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# thorchain.defi_pool_block_fees

> THORChain pool fees per block — swap and liquidity fees collected.

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

## Table Description

The `thorchain.defi_pool_block_fees` table block-level data for pool fees on THORChain. This table is partitioned by day.

## Column Descriptions

| **Column**                       | **Type**  | **Description**                        |
| -------------------------------- | --------- | -------------------------------------- |
| **DAY**                          | date      | Date of the record                     |
| **pool\_name**                   | varchar   | Name of the liquidity pool             |
| **rewards**                      | varchar   | Rewards                                |
| **total\_liquidity\_fees\_rune** | varchar   | Identifier                             |
| **asset\_liquidity\_fees**       | varchar   | Identifier                             |
| **rune\_liquidity\_fees**        | varchar   | Identifier                             |
| **earnings**                     | varchar   | Earnings                               |
| **\_unique\_key**                | varchar   | Unique Key                             |
| **\_INSERTED\_TIMESTAMP**        | timestamp | Timestamp of the record                |
| **fact\_pool\_block\_fees\_id**  | bigint    | Surrogate key for the fact record      |
| **inserted\_timestamp**          | timestamp | Time when the record was inserted      |
| **modified\_timestamp**          | timestamp | Time when the record was last modified |

## Table Sample

<TableSample tableSchema="thorchain" tableName="defi_pool_block_fees" />