MNDE_Distinct_Tx_Count | MSOL_Distinct_Tx_Count | MNDE_Distinct_Swapper_Count | MSOL_Distinct_Swapper_Count | MNDE_Total_Swap_Volume_USD | MSOL_Total_Swap_Volume_USD | MNDE_Avg_Swap_Volume_USD | MSOL_Avg_Swap_Volume_USD | |
|---|---|---|---|---|---|---|---|---|
1 | 537242 | 18050531 | 36933 | 325865 | 102027223.02 | 3229286194.39 | 184.031123661 | 177.121077959 |
datavortexTotal Swaps
Updated 2025-02-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH swap_data AS (
SELECT
swap_from_mint,
tx_id,
swapper,
swap_from_amount_usd
FROM
solana.marinade.ez_swaps
WHERE
swap_from_mint IN ('MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey', 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So')
)
SELECT
COUNT(DISTINCT CASE WHEN swap_from_mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' THEN tx_id END) AS "MNDE_Distinct_Tx_Count",
COUNT(DISTINCT CASE WHEN swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN tx_id END) AS "MSOL_Distinct_Tx_Count",
COUNT(DISTINCT CASE WHEN swap_from_mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' THEN swapper END) AS "MNDE_Distinct_Swapper_Count",
COUNT(DISTINCT CASE WHEN swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN swapper END) AS "MSOL_Distinct_Swapper_Count",
SUM(CASE WHEN swap_from_mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' THEN swap_from_amount_usd END) AS "MNDE_Total_Swap_Volume_USD",
SUM(CASE WHEN swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN swap_from_amount_usd END) AS "MSOL_Total_Swap_Volume_USD",
AVG(CASE WHEN swap_from_mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey' THEN swap_from_amount_usd END) AS "MNDE_Avg_Swap_Volume_USD",
AVG(CASE WHEN swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN swap_from_amount_usd END) AS "MSOL_Avg_Swap_Volume_USD"
FROM
swap_data;
Last run: 2 months ago
1
87B
1s