datavortexinterim-coral
Updated 2024-12-17
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
›
⌄
⌄
SELECT
CONCAT(symbol_in, '-WKLAY-', symbol_out) AS swap_pair,
COUNT(DISTINCT tx_hash) AS swaps
FROM
kaia.defi.ez_dex_swaps
WHERE
platform = 'capybara'
AND (symbol_in = 'WKLAY' OR symbol_out = 'WKLAY')
AND symbol_in IS NOT NULL
AND symbol_out IS NOT NULL
GROUP BY
symbol_in, symbol_out
ORDER BY
swaps DESC
LIMIT 10;
/*
WITH wklay_swaps AS (
SELECT
tx_hash,
origin_from_address,
symbol_in,
symbol_out,
block_timestamp
FROM
kaia.defi.ez_dex_swaps
WHERE
platform = 'capybara'
AND (symbol_in = 'WKLAY' OR symbol_out = 'WKLAY')
AND symbol_in IS NOT NULL
AND symbol_out IS NOT NULL
),
subsequent_swaps AS (
SELECT
s1.tx_hash AS first_tx_hash,
s2.tx_hash AS subsequent_tx_hash,
QueryRunArchived: QueryRun has been archived