DATE | DAILY_TRANSACTIONS | DAILY_FEES_SOL | DAILY_FEES_USD | SUCCESSFUL_TXS | FAILED_TXS | |
---|---|---|---|---|---|---|
1 | 2025-02-26 00:00:00.000 | 11944196 | 1184.353339 | 135398.75 | 7436499 | 4507697 |
2 | 2025-02-25 00:00:00.000 | 91713255 | 8370.162197 | 1178127.9 | 53219970 | 38493285 |
3 | 2025-02-24 00:00:00.000 | 93595872 | 8785.060467 | 1392412.96 | 56515021 | 37080851 |
4 | 2025-02-23 00:00:00.000 | 84655994 | 8131.602899 | 1379142.29 | 50346393 | 34309601 |
5 | 2025-02-22 00:00:00.000 | 77582227 | 7393.962599 | 1272527.22 | 49335063 | 28247164 |
6 | 2025-02-21 00:00:00.000 | 84107647 | 9167.763181 | 1596009.2 | 53443171 | 30664476 |
7 | 2025-02-20 00:00:00.000 | 88079145 | 10319.753832 | 1778054.67 | 55140403 | 32938742 |
8 | 2025-02-19 00:00:00.000 | 85104057 | 15187.67983 | 2579780.85 | 53086712 | 32017345 |
9 | 2025-02-18 00:00:00.000 | 90716891 | 10649.386593 | 1804709.94 | 54902528 | 35814363 |
10 | 2025-02-17 00:00:00.000 | 93705308 | 9756.732555 | 1786696.73 | 59770109 | 33935199 |
11 | 2025-02-16 00:00:00.000 | 96270182 | 9506.628398 | 1827746.99 | 58881270 | 37388912 |
12 | 2025-02-15 00:00:00.000 | 98087654 | 11388.929402 | 2233267.61 | 56836814 | 41250840 |
13 | 2025-02-14 00:00:00.000 | 100409680 | 17348.20703 | 3455165.2 | 59561718 | 40847962 |
14 | 2025-02-13 00:00:00.000 | 104226190 | 16571.325683 | 3211771.89 | 60292958 | 43933232 |
15 | 2025-02-12 00:00:00.000 | 107700988 | 19146.593788 | 3741636.82 | 61346739 | 46354249 |
16 | 2025-02-11 00:00:00.000 | 106627836 | 25374.083276 | 5091506.88 | 61192343 | 45435493 |
17 | 2025-02-10 00:00:00.000 | 105591395 | 29661.254222 | 6002996.75 | 58462079 | 47129316 |
18 | 2025-02-09 00:00:00.000 | 105027748 | 22622.614459 | 4540847.98 | 57194200 | 47833548 |
19 | 2025-02-08 00:00:00.000 | 97258190 | 14644.881707 | 2850085.33 | 58706203 | 38551987 |
20 | 2025-02-07 00:00:00.000 | 104398037 | 18936.024534 | 3688551.38 | 59992765 | 44405272 |
boonzadeh-Byd_n3Getting Started
Updated 2 days ago
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
DATE_TRUNC('day', block_timestamp_hour) as date,
SUM(transaction_count) as daily_transactions,
SUM(total_fees_native)/1e9 as daily_fees_sol, -- Converting from lamports to SOL
SUM(total_fees_usd) as daily_fees_usd,
SUM(transaction_count_success) as successful_txs,
SUM(transaction_count_failed) as failed_txs
FROM solana.stats.ez_core_metrics_hourly
WHERE block_timestamp_hour >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY 1
ORDER BY 1 DESC;
Last run: 2 days ago
31
2KB
1s