DATE | New Address | Total Address | Returning Address | |
|---|---|---|---|---|
1 | 2024-12-18 00:00:00.000 | 1 | 1 | 0 |
2 | 2024-12-19 00:00:00.000 | 1 | 1 | 0 |
3 | 2024-12-20 00:00:00.000 | 8 | 9 | 1 |
4 | 2024-12-21 00:00:00.000 | 33 | 33 | 0 |
5 | 2024-12-22 00:00:00.000 | 27 | 27 | 0 |
6 | 2024-12-23 00:00:00.000 | 58 | 62 | 4 |
7 | 2024-12-24 00:00:00.000 | 17 | 22 | 5 |
8 | 2024-12-25 00:00:00.000 | 40 | 42 | 2 |
9 | 2024-12-26 00:00:00.000 | 43 | 50 | 7 |
10 | 2024-12-27 00:00:00.000 | 18 | 24 | 6 |
11 | 2024-12-28 00:00:00.000 | 17 | 24 | 7 |
12 | 2024-12-29 00:00:00.000 | 39 | 48 | 9 |
13 | 2024-12-30 00:00:00.000 | 30 | 40 | 10 |
14 | 2024-12-31 00:00:00.000 | 34 | 46 | 12 |
15 | 2025-01-01 00:00:00.000 | 68 | 80 | 12 |
16 | 2025-01-02 00:00:00.000 | 55 | 79 | 24 |
17 | 2025-01-03 00:00:00.000 | 53 | 73 | 20 |
18 | 2025-01-04 00:00:00.000 | 23 | 41 | 18 |
19 | 2025-01-05 00:00:00.000 | 34 | 61 | 27 |
20 | 2025-01-06 00:00:00.000 | 70 | 107 | 37 |
hess2. Daily Number of New Vs. Returning Addresses
Updated 2025-03-07
999
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 layer_base as (select block_timestamp::Date as date,
tx_hash,
contract_address as token_address,
'0x' || substr(TOPIC_1,27) as null_address,
'0x' || substr(TOPIC_2,27) as user_address,
event_index,
TOPICS,
livequery.utils.udf_hex_to_int(DATA) as amount_raw,
from ink.core.fact_event_logs
where origin_from_address = lower('0xe93685f3bBA03016F02bD1828BaDD6195988D950')
having null_address = '0x0000000000000000000000000000000000000000')
,
final as ( select a.date,
a.tx_hash,
user_address,
token_address,
amount_raw,
regexp_substr_all(SUBSTR(INPUT_DATA, 11, len(INPUT_DATA)), '.{64}') AS segmented_data,
livequery.utils.udf_hex_to_int(segmented_data[2]) as src_chain,
case when src_chain = 30280 then 'Sei'
when src_chain = 30177 then 'Kava'
when src_chain = 30151 then 'Metis'
when src_chain = 223 then 'B2'
when src_chain = 30106 then 'Avalanche'
when src_chain = 30295 then 'Flare'
when src_chain = 30324 then 'Abstract'
when src_chain = 30109 then 'Polygon'
when src_chain = 30362 then 'Berachain'
when src_chain = 30312 then 'Ape'
when src_chain = 30294 then 'Gravity'
when src_chain = 30168 then 'Solana'
when src_chain = 30165 then 'Zksync_Era'
when src_chain = 30217 then 'Manta'
when src_chain = 30181 then 'Mantle'
when src_chain = 30138 then 'Fuse'
when src_chain = 30150 then 'Kaia'
Last run: about 1 month ago
80
3KB
17s