mohammadhnumber of trades to gALGO3 and from gALGO3 by day
    Updated 2022-04-28
    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
    Run a query to Download Data