SELECT HOUR::DATE AS DAYS, AVG(Price) AS Price

FROM ethereum.core.fact_hourly_token_prices

WHERE Token_Address = '0xd31a59c85ae9d8edefec411d448f90841571b89c' AND DAYS >= '2022-04-20'

GROUP BY DAYS

ORDER BY DAYS),

NFT_SALES AS (SELECT BLOCK_TIMESTAMP::DATE AS Days, SUM(SALES_AMOUNT) AS SALES_AMOUNT

FROM solana.core.fact_nft_sales

WHERE SUCCEEDED = 'TRUE' AND DAYS >= '2022-04-20'

GROUP BY Days),

SALES_VOUME AS (

SELECT NFT_SALES.Days, SALES_AMOUNT*Price AS VOLUME

FROM SOL_PRICE JOIN NFT_SALES USING (Days)

),

Total_Sales_Volume AS (SELECT SUM(VOLUME) AS "Total Sales Volume" FROM SALES_VOUME)

SELECT "Total Sales Volume" /DATEDIFF(DAY, '2022-04-20', CURRENT_DATE-1) AS "Average sales volume/day" FROM Total_Sales_Volume