Mrftiangry-sapphire
    Updated 16 hours ago
    SELECT
    date_trunc (day, block_timestamp) as date,
    count (DISTINCT from_address) as "Total addresses",
    sum ("Total addresses") over (order by date) as "cumulative addresses"
    from monad.testnet.fact_transactions
    where date > '2025-02-18 00:00:00.000'
    GROUP by 1
    Last run: about 16 hours agoAuto-refreshes every 12 hours
    DATE
    Total addresses
    cumulative addresses
    1
    2025-03-14 00:00:00.000337544734955763
    2
    2025-03-09 00:00:00.000129481421640767
    3
    2025-03-18 00:00:00.000436966953693523
    4
    2025-02-19 00:00:00.000127071127071
    5
    2025-02-21 00:00:00.000465659879260
    6
    2025-02-24 00:00:00.0007635502637754
    7
    2025-03-02 00:00:00.000113070810880592
    8
    2025-02-28 00:00:00.00012009258604015
    9
    2025-03-15 00:00:00.000494454239900305
    10
    2025-03-03 00:00:00.000135983812240430
    11
    2025-03-07 00:00:00.000164073918834564
    12
    2025-03-12 00:00:00.000313349927933765
    13
    2025-03-13 00:00:00.000364655131580316
    14
    2025-02-23 00:00:00.0005525901874204
    15
    2025-02-26 00:00:00.00021087055950151
    16
    2025-02-27 00:00:00.00014529397403090
    17
    2025-03-10 00:00:00.000118265022823417
    18
    2025-03-06 00:00:00.000150176017193825
    19
    2025-03-11 00:00:00.000197684924800266
    20
    2025-02-20 00:00:00.000286530413601
    28
    1KB
    68s