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

),

depositors as (select startday, sum(count(*)) over (order by startday) as claimers

from (select claimer, min(day) as startday

from op_claims

group by claimer

)

group by startday

order by startday desc)

select *, claimers - lag(claimers, 1, 0) over ( order by startday) as new_claimers,

(claimers/248699) as percentage_users_claimed

from depositors