kentoartistic-scarlet
Updated 2024-11-01
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
DAY(BLOCK_TIMESTAMP_HOUR) AS day,
SUM(TRANSACTION_COUNT) AS total_transactions,
SUM(UNIQUE_FROM_COUNT) AS unique_senders
FROM sei.stats.ez_core_metrics_hourly
WHERE BLOCK_TIMESTAMP_HOUR >= '2024-10-01'
AND BLOCK_TIMESTAMP_HOUR < '2024-11-01'
GROUP BY day
ORDER BY total_transactions DESC, unique_senders DESC;
QueryRunArchived: QueryRun has been archived