zyroq14
Updated 10 days ago
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
›
⌄
SELECT
CASE
WHEN TOKEN_IN = '0x357b0b74bc833e95a115ad22604854d6b0fca151cecd94111770e5d6ffc9dc2b' THEN 'USDt'
WHEN TOKEN_IN = '0xbae207659db88bea0cbead6da0ed00aac12edcdda169e591cd41c94180b46f3b' THEN 'USDC'
WHEN TOKEN_IN = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' THEN 'lzUSDC'
WHEN TOKEN_IN = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT' THEN 'lzUSDT'
WHEN TOKEN_IN = '0xb36527754eb54d7ff55daf13bcb54b42b88ec484bd6f0e3b2e0d1db169de6451'THEN 'AMI'
ELSE COALESCE(SYMBOL_IN, '')
END || ' - ' ||
CASE
WHEN TOKEN_OUT = '0x357b0b74bc833e95a115ad22604854d6b0fca151cecd94111770e5d6ffc9dc2b' THEN 'USDt'
WHEN TOKEN_OUT = '0xbae207659db88bea0cbead6da0ed00aac12edcdda169e591cd41c94180b46f3b' THEN 'USDC'
WHEN TOKEN_OUT = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' THEN 'lzUSDC'
WHEN TOKEN_OUT = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT' THEN 'lzUSDT'
WHEN TOKEN_OUT = '0xb36527754eb54d7ff55daf13bcb54b42b88ec484bd6f0e3b2e0d1db169de6451'THEN 'AMI'
ELSE COALESCE(SYMBOL_OUT, '')
END AS Pair,
TOKEN_IN || ' - ' || TOKEN_OUT AS pair2,
SUM(COALESCE(amount_in_usd, amount_out_usd, 0)) AS volume,
COUNT(DISTINCT swapper) AS unique_swappers,
COUNT(tx_hash) AS total_swaps
FROM aptos.defi.ez_dex_swaps
WHERE
block_timestamp >= DATEADD(DAY, -7, CURRENT_DATE) -- Last 7 days
GROUP BY
Pair, pair2
ORDER BY
total_swaps DESC;
Last run: 10 days ago
...
701
126KB
3s