strawbettyTop 10 ASAs on Tinyman
    Updated 2022-03-28
    WITH tab1 as (
    SELECT
    swap_to_asset_id,
    count(DISTINCT swapper) as swaps
    from algorand.swaps
    WHERE block_timestamp > '2022-01-01'
    AND swap_program like 'tinyman'
    GROUP BY 1
    ORDER by 2 DESC
    LIMIT 11
    )

    SELECT
    asset_name,
    swaps
    FROM tab1
    LEFT outer JOIN algorand.asset
    ON swap_to_asset_id = asset_id
    WHERE NOT asset_name is NULL
    Run a query to Download Data