mariyaVolume of swap to-from gALGO3
    Updated 2022-05-03

    with
    st as (select date_trunc('day',block_timestamp) as dt, count (distinct tx_group_id) as st, sum (swap_to_amount) as stv from algorand.swaps where swap_to_asset_id ='694432641' group by 1),
    sf as (select date_trunc('day',block_timestamp) as dt, count (distinct tx_group_id) as sf, sum (swap_from_amount) as sfv from algorand.swaps where swap_from_asset_id ='694432641' group by 1)
    select st.dt, st.st as "Swap to gAlgo3", sf.sf as "Swap from gAlgo3", stv as "Volume: Swap to gAlgo3", sfv as "Volume: Swap from gAlgo3" from st inner join sf on st.dt=sf.dt order by 1
    Run a query to Download Data