DATE_TRUNC('day', BLOCK_TIMESTAMP) AS Date,

SUM(USER_FEE_AMOUNT) AS Total_Fees,

SUM(Total_Fees) OVER (ORDER BY DATE) AS CUM_Fees,

AVG(USER_FEE_AMOUNT) AS AVG_Fees,

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

GROUP BY 1