magmonadverse total minted, unique minters & avg mint fee
    Updated 2025-04-04
    select
    count(e.tx_hash) AS totalmintednfts,
    count(distinct origin_from_address) AS uniqueminters,
    avg(t.tx_fee) as avgmintfee
    from monad.testnet.fact_event_logs e
    join monad.testnet.fact_transactions t
    on e.tx_hash = t.tx_hash
    where e.contract_address = lower('0xe25c57fF3EeA05d0F8bE9aaAE3F522DdC803cA4E')
    and e.topic_0 = '0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62'
    and e.tx_succeeded = 1
    and e.block_timestamp >= '2025-02-19 04:00:00';


    Last run: 23 days ago
    TOTALMINTEDNFTS
    UNIQUEMINTERS
    AVGMINTFEE
    1
    3604463179680.02447970896
    1
    31B
    91s