with swap_data AS (
SELECT
date(block_timestamp) as date,
count(swapper) as swapper_count,
count(DISTINCT tx_group_id) as swap_count,
swap_program
from algorand.swaps
where date(block_timestamp) >= '2022-04-01'
and swap_from_amount > 0
and swap_to_asset_id = '694432641' -- gALGO3
GROUP by date, swap_program
)
SELECT
s.date,
s.swap_count,
s.swap_program
FROM swap_data s
GROUP BY s.date, s.swap_program, s.swap_count