DATE | BLOCKS_PER_DAY | CUM_BLOCKS | NUM_TXNS | CUM_TXNS | ACTIVE_USERS | PAID_FEES_AMOUNT | CUM_PAID_FEES | MONAD_VOLUME | CUM_MONAD_VOLUME | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-02-16 00:00:00.000 | 116984 | 287504 | 6895976 | 38507268 | 271 | 34589.846179697 | 101983.414298331 | 12674.42579249 | 10223595161.1607 |
2 | 2025-03-02 00:00:00.000 | 156170 | 2273767 | 10743428 | 161260110 | 1130708 | 105268.636434177 | 1412855.38426182 | 11367205.867795 | 10678584357.685 |
3 | 2025-03-22 00:00:00.000 | 160936 | 5403457 | 25357362 | 494069958 | 7690269 | 142884.59989606 | 4307253.45079416 | 6533215.21753936 | 10956604657.1217 |
4 | 2025-01-10 00:00:00.000 | 1689 | 7843 | 2121 | 24459 | 39 | 416.451610887 | 491.026336495 | 40228.857556512 | 11403849.114253 |
5 | 2025-02-04 00:00:00.000 | 2371 | 55300 | 4338 | 16863548 | 159 | 34.648402038 | 30145.900832314 | 1060.375812732 | 10012014886.8551 |
6 | 2025-04-16 00:00:00.000 | 161071 | 8924312 | 19281361 | 963664225 | 8908740 | 160000.19366825 | 7806869.08083382 | 9121745.07584811 | 11192916050.8746 |
7 | 2025-04-12 00:00:00.000 | 152888 | 8291110 | 17581946 | 889625236 | 7267703 | 121643.809169323 | 7216480.48721598 | 12197369.0532195 | 11144157131.3813 |
8 | 2025-02-19 00:00:00.000 | 98026 | 433843 | 1255695 | 40526739 | 127071 | 35127.879265093 | 141347.544721666 | 154618548.148167 | 10495456215.4798 |
9 | 2025-03-18 00:00:00.000 | 166693 | 4770524 | 18810848 | 413382534 | 5534359 | 155129.794152051 | 3685112.69296333 | 11623695.1274088 | 10926967150.1698 |
10 | 2025-04-02 00:00:00.000 | 120629 | 6938500 | 18068070 | 706183556 | 8411131 | 141434.697317417 | 5878100.3603652 | 9603944.59776021 | 11052169759.9335 |
11 | 2025-01-24 00:00:00.000 | 6731 | 36816 | 14555064 | 14613336 | 2138 | 25133.378899908 | 25949.812730901 | 9999524411.69506 | 10011808979.4654 |
12 | 2025-01-27 00:00:00.000 | 1234 | 39089 | 2019 | 14617043 | 117 | 36.759816233 | 26002.04589395 | 4245.366060419 | 10011814103.35 |
13 | 2025-04-03 00:00:00.000 | 128045 | 7066545 | 17800944 | 723984500 | 8528531 | 129819.774584282 | 6007920.13494948 | 7703528.27068792 | 11059873288.2042 |
14 | 2025-02-03 00:00:00.000 | 2458 | 52929 | 3285 | 16859210 | 133 | 40.077891782 | 30111.252430276 | 76768.422759682 | 10012013826.4792 |
15 | 2025-03-30 00:00:00.000 | 142464 | 6548233 | 18356911 | 651107883 | 7197912 | 149132.848098419 | 5445934.65992866 | 7427845.38708663 | 11025290448.1478 |
16 | 2025-04-04 00:00:00.000 | 128956 | 7195501 | 16915677 | 740900177 | 8208705 | 115353.423242731 | 6123273.55819221 | 8213628.91722503 | 11068086917.1214 |
17 | 2025-01-18 00:00:00.000 | 408 | 25859 | 447 | 43993 | 30 | 3.558277016 | 643.806635981 | 222.60972096 | 11874570.3190141 |
18 | 2025-03-25 00:00:00.000 | 142393 | 5832204 | 20312797 | 555008031 | 7471725 | 146608.009236616 | 4747177.87834563 | 10761964.1728023 | 10984741151.6435 |
19 | 2025-03-21 00:00:00.000 | 161400 | 5242521 | 21576012 | 468712596 | 6775006 | 183750.476181358 | 4164368.8508981 | 8277164.10776201 | 10950071441.9042 |
20 | 2025-01-11 00:00:00.000 | 207 | 8050 | 208 | 24667 | 18 | 1.73005592 | 492.756392415 | 220.00000077 | 11404069.1142537 |
saeedmzn[Monad] - blocks per day
Updated 4 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
DATE_TRUNC('day', block_timestamp) as date,
COUNT(DISTINCT block_number) as blocks_per_day,
sum (blocks_per_day) over(order by date ) cum_blocks ,
COUNT(DISTINCT tx_hash) as num_txns,
sum (num_txns) over(order by date ) cum_txns ,
count (DISTINCT from_address) active_users ,
sum (TX_FEE) paid_fees_amount ,
sum (paid_fees_amount) over (order by date) cum_paid_fees ,
sum (value) monad_volume ,
sum (monad_volume) over (order by date) cum_monad_volume
FROM monad.testnet.fact_transactions
GROUP BY 1
Last run: 4 days ago
...
103
13KB
294s