DATE_TRUNC('week', DAY) AS week,

SUM(liquidity_fees) as LF,

SUM(BLOCK_REWARDS) as BR,

(SUM(Block_rewards)+SUM(liquidity_fees))/2 as MID,

SUM(liquidity_fees_USD) as liquidity_f,

SUM(block_rewards_USD) as block_r,

FROM thorchain.defi.fact_daily_earnings

GROUP BY

DATE_TRUNC('week', DAY)