TOKEN | VOLUME_USD_24H | TOTAL_SWAPS_24H | |
|---|---|---|---|
1 | mSOL | 6192522.79 | 59547 |
defi__josh24 hours trading volume
Updated 55 minutes ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH mSOL_swaps AS (
SELECT
SUM(CASE
WHEN swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN swap_from_amount_usd
WHEN swap_to_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' THEN swap_to_amount_usd
END) as total_volume_usd,
COUNT(*) as number_of_swaps
FROM
solana.defi.ez_dex_swaps
WHERE
block_timestamp >= DATEADD(hour, -24, CURRENT_TIMESTAMP())
AND (
swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
OR swap_to_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
)
)
SELECT
'mSOL' as token,
ROUND(total_volume_usd, 2) as volume_usd_24h,
number_of_swaps as total_swaps_24h
FROM
mSOL_swaps;
Last run: about 1 hour agoAuto-refreshes every 12 hours
1
27B
6s