drone-mostafaSYMBOL_OUT day
Updated 2023-05-04
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
›
⌄
with base as (SELECT
SYMBOL_OUT,
count (DISTINCT TX_HASH) as TXN,
count (DISTINCT ORIGIN_FROM_ADDRESS) as Users,
sum (AMOUNT_OUT_USD) as USD
FROM avalanche.core.ez_dex_swaps
GROUP BY 1 ORDER BY TXN DESC limit 10)
SELECT
date_trunc ('month',BLOCK_TIMESTAMP) as Date,
SYMBOL_OUT,
count (DISTINCT TX_HASH) as TXN,
count (DISTINCT ORIGIN_FROM_ADDRESS) as Users,
sum (AMOUNT_OUT_USD) as USD
FROM avalanche.core.ez_dex_swaps
WHERE SYMBOL_OUT in (SELECT SYMBOL_OUT FROM base)
GROUP BY 1,2
Run a query to Download Data