from solana.core.dim_labels where ADDRESS_NAME = 'y00ts: mint t00bs'

and address != '9P1pVkfGErLKY8bEC5smKytBoAFujpoUdCo8LnQGeg3M'

),

sol_price as

(SELECT date(recorded_hour) as day, avg(close) as avg_val

from solana.core.fact_token_prices_hourly

where SYMBOL = 'SOL'

GROUP by 1 )

SELECT count(DISTINCT tx_id) as total_mint_txs,

count(DISTINCT purchaser) as total_minters,

sum(mint_price*avg_val) as total_amount,

max(mint_price*avg_val) as max_mint_price_paid,

min(mint_price*avg_val) as min_mint_price_paid,

avg(mint_price*avg_val) as avg_mint_price_paid

from

( SELECT * from

(SELECT * from solana.core.fact_nft_mints

join nft_address

on address = mint )

where SUCCEEDED = TRUE and mint_currency = 'So11111111111111111111111111111111111111111')

join sol_price on day = date(block_timestamp)

LIMIT 100