crypto_edgarSCS Token Info
    Updated 2023-08-03
    -- Note: We had to correct for wrong? mints & burns at the start
    WITH
    SCS_Burns as (
    SELECT
    TX_ID,
    BLOCK_TIMESTAMP,
    CASE
    WHEN EVENT_TYPE = 'burnChecked' THEN INSTRUCTION:parsed:info:tokenAmount:amount / POW(10, 5)
    WHEN EVENT_TYPE = 'burn' THEN INSTRUCTION:parsed:info:amount / POW(10, 5)
    END AS amount_tokens_burned
    FROM
    solana.core.fact_events
    WHERE
    BLOCK_TIMESTAMP >= '2023-02-24'
    AND EVENT_TYPE IN ('burn', 'burnChecked')
    AND INSTRUCTION:parsed:info:mint = 'SCSuPPNUSypLBsV4darsrYNg4ANPgaGhKhsA3GmMyjz'
    AND TX_ID != 'mGxqJ6DA6qoRo4u1t5tPCyMT3Resjuv1dWu4StZh5Pgy5o8zxLo6c9u6XKJTJtM6ZjQgzDW9oSXWKbHAsPrRtBC'
    ),
    SCS_Mints as (
    SELECT
    TX_ID,
    BLOCK_TIMESTAMP,
    CASE
    WHEN EVENT_TYPE = 'mintToChecked' THEN INSTRUCTION:parsed:info:tokenAmount:amount / POW(10, 5)
    WHEN EVENT_TYPE = 'mintTo' THEN INSTRUCTION:parsed:info:amount / POW(10, 5)
    END AS amount_tokens_minted
    FROM
    solana.core.fact_events
    WHERE
    BLOCK_TIMESTAMP >= '2023-02-24'
    AND EVENT_TYPE IN ('mintTo', 'mintToChecked')
    AND INSTRUCTION:parsed:info:mint = 'SCSuPPNUSypLBsV4darsrYNg4ANPgaGhKhsA3GmMyjz'
    AND TX_ID != '46Zrwcoop4BpaxdXiit6P9khZ1eQwT5F4wp7otLfMMFGqvUZqbPTXeyyNkCBaWdtNQNvEKZvPYyACcS7t8AoYJPA'
    )
    SELECT
    (