TOTAL_SWAPS | SWAP_VOLUME | SWAPPERS | AVG_SWAPS | SWAP_PER_SECOND | |
|---|---|---|---|---|---|
1 | 14308235 | 2089456877.60279 | 732435 | 19.53516 | 0.453711 |
datavortexdramatic-rose
Updated 2025-04-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
WITH filtered AS (
SELECT tx_hash, trader, amount_out_usd
FROM near.defi.ez_dex_swaps
WHERE block_timestamp >= '2024-04-29'
AND block_timestamp < '2025-04-30'
)
SELECT
COUNT(DISTINCT tx_hash) AS total_swaps,
SUM(amount_out_usd) AS swap_volume,
COUNT(DISTINCT trader) AS swappers,
COUNT(DISTINCT tx_hash) / NULLIF(COUNT(DISTINCT trader), 0) AS avg_swaps,
COUNT(DISTINCT tx_hash) / 31536000.0 AS swap_per_second
FROM filtered;
Last run: about 1 month ago
1
54B
512s