hessTotal Number of New Users Per Project type
Updated 2024-12-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
36
›
⌄
WITH address_bank as (select * from
( values ('0x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31','Metamask','dex'),
('0xa5972eee0c9b5bbb89a5b16d1d65f94c9ef25166','layerzero','bridge'),
('0x5c9bbe51f7f19f8c77df7a3ada35ab434aaa86c5','Merkly','bridge'),
('0x18556da13313f3532c54711497a8fedac273220e','trader joe','defi'),
('0x1195cf65f83b3a5768f3c496d3a05ad6412c64b7','Layer3','dapp'),
('0x4dae2f939acf50408e13d58534ff8c2776d45265','Uniswap','dex'),
('0x1a731b2299e22fbac282e7094eda41046343cb51','trader joe','defi'),
('0xca10e8825fa9f1db0651cd48a9097997dbf7615d','Woofi','defi'),
('0x29d096cd18c0da7500295f082da73316d704031a','layerzero','bridge'),
('0x88de50b233052e4fb783d4f6db78cc34fea3e9fc','Odos','dex'),
('0xe030543b943bdcd6559711ec8d344389c66e1d56','Merkly','bridge'),
('0x398baa6ffc99126671ab6be565856105a6118a40','Hyperspace','nft'),
('0x1dac23e41fc8ce857e86fd8c1ae5b6121c67d96d','OKX','dex'),
('0xcdbcd51a5e8728e0af4895ce5771b7d17ff71959','Sushiswap','defi')
as a (address,project_name, label_type)))
,
bonk as ( select address,
project_name,
label_type
from crosschain.core.dim_labels
UNION
select address,
project_name,
label_type
from address_bank
UNION
select address,
project_name,
label_type
from avalanche.core.dim_labels
)
,
FirstTransaction AS (
SELECT
from_address,
QueryRunArchived: QueryRun has been archived