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

),

unique_claimers as (select

count(distinct(claimer)) as unique_claimers

from op_claims ),

total_op_claimed as (select sum(amount) as total_claimed

from op_claims),

eligile_users as (select

248699 as elibigle_users

),

total_op_amount as (

select 214748364 as total_op_available

),

final as (select * from unique_claimers

join total_op_claimed

join eligile_users

join total_op_amount)

select *,

(total_claimed/total_op_available) as amount_claimed_percentage,

(unique_claimers/elibigle_users) as users_claimed_percentage

from final