SELECT

date_trunc('day', RECORDED_HOUR) as day1,

median(CLOSE) as solana_price

FROM solana.core.fact_token_prices_hourly

WHERE symbol LIKE 'SOL'

GROUP BY 1

), tab as (

SELECT

a.mint as mint1,

token_name

FROM solana.core.fact_nft_sales as a

LEFT outer JOIN solana.core.dim_nft_metadata as b

ON a.mint = b.mint

WHERE block_timestamp > CURRENT_DATE - 180

AND token_name IN (

'DeGods',

'ABC',

'Solana Monkey Business',

'Okay Bears',

'Degen Apes',

'Blocksmith Labs',

'Famous Fox Federation',

'Cets On Creck',

'Jelly Rascals',

'Degen Fat Cats'

)

GROUP BY 1,2

SELECT

SPLIT_PART(block_timestamp, ' ', 1) as day,

token_name as column2,

count(DISTINCT tx_id) as sales,

count(DISTINCT PURCHASER) as nft_buyers,

sum(SALES_AMOUNT * solana_price) as sales_volume,