TRANSFER_DATE | TOTAL_RUNE_TRANSFERRED | |
|---|---|---|
1 | 2025-04-16 00:00:00.000 | 27539028.4695022 |
2 | 2025-04-17 00:00:00.000 | 20347969.5785037 |
3 | 2025-04-18 00:00:00.000 | 21269839.6898802 |
4 | 2025-04-19 00:00:00.000 | 21044008.3456078 |
5 | 2025-04-20 00:00:00.000 | 23003871.8045984 |
6 | 2025-04-21 00:00:00.000 | 50674170.2139298 |
7 | 2025-04-22 00:00:00.000 | 128516415.844765 |
8 | 2025-04-23 00:00:00.000 | 57029322.5256372 |
9 | 2025-04-24 00:00:00.000 | 154664222.598845 |
10 | 2025-04-25 00:00:00.000 | 48572961.2923085 |
11 | 2025-04-26 00:00:00.000 | 19526792.5213582 |
12 | 2025-04-27 00:00:00.000 | 27213164.7496609 |
13 | 2025-04-28 00:00:00.000 | 28650325.0194062 |
14 | 2025-04-29 00:00:00.000 | 184955825.611386 |
15 | 2025-04-30 00:00:00.000 | 36954438.2873606 |
16 | 2025-05-01 00:00:00.000 | 39443971.9734582 |
17 | 2025-05-02 00:00:00.000 | 128831553.196808 |
18 | 2025-05-03 00:00:00.000 | 85005403.6682596 |
19 | 2025-05-04 00:00:00.000 | 278017652.532247 |
20 | 2025-05-05 00:00:00.000 | 73224815.2422604 |
walemathsTotal RUNE Transferred in the Last 30 Days
Updated 2025-05-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH recent_transfers AS (
SELECT
from_address AS user_id,
rune_amount,
block_timestamp
FROM
thorchain.core.fact_transfers
WHERE
block_timestamp >= DATEADD(day, -30, CURRENT_TIMESTAMP())
)
SELECT
DATE(block_timestamp) AS transfer_date,
SUM(rune_amount) AS total_rune_transferred
FROM
recent_transfers
GROUP BY
transfer_date
ORDER BY
transfer_date;
Last run: about 1 month ago
31
1KB
1s