piperTotal minted Mad Scientists and burned $LAB copy
    Updated 2025-01-25

    SELECT
    DATE_TRUNC('month', BLOCK_TIMESTAMP) AS "Date",
    COUNT(1) AS mints
    FROM
    osmosis.core.fact_transactions
    WHERE
    MSGS[14].attributes[2].value = lower('osmo1mrl3lug3cr5ltcutlpj2m8vqgcsw3fw94jysgcctyukdunnrmjhs8cacrf')
    AND
    BLOCK_TIMESTAMP >= '2024-04-16'
    GROUP BY 1
    ORDER BY 1 ASC

    Last run: 23 days ago
    Date
    MINTS
    1
    2024-04-01 00:00:00.0006452
    2
    2024-05-01 00:00:00.000610
    3
    2024-06-01 00:00:00.000245
    4
    2024-07-01 00:00:00.000276
    5
    2024-08-01 00:00:00.000300
    6
    2024-09-01 00:00:00.00082
    7
    2024-10-01 00:00:00.000113
    8
    2024-11-01 00:00:00.000196
    9
    2024-12-01 00:00:00.000169
    10
    2025-01-01 00:00:00.00076
    10
    320B
    19s