with inflow as (SELECT date_trunc('day', block_timestamp) as "DATE", sum(SWAP_FROM_AMOUNT) as Inflow
from algorand.swaps
where SWAP_TO_ASSET_ID = '694432641'
GROUP by 1
),
outflow as (SELECT date_trunc('day', block_timestamp) as "DATE", sum(SWAP_TO_AMOUNT) as Outflow
from algorand.swaps
where SWAP_from_ASSET_ID = '694432641'
GROUP by 1
)
select A.date, a.Inflow as Asset_Swaped_To_gALGO3, -b.Outflow as Asset_gALGO3_Swapped_to from inflow A
left outer join Outflow B ON A.date = B.date