TRANSACTION_DATE | TOTAL_FEES_PAID_USD | |
|---|---|---|
1 | 2024-08-25 00:00:00.000 | 43.39 |
2 | 2024-08-26 00:00:00.000 | 94.68 |
3 | 2024-08-27 00:00:00.000 | 97.1 |
4 | 2024-08-28 00:00:00.000 | 91.99 |
5 | 2024-08-29 00:00:00.000 | 93.22 |
6 | 2024-08-30 00:00:00.000 | 80.36 |
7 | 2024-08-31 00:00:00.000 | 79.61 |
8 | 2024-09-01 00:00:00.000 | 83.03 |
9 | 2024-09-02 00:00:00.000 | 95.31 |
10 | 2024-09-03 00:00:00.000 | 112.37 |
11 | 2024-09-04 00:00:00.000 | 113.55 |
12 | 2024-09-05 00:00:00.000 | 117.95 |
13 | 2024-09-06 00:00:00.000 | 114.77 |
14 | 2024-09-07 00:00:00.000 | 111.85 |
15 | 2024-09-08 00:00:00.000 | 111.78 |
16 | 2024-09-09 00:00:00.000 | 115.84 |
17 | 2024-09-10 00:00:00.000 | 129.21 |
18 | 2024-09-11 00:00:00.000 | 115.39 |
19 | 2024-09-12 00:00:00.000 | 116.71 |
20 | 2024-09-13 00:00:00.000 | 117.93 |
moonshot21Daily Total Fees
Updated 2025-02-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
transaction_date,
total_fees_usd_today AS total_fees_paid_usd
FROM (
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP_HOUR) AS transaction_date,
SUM(TOTAL_FEES_USD) AS total_fees_usd_today
FROM
eclipse.stats.ez_core_metrics_hourly
WHERE
BLOCK_TIMESTAMP_HOUR >= DATE_TRUNC('day', CURRENT_TIMESTAMP) - INTERVAL '1 year'
GROUP BY
transaction_date
) AS daily_fees
ORDER BY
transaction_date;
Last run: 11 days ago
...
180
6KB
1s