MONTH | DEX | SWAPS | SWAPPER | VOLUME_USD | |
|---|---|---|---|---|---|
1 | 2023-01-01 00:00:00.000 | Raydium | 996473 | 4869 | 6847804.98 |
2 | 2025-01-01 00:00:00.000 | Jupiter | 52378 | 10606 | 500125095.72 |
3 | 2024-04-01 00:00:00.000 | Orca | 3689 | 1302 | 3050916.73 |
4 | 2022-11-01 00:00:00.000 | Raydium | 254265 | 4969 | 14774368.11 |
5 | 2024-12-01 00:00:00.000 | Raydium | 180786 | 29305 | 36793703.93 |
6 | 2024-03-01 00:00:00.000 | Raydium | 396939 | 3079 | 39859594.15 |
7 | 2024-08-01 00:00:00.000 | Jupiter | 103578 | 15160 | 318780337.24 |
8 | 2023-06-01 00:00:00.000 | Saber Router | 11 | 8 | 684.28 |
9 | 2023-04-01 00:00:00.000 | Saber Stable Swap | 292 | 2 | 2712.39 |
10 | 2024-02-01 00:00:00.000 | Saber Stable Swap | 107 | 2 | 51947.5 |
11 | 2024-02-01 00:00:00.000 | Meteora | 10870 | 752 | 5566385.35 |
12 | 2024-03-01 00:00:00.000 | Jupiter | 313260 | 40969 | 452072845.66 |
13 | 2024-08-01 00:00:00.000 | Orca | 6121 | 516 | 2644274.22 |
14 | 2023-07-01 00:00:00.000 | Saber Router | 11 | 9 | 1705.45 |
15 | 2023-03-01 00:00:00.000 | Saber Stable Swap | 350 | 3 | 18504.84 |
16 | 2023-04-01 00:00:00.000 | Raydium | 1265803 | 1047 | 6052541.71 |
17 | 2022-10-01 00:00:00.000 | Jupiter | 310518 | 4829 | 84982416.17 |
18 | 2023-12-01 00:00:00.000 | Raydium | 1847656 | 6505 | 61119976.85 |
19 | 2024-03-01 00:00:00.000 | phoenix | 417 | 78 | 86904.62 |
20 | 2022-12-01 00:00:00.000 | Saber Stable Swap | 1391 | 7 | 120378.35 |
Pine AnalyticsMarinade 2
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
›
⌄
SELECT
date_trunc('month', block_timestamp) as month,
case when PLATFORM ilike '%jupiter%' then 'Jupiter'
when PLATFORM ilike '%raydium%' then 'Raydium'
when PLATFORM ilike '%meteora%' then 'Meteora'
when PLATFORM ilike '%orca%' then 'Orca'
else platform end as dex,
count(*) as swaps,
count(DISTINCT SWAPPER) as swapper,
sum(
case when not SWAP_FROM_AMOUNT_USD is null then SWAP_FROM_AMOUNT_USD
when not SWAP_TO_AMOUNT_USD is null then SWAP_TO_AMOUNT_USD
else 0 end
) as volume_usd
from solana.marinade.ez_swaps
where swap_to_symbol ilike '{{ token }}'
or swap_from_symbol ilike '{{ token }}'
GROUP by 1,2
--limit 100
Last run: about 2 months ago
...
220
12KB
3s