0xaiman2023-05-05 03:03 PM
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
nftca as (
select
address,
project_name
from
avalanche.core.dim_labels dl
where
label_type = 'nft'
),
auserlist1 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 (
Run a query to Download Data