COUNT(DISTINCT TX_HASH) AS Total_Trades,

COUNT(DISTINCT TRADER) AS Total_Traders,

SUM(EDGE_AMOUNT_USD) AS Total_Volume,

COUNT(DISTINCT SYMBOL) AS Total_Assests,

SUM(USER_FEE_AMOUNT) AS Total_Fees,

AVG(USER_FEE_AMOUNT) AS AVG_fee,

SUM(USER_FEE_AMOUNT) / SUM(USER_AMOUNT_USD) AS Fee_to_Volume_Ratio

FROM base.vertex.ez_edge_trades

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