select HOUR::date as date,

avg (price) as NEAR_Price

from near.price.ez_prices_hourly

where symbol = 'NEAR'

AND date>='2024-01-01'

group by 1

),

t1 as ( select

block_timestamp::date as date,

platform_name as market,

from near.nft.ez_nft_sales

where block_timestamp::date>='2024-01-01')

select trunc(date,'week') as weekly,

market,

sum(price*NEAR_Price) as volume_usd,

sum(volume_usd) over (partition by market ORDER BY weekly asc) as Cum_Volume

from t1 a join price b using (date)

group by 1,2

HAVING market not in ('FewAndFar', 'Apollo42')