HOUR | DOMAINS_CLAIMED | TOTAL_DOMAINS_CLAIMED | |
|---|---|---|---|
1 | 2025-02-27 15:00:00.000 | 45 | 357903 |
2 | 2025-02-27 14:00:00.000 | 53 | 357858 |
3 | 2025-02-27 13:00:00.000 | 72 | 357805 |
4 | 2025-02-27 12:00:00.000 | 125 | 357733 |
5 | 2025-02-27 11:00:00.000 | 92 | 357608 |
6 | 2025-02-27 10:00:00.000 | 107 | 357516 |
7 | 2025-02-27 09:00:00.000 | 105 | 357409 |
8 | 2025-02-27 08:00:00.000 | 78 | 357304 |
9 | 2025-02-27 07:00:00.000 | 175 | 357226 |
10 | 2025-02-27 06:00:00.000 | 157 | 357051 |
11 | 2025-02-27 05:00:00.000 | 94 | 356894 |
12 | 2025-02-27 04:00:00.000 | 65 | 356800 |
13 | 2025-02-27 03:00:00.000 | 168 | 356735 |
14 | 2025-02-27 02:00:00.000 | 121 | 356567 |
15 | 2025-02-27 01:00:00.000 | 62 | 356446 |
16 | 2025-02-27 00:00:00.000 | 64 | 356384 |
17 | 2025-02-26 23:00:00.000 | 63 | 356320 |
18 | 2025-02-26 22:00:00.000 | 25 | 356257 |
19 | 2025-02-26 21:00:00.000 | 22 | 356232 |
20 | 2025-02-26 20:00:00.000 | 50 | 356210 |
lsdboy-V2QpWUalldomain eclipse copy
Updated 2025-01-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
-- forked from jackguy / alldomain eclipse @ https://flipsidecrypto.xyz/jackguy/q/K6VO2kqt7TDz/alldomain-eclipse
SELECT
date_trunc('hour', block_timestamp) as hour,
count(*) as domains_claimed,
sum(domains_claimed) over (order by hour) as total_domains_claimed
FROM (
SELECT
f.value as log_message,
t.*
FROM eclipse.core.fact_transactions t,
LATERAL FLATTEN(input => log_messages) f
where log_message LIKE '%Program log: Creating new domain%'
and ENDSWITH(f.value, '.turbo')
--LIMIT 100
)
GROUP BY 1
order by 1 DESC
Last run: about 2 months ago
...
2685
99KB
427s