siavashj2023-05-07 05:13 PM
Updated 2023-05-07
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
›
⌄
⌄
/*with a as (
select
address, label , label_type
from ethereum.core.dim_labels
where address_name ilike 'blur'
or label ilike 'blur'
)
select *
from ethereum.core.ez_nft_transfers
where nft_from_address in (select address from a)
--and event_name in ('Transfer' , 'Approval')
limit 200
select *
from external.defillama.dim_protocols
where category ilike '%taking%'
and chain in ('Ethereum','Avalanche')
limit 100
select distinct platform
from ethereum.core.dim_dex_liquidity_pools*/
select *
from ethereum.core.dim_labels
where label_type ilike '%token%'
and label_subtype = 'token_contract'
Run a query to Download Data