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

avg(price) as avg_Price

FROM ethereum.price.ez_hourly_token_prices

WHERE date BETWEEN '2023-12-01' AND current_timestamp

AND symbol = 'WETH'

GROUP BY 1

),

open_fee as (

SELECT date_trunc('d',block_timestamp) as date,

sum(platform_fee) as Total_platform_fee,

sum(platform_fee_usd) as Total_platform_fee_usd

FROM ethereum.nft.ez_nft_sales

WHERE date BETWEEN '2023-12-01' AND current_timestamp

AND platform_name = 'opensea'

--AND currency_symbol = 'ETH'

GROUP BY 1

SELECT

o.date,

p.avg_price,

o.Total_platform_fee_usd

FROM open_fee o

LEFT JOIN price p using(date)

ORDER BY 1