0xaiman2023-05-05 06:14 AM
Updated 2023-05-05
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
a as (
select
address, project_name
from
avalanche.core.dim_labels
where
label_type = 'defi'
-- and label_subtype != 'token_contract'
),
auserlist as (
(
select
sender
from
avalanche.core.ez_dex_swaps
where
token_in = lower('0x68327a91E79f87F501bC8522fc333FB7A72393cb') --AUX
or token_out = lower('0x68327a91E79f87F501bC8522fc333FB7A72393cb')
group by
1
)
union
(
select
sender
from
avalanche.core.ez_dex_swaps
where
token_in = lower('0x13E7bceFddE72492E656f3fa58baE6029708e673') --AgX
or token_out = lower('0x13E7bceFddE72492E656f3fa58baE6029708e673')
group by
1
)
)
, raw as (select
Run a query to Download Data