date(block_timestamp) as date, sw.swap_program,

count(DISTINCT sw.tx_group_id) as swapped_count,

count(DISTINCT sw.swapper) as swapper_count,

sum(case when swap_from_asset_id = 0 then swap_from_amount else 0 END) as algo_volume

from algorand.swaps sw

where date(block_timestamp) >= '2022-03-29'

and sw.swap_from_amount > 0

and (sw.swap_from_asset_id = 0 or swap_from_asset_id = 441139422) -- goMINT

and (swap_to_asset_id = 441139422 or swap_to_asset_id = 0)

group by date, sw.swap_program