SYMBOL AS Asset_Symbol,

TO_CHAR(ROUND(SUM(EDGE_AMOUNT_USD), 2), '$999,999,999,999.00') AS Total_Trade_Volume_USD,

COUNT(DISTINCT TX_HASH) AS Total_Trades,

COUNT(DISTINCT TRADER) AS Unique_Traders

FROM base.vertex.ez_edge_trades

WHERE BLOCK_TIMESTAMP::Date >= '2024-09-17' -- Launch date

GROUP BY 1

ORDER BY SUM(EDGE_AMOUNT_USD) DESC