select
day::DATE as DATE,
sum (LIQUIDITY_FEES) as "LIQUIDITY FEES",
sum (BLOCK_REWARDS) as "BLOCK REWARDS",
"BLOCK REWARDS" - "LIQUIDITY FEES" as "Fee volume need to offset"
from flipside_prod_db.thorchain.daily_earnings where day >= '2022-01-01' and LIQUIDITY_FEES > 0 group by DATE