LABEL_TYPE | LABEL_VOLUME | LABEL | |
---|---|---|---|
1 | token | 53390.44922129 | jito |
2 | token | 191224.112039668 | jupiter staked sol |
3 | token | 1255161.60754666 | wrapped sol |
4 | token | 208965.830245346 | jupiter perps |
5 | token | 59617.750007616 | jupiter |
6 | token | 9058.499814332 | wormhole token |
7 | token | 20433.42056583 | usd coin |
yasmin-n-d-r-htokens swap from
Updated 2025-02-21
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
›
⌄
WITH t1 AS (
SELECT
SUM(SWAP_FROM_AMOUNT) AS volume,
SWAP_TO_MINT
FROM
solana.defi.fact_swaps
WHERE
SWAP_FROM_MINT = 'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn'
AND block_timestamp >= current_date - 30
AND SWAP_TO_MINT != 'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn'
GROUP BY
SWAP_TO_MINT
ORDER BY
1 DESC
LIMIT
11
)
SELECT
b.LABEL_TYPE,
a.volume AS label_volume,
b.LABEL
FROM
t1 a
INNER JOIN solana.core.dim_labels b ON a.SWAP_TO_MINT = b.address;
Last run: about 2 months ago
7
279B
5s