itsxenuxBalloonsville Rug Average Sale Price
    Updated 2022-02-22
    WITH all_sales AS (
    SELECT
    tx_id,
    block_timestamp,
    (
    inner_instruction:instructions[0]:parsed:info:lamports +
    inner_instruction:instructions[1]:parsed:info:lamports +
    inner_instruction:instructions[2]:parsed:info:lamports +
    inner_instruction:instructions[3]:parsed:info:lamports +
    COALESCE(inner_instruction:instructions[4]:parsed:info:lamports, 0)
    )/POW(10,9) AS sell_price
    FROM solana.nfts SN
    JOIN solana.labels SL
    ON SN.mint = SL.address
    WHERE date(block_timestamp) > '2022-02-04'
    AND instruction:programId = 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8'
    AND array_size(inner_instruction:instructions) > 4
    AND SL.label = 'balloonsville'
    )

    SELECT
    date(block_timestamp) AS date,
    avg(sell_price) AS average_sale
    from all_sales
    GROUP BY date
    ORDER BY date

    Run a query to Download Data