-- forked from total trading volume, number of transactions and active users copy @ https://flipsidecrypto.xyz/edit/queries/f2dcb962-c073-4b79-b28a-4e6aa8dbce23
-- forked from mighty_joe / total trading volume, number of transactions and active users @ https://flipsidecrypto.xyz/mighty_joe/q/WmS0vjmZHgGw/total-trading-volume-number-of-transactions-and-active-users
SELECT
sum( amount_in_usd) AS Total_trading_volume,
COUNT(DISTINCT tx_hash) AS Total_number_of_transactions,
COUNT(DISTINCT origin_from_address) AS Total_active_users,
platform
FROM ethereum.defi.ez_dex_swaps
WHERE platform IN ('uniswap-v3', 'curve', 'sushiswap','balancer')
AND amount_in_usd IS NOT NULL
GROUP BY 4