SELECT

block_timestamp,

block_id,

n.blockchain,

recent_block_hash,

tx_id,

n.mint,

b.label,

succeeded,

pretokenbalances,

posttokenbalances,

instruction,

inner_instruction,

inner_instruction:instructions[0]:parsed:info:lamports/POW(10,9) as price_0,

inner_instruction:instructions[1]:parsed:info:lamports/POW(10,9) as price_1,

inner_instruction:instructions[2]:parsed:info:lamports/POW(10,9) as price_2,

inner_instruction:instructions[3]:parsed:info:lamports/POW(10,9) as price_3,

COALESCE (inner_instruction:instructions[4]:parsed:info:lamports/POW(10,9), 0) as price_4,

(price_0 + price_1 + price_2 + price_3 + price_4) AS sales_price

FROM solana.nfts n

LEFT OUTER JOIN solana.labels b

ON n.mint = b.address

WHERE date(block_timestamp) >= '2022-02-05'

AND b.label = 'balloonsville'

AND instruction:programId = 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8'

AND label IS NOT NULL

AND array_size(inner_instruction:instructions) > 2

SELECT

date(block_timestamp) AS date,

sum(sales_price) as daily_volume,

avg(sales_price) as average_price