DAY | New users | Total users | Retained users | |
|---|---|---|---|---|
1 | 2024-02-01 00:00:00.000 | 3183 | 1253734 | 1250551 |
2 | 2024-01-01 00:00:00.000 | 6729 | 1250551 | 1243822 |
3 | 2023-12-01 00:00:00.000 | 7658 | 1243822 | 1236164 |
4 | 2023-11-01 00:00:00.000 | 48820 | 1236164 | 1187344 |
5 | 2023-10-01 00:00:00.000 | 112898 | 1187344 | 1074446 |
6 | 2023-09-01 00:00:00.000 | 248457 | 1074446 | 825989 |
7 | 2023-08-01 00:00:00.000 | 181679 | 825989 | 644310 |
8 | 2023-07-01 00:00:00.000 | 107632 | 644310 | 536678 |
9 | 2023-06-01 00:00:00.000 | 80558 | 536678 | 456120 |
10 | 2023-05-01 00:00:00.000 | 64063 | 456120 | 392057 |
11 | 2023-04-01 00:00:00.000 | 137952 | 392057 | 254105 |
12 | 2023-03-01 00:00:00.000 | 124822 | 254105 | 129283 |
13 | 2023-02-01 00:00:00.000 | 11674 | 129283 | 117609 |
14 | 2023-01-01 00:00:00.000 | 12437 | 117609 | 105172 |
15 | 2022-12-01 00:00:00.000 | 29156 | 105172 | 76016 |
16 | 2022-11-01 00:00:00.000 | 27019 | 76016 | 48997 |
17 | 2022-10-01 00:00:00.000 | 15398 | 48997 | 33599 |
18 | 2022-09-01 00:00:00.000 | 2825 | 33599 | 30774 |
19 | 2022-08-01 00:00:00.000 | 4658 | 30774 | 26116 |
20 | 2022-07-01 00:00:00.000 | 4656 | 26116 | 21460 |
winnie-fs2024-01-18 09:12 AM
Updated 2024-01-18
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
›
⌄
with
-- ETH
A as( select block_timestamp, eth_from_address as whale, eth_to_address as bridge from ethereum.core.ez_eth_transfers union all
select block_timestamp, eth_to_address as whale, eth_from_address as bridge from ethereum.core.ez_eth_transfers union all
select block_timestamp, from_address as whale, to_address as bridge from ethereum.core.ez_token_transfers union all
select block_timestamp, to_address as whale, from_address as bridge from ethereum.core.ez_token_transfers
),
B as( select whale, min(block_timestamp) as first_time
from A
where bridge in ( '0xae0ee0a63a2ce6baeeffe56e7714fb4efe48d419',
'0xf6080d9fbeebcd44d89affbfd42f098cbff92816',
'0x283751a21eafbfcd52297820d27c1f1963d9b5b4',
'0x0437465dfb5b79726e35f08559b0cbea55bb585c',
'0xbb3400f107804dfb482565ff1ec8d8ae66747605',
'0xbf67f59d2988a46fbff7ed79a621778a3cd3985b',
'0xcf58536d6fab5e59b654228a5a4ed89b13a876c2')
group by 1),
C as( select date_trunc('month',first_time) as day, count(*) as new_user
from B
group by 1),
D as( select *, sum(new_user) over (order by day) as total_user
from C)
select day,
new_user as "New users",
total_user as "Total users",
total_user - new_user as "Retained users"
from D
order by day desc
Last run: about 1 year ago
24
1KB
43s