DAILY | New Address | Cumulative New Address | |
|---|---|---|---|
1 | 2024-10-27 00:00:00.000 | 5376 | 1748014 |
2 | 2025-02-04 00:00:00.000 | 85311 | 12541165 |
3 | 2024-12-20 00:00:00.000 | 79229 | 5264700 |
4 | 2024-08-31 00:00:00.000 | 53548 | 396596 |
5 | 2024-07-07 00:00:00.000 | 138 | 28077 |
6 | 2024-08-20 00:00:00.000 | 4061 | 213701 |
7 | 2025-02-19 00:00:00.000 | 43592 | 13675690 |
8 | 2024-06-04 00:00:00.000 | 780 | 13221 |
9 | 2024-12-15 00:00:00.000 | 64003 | 4641365 |
10 | 2024-09-04 00:00:00.000 | 4990 | 409476 |
11 | 2024-10-07 00:00:00.000 | 6735 | 1408710 |
12 | 2024-11-22 00:00:00.000 | 99886 | 2467675 |
13 | 2024-09-03 00:00:00.000 | 573 | 404486 |
14 | 2024-08-07 00:00:00.000 | 1597 | 87338 |
15 | 2024-11-01 00:00:00.000 | 11629 | 1796783 |
16 | 2024-06-06 00:00:00.000 | 645 | 14706 |
17 | 2025-01-24 00:00:00.000 | 132316 | 11663297 |
18 | 2024-06-09 00:00:00.000 | 124 | 15913 |
19 | 2024-09-30 00:00:00.000 | 40370 | 1076426 |
20 | 2024-11-23 00:00:00.000 | 118457 | 2586132 |
hessNew Address
Updated 2025-03-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with new as ( select block_timestamp,
from_address as user
from sei.core_evm.fact_transactions
where block_timestamp::date >= '2024-05-27'
UNION all
select block_timestamp,
to_address as user
from sei.core_evm.fact_transactions
where block_timestamp::date >= '2024-05-27'
)
,
new_address as ( select min(block_timestamp) as day,
user
from new
group by 2)
select trunc(day,'day') as daily,
count(DISTINCT user) as "New Address",
sum("New Address") over (order by daily asc) as "Cumulative New Address"
from new_address
group by 1
Last run: about 2 months ago
...
283
11KB
6s