niloUntitled Query
Updated 2022-11-20
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
swap_program as exchange,
case when a.swap_to_asset_id = 0 then 'ALGO' else b.asset_name end as asset_to,
count (a.tx_group_id) as num_swaps
from algorand.defi.fact_swap a
left join algorand.core.dim_asset b
on b.asset_id = a.swap_to_asset_id
where swap_program='tinyman'
group by 1, 2
order by 3 DESC
limit 5
Run a query to Download Data