-- 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
ORDER BY 1