type | USER_COUNT | WALLET_COUNT_PERCENTAGE | |
|---|---|---|---|
1 | A : < 1 days | 348859 | 91.384631 |
2 | B : < 1-10 days | 6063 | 1.588221 |
3 | C : < 10-30 days | 4547 | 1.1911 |
4 | D : < 30-90 days | 3462 | 0.906881 |
5 | E : < 90-180 days | 3437 | 0.900332 |
6 | F : < 180-365 days | 4089 | 1.071125 |
7 | G : over 1 year | 11291 | 2.95771 |
elsina2025-02-23: Age wallet
Updated 2025-02-23
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 t1 as (
SELECT
origin_from_address as user,
min(block_timestamp) as min_platform_tx
from
kaia.core.fact_event_logs
where
contract_address in ('0x84f8c3c8d6ee30a559d73ec570d574f671e82647', '0x990d8cfbce8892e2126f85637f3728b53266b45e', '0x63d4f17d2a8a729fd050f7679d961b1dfbb1e3af',
'0x6b684816884def88cbc72e1bfa47242ff27fd0de', '0x9bcb2efc545f89986cf70d3adc39079a1b730d63', '0x8da74ba3db7b440264421373d2cbfca2b10e2e3b', '0x26e7e1f2351a39c3b718512bb4480aa6892bef9b',
'0x976232eb7eb92287ff06c5d145bd0d1c033eca58', '0xa9dc3a0a9b0fd00f5572996cfb1fac79a78eb9f1', '0xaeb0c547c3175aed37f67f4565a5064ee48b8cae', '0xb97c9b2a4ea46672f46e05740621a12c7928d73e',
'0xe777abd2594c81149d1b0dd35203ccbafaa234fd', '0x2e5be2ad0473ec82fd66f2f476a510c9f3962583', '0x144Fa704D6d7A12950AC4EaD5C48cB5D5e79cD14', '0x52678aeff4b82b0b167ca3e37c272f574ca9fde0',
'0x9d0c0675a995d5F12b03E880763F639d0628b5C6', '0x3b58a4C865B568a2F6a957C264F6b50CbA35D8CE', '0x0A6cE134Bcb399D0F7a25D2d776fFbed4557c7AF', '0xabbF528374c9f431dFd45E25c01490389Ff8fd6a',
'0x1a818d53ecdcdb9a3af102a9df4436122b9a643c', '0x8D967653D64Ad05c57927995866DCB45399210aA', '0x13AF3A8f1428dDC20be8Bd47821F69779e24F80c')
group by user
),
t2 as (
SELECT
user,
min_platform_tx,
min(block_timestamp) as min_tx
from
kaia.core.fact_transactions b left join t1 a on user = from_address
group by
user, min_platform_tx
),
t3 as (
select
user,
datediff('day' , min_tx , min_platform_tx) as age_wallets
from t2
)
select
case
Last run: about 1 month ago
7
244B
86s