Updated 2025-03-21
    select
    date_trunc('hour', block_timestamp) as hour,
    count(distinct tx_hash) as txs,
    count(distinct from_address) as active_wallets,
    count(distinct to_address) as active_contracts,
    sum(TX_FEE) as mon_gas_fees
    from monad.testnet.fact_transactions
    where block_timestamp > '2025-02-18'
    group by 1

    Last run: about 1 month ago
    HOUR
    TXS
    ACTIVE_WALLETS
    ACTIVE_CONTRACTS
    MON_GAS_FEES
    1
    2025-03-03 06:00:00.000500025131892269755052.5267192
    2
    2025-03-08 06:00:00.00043626593986270843678.380856701
    3
    2025-03-11 14:00:00.0001405529142377278529254.106705878
    4
    2025-03-12 09:00:00.0001388902223450315107709.481197515
    5
    2025-03-13 06:00:00.000873544177998347307253.663932585
    6
    2025-03-15 00:00:00.000554197232684144034320.336294034
    7
    2025-03-17 08:00:00.000837479258332407417124.812763621
    8
    2025-03-17 13:00:00.000951588335364237097722.214217579
    9
    2025-03-17 17:00:00.0008275372918812386610134.551635842
    10
    2025-03-19 00:00:00.000626658305923137314903.558940659
    11
    2025-02-20 08:00:00.00013223326437109542055.525956282
    12
    2025-02-22 04:00:00.00018682833692222431633.255859399
    13
    2025-02-25 22:00:00.000635666102964450068079.875007511
    14
    2025-03-14 18:00:00.000831153289869201006182.004847406
    15
    2025-02-25 08:00:00.00035594162587230356156.637204002
    16
    2025-03-02 00:00:00.00032362349829122772894.544975034
    17
    2025-03-04 06:00:00.000471300106383256185034.658234422
    18
    2025-03-06 20:00:00.00035259672891144293559.635586628
    19
    2025-03-07 16:00:00.000534318123839207615404.562287959
    20
    2025-03-11 20:00:00.0001277403237775176516918.98128553
    ...
    754
    46KB
    36s