![defi_funds1 | Flipside Analyst defi_funds1 | Flipside Analyst](https://res.cloudinary.com/dsr37ut2z/image/upload/w_1200,f_auto/v1710772467/feuvrxrdzgzwcld8lvxj.png)
defi_funds1
Solana Dex Performance for Q1
Apr 4, 2024 - The comprehensive SQL query for analyzing DEX performances on Solana encompasses various metrics such as trade volumes, liquidity, fees generated, and more. It provides insights into the activities within the DEX ecosystem on the Solana blockchain. This query aggregates data from relevant tables, calculates key performance indicators, and offers a holistic view of DEX performance over a specified timeframe. It enables users to track trends, identify top-performing pools, and make informed decisions based on the comprehensive analysis of DEX activities. including The provided SQL query analyzes swap transactions involving the WEN token and another token $bonk on the Solana blockchain between January 1st, 2024, and March 31st, 2024. It identifies the swap program and counts the number of distinct transactions (`swaps`). The query is modified to include only transactions involving exactly two tokens.