datavortextotals
Updated 2024-12-24
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
COUNT(DISTINCT tx_hash) AS "Total Swaps",
COUNT(DISTINCT swapper) AS "Total Swappers",
COALESCE(SUM(amount_in_usd), 0) AS "Total Swap In Volume"
FROM
aptos.defi.ez_dex_swaps
WHERE
block_timestamp >= DATE_TRUNC('month', CURRENT_DATE);
QueryRunArchived: QueryRun has been archived