Updated 2024-07-19
    SELECT --*
    count(distinct to_address) as users,
    sum(amount) as Total_BLAST,
    avg(amount) as Average_Claim_amount

    from blast.core.ez_token_transfers
    where contract_address like '0xb1a5700fa2358173fe465e6ea4ff52e36e88e2ad'
    and from_address like '0xf7be503166828fe8565c520d66645ac6a06bbdd7'
    and symbol like 'BLAST'
    QueryRunArchived: QueryRun has been archived