SWAP_DAY | TOKEN_PAIR | SWAP_VOLUME | RANK | |
|---|---|---|---|---|
1 | 2025-03-27 00:00:00.000 | SOL-USDC | 235274338 | 1 |
2 | 2025-03-27 00:00:00.000 | TRUMP-USDC | 22667104 | 2 |
3 | 2025-03-27 00:00:00.000 | FARTCOIN-USDC | 18076919 | 3 |
4 | 2025-03-27 00:00:00.000 | SOL-USDT | 15953082 | 4 |
5 | 2025-03-27 00:00:00.000 | USDC-USDT | 12258619 | 5 |
6 | 2025-03-02 00:00:00.000 | SOL-USDC | 854852941 | 1 |
7 | 2025-03-02 00:00:00.000 | TRUMP-USDC | 379590630 | 2 |
8 | 2025-03-02 00:00:00.000 | USDC-USDT | 109766550 | 3 |
9 | 2025-03-02 00:00:00.000 | SOL-USDT | 56894129 | 4 |
10 | 2025-03-02 00:00:00.000 | USDC-WBTC | 36541040 | 5 |
11 | 2025-03-22 00:00:00.000 | SOL-USDC | 134211598 | 1 |
12 | 2025-03-22 00:00:00.000 | TRUMP-USDC | 26011274 | 2 |
13 | 2025-03-22 00:00:00.000 | SOL-USDT | 10241343 | 3 |
14 | 2025-03-22 00:00:00.000 | FARTCOIN-USDC | 9084870 | 4 |
15 | 2025-03-22 00:00:00.000 | USDC-USDT | 8411662 | 5 |
16 | 2025-03-19 00:00:00.000 | SOL-USDC | 352504501 | 1 |
17 | 2025-03-19 00:00:00.000 | TRUMP-USDC | 54310741 | 2 |
18 | 2025-03-19 00:00:00.000 | EURC-USDC | 25982942 | 3 |
19 | 2025-03-19 00:00:00.000 | CBBTC-USDC | 23359297 | 4 |
20 | 2025-03-19 00:00:00.000 | SOL-USDT | 20770092 | 5 |
ArioTop Pairs by Swap Volume
Updated 2 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
31
32
33
34
35
36
›
⌄
WITH stablecoins as (
select
token_address,
Symbol,
Name,
case when DECIMALS is null then 6 else decimals end as decimal
from solana.price.ez_asset_metadata
where token_address in (
'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v', -- USDC
'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB', -- USDT
'2b1kV6DkPAnxd5ixfnxCpjxmKwqjjaYmCZfHsFu24GXo', -- PYUSD
'A1KLoBrKBde8Ty9qtNQUtq3C2ortoC3u7twggz7sEto6', -- USDY
'USDSwr9ApdHk5bvJKMjzff41FfuX8bSxdKcR81vTwcA', -- USDS
'9zNQRsGLjNKwCUU5Gq5LR8beUCPzQMVMqKAi3SSZh54u', -- FDUSD
'susdabGDNbhrnCa6ncrYo81u4s9GM8ecK2UwMyZiq4X', -- sUSD
'FrBfWJ4qE5sCzKm3k3JaAtqZcXUh4LvJygDeketsrsH4', -- ZUSD
'HzwqbKZw8HxMN6bF2yFZNrht3c2iXXzpKcFu7uBEDKtr' -- EURC
)
union
select
'susdabGDNbhrnCa6ncrYo81u4s9GM8ecK2UwMyZiq4X' as token_address,
'sUSD' as Symbol,
'Solayer USD' as Name,
6 as decimal
),
normalized_swaps AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS swap_day,
CASE
WHEN SWAP_FROM_SYMBOL < SWAP_TO_SYMBOL THEN SWAP_FROM_SYMBOL
ELSE SWAP_TO_SYMBOL
END AS token1,
CASE
WHEN SWAP_FROM_SYMBOL < SWAP_TO_SYMBOL THEN SWAP_TO_SYMBOL
Last run: 2 days ago
...
155
8KB
160s