with thorchain_swaps as (select date_trunc('day', block_timestamp) as dt, count(distinct tx_id) as num_swaps,

sum(from_amount_usd) as swap_volume_usd, sum(liq_fee_asset_usd) as swap_fee_usd

from flipside_prod_db.thorchain.swaps

group by 1),

rune_price as (select date_trunc('day', block_timestamp) as dt, avg(rune_usd) as rune_price_usd

from flipside_prod_db.thorchain.prices

group by 1),

thorchain_rewards as (select date_trunc('day', a.day) as dt,

sum(block_rewards * rune_price_usd) as block_rewards_usd

from flipside_prod_db.thorchain.block_rewards a

inner join rune_price b on date_trunc('day', a.day) = b.dt

group by 1)

select avg(block_rewards_usd/swap_fee_usd) as avg_rewards_per_swap_fees

from thorchain_swaps a

inner join thorchain_rewards b on a.dt = b.dt

where a.dt >= current_date-7 and a.dt != current_date