Try Quests to earn cryptoOrderbook level market stats. for vertex protocol
This SQL query retrieves aggregated data from the `arbitrum.vertex.ez_market_stats` table, combining on-chain data with data from Vertex's ticker V2 API. It calculates the total fee amount and total amount in USD for each ticker_id from the on-chain data. Additionally, it aggregates the last price and quote volume for each ticker_id from the Vertex ticker V2 API data within the last 24 hours. The results are joined based on the ticker_id column and ordered by the third column in descending order.