Sbhn_NPOP Overall
    Updated 2022-09-28
    --credit : akbaridria
    with data_claimed as (
    select
    block_timestamp::date as date,
    try_to_number(event_inputs:amount::string)/pow(10, 18) as amount,
    event_inputs:recipient as user
    from
    optimism.core.fact_event_logs
    where
    -- tx_hash = '0x4afc33784549bc633b3618efb8c88e663890728889f21d467f39257c18d33156'
    -- and
    contract_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'
    and
    event_name = 'Claimed'
    )
    select
    sum(amount) as total_op,
    count(distinct user) as address
    from
    data_claimed
    Run a query to Download Data