What is Orca?

Orca is an incredibly fast and user-friendly decentralized exchange on the Solana blockchain. Orca is the easiest way to exchange cryptocurrency on the Solana blockchain. You can exchange tokens with minimal transaction fees and lower latency than any DEX on Ethereum, all while knowing that you're getting a fair price.

The 5 most popular swapping pairs (by USD amount) for each day since February 1st on Orca.

This dashboard asked us to create a visualization showing the 5 most popular swapping pairs (by USD amount) for each day since February 1st on Orca.

The steps are as follows:

• Only data after February 1 will be considered. block_timestamp::date >= '2022-02-01'
• The swap must be completed successfully. succeeded = 'True'
• Swaps must be performed in Orca. swap_program = 'orca'
• In the question it is mentioned that for convenience, one of the pairs should be considered USDC or USDT. SWAP_FROM_MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' or SWAP_FROM_MINT = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' or SWAP_to_MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' or SWAP_to_MINT = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'
• The amount of swaps cannot be 0. SWAP_FROM_AMOUNT>0 and SWAP_TO_AMOUNT>0
• 1 and 2 cannot be equal. SWAP_FROM_MINT != SWAP_TO_MINT
• group by date, swap_from_mint and swap_to_mint

Which trading pairs remain in the top 5 each day?

Are there any tokens that seem to currently be trending based on their swap volume on Orca?

for this question, I want to use a simple query that shows the volume of the swap of tokens (sum of from and to). In my mind, it is better to don't consider usdc to usdt tokens. If we give it up next token that be trended is wrapped sol and after that is marinde staked sol. The first 10 are shown in the below chart.

Why are those tokens popular to swap for on Orca right now?

In the above chart, we can see the 5 most popular swapping pairs (by USD amount) for each day. as you can see the most popular based on volume is usdc to usdt (blue). There is no data for February 22, which is strange.

I answer this question according to the previous chart. As you can see there are green and orange column in each day. To be clear, I show individually each color below.

So as you can see usdc to wrapped sol and wrapped sol to usdc are remaining in the top 5 of most popular trading pair in this time period.

In my opinion, wrapped sol has always been trend in Solana network because is a native token of this blockchain. marinade staked sol is a liquid staking token that you receive when you stake SOL on the Marinade protocol. As Solana holders tend to stake it, so are the platforms that stake it are trend.