crypto_edgarDRAKO Circulating
    Updated 2024-03-06
    WITH DRAKO_TRANSFERS_PREP AS (
    SELECT
    BLOCK_TIMESTAMP,
    TX_TO,
    AMOUNT
    FROM
    solana.core.fact_transfers
    WHERE
    BLOCK_TIMESTAMP >= '2023-12-23'
    AND TX_FROM = 'DroptNNMMR8Hk5V3TuhCxSTG8NkPT3DfhbJUXWvytAPo'
    AND MINT = 'drakduQWnTS89CdTUdgHmZzEkN6reBLYqrk8rzVhU53'
    ),
    DRAKO_BURNED_PREP AS (
    SELECT
    TX_ID,
    INSTRUCTION:parsed:info:mint as TOKEN_ADDRESS,
    INSTRUCTION:parsed:info:amount as AMOUNT,
    5 AS DECIMALS
    FROM
    solana.core.fact_events
    WHERE
    BLOCK_TIMESTAMP >= '2023-12-23'
    AND EVENT_TYPE IN ('burn', 'burnChecked')
    AND TOKEN_ADDRESS = 'drakduQWnTS89CdTUdgHmZzEkN6reBLYqrk8rzVhU53'
    )
    SELECT
    (
    SELECT
    SUM(AMOUNT)
    FROM
    DRAKO_TRANSFERS_PREP
    ) - (
    SELECT
    COALESCE(SUM(AMOUNT / POW(10, DECIMALS)), 0)
    FROM
    DRAKO_BURNED_PREP
    QueryRunArchived: QueryRun has been archived