Jor-elHoney Burn and Mint
    Updated 2025-02-21
    with
    august_mint as (
    select
    sum(mint_amount/1e9) as total_minted
    from solana.defi.fact_token_mint_actions
    where mint = '4vMsoUT2BWatFweudnQM1xedRLfJgJ7hswhcpz4xgBTy'
    and block_timestamp::date >= '2024-08-01'
    and block_timestamp::date < '2024-09-01'
    ),
    august_burn as (
    select
    -sum(burn_amount/1e9) as total_burned
    from solana.defi.fact_token_burn_actions
    where mint = '4vMsoUT2BWatFweudnQM1xedRLfJgJ7hswhcpz4xgBTy'
    and block_timestamp::date >= '2024-08-01'
    and block_timestamp::date < '2024-09-01'
    ),
    july_burn as (
    select
    -sum(burn_amount/1e9) as total_burned
    from solana.defi.fact_token_burn_actions
    where mint = '4vMsoUT2BWatFweudnQM1xedRLfJgJ7hswhcpz4xgBTy'
    and block_timestamp::date >= '2024-07-01'
    and block_timestamp::date < '2024-08-01'
    )

    select
    coalesce(august_mint.total_minted, 0) as "Total Minted in August 2024",
    coalesce(august_burn.total_burned, 0) as "Total Burned in August 2024",
    coalesce(july_burn.total_burned, 0) as "Total Burned in July 2024",
    case
    when july_burn.total_burned = 0 then null
    else round(((august_burn.total_burned - july_burn.total_burned) / july_burn.total_burned) * 100, 2)
    end as "Percentage Difference in Burned Amount (August vs July)"
    from august_mint, august_burn, july_burn;

    QueryRunArchived: QueryRun has been archived