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

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

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

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

+ COALESCE (inner_instruction:instructions[4]:parsed:info:lamports/POW(10,9), 0)) AS sales_price

FROM solana.nfts

WHERE date(block_timestamp) >= '2022-01-01'

AND instruction:programId in('MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8','M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K')

AND array_size(inner_instruction:instructions) > 2

group by tdate