rahoTotal Users OP Claimed
    Updated 2023-04-13
    -- DelegateChanged - DelegateVotesChanged

    with claims as (select
    date_trunc('day', block_timestamp) as tx_date,
    block_number,
    tx_hash,
    origin_from_address,
    origin_to_address,
    contract_address,
    from_address,
    to_address,
    raw_amount / power(10,18) as amount
    from optimism.core.fact_token_transfers
    where contract_address = '0x4200000000000000000000000000000000000042'
    and from_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'),

    total_claimed as (
    select
    sum(amount)
    from claims
    ),

    total_users_claimed as(
    select
    count(distinct to_address) as users
    from
    claims
    )

    select
    sum(users)
    from
    total_users_claimed
    limit 100
    Run a query to Download Data