Eman-RazTotal Stats
    Updated 2025-04-04
    with overview as (select block_timestamp, tx_hash, from_address as minter, tx_fee as mint_fee, value as price, case
    when (to_address='0xb33d7138c53e516871977094b249c8f2ab89a4f4' and origin_function_signature='0xa0712d68') then 'Open Edition Chogstar'
    when (to_address='0xe25c57ff3eea05d0f8be9aaae3f522ddc803ca4e' and origin_function_signature='0x1249c58b') then 'Chapter1: The Genesis'
    when (to_address='0xdd23ade69fc2fe1934aa36c5ab12f6dc58a3446f' and origin_function_signature='0x1249c58b') then 'Community Member of Monad'
    when (to_address='0x51e6da0e284609cd96e3134b12e94b4c4f0ca241' and origin_function_signature='0xa7244eb6') then 'Kintsu Beta Access Pass'
    when (to_address='0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7' and origin_function_signature='0xd123b4d8') then 'Layer3 CUBE'
    end as collection_name
    from monad.testnet.fact_transactions
    where tx_succeeded='TRUE' and
    to_address in ('0xb33d7138c53e516871977094b249c8f2ab89a4f4','0xe25c57ff3eea05d0f8be9aaae3f522ddc803ca4e',
    '0xdd23ade69fc2fe1934aa36c5ab12f6dc58a3446f','0x51e6da0e284609cd96e3134b12e94b4c4f0ca241',
    '0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7')
    and origin_function_signature in ('0xa0712d68','0x1249c58b','0x1249c58b','0xa7244eb6','0xd123b4d8'))

    select count(distinct tx_hash) as "Number of NFTs Minted", sum(price) as "Minting Volume (MON)",
    round(sum(mint_fee),2) as "Minting Fees (MON)", count(distinct minter) as "Number of Minters"
    from overview
    where collection_name='{{Collection_Name}}' AND BLOCK_TIMESTAMP::DATE>='2025-02-19'


    Last run: 23 days ago
    Number of NFTs Minted
    Minting Volume (MON)
    Minting Fees (MON)
    Number of Minters
    1
    3347950338.85384712419227.481659258
    1
    42B
    154s