Approach:

To understand the swapping behavior of Yieldly asset on DEXs, the following tables and assumptions should be considered:

• Inflow and outflow

    from flipside_prod_db.algorand.swaps
    where SWAP_FROM_ASSET_ID='226701642' or where SWAP_TO_ASSET_ID='226701642'
  

• Top ASAs

    from flipside_prod_db.algorand.swaps join flipside_prod_db.algorand.asset 
  

• Price analysis

    from flipside_prod_db.algorand.prices_swap
    where ASSET_ID='226701642'
  

• Time period

    BLOCK_TIMESTAMP>='2022-01-01' since start of 2022
  

Overview:

Let’s get a better understanding of how people are swapping Yieldly(YLDY: Asset ID: 226701642).

Show us the total volume inflow and outflow of Yieldly(YLDY: Asset ID: 226701642) by day in 2022 then break it out by DEX as well. Is swapping for YLDY more popular on some DEXs than others? Additionally what assets are users swapping for YLDLY? Are there any standout days of swap volume for Yieldly? If so, write about what may have caused that spike. Note any other interesting findings related to YLDY swaps!

Results:

In this essay, the graphs presents the acquired metrics and according to them the following statements could be concluded:

1. In general, the outflow of Yieldly was more than inflow of it in 2022.
2. The biggest inflow and outflow occurred on May 13th with near 500 million token.
3. The main reason of biggest swapping volume is because of market crush and people wants to avoid holding assets with large decrement in price.
4. Tinyman is the most used DEX for swapping Yieldly by far.
5. ALGO and Defly token are two of the most used ASAs for outflow and inflow of Yieldly.
6. The Yieldly price spiked on January 13th and after that kept its consistent trend.