niloUntitled Query
    Updated 2022-11-20
    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