date_trunc('day', block_timestamp) as day,

sum(raw_amount/power(10,18)) as volume,

count(DISTINCT tx_hash) as events,

count(DISTINCT origin_from_address) as users

--tx_hash,

--block_timestamp,

--sum(CASE WHEN to_address LIKE '0xfeefeefeefeefeefeefeefeefeefeefeefeefeef' THEN raw_amount/power(10,18) END) as fee_sUSD,

--sum(CASE WHEN to_address not LIKE '0xfeefeefeefeefeefeefeefeefeefeefeefeefeef' AND from_address LIKE '0x0000000000000000000000000000000000000000' THEN raw_amount END) as amt_out,

--sum(CASE WHEN to_address not LIKE '0xfeefeefeefeefeefeefeefeefeefeefeefeefeef' AND from_address LIKE '0x0000000000000000000000000000000000000000' THEN contract_address END) as token_out

-- sum(CASE WHEN to_address LIKE '0x0000000000000000000000000000000000000000' THEN raw_amount END) as amt_in

-- CASE WHEN to_address LIKE '0x0000000000000000000000000000000000000000' THEN contract_address END as token_in

FROM optimism.core.fact_token_transfers

--where tx_hash LIKE '0xbccf33bd0b19aeb374bc9e749f208b360b18051ee87206d26d6297faa522d1ec'

WHERE to_address LIKE '0x0000000000000000000000000000000000000000'

AND from_address LIKE '0xfeefeefeefeefeefeefeefeefeefeefeefeefeef'

AND ORIGIN_FUNCTION_SIGNATURE LIKE '0xd294f093'

--LIMIT 100

GROUP by 1

--GROUP BY 1,2