datavortexMoon shot
Updated 2025-01-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
⌄
--7rtiKSUDLBm59b1SBmD9oajcP8xE64vAGSMbAN5CXy1q
/*
SELECT
COUNT(DISTINCT tx_id) AS "total_swaps",
SUM(swap_from_amount_usd) AS "total swap volume",
COUNT(DISTINCT swapper) AS "total swappers"
FROM
solana.defi.ez_dex_swaps
WHERE
swap_from_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN';
*/
SELECT
COUNT(DISTINCT tx_id) AS "total_swaps",
SUM(swap_from_amount_usd) AS "total_swap_out_volume",
SUM(swap_to_amount_usd) AS "total_swap_in_volume",
COUNT(DISTINCT swapper) AS "total_swappers"
FROM
solana.defi.ez_dex_swaps
WHERE
swap_from_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'
OR swap_to_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN';
QueryRunArchived: QueryRun has been archived