select
date_trunc('hour', block_timestamp) as date, sw.swap_program,
avg(swap_from_amount/swap_to_amount) as avg_price
from algorand.swaps sw
where date(block_timestamp) = '2022-03-30'
and sw.swap_from_amount > 0
and sw.swap_to_amount > 0
and (sw.swap_from_asset_id = 0)
and (swap_to_asset_id = 441139422) -- goMINT
group by date, sw.swap_program