day AS reward_date,

SUM(block_rewards) AS total_block_rewards,

AVG(avg_node_count) AS avg_node_count

thorchain.defi.fact_block_rewards

GROUP BY

reward_date

ORDER BY

reward_date;