block_timestamp::date as d1,

tx_id,

n.mint,

b.label,

inner_instruction:instructions[0]:parsed:info:lamports/1e9 as price0,

inner_instruction:instructions[1]:parsed:info:lamports/1e9 as price1,

inner_instruction:instructions[2]:parsed:info:lamports/1e9 as price2,

inner_instruction:instructions[3]:parsed:info:lamports/1e9 as price3,

COALESCE (inner_instruction:instructions[4]:parsed:info:lamports/1e9, 0) as price4,

(price0 + price1 + price2 + price3 + price4) AS SalePrice

FROM solana.nfts n

LEFT OUTER JOIN solana.labels b

ON n.mint = b.address

Where block_timestamp::date >='2022-02-05'

AND b.label = 'balloonsville'

AND instruction:programId = 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8'

AND label IS NOT NULL

and array_size(inner_instruction:instructions) > 4

-- And inner_instruction:instructions[0]:parsed:info:source='MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8'

and SUCCEEDED = 'TRUE')

select d1 as day,

avg(SalePrice) as averageSalePrice,

count(tx_id) as SaleVolume

from bl group by 1 order by 1

--tx_id='3Y9afYw3scHSfnz7qbfNacCe9xY6G6vDAMmJkShNxEZNETHjuoDTq4btin9igwoWFWzV7kpC96r5rWAWH9o5oNXW'

select sum (SaleVolume) as Total_Sale_Volume,

avg(averageSalePrice) as Average_sale_price,

min(averageSalePrice) as Min_sale_Price_Sol,

max(averageSalePrice) as max_sale_price_Sol

from t1