primo_dataEthereum Labels
Updated 2022-12-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
⌄
select distinct address, address_name, '' project_name, label_type, label_subtype --, '{today_dt}' dt
from ethereum.core.dim_labels
where label_subtype not in ('token_contract','deposit_wallet','hot_wallet','cold_wallet')
and label_type not in ('chadmin','cex')
and address_name not in ('1inch: general contract','mev bot: general contract','unibright: general contract','nest protocol: general contract','gnosis safe: general contract','loopring: general contract')
and label_subtype != 'nf_token_contract'
limit 10
/*
select address_name, label_type, label_subtype, count(1) ct
--select count(1) ct
from ethereum.core.dim_labels
where label_subtype not in ('token_contract','deposit_wallet','hot_wallet','cold_wallet')
and label_type not in ('chadmin','cex')
and address_name not in ('1inch: general contract','mev bot: general contract','unibright: general contract','nest protocol: general contract','gnosis safe: general contract','loopring: general contract')
and label_subtype != 'nf_token_contract'
group by 1,2,3
order by 4 desc
*/
Run a query to Download Data