select count(*) as swap_from_gAlgo3, date(block_timestamp) as date from algorand.swaps where swap_from_asset_id = 694432641 group by date

),

list_to as (

select count(*) as swap_to_galgo3, date(block_timestamp) as date from algorand.swaps where swap_to_asset_id = 694432641 group by date

select swap_from_galgo3, swap_to_galgo3, list_from.date from list_from inner join list_to

where list_from.date = list_to.date