with from_algo as(select count(SWAPPER) as swap_from_algo,date_trunc('day', block_timestamp) as block_day
from algorand.swaps
where SWAP_FROM_ASSET_ID= 694432641
group by block_day),
to_algo as(select count(SWAPPER) as swap_to_algo,date_trunc('day', block_timestamp) as block_day
from algorand.swaps
where SWAP_TO_ASSET_ID= 694432641
group by block_day)
select from_algo.swap_from_algo,from_algo.block_day,to_algo.swap_to_algo from
from_algo INNER JOIN to_algo ON from_algo.block_day=to_algo.block_day