0xaiman2023-05-05 03:15 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
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
)
),
inc_date as (
select
date(tm) as day,
count(distinct uw) as n_wallet_address
from
(
select
from_address as uw,
min(block_timestamp) as tm
from
Run a query to Download Data