SELECT event_inputs:recipient as claimer,

min(block_timestamp) as cliam_time,

sum(event_inputs:amount/pow(10,18)) as claim_amount

FROM optimism.core.fact_event_logs

WHERE origin_to_address = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de' AND event_name = 'Claimed'

GROUP BY 1

SELECT

COUNT(DISTINCT claimer) as total_claimer,

sum(claim_amount) as total_op_claimed,

avg(claim_amount) as avg_claim_amount,

max(claim_amount) as max_claim_amount

FROM claimers_list