with claims as (select

date_trunc('day', block_timestamp) as tx_date,

block_number,

tx_hash,

origin_from_address,

origin_to_address,

contract_address,

from_address,

to_address,

raw_amount / power(10,18) as amount

from optimism.core.fact_token_transfers

where contract_address = '0x4200000000000000000000000000000000000042'

and from_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'),

total_claimed as (

select

sum(amount)

from claims

select

*

from

total_claimed