granadohoThe Volume of Trades to gALGO3 and from gALGO3 by day
    Updated 2022-04-25
    (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)

    Run a query to Download Data