Updated 2025-03-18

    select
    DATE_TRUNC('month', block_timestamp) AS month,
    sum(AMOUNT) as burn_amount
    from
    kaia.core.ez_token_transfers
    where
    block_timestamp > current_date - interval '12 months'
    AND SYMBOL = 'MBX'
    AND LOWER(TO_ADDRESS) = LOWER('0x4343cAA984a49b2184681a26031c5e75e02D7942')
    GROUP BY
    month
    ORDER BY
    month;


    QueryRunArchived: QueryRun has been archived