headitmanagerMagic Eden - 5NFT
    Updated 2022-03-19
    SELECT 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 ,INSTRUCTION:accounts[1] as nft
    FROM solana.nfts
    WHERE date(block_timestamp) >= '2022-01-01'
    AND instruction:programId in('MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8','M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K')
    AND array_size(inner_instruction:instructions) > 2 and (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)) is not null
    group by nft
    order by sales_price DESC
    limit 5