-- forked from WBTC Buy/ Sell @ https://flipsidecrypto.xyz/edit/queries/1251b161-7be3-4989-9acd-2d376f77b1e1

-- forked from ETH Buy and Sell @ https://flipsidecrypto.xyz/edit/queries/3dd736dd-e4fe-4805-a12a-8282f2f88fe7

WITH buys AS(

select

date_trunc('hour',BLOCK_TIMESTAMP) AS DATE,

SUM(amount_out) AS total_bought

from optimism.core.ez_dex_swaps

WHERE DATE BETWEEN {{start_date}} AND {{end_date}}

AND token_out=lower('0x4200000000000000000000000000000000000042')

group by 1

),

sells AS(

select

date_trunc('hour',BLOCK_TIMESTAMP) AS DATE,

SUM(amount_in) AS total_sold

from optimism.core.ez_dex_swaps

WHERE DATE BETWEEN {{start_date}} AND {{end_date}}

AND token_in=lower('0x4200000000000000000000000000000000000042')

group by 1

),

price AS(

select

date_trunc('hour', HOUR) AS DATE,

Symbol,

avg(price) as price

from crosschain.core.ez_hourly_prices

WHERE DATE BETWEEN {{start_date}} AND {{end_date}}

AND SYMBOL='OP'

group by 1,2

b.date,