TOTAL_VOLUME_ALL_TIME | DAY | TOTAL_VOLUME | |
|---|---|---|---|
1 | 509.1 | 2025-02-27 00:00:00.000 | 0 |
2 | 509.1 | 2025-02-26 00:00:00.000 | 0 |
3 | 509.1 | 2025-02-25 00:00:00.000 | 0 |
4 | 509.1 | 2025-02-24 00:00:00.000 | 0 |
5 | 509.1 | 2025-02-23 00:00:00.000 | 509.1 |
monadmetrics-JFe1_RTotal Volume & Daily Volume
Updated 2025-02-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
WITH daily_volume AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
SUM(value) AS total_volume
FROM MONAD.testnet.fact_transactions
WHERE to_address = '0x66e40f67afd710386379a6bb24d00308f81c183f'
AND block_timestamp >= '2025-02-19 15:00:00.000'
GROUP BY 1
)
SELECT
(SELECT SUM(total_volume) FROM daily_volume) AS total_volume_all_time,
day,
total_volume
FROM daily_volume
ORDER BY 2 DESC;
Last run: about 1 month ago
5
185B
6s