date_trunc('day', block_timestamp) as day,

count(DISTINCT ORIGIN_FROM_ADDRESS) as users,

sum(raw_amount / power(10, decimals)) as claim_volue,

avg(raw_amount / power(10, decimals)) as avg_claim

FROM optimism.core.fact_token_transfers

LEFT outer JOIN optimism.core.dim_contracts

ON address = contract_address

WHERE symbol LIKE 'OP'

AND from_address LIKE lower('0xFeDFAF1A10335448b7FA0268F56D2B44DBD357de')

AND ORIGIN_FUNCTION_SIGNATURE LIKE '0x2e7ba6ef'

GROUP BY 1