TOKEN_PAIR | SWAPS | VOLUME | PERCENT_OF_TOTAL_VOLUME | |
|---|---|---|---|---|
1 | USDC-SOL | 5862589 | 1191478354.70955 | 20.084380877 |
2 | SOL-SOL | 2641553 | 779570699.759565 | 13.140981364 |
3 | USDC-USDC | 764238 | 396607854.235993 | 6.685495521 |
4 | USDC-USDT | 144745 | 317154655.030228 | 5.346177598 |
5 | FARTCOIN-USDC | 63234 | 300646978.794024 | 5.067912823 |
6 | JITOSOL-SOL | 18523 | 101628007.699018 | 1.713111788 |
7 | JLP-USDC | 25501 | 91355058.2760638 | 1.539943867 |
8 | GHIBLI-SOL | 210980 | 91064289.1184891 | 1.535042462 |
9 | USDC-JUP | 83912 | 90700598.0182382 | 1.528911834 |
10 | TRUMP-USDC | 41446 | 81287827.3681859 | 1.37024368 |
11 | USDT-SOL | 1773032 | 68411381.4750443 | 1.153189428 |
12 | USDG-USDC | 2144 | 54913745.0040663 | 0.9256639583 |
13 | DSOL-SOL | 1023 | 54290378.604 | 0.9151560644 |
14 | FARTCOIN-SOL | 42986 | 47694571.0130117 | 0.8039725827 |
15 | GHIBLI-USDC | 56709 | 33938975.8547067 | 0.5720987838 |
16 | JELLYJELLY-SOL | 40372 | 28101041.9551815 | 0.4736905437 |
17 | USDC-EURC | 1539 | 28002328.952252 | 0.4720265693 |
18 | SOL-JUPSOL | 3613 | 25100100.7087477 | 0.4231046084 |
19 | RFC-SOL | 90137 | 24831694.4519653 | 0.4185801674 |
20 | WBTC-USDC | 19031 | 24673968.312621 | 0.4159214268 |
Hashflownjukn
Updated 2025-03-31
999
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 base AS (
SELECT
tx_id,
block_id,
swap_from_mint,
swap_to_mint,
swap_from_amount,
swap_to_amount,
swap_from_amount_usd,
swap_to_amount_usd
FROM solana.defi.ez_dex_swaps
WHERE block_timestamp >= DATEADD(day, -7, CURRENT_TIMESTAMP())
),
flattened AS (
SELECT
tx_id,
block_id,
swap_from_mint AS address,
COALESCE(swap_from_amount_usd, swap_to_amount_usd) / NULLIF(swap_from_amount, 0) AS price
FROM base
UNION ALL
SELECT
tx_id,
block_id,
swap_to_mint AS address,
COALESCE(swap_to_amount_usd, swap_from_amount_usd) / NULLIF(swap_to_amount, 0) AS price
FROM base
),
prices AS (
SELECT
address,
tx_id,
block_id,
MAX(price) AS price
Last run: 22 days ago
...
1000
49KB
128s