DAY | TOTAL_TRANSACTION_VOLUME | CUMULATIVE_TRANSACTION_VOLUME | GRAND_TOTAL | |
---|---|---|---|---|
1 | 2025-03-17 00:00:00.000 | 11573.034011621 | 74041.906153978 | 2693366.63414914 |
2 | 2025-03-18 00:00:00.000 | 12358.497674761 | 86400.403828739 | 2693366.63414914 |
3 | 2025-03-19 00:00:00.000 | 10456.195518677 | 96856.599347415 | 2693366.63414914 |
4 | 2025-02-24 00:00:00.000 | 2 | 2 | 2693366.63414914 |
5 | 2025-02-25 00:00:00.000 | 37.765893028 | 39.765893028 | 2693366.63414914 |
6 | 2025-03-02 00:00:00.000 | 0 | 39.765893028 | 2693366.63414914 |
7 | 2025-03-20 00:00:00.000 | 6758.365672248 | 103614.965019663 | 2693366.63414914 |
8 | 2025-03-21 00:00:00.000 | 6232.653959473 | 109847.618979136 | 2693366.63414914 |
9 | 2025-03-09 00:00:00.000 | 3342.021627864 | 7304.010142317 | 2693366.63414914 |
10 | 2025-03-10 00:00:00.000 | 7030.864682633 | 14334.87482495 | 2693366.63414914 |
11 | 2025-03-04 00:00:00.000 | 1.5 | 41.265893028 | 2693366.63414914 |
12 | 2025-03-06 00:00:00.000 | 18.093561186 | 59.359454214 | 2693366.63414914 |
13 | 2025-03-08 00:00:00.000 | 3902.629060238 | 3961.988514452 | 2693366.63414914 |
14 | 2025-03-22 00:00:00.000 | 8360.666265202 | 118208.285244338 | 2693366.63414914 |
15 | 2025-03-23 00:00:00.000 | 7884.928904607 | 126093.214148945 | 2693366.63414914 |
16 | 2025-03-24 00:00:00.000 | 7486.7274566 | 133579.941605544 | 2693366.63414914 |
17 | 2025-03-11 00:00:00.000 | 9439.767926692 | 23774.642751641 | 2693366.63414914 |
18 | 2025-03-12 00:00:00.000 | 4675.043703763 | 28449.686455404 | 2693366.63414914 |
19 | 2025-03-13 00:00:00.000 | 5714.269381599 | 34163.955837003 | 2693366.63414914 |
20 | 2025-03-14 00:00:00.000 | 2478.804475784 | 36642.760312787 | 2693366.63414914 |
peachycrypttTransaction volume
Updated 2025-05-27Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with raw as(
select
date_trunc('day', block_timestamp) as day,
sum(value) as total_transaction_volume
from monad.testnet.fact_transactions
where to_address = LOWER('0xb6091233aAcACbA45225a2B2121BBaC807aF4255')
group by date_trunc('day', block_timestamp)
),
totals as (
select
day,
total_transaction_volume,
SUM(total_transaction_volume) OVER (ORDER BY day) AS cumulative_transaction_volume,
SUM(total_transaction_volume) OVER () as grand_total
from raw
order by day
)
select * from totals
Last run: about 1 month ago
86
6KB
28s