Description of work:

• During the recent spike in market volatility, which chain saw the most activity in swaps for sushi? Polygon, Ethereum or Harmony?
• For do this, we for FIRST STEP get number of swap and swap amount in USD for:
  • Polygon [Use the polygon schema and polygon.events_emitted table]
  • Ethereum [use the crosschain schema and crosschain.ez_swap table]
  • Harmony [use the mdao_harmony schema and mdao_harmony.swaps table]
• For the NEXT STEP, we will compare Polygon, Ethereum and Harmony in terms of the number of swaps and the amount of swaps on a daily basis.

1 ---> Swaps for sushi on Polygon

• In this section we using polygon schema and [polygon.events_emitted] and [polygon.udm_events] tables with filters [events.event_name = 'Swap'] and [events.contract_name like any ('% SUSHI%')] We get the number of swaps per day and the amount of swaps in USD for SUSHI

2 ---> Swaps for sushi on Ethereum

• In this section we using crosschain schema and [crosschain.ez_swaps] table with filters [symbol_in like 'SUSHI'] and `[blockchain = 'Ethereum'] We get the number of swaps per day and the amount of swaps in USD for SUSHI

3 ---> Swaps for sushi on Harmony

• In this section we using mdao_harmony schema and [mdao_harmony.swaps] table with filters (token1_symbol like '%1SUSHI%' and token1_name like 'SushiToken' and amount1out != 0 and amount1in = 0) or (token0_symbol like '%1SUSHI%' and token0_name like 'SushiToken' and amount0out != 0 and amount0in = 0) We get the number of swaps per day and the amount of swaps in USD for SUSHI

4 ---> Swaps for sushi on Polygon, Ethereum and Harmony

• In this section, we examine the swap for SUCHI on the three blockchains polygon, harmony and ethereum simultaneously and compare the results obtained.

According to the results obtained from the number of swaps for SUSHI, it is clear that:

• The number of swaps for sushi is the highest for harmony, followed by polygon and ethereum, respectively
• Users are more inclined to swap sushi in harmony

According to the results obtained from the swap amount in USD for SUSHI, it is clear that:

• The swap amount in USD for sushi is the highest for ethereum, followed by polygon and harmony, respectively
• Users choose more amount of sushi in ethereum for swaps
• The number of swaps and the amount of swaps for sushi on Polygon is Decreasing from 2022 onwards
• The number of swaps for sushi on Ethereum has been Increasing since 2022
• The amount of swaps for sushi on Ethereum is Decreasing from 2022 onwards
• The number of swaps and the amount of swaps for sushi on Harmony is Decreasing from 2022 onwards