Date_trunc('Week',BlocK_TIMESTAMP)::DATE AS WEEK,

sum(SALES_AMOUNT) AS "Sales Volume (SOL)",

sum("Sales Volume (SOL)") over (order by WEEK) AS "Cumulative Sales Volume (SOL)",

sum(SALES_AMOUNT*Price) AS "Sales Volume (USD)",

sum("Sales Volume (USD)") over (order by WEEK) AS "Cumulative Sales Volume (USD)",

count(DISTINCT PURCHASER) AS "Unique Buyers Count",

count(*) AS "Sales Count",

Avg(SALES_AMOUNT) AS "Average Price (SOL)",

Avg(SALES_AMOUNT*Price) AS "Average Sale Price (USD)"

from solana.core.fact_nft_sales inner join (select Date_trunc('HOUR',BlocK_TIMESTAMP) AS HOUR,avg(LATEST_ANSWER_ADJ) AS Price from ethereum.chainlink.ez_oracle_feeds

where FEED_NAME='SOL / USD' group by 1) on Date_trunc('hour',BlocK_TIMESTAMP)=HOUR

where SUCCEEDED=TRUE

group by 1)