DATE | QUARTER | New Address | Cumulative New Addresses | |
|---|---|---|---|---|
1 | 2024-05-27 00:00:00.000 | Q2-2024 (EVM Launch) | 139 | 139 |
2 | 2024-05-28 00:00:00.000 | Q2-2024 (EVM Launch) | 746 | 885 |
3 | 2024-05-29 00:00:00.000 | Q2-2024 (EVM Launch) | 1599 | 2484 |
4 | 2024-05-30 00:00:00.000 | Q2-2024 (EVM Launch) | 1424 | 3908 |
5 | 2024-05-31 00:00:00.000 | Q2-2024 (EVM Launch) | 2007 | 5915 |
6 | 2024-06-01 00:00:00.000 | Q2-2024 (EVM Launch) | 2799 | 8714 |
7 | 2024-06-02 00:00:00.000 | Q2-2024 (EVM Launch) | 3195 | 11909 |
8 | 2024-06-03 00:00:00.000 | Q2-2024 (EVM Launch) | 892 | 12801 |
9 | 2024-06-04 00:00:00.000 | Q2-2024 (EVM Launch) | 915 | 13716 |
10 | 2024-06-05 00:00:00.000 | Q2-2024 (EVM Launch) | 1573 | 15289 |
11 | 2024-06-06 00:00:00.000 | Q2-2024 (EVM Launch) | 713 | 16002 |
12 | 2024-06-07 00:00:00.000 | Q2-2024 (EVM Launch) | 694 | 16696 |
13 | 2024-06-08 00:00:00.000 | Q2-2024 (EVM Launch) | 843 | 17539 |
14 | 2024-06-09 00:00:00.000 | Q2-2024 (EVM Launch) | 182 | 17721 |
15 | 2024-06-10 00:00:00.000 | Q2-2024 (EVM Launch) | 294 | 18015 |
16 | 2024-06-11 00:00:00.000 | Q2-2024 (EVM Launch) | 679 | 18694 |
17 | 2024-06-12 00:00:00.000 | Q2-2024 (EVM Launch) | 1567 | 20261 |
18 | 2024-06-13 00:00:00.000 | Q2-2024 (EVM Launch) | 1778 | 22039 |
19 | 2024-06-14 00:00:00.000 | Q2-2024 (EVM Launch) | 408 | 22447 |
20 | 2024-06-15 00:00:00.000 | Q2-2024 (EVM Launch) | 297 | 22744 |
hessDaily New Addresses
Updated 2025-03-27
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with basic AS (
SELECT
a.block_timestamp::date AS date,
a.tx_hash,
CONCAT('0x', SUBSTR(HEX_ENCODE(data), 25, 40)) AS user,
value,
tx_fee,
b.status
FROM
sei.core_evm.fact_event_logs a
LEFT JOIN
sei.core_evm.fact_transactions b
ON
a.tx_hash = b.tx_hash
WHERE
a.block_timestamp::date >= '2024-05-01'
AND b.block_timestamp::date >= '2024-05-01'
UNION ALL
SELECT
block_timestamp::date AS date,
tx_hash,
from_address AS user,
value,
tx_fee,
status
FROM
sei.core_evm.fact_transactions
WHERE
block_timestamp::date >= '2024-04-27'
)
,
new as (select min(date::date) as date,
user
from basic
Last run: 12 days ago
...
305
15KB
62s