select
date_trunc('day',block_timestamp) as block_day,
count(tx_group_id) as swaps,
sum(swap_from_amount) as STBL_volume,
sum(swap_to_amount) as USDC_volume
from algorand.swaps
where
swap_from_asset_id = '465865291' AND
swap_to_asset_id = '31566704' AND
block_timestamp >= '2022-05-08'
group by block_day
order by block_day