MONTH | DEX | SWAPS | SWAPPER | VOLUME_USD | |
|---|---|---|---|---|---|
1 | 2024-09-01 00:00:00.000 | Raydium | 45033 | 1050 | 9673132.99 |
2 | 2023-12-01 00:00:00.000 | Saber Router | 55 | 40 | 74872.17 |
3 | 2023-01-01 00:00:00.000 | Raydium | 996473 | 4869 | 6847804.98 |
4 | 2024-04-01 00:00:00.000 | Orca | 3689 | 1302 | 3050916.73 |
5 | 2025-01-01 00:00:00.000 | Jupiter | 52378 | 10606 | 500125095.72 |
6 | 2024-08-01 00:00:00.000 | Meteora | 9698 | 842 | 5945577.48 |
7 | 2025-04-01 00:00:00.000 | Raydium | 59711 | 3424 | 6615659.69 |
8 | 2024-01-01 00:00:00.000 | Raydium | 1109156 | 3554 | 26153900.22 |
9 | 2024-05-01 00:00:00.000 | phoenix | 68 | 19 | 13400.37 |
10 | 2024-09-01 00:00:00.000 | phoenix | 2 | 2 | 14.73 |
11 | 2024-07-01 00:00:00.000 | phoenix | 1 | 1 | 16.4 |
12 | 2023-04-01 00:00:00.000 | Raydium | 1265803 | 1047 | 6052541.71 |
13 | 2022-10-01 00:00:00.000 | Jupiter | 310518 | 4829 | 84982416.17 |
14 | 2025-04-01 00:00:00.000 | Meteora | 15696 | 879 | 2919552.83 |
15 | 2023-11-01 00:00:00.000 | Raydium | 3880476 | 3014 | 34137660.86 |
16 | 2022-11-01 00:00:00.000 | Saber Router | 122 | 68 | 122462.6 |
17 | 2023-01-01 00:00:00.000 | Saber Stable Swap | 984 | 3 | 143252.61 |
18 | 2024-10-01 00:00:00.000 | Saber Router | 2 | 2 | 16.99 |
19 | 2025-02-01 00:00:00.000 | Orca | 4377 | 704 | 793765.01 |
20 | 2025-03-01 00:00:00.000 | Orca | 6327 | 915 | 401948.36 |
Pine AnalyticsMarinade 2
Updated 2025-04-13
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: 13 days ago
...
233
13KB
8s