> ## 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_daily_earnings

> THORChain daily protocol earnings — fees, rewards, and revenue breakdown.

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_daily_earnings` table daily earnings statistics for THORChain. This table tracks liquidity fees, block rewards, and total earnings distributed to nodes and pools. This table is partitioned by day.

## Column Descriptions

| **Column**                    | **Type**      | **Description**                        |
| ----------------------------- | ------------- | -------------------------------------- |
| **day**                       | date          | Date of the record                     |
| **liquidity\_fees**           | varchar       | Identifier                             |
| **liquidity\_fees\_usd**      | decimal(20,6) | Identifier                             |
| **block\_rewards**            | varchar       | Block Rewards                          |
| **block\_rewards\_usd**       | decimal(20,6) | Block Rewards Usd                      |
| **total\_earnings**           | varchar       | Total Earnings                         |
| **total\_earnings\_usd**      | decimal(20,6) | Total Earnings Usd                     |
| **earnings\_to\_nodes**       | varchar       | Earnings To Nodes                      |
| **earnings\_to\_nodes\_usd**  | decimal(20,6) | Earnings To Nodes Usd                  |
| **earnings\_to\_pools**       | varchar       | Earnings To Pools                      |
| **earnings\_to\_pools\_usd**  | decimal(20,6) | Earnings To Pools Usd                  |
| **avg\_node\_count**          | varchar       | Avg Node Count                         |
| **\_inserted\_timestamp**     | timestamp     | Timestamp of the record                |
| **fact\_daily\_earnings\_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_daily_earnings" />