rw2023Warp Total burned
    Updated 2023-07-10
    -- forked from Warp @ https://flipsidecrypto.xyz/edit/queries/c5ecd427-d3c8-4cec-a126-37645e866a79

    WITH abc_mints AS (
    SELECT instruction:accounts[5]::string AS mint
    FROM solana.core.fact_events
    WHERE succeeded
    AND block_timestamp::date = '2022-08-21'::date
    AND program_id = 'cndy3Z4yapfJBmL3ShUp5exZKqR3z33thTzeNMm2gRZ' -- Candy Machine Program ID
    AND instruction:accounts[0] = 'Gp1MTXdKKRDLC8fDVqU3SKFQ1cGqMq47VCA2bDpnMCkb' -- Candy Machine
    AND instruction:accounts[1] = 'GVkb5GuwGKydA4xXLT9PNpx63h7bhFNrDLQSxi6j5NuF' -- CM Creator
    AND instruction:accounts[6] = 'CMAWeiRp4sYJVDJA7XAy4qyvX2ovLX848x4Qj5H3nK7D' -- Mint Authority
    ),


    warped AS (
    SELECT
    signers[0] AS user_address
    FROM solana.core.fact_events
    WHERE PARSE_JSON(instruction):parsed:info:mint IN (SELECT mint FROM abc_mints)
    AND BLOCK_TIMESTAMP > '2023-04-26'
    AND event_type = 'burn'
    )

    SELECT
    COUNT(*) AS total_burned_nfts,
    10000 - total_burned_nfts as remaining_abc_solana,
    total_burned_nfts / 10000 as perc_warped
    FROM warped


    Run a query to Download Data