thorchain.defi_daily_earnings - Dune Docs

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