2844The number of trades to gALGO3 and from gALGO3 by day
    Updated 2022-04-29
    WITH from_Galgo as
    (
    select date_trunc('day',block_timestamp) as DATE, count (swap_from_asset_id) as "number of trades from gALGO3"
    from algorand.swaps
    where swap_from_asset_id = '694432641'
    and block_timestamp >= '2022-01-01'
    group by DATE
    order by date desc
    ),
    to_Galgo AS(
    select date_trunc('day',block_timestamp) as DATE2, count (swap_to_asset_id) as "number of trades to gALGO3"
    from algorand.swaps
    where swap_to_asset_id = '694432641'
    and block_timestamp >= '2022-01-01'
    group by DATE2
    order by date2 desc
    )
    select DATE, "number of trades to gALGO3","number of trades from gALGO3"
    from from_Galgo,to_Galgo
    where from_Galgo.DATE=to_Galgo.DATE2
    group by DATE, "number of trades to gALGO3","number of trades from gALGO3"
    order by date desc
    Run a query to Download Data