Mrftilevel-maroon
    Updated 2 days ago
    SELECT
    date_trunc (day, block_timestamp) as date,
    count (DISTINCT tx_hash) as "Total Transaction",
    sum ("Total Transaction") over (order by date) as "Cumulative tx count",
    sum (TX_FEE_PRECISE) as "Total fee (MON)",
    sum ("Total fee (MON)") over (order by date) as "Cumulative fee (MON)"
    from monad.testnet.fact_transactions
    where date > '2025-02-18 00:00:00.000'
    GROUP by 1
    Last run: 2 days agoAuto-refreshes every 12 hours
    DATE
    Total Transaction
    Cumulative tx count
    Total fee (MON)
    Cumulative fee (MON)
    1
    2025-03-14 00:00:00.00015466388302930422151948.6408933082967558.52970847
    2
    2025-02-19 00:00:00.0001255695125569535127.87926509335127.879265093
    3
    2025-02-21 00:00:00.0004441337942528045275.945508638121390.504949673
    4
    2025-03-02 00:00:00.00010743428121989066105268.6364341771306635.71880525
    5
    2025-03-09 00:00:00.0009595439196945171100745.274538392082349.45892644
    6
    2025-02-28 00:00:00.0001487236099749232158076.098605031088184.95925534
    7
    2025-03-15 00:00:00.00016277855319208277146237.7921640623113796.32187254
    8
    2025-02-24 00:00:00.00099110163399969199253.225042144350936.672213608
    9
    2025-02-26 00:00:00.0002211732669412616264288.723855935765695.03631038
    10
    2025-02-27 00:00:00.0001546425684876872164413.824339933930108.860650313
    11
    2025-03-03 00:00:00.00010907604132896670118367.1901853191425002.90899057
    12
    2025-03-07 00:00:00.00010752657176640777116083.3443781161874436.73061804
    13
    2025-03-12 00:00:00.00031961953266486001203153.2975191862620776.2704191
    14
    2025-03-13 00:00:00.00020978033287464034194833.6183960682815609.88881517
    15
    2025-02-23 00:00:00.00095397692408867578429.740617416251683.447171464
    16
    2025-03-16 00:00:00.00017658629336866906142044.4578230273255840.77969556
    17
    2025-03-10 00:00:00.00011903796208848967133441.1306643682215790.58959081
    18
    2025-03-06 00:00:00.00010392027165888120103623.3339207851758353.38623993
    19
    2025-03-11 00:00:00.00025675081234524048201832.3833091062417622.97289991
    20
    2025-02-22 00:00:00.00051236261454890651863.201604375173253.706554048
    27
    2KB
    306s