mariyaVolume of swap to-from gALGO3
Updated 2022-05-03
9
1
2
3
4
5
›
⌄
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