flipside

    All Time Bonk Burn copy
    feyikemiAll Time Bonk Burn copy
    Updated 2024-03-20
    -- forked from dannyamah / All Time Bonk Burn @ https://flipsidecrypto.xyz/dannyamah/q/6584JKsog-RN/all-time-bonk-burn

    /* FeeWallet: 'ZG98FUCjb8mJ824Gbs6RsgVmr1FhXb2oNiJHa2dwmPd' */
    /* FirstTradeTimestamp: TIMESTAMP '2023-08-17' */
    /* Bonk Contract Address: 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263' */

    SELECT
    sum(burn_amount) / pow(10, 5) AS total_burn_amount
    FROM solana.defi.fact_token_burn_actions
    WHERE mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
    AND burn_authority = 'ZG98FUCjb8mJ824Gbs6RsgVmr1FhXb2oNiJHa2dwmPd'
    AND date(block_timestamp) >= '2023-08-17'
    AND succeeded


    QueryRunArchived: QueryRun has been archived