DATE | PAIRS | SWAPS | |
|---|---|---|---|
1 | 2024-12-01 00:00:00.000 | WETH.e -> WAVAX | 2522 |
2 | 2024-12-01 00:00:00.000 | WAVAX -> USDt | 928 |
3 | 2024-12-01 00:00:00.000 | USDC -> WAVAX | 5052 |
4 | 2024-12-01 00:00:00.000 | WAVAX -> BIG | 1700 |
5 | 2024-12-01 00:00:00.000 | COQ -> WAVAX | 500 |
6 | 2024-12-01 00:00:00.000 | WAVAX -> USDC | 5443 |
7 | 2024-12-01 00:00:00.000 | USDC -> USDt | 778 |
8 | 2024-12-01 00:00:00.000 | WAVAX -> COQ | 800 |
9 | 2024-12-01 00:00:00.000 | USDt -> USDC | 851 |
10 | 2024-12-01 00:00:00.000 | others | 26547 |
11 | 2024-12-01 00:00:00.000 | BIG -> WAVAX | 1505 |
12 | 2024-12-01 00:00:00.000 | WAVAX -> BTC.b | 2384 |
13 | 2024-12-01 00:00:00.000 | AUSD -> WAVAX | 910 |
14 | 2024-12-01 00:00:00.000 | BTC.b -> WAVAX | 2464 |
15 | 2024-12-01 00:00:00.000 | USDt -> WAVAX | 946 |
16 | 2024-12-01 00:00:00.000 | WAVAX -> WETH.e | 2538 |
17 | 2024-12-02 00:00:00.000 | USDt -> USDC | 1618 |
18 | 2024-12-02 00:00:00.000 | USDC -> USDt | 1746 |
19 | 2024-12-02 00:00:00.000 | COQ -> WAVAX | 1788 |
20 | 2024-12-02 00:00:00.000 | WAVAX -> USDt | 2030 |
FatemeTheLady06. Pairs copy
Updated 2025-02-10
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 top10 as (
SELECT
concat(SYMBOL_IN, ' -> ', SYMBOL_OUT) as Pairs,
count(DISTINCT tx_hash) AS Swaps
from
avalanche.defi.ez_dex_swaps
WHERE
TRUNC(block_timestamp, 'day') >= '2024-12-01'
GROUP BY
1
order by
2 desc
limit
18
)
SELECT
TRUNC(block_timestamp, 'day') as date,
case
when concat(SYMBOL_IN, ' -> ', SYMBOL_OUT) in (
select
Pairs
from
top10
) then concat(SYMBOL_IN, ' -> ', SYMBOL_OUT)
else 'others'
end as Pairs,
count(DISTINCT tx_hash) AS Swaps
from
avalanche.defi.ez_dex_swaps
WHERE
TRUNC(block_timestamp, 'day') >= '2024-12-01'
GROUP BY
1,
2
order by
1 asc
Last run: 2 months ago
...
1268
60KB
4s