select sum(swap_from_amount) as volume_from, date(block_timestamp) as date from algorand.swaps where swap_from_asset_id = 694432641 group by date

),

list_to as (

select sum(swap_to_amount) as volume_to, date(block_timestamp) as date from algorand.swaps where swap_to_asset_id = 694432641 group by date

select volume_from, volume_to, list_from.date from list_from inner join list_to

where list_from.date = list_to.date