rahoprospective-bronze
    Updated 2024-09-10
    SELECT
    DISTINCT user_address,
    balance,
    MAX(block_timestamp) AS latest_timestamp
    FROM ethereum.core.fact_token_balances
    WHERE contract_address = LOWER('0xb47e3cd837dDF8e4c57F05d70Ab865de6e193BBB')
    AND block_timestamp <= '2024-09-01'
    AND balance > 0
    GROUP BY 1,2
    QueryRunArchived: QueryRun has been archived