Question:

Q8. Let’s take a closer look at DEXs on Optimism, specifically Velodrome. Make a dashboard that compares Velodrome to any other Optimism DEX based on: -Total number of swaps by day over the last month -Total number of wallets swapping by day -What are the most popular asset pairs to swap from and too -Top 10 assets swapping from -Top 10 assets to swap to

Overview of essay:

The Optimism Network or Optimism is a second layer solution, which was created to solve the scalability problems of the Ethereum network. With the help of this solution, you can reduce your transaction cost up to 100 times. The native digital currency of this network is called Optimism (OP).

The Velodrome has been launched since May 31, 2022 on Optimism. Velodrome has been compared with Rubicon and Uniswap as an Optimism DEXs. Criteria have been introduced in the question above.

This investigation has been done for the past month.

Velodrome:

• Swaps:

  SELECT *

  FROM optimism.velodrome.ez_swaps where BLOCK_TIMESTAMP>=CURRENT_DATE-30

• Swap from Asset:

  SYMBOL_IN

• Swap to Asset

  SYMBOL_OUT

• Asset pairs:

  CONCAT(SYMBOL_IN,' / ',SYMBOL_OUT)

Rubicon:

• Swaps:

  select * from optimis.core.fact_token_transfers where ORIGIN_TO_ADDRESS='0x7af14adc8aea70f063c7ea3b2c1ad0d7a59c4bff' and ORIGIN_FUNCTION_SIGNATURE='0xf10f1f58'

• Swap from Asset:

  Contract address of token

  where ORIGIN_FROM_ADDRESS=FROM_ADDRESS

• Swap to Asset

  Contract address of token

  where ORIGIN_FROM_ADDRESS=TO_ADDRESS

Uniswap:

• Swaps:

  select * from optimis.core.fact_token_transfers where ORIGIN_TO_ADDRESS='0xe592427a0aece92de3edee1f18e0157c05861564' and ORIGIN_FUNCTION_SIGNATURE='0x414bf389'

• Swap from Asset:

  Contract address of token

  where ORIGIN_FROM_ADDRESS=FROM_ADDRESS

• Swap to Asset

  Contract address of token

  where ORIGIN_FROM_ADDRESS=TO_ADDRESS

Swap analyze:

The application of three mentioned DEXs has been compared as:

• The Velodrome has more distinct swapper than other two DEXs.
• The Number of swaps on Velodrome is more than other two DEX programs.
• The highest usage of Velodrome occurred on July 29 by 71.18k swaps.
• On July 28, the total number of 3810 distinct swappers executed swaps on Velodrome.

Popular assets for swapping from and to:

The most popular assets for swapping from and to have been altered for various DEXs.

• The Velodrome and Rubicon has same behavior and the most popular assets for swapping from on both of them are USDC and OP.
• The behavior of Uniswap is different from them and popular assets for swapping from are WETH and USDC.
• All of the three DEXs have same popular assets for swapping to in their first rank and that is USDC.
• The second most popular assets for swapping to On Velodrome is OP, in Rubicon is USDT and in Uniswap is WETH.

Asset pairs:

Now lets track the asset pairs on DEXs on Optimism.

• The most popular asset pair for all of the DEXs are diffrent.
• The USDC/OP pair has the most application on Velodrome.
• In Rubicon, the USDC/USDT asset pair has the highest usage with 24% of swaps.
• In Uniswap, the WETH/USDC assets pair takes the 30% of swaps and is the most popular one.
• The usage of OP token as a native asset of Optimism can be considered for a popularity of DEX on Optimism and based on it, the Velodrome is the popular one.