(select
block_timestamp::date as date,
sum(swap_from_amount) as total_swap_from,
NULL as total_swap_to
from algorand.swaps
where swap_from_asset_id = '694432641'
group by 1
order by 1)
UNION
(select
block_timestamp::date as date,
NULL as total_swap_from,
sum(swap_to_amount) as total_swap_to
from algorand.swaps
where swap_to_asset_id = '694432641'
group by 1
order by 1)