MLDZMNpepe7
    Updated 2023-06-07
    -- forked from fbba3 @ https://flipsidecrypto.xyz/edit/queries/68f89235-500f-4140-80a7-812813fbfa72

    select
    BLOCK_TIMESTAMP::date date ,
    count(distinct USER_ADDRESS) as holder ,
    sum(balance) as balances
    from
    ethereum.core.fact_token_balances
    where
    CONTRACT_ADDRESS ilike '0x6982508145454ce325ddbe47a25d4ec3d2311933'
    and
    date >= CURRENT_DATE - 30
    group by 1


    Run a query to Download Data