piperTotal minted Mad Scientists and burned $LAB copy copy
    Updated 2024-10-24
    WITH all_nft_holders AS (
    SELECT
    DISTINCT TX_FROM AS nft_holders
    FROM
    osmosis.core.fact_transactions
    WHERE
    MSGS[14].attributes[2].value = lower('osmo1mrl3lug3cr5ltcutlpj2m8vqgcsw3fw94jysgcctyukdunnrmjhs8cacrf')
    AND
    BLOCK_TIMESTAMP >= '2024-04-16'
    )

    SELECT
    DATE,
    BALANCE/1000000 AS balance,
    ADDRESS AS holders
    FROM
    osmosis.core.fact_daily_balances
    WHERE
    ADDRESS IN (SELECT nft_holders FROM all_nft_holders)
    AND
    CURRENCY = 'factory/osmo17fel472lgzs87ekt9dvk0zqyh5gl80sqp4sk4n/LAB'
    AND
    DATE >= CURRENT_DATE
    QueryRunArchived: QueryRun has been archived