SELECT

date_trunc(day,HOUR) block_timestamp_,

avg(price) ethprice

FROM ethereum.core.fact_hourly_token_prices

WHERE symbol in ('WETH')

AND date_trunc(day,HOUR) >= '2022-07-01' and date_trunc(day,HOUR)<'2022-08-01'

group by 1

select BLOCK_TIMESTAMP::date date ,

sum (PRICE) as volume ,

sum (volume) over ( order by date ) cum_volume

from optimism.core.ez_nft_sales

where BLOCK_TIMESTAMP::date >= '2022-07-01' and BLOCK_TIMESTAMP::date <'2022-08-01'

and CURRENCY_SYMBOL = 'ETH'

group by 1