KaskoazulTop 10 ASA by new addresses number
    Updated 2022-02-17
    WITH New_wallets AS (
    SELECT
    address
    FROM
    algorand.account
    WHERE
    created_at>= 18363444 AND created_at<=18974008 -- 18363444 January first block 18974008 January last block
    ),

    TOP_10 AS (
    SELECT
    count(address) as Number_of_addresses,
    asset_id
    FROM
    algorand.account_asset
    WHERE
    address IN ( SELECT * from New_wallets )
    GROUP BY 2
    ORDER BY 1 DESC
    LIMIT 10
    )
    SELECT
    Number_of_addresses,
    CASE asset_id
    WHEN '287867876' THEN 'Opulous'
    WHEN '312769' THEN 'Tether USDt'
    WHEN '31566704' THEN 'USDC'
    WHEN '27165954' THEN 'PLANET'
    WHEN '137020565' THEN 'Buy Token'
    WHEN '300208676' THEN 'Smile Coin'
    WHEN '226701642' THEN 'Yieldly'
    WHEN '283820866' THEN 'Xfinite Entertainment Token'
    WHEN '230946361' THEN 'AlgoGems'
    WHEN '548981315' THEN 'Drape Coin (deleted)'
    END AS ASA
    Run a query to Download Data