crypto_edgarDRAKO Minted
    Updated 2024-03-06
    WITH
    DRAKO_MINTED_PREP AS (
    SELECT
    block_timestamp,
    TX_ID,
    INSTRUCTION:parsed:info:mint as TOKEN_ADDRESS,
    CASE WHEN EVENT_TYPE IN ('mint', 'mintToChecked') THEN INSTRUCTION:parsed:info:tokenAmount:amount
    ELSE INSTRUCTION:parsed:info:amount END AS AMOUNT,
    5 as DECIMALS
    FROM
    solana.core.fact_events
    WHERE
    BLOCK_TIMESTAMP >= '2023-12-23'
    AND TOKEN_ADDRESS = 'drakduQWnTS89CdTUdgHmZzEkN6reBLYqrk8rzVhU53'
    AND EVENT_TYPE IN ('mint', 'mintTo', 'mintToChecked')
    )
    SELECT
    SUM(AMOUNT / POW(10, DECIMALS)) AS TOTAL_DRAKO_MINTED
    FROM
    DRAKO_MINTED_PREP
    QueryRunArchived: QueryRun has been archived