SELECT

recorded_hour::date as date,

AVG(close) as price

FROM

solana.core.fact_token_prices_hourly

WHERE

SYMBOL = 'SOL'

GROUP BY 1

),

nft_sales AS --'2023-03-06 -> Start of the Second Season'

SELECT

MARKETPLACE as MARKETPLACE_NAME,

PROGRAM_ID as MARKETPLACE_ID,

BLOCK_TIMESTAMP,

TX_ID,

PURCHASER,

SELLER,

SALES_AMOUNT * price as PAID_SOL

FROM

solana.core.fact_nft_sales a JOIN sol_Price b ON a.BLOCK_TIMESTAMP::date = b.date

WHERE SUCCEEDED = 'true'

SELECT

CASE WHEN BLOCK_TIMESTAMP::date < '2023-03-06' then 'First Season'

ELSE 'Second Season' END as tensor_seasons,

COUNT(distinct TX_ID) as total_NFT_Sales,

MAX(PAID_SOL) as highest_NFT_Worth,

AVG(PAID_SOL) as average_NFT_Worth,

MIN(PAID_SOL) as minimum_NFT_Worth,

COUNT(distinct PURCHASER) as total_Buyers,

COUNT(distinct SELLER) as total_Sellers,