rezarwzOverall User Retention Rate Based on Day of Activity
Updated 2024-06-25
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 all_tx as (
SELECT
*
from
(
SELECT
case
when to_address in (
'0x0ea92deaf7141f405f00bfaad76a8ac74e155c00',
'0x4a1d9220e11a47d8ab22ccd82da616740cf0920a',
'0x9aecedcd6a82d26f2f86d331b17a1c1676442a87',
'0xfadfb0bc400427663020887e7c8073d03a35dc3c',
'0x434575eaea081b735c985fa9bf63cd7b87e227f9',
'0xeff87a51f5abd015f1afcd5737bbab450ea15a24',
'0xc02819a157320ba2859951a1dfc1a5e76c424dd4',
'0x8e2b50413a53f50e2a059142a9be060294961e40',
'0x44f33bc796f7d3df55040cd3c631628b560715c2',
'0x57dcc7b8867a61d82af5b9763687480aa0f040b6',
'0xca13a0a221ef0c5a1343ff262c94d6eb58562e59',
'0xd9747a98624f0b64b4412632c420672e16432334',
'0xbbb2efcf4a3002f8c9a0dad5ec86668c7a52a892',
'0xd2499b3c8611e36ca89a70fda2a72c49ee19eaa8',
'0x6a372dbc1968f4a07cf2ce352f410962a972c257',
'0xa64b73699cc7334810e382a4c09caec53636ab96',
'0x0ea92deaf7141f405f00bfaad76a8ac74e155c00',
'0xeff87a51f5abd015f1afcd5737bbab450ea15a24'
) then 'Lending'
when to_address in (
'0x02df485037c08c3743c182636987c1452cf2e7f9',
'0x4b4f82274357977a7d71083d92df8f07603c239b',
'0xe626daf20ed0b9a4cba675d98b4c411cad570e47',
'0xd9d14e0277018fa35c259dd8a139f3d1efce871d',
'0x4f15dc351afd02311a335236296aaa28081f5cfe',
'0xd3b740887872d82b71191b8fcbdad4fb19b397b0',
'0x461efe0100be0682545972ebfc8b4a13253bd602',
'0x5628a0bd833612299c91d25358f86fcb2dab4207',
QueryRunArchived: QueryRun has been archived