drone-mostafa% TXN
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 alls as (SELECT
ORIGIN_FROM_ADDRESS,
count (DISTINCT TX_HASH) as TXN_Users
FROM avalanche.core.ez_dex_swaps
WHERE ORIGIN_FROM_ADDRESS != '{{User_wallet}}'
GROUP BY 1),
targets as (SELECT
count (DISTINCT TX_HASH) as TXN_Target
FROM avalanche.core.ez_dex_swaps
WHERE ORIGIN_FROM_ADDRESS = '{{User_wallet}}'
),
dex_users as (SELECT
count (DISTINCT ORIGIN_FROM_ADDRESS) as All_users
FROM avalanche.core.ez_dex_swaps)
SELECT
All_users as al,
count (DISTINCT (CASE when TXN_Users > TXN_Target then ORIGIN_FROM_ADDRESS end)) as greater,
count (DISTINCT (CASE when TXN_Users < TXN_Target then ORIGIN_FROM_ADDRESS end)) as less,
(greater * 100) / al as "% greater",
(less * 100) / al as "% less"
FROM alls
LEFT JOIN targets
LEFT JOIN dex_users
GROUP BY 1
Run a query to Download Data