SELECT date_trunc('day', hour) as date,

avg(price) as OP_Price

FROM optimism.core.fact_hourly_token_prices

WHERE token_address = '0x4200000000000000000000000000000000000042'

GROUP BY 1

),

t2 AS (

SELECT Date_trunc('day',BLOCK_TIMESTAMP) AS Dt2, AMOUNT_IN AS FROM_OP

FROM optimism.velodrome.ez_swaps

WHERE TOKEN_ADDRESS_IN = '0x4200000000000000000000000000000000000042'

UNION ALL

SELECT Date_trunc('day',BLOCK_TIMESTAMP), AMOUNT_IN

FROM optimism.sushi.ez_swaps

WHERE TOKEN_IN = '0x4200000000000000000000000000000000000042'

),

t3 AS (

SELECT Date_trunc('day',BLOCK_TIMESTAMP) AS Dt3, AMOUNT_OUT AS TO_OP

FROM optimism.velodrome.ez_swaps

WHERE TOKEN_ADDRESS_OUT = '0x4200000000000000000000000000000000000042'

UNION ALL

SELECT Date_trunc('day',BLOCK_TIMESTAMP) , AMOUNT_OUT

FROM optimism.sushi.ez_swaps

WHERE TOKEN_OUT = '0x4200000000000000000000000000000000000042'

),

t22 AS (

SELECT dt2 , SUM(FROM_OP) AS FROM_OP

FROM t2

GROUP BY 1

),

t33 AS (

SELECT dt3 , SUM(TO_OP) AS TO_OP