ErsvanCurrent top 20 holders for toke (June)
    Updated 2022-06-21
    SELECT
    BALANCE_DATE,
    USER_ADDRESS,
    SYMBOL,
    BALANCE
    FROM (
    SELECT
    ROW_NUMBER() OVER (
    partition by USER_ADDRESS order by BALANCE ASC
    ) AS RN,
    *
    FROM
    flipside_prod_db.ethereum.erc20_balances
    WHERE
    BALANCE_DATE BETWEEN '2022-6-01' AND CURRENT_DATE
    AND CONTRACT_ADDRESS = '0x2e9d63788249371f1dfc918a52f8d799f4a38c94'
    AND USER_ADDRESS IN (
    SELECT DISTINCT USER_ADDRESS FROM flipside_prod_db.ethereum.erc20_balances WHERE
    BALANCE_DATE BETWEEN '2022-6-01' AND CURRENT_DATE
    AND CONTRACT_ADDRESS = '0x2e9d63788249371f1dfc918a52f8d799f4a38c94'
    )
    )
    WHERE RN = 1
    AND LABEL_SUBTYPE IS NULL
    ORDER BY BALANCE DESC
    LIMIT 20






    Run a query to Download Data