KaskoazulTop 10 assets Algofi
    Updated 2022-03-22
    select ass.asset_name,
    sw.swap_program,
    count(sw.swap_to_asset_id) as swaps
    from algorand.swaps sw
    inner join algorand.asset ass
    on sw.swap_to_asset_id = ass.asset_id
    where block_timestamp >= '2022-01-01'
    and swap_from_amount > 0
    and swap_program = 'algofi'
    group by 1,2
    order by 3 desc
    limit 10

    Run a query to Download Data