permaryDaily mints
    Updated 2025-03-07
    select
    date_trunc('day', block_timestamp) as "date",
    count (*) as "Daily mints",
    count(distinct origin_from_address) as "Minters"
    from monad.testnet.fact_event_logs
    where
    --origin_function_signature = '0x1ff7712f'
    topic_0 = '0x7a7be958aedb09208ae6ed49fc0841ccb7f951498c9afc1c2bfa4abbd0e3ff82'
    and contract_address = lower ('0x9077D31A794D81c21b0650974d5F581F4000CD1a')
    group by "date"
    order by "date" desc;
    --and tx_succeeded = 'true'
    --mints
    --0x1ff7712f
    Last run: about 2 months ago
    date
    Daily mints
    Minters
    1
    2025-03-07 00:00:00.0001764815663
    2
    2025-03-06 00:00:00.0002948326156
    3
    2025-03-05 00:00:00.0004347938650
    4
    2025-03-04 00:00:00.0003986636622
    5
    2025-03-03 00:00:00.0001424910625
    6
    2025-03-02 00:00:00.0004190536217
    7
    2025-03-01 00:00:00.0008337975771
    8
    2025-02-28 00:00:00.0004330536279
    9
    2025-02-27 00:00:00.0005697949749
    10
    2025-02-26 00:00:00.000116807107680
    11
    2025-02-25 00:00:00.0004561539971
    12
    2025-02-24 00:00:00.0003010523204
    13
    2025-02-23 00:00:00.0002511525105
    14
    2025-02-22 00:00:00.0003789136912
    15
    2025-02-21 00:00:00.0009283590391
    16
    2025-02-20 00:00:00.0002412223292
    17
    2025-02-19 00:00:00.00034713328
    18
    2025-02-18 00:00:00.000118
    19
    2025-02-17 00:00:00.00063
    20
    2025-02-15 00:00:00.00011
    29
    1KB
    1s