date(date_trunc('day', block_timestamp)) as day,

tx_hash,

to_address as claimer,

raw_amount/1e18 as amount

from optimism.core.fact_token_transfers

where contract_address = lower('0x4200000000000000000000000000000000000042') --OP token

and from_address = lower('0xfedfaf1a10335448b7fa0268f56d2b44dbd357de') --claim contract

),

claimed_per_day as (select

day,

sum(amount) as daily_claimed

from op_claims

group by day

select *,

sum(daily_claimed) over (order by day asc rows between unbounded preceding and current row) as cum_claimed,

(cum_claimed/214748364) as percentage_op_claimed

from claimed_per_day