PapasotMost Popular ASAs (wallets and asset name)
    Updated 2022-02-02
    SELECT
    asset_name AS ASA,
    asset_id,
    COUNT(DISTINCT(address)) AS wallets
    FROM
    algorand.account_asset
    WHERE
    asset_id IS NOT NULL
    AND
    (
    asset_id = '226701642' OR
    asset_id = '287867876' OR
    asset_id = '27165954' OR
    asset_id = '137594422' OR
    asset_id = '384303832' OR
    asset_id = '230946361' OR
    asset_id = '297995609' OR
    asset_id = '300208676' OR
    asset_id = '31566704' OR
    asset_id = '312769'
    )
    GROUP BY asset_id, asset_name
    Order by wallets DESC
    Limit 10
    Run a query to Download Data