Total Number of Trades | Total Unique Traders | Total Trading Volume ($) | Average Trade Size ($) | Number of Whale Traders | |
|---|---|---|---|---|---|
1 | 7111530 | 685844 | 11478417707.48 | 1614.332765681 | 31733 |
defi__josh$TRUMP Trading Metrics & Trader Analysis on Raydium (2025) 2
Updated 7 days ago
99
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
›
⌄
-- forked from $TRUMP Trading Metrics & Trader Analysis on Raydium (2025) @ https://flipsidecrypto.xyz/studio/queries/81d7463e-fb29-4ad1-8905-8d8182feffcd
WITH token_contract_addresses (address) AS (
SELECT '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN' as address
)
SELECT
COUNT(*) AS "Total Number of Trades"
, COUNT(DISTINCT swapper) AS "Total Unique Traders"
, SUM(COALESCE(swap_from_amount_usd, swap_to_amount_usd)) AS "Total Trading Volume ($)"
, AVG(COALESCE(swap_from_amount_usd, swap_to_amount_usd)) AS "Average Trade Size ($)"
, COUNT(DISTINCT CASE
WHEN COALESCE(swap_from_amount_usd, swap_to_amount_usd) > 5000
THEN swapper
END) AS "Number of Whale Traders"
FROM solana.defi.ez_dex_swaps
WHERE swap_program IN (
'Raydium Liquidity Pool V4',
'raydium concentrated liquidity',
'raydium constant product market maker'
)
AND (swap_to_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'
OR swap_from_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN')
AND block_timestamp >= '2025-01-01';
Last run: 7 days ago
1
54B
32s