JeffersPrivate minting analysis
    Updated 2025-03-08
    with mint_data as
    (
    select *
    from monad.testnet.fact_event_logs
    where contract_address = lower('0xE8F0635591190Fb626F9D13C49b60626561Ed145')
    and topic_1 = lower('0x0000000000000000000000000000000000000000000000000000000000000000')
    and block_timestamp >= '2025-02-19 16:00:00'
    ),

    private_mint as
    (
    select
    m.tx_hash,
    m.contract_address AS nft_contract,
    m.origin_from_address AS minter_wallet,
    m.origin_to_address AS minting_contract,
    t.block_timestamp,
    t.from_address,
    t.to_address,
    t.value as MON_value,
    t.tx_fee as gas_fee,
    from mint_data m
    join monad.testnet.fact_transactions t
    on m.tx_hash = t.tx_hash
    where m.block_timestamp < '2025-02-20 15:59:00'
    order by m.block_timestamp
    )

    SELECT
    gas_fee,
    COUNT(DISTINCT minter_wallet) AS unique_minting_wallets,
    COUNT(*) AS total_mints
    FROM private_mint
    GROUP BY gas_fee
    ORDER BY gas_fee DESC;

    Last run: about 2 months ago
    GAS_FEE
    UNIQUE_MINTING_WALLETS
    TOTAL_MINTS
    1
    0.7761311
    2
    0.021452683222
    3
    0.0153488411
    4
    0.01473725761515
    5
    0.01473600961313
    6
    0.014734886444
    7
    0.014733763222
    8
    0.014530276877
    9
    0.014529153633
    10
    0.01228102244
    11
    0.01228000822
    12
    0.01227907211
    13
    0.01227813611
    14
    0.01210762811
    15
    0.01130734811
    16
    0.009824817677
    17
    0.009823257611
    18
    0.0089187711
    19
    0.00891804911
    20
    0.0081873487070
    35
    638B
    8s