headitmanagersales volume chart
    Updated 2022-04-09
    with OpenSea_volume_tbl as (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)
    + COALESCE (inner_instruction:instructions[3]:parsed:info:lamports/POW(10,9), 0)
    + COALESCE (inner_instruction:instructions[4]:parsed:info:lamports/POW(10,9), 0)
    + COALESCE (inner_instruction:instructions[5]:parsed:info:lamports/POW(10,9), 0)
    + COALESCE (inner_instruction:instructions[6]:parsed:info:lamports/POW(10,9), 0)
    + COALESCE (inner_instruction:instructions[7]:parsed:info:lamports/POW(10,9), 0)
    + COALESCE (inner_instruction:instructions[8]:parsed:info:lamports/POW(10,9), 0)
    ) AS OpenSea_volume
    from solana.fact_events where
    PROGRAM_ID='hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk' and
    array_size(inner_instruction:instructions) > 3
    and date(block_timestamp) >= '2022-04-06'
    )
    , magic_volume_tbl as (
    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 magic_volume
    FROM solana.nfts
    WHERE date(block_timestamp) >= '2022-04-06'
    AND instruction:programId in('MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8','M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K')
    AND array_size(inner_instruction:instructions) > 2
    )
    ,OpenSea_users_tbl as (select count(distinct instruction:accounts[0]) as OpenSea_users
    from solana.fact_events where
    PROGRAM_ID='hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk' and
    array_size(inner_instruction:instructions) > 3
    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)
    + COALESCE (inner_instruction:instructions[3]:parsed:info:lamports/POW(10,9), 0)
    + COALESCE (inner_instruction:instructions[4]:parsed:info:lamports/POW(10,9), 0)