freeman_7AmountStakED
    Updated 2024-11-29
    with claimers as (
    select
    count(distinct decoded_log:recipient) as Claimer,
    sum(decoded_log:amount /power(10,18)) as TotalClaimed,
    from optimism.core.fact_decoded_event_logs
    where contract_address = '0x4ee97a759aaca2edf9c1445223b6cd17c2ed3fb4'
    and event_name = 'TokensClaimed'
    ),
    stake as (
    select
    count(decoded_log:provider) as staker,
    sum(decoded_log:amount/ power(10,18)) as AmountStaked,
    --datediff('week', current_timestamp ,to_timestamp(decoded_log:locktime)) as lockDuration,
    from optimism.core.fact_decoded_event_logs
    where contract_address = lower('0x521b4c065bbdbe3e20b3727340730936912dfa46')
    and event_name = 'Deposit'
    )
    Select
    Claimer,
    staker,
    AmountStaked,
    TotalClaimed,
    30000000 as ToTalClaimable
    From stake,claimers












    QueryRunArchived: QueryRun has been archived