SELECT date_trunc("DAY", RECORDED_HOUR) as day, AVG(CLOSE) as price

FROM solana.core.fact_token_prices_hourly

WHERE SYMBOL = 'SOL'

AND date(RECORDED_HOUR) > current_date() - INTERVAL '120 DAYS'

GROUP BY 1

ORDER BY 1 desc

),

sales as (

SELECT *

FROM solana.core.fact_nft_sales s

JOIN solana.core.dim_labels l

ON l.address = s.mint

WHERE succeeded = TRUE

AND l.label in ('genesis genopets habitats', 'genopets habitats')

AND date(BLOCK_TIMESTAMP) > current_date() - INTERVAL '120 DAYS'

)

SELECT day, price, AVG(SALES_AMOUNT) as average_price_SOL

FROM price p

JOIN sales s

ON p.day = date_trunc("DAY", s.BLOCK_TIMESTAMP)

GROUP BY 1, 2