zero-ndoLtSto/from galgo3
    Updated 2022-04-30
    (
    select
    date_trunc('day',block_timestamp) as "date",
    count(distinct tx_group_id) as "number of trades",
    sum(swap_to_amount) as "volume of trades",
    'to galgo3' as "action"
    from algorand.swaps
    where swap_to_asset_id ='694432641'
    group by "date"
    )
    UNION
    (
    select
    date_trunc('day',block_timestamp) as "date",
    count(distinct tx_group_id) as "number of trades",
    sum(swap_from_amount) as "volume of trades",
    'from galgo3' as "action"
    from algorand.swaps
    where swap_from_asset_id ='694432641'
    group by "date"
    )
    Run a query to Download Data