trunc(block_timestamp,'day') as date,

asset_name as asset_swapped_for_STBL,

count(distinct tx_group_id) as n_swaps,

count(distinct swapper) as n_swappers

from algorand.swaps x

join algorand.account_asset y on x.swap_from_asset_id=y.asset_id

where block_timestamp between '2022-05-08' and '2022-05-14'

and swap_to_asset_id=465865291

group by 1,2

order by 1 asc, 3 desc