KaskoazulTop10 swap pairs daily 2.0
Updated 2022-02-28
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
›
⌄
WITH A AS (
SELECT
s.block_timestamp::date as fecha,
l.label as labelTo,
swap_from_amount,
swap_to_amount,
swap_from_mint,
swap_to_mint
FROM
solana.swaps s
INNER JOIN solana.labels l
ON s.swap_from_mint = l.address
WHERE fecha >= '2022-02-01'
AND s.succeeded = 'TRUE'
),
B AS (
SELECT
fecha,
CONCAT (labelTo, '-', l.label) as Pair
FROM A a
INNER JOIN solana.labels l
ON a.swap_to_mint = l.address
)
SELECT
fecha,
Pair
--count(Pair)
FROM b
--group by 1--,2
--order by 2 desc
WHERE Pair = 'usd coin-usd coin'
Run a query to Download Data