MahrooUntitled Query
    Updated 2022-11-15
    with claimerst as (
    select block_timestamp as claimdate,
    event_inputs:recipient as Claimer,
    event_inputs:amount/1e18 as Claimed_Volume
    from optimism.core.fact_event_logs
    where origin_to_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'
    and origin_function_signature = '0x2e7ba6ef'
    and event_name = 'Claimed')

    select block_timestamp::date as date,
    count (distinct delegator) as Delegators_Count
    from optimism.core.fact_delegations t1 join claimerst t2 on t1.Delegator = t2.claimer
    where status = 'SUCCESS'
    and t1.block_timestamp > claimdate
    group by 1
    Run a query to Download Data