0xaiman2023-05-04 01:18 PM
Updated 2023-06-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with aux as (select
date_trunc('day',block_timestamp) as day, count(distinct sender) as n_aux_trader
from
avalanche.core.ez_dex_swaps
where
token_in = lower('0x68327a91E79f87F501bC8522fc333FB7A72393cb') --AUX
or token_out=lower('0x68327a91E79f87F501bC8522fc333FB7A72393cb')
group by 1),
agx as (select
date_trunc('day',block_timestamp) as day, count(distinct sender) as n_agx_trader
from
avalanche.core.ez_dex_swaps
where
token_in = lower('0x13E7bceFddE72492E656f3fa58baE6029708e673') --AUX
or token_out=lower('0x13E7bceFddE72492E656f3fa58baE6029708e673')
group by 1)
select aux.day, n_aux_trader,n_agx_trader
from aux join agx on aux.day=agx.day
Run a query to Download Data