date_trunc('week', day),

block_rewards * rune_price,

(earnings + block_rewards) * rune_price,

bonding_earnings * rune_price

FROM flipside_prod_db.thorchain.block_rewards

LEFT outer JOIN (

SELECT

date_trunc('day', block_timestamp) as day1,

median(LIQ_FEE_RUNE_USD/LIQ_FEE_RUNE) as rune_price

FROM flipside_prod_db.thorchain.swaps

where not LIQ_FEE_RUNE = 0

GROUP BY 1

) ON day = day1