maybeyonasalgo_galgo_dex
Updated 2022-04-27
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date(block_timestamp) as date,
swap_program,
count(distinct tx_group_id) as swaps,
sum(
case when swap_from_asset_id = '694432641' then swap_from_amount else swap_to_amount end
) as volume
from algorand.swaps
where swap_from_asset_id = '694432641' or swap_to_asset_id = '694432641'
group by 1,2
-- limit 100
Run a query to Download Data