KaskoazulPattern_ALGO-ASA
    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
    ),

    BAL100K AS (
    SELECT
    address,
    balance as balance_ALGO
    FROM
    algorand.account
    WHERE
    address IN ( SELECT address from New_wallets )
    AND balance_ALGO > 100000
    )

    SELECT
    AA.address,
    AA.amount,
    AA.asset_name,
    A.balance
    FROM
    algorand.account_asset AA
    INNER JOIN
    algorand.account A
    ON AA.address = A.address
    WHERE
    AA.address IN (SELECT address from BAL100K)
    ORDER BY 2 desc
    LIMIT 25
    Run a query to Download Data