Impacts of UST on STBL

In this Presentation i'm look at how much STBL was borrowed and how much repaid during the volatile week? What assets were swapped for STBL? Was there more swap volume into or out of STBL? Did we see a one to one swap swap volume with USDC? If not, why not? Were there certain trades causing this discrepancy? Look at actions regarding STBL such as staking on AlgoFi! Is there anything else interesting related to STBL that's worth noting? If so, i describe what i have found!

Method

I used the algorand.transactions table to get the number and volume of borrow and repay, and I filtered it with app_id = '465814278'.

To get Borrowing,I filtered try_base64_decode_string (tx_message: txn: note :: string) = 'Market: b'.
To get Repaying, I filtered try_base64_decode_string (tx_message: txn: note :: string) = 'Market: rb'.

I used the algorand.swaps table to get the number and volume of STBL swaps.

I filtered to get the STBL from swap SWAP_FROM_ASSET_ID = '465865291'
I filtered to get the STBL to swap SWAP_To_ASSET_ID = '465865291'

I used the algorand.application_call_transaction table to get tx_group_id for staking and unstaking in Algofi, and I filtered it with app_id = '482608867'.

To get staking,I filtered try_base64_decode_string(tx_message:txn:note::string) = 'Market: mt'.
To get unstaking, I filtered try_base64_decode_string(tx_message:txn:note::string) = 'Market: rcu'.
list the resulting tx_group_id with the table algorand.asset_transfer_transaction I joined and filtered with asset_transferred = 465865291

Total volume and number repay and borrow STBL

In the next chart, the blue line shows the number of borrow and the green line shows the number of repay from 2022-5-8 to 2022-5-14.

Due to the crach of the market on May 11th, the number of repay on that day has more than doubled compared to the previous days.

The number of borrows has not changed significantly.

In the next chart, the volumes of Repay and borrow STBL are compared on the same date. It is clear that on May 11th, the volume of repay and borrow has increased. On May 13th and 14th, the volume of borrow has more the volume of repay STBL.

Asset volume that swapped (from to STBL)

The next chart shows assets that have been swapped from STBL since 2022-5-8 to 2022-5-14. The highest volume is STBL to Algo swap, which is about 81.6%. goBTC, goETH and __USDC__are in the next ranks.

The next chart shows assets that have been swapped from STBL since 2022-5-8 to 2022-5-14. The highest volume is STBL to Algo swap, which is about 80.3%. goBTC, goETH and __USDC__are in the next ranks.

Was there more swap volume into or out of STBL? The volume of swaps to STBL is more than the volume of swaps from STBL.

Volume From STBL = 5.36 M
Volume To STBL = 5.83 M

Did we see a one to one swap swap volume with USDC? No,The largest volume of STBL swaps was related to Algo, and goBTC and goETH are in the next ranks. USBC has a smaller share in STBL swaps.

Stake and Unstake STBL(2022-5-8 To 2022-5-14)

The next chart show the volume of STBL that were staked and unstaked. The volume of unstaked STBL on May 11th was the most with 431.54k in USD. Also, the volume of staked STBL was the most on this day, Unlike the number of staked when was the most on May 8th and May 9th.

The next chart shows the most STBL were unstaked on May 11th, with 222. On this day the number of staked was 88. The most number of STBLs were staked on May 8th and May 9th with 96.

Conclusion

On May 11th, the number of repay on that day has more than doubled compared to the previous days.
The number of borrows has not changed significantly.
The volume of swaps to STBL is more than the volume of swaps from STBL.
The largest volume of STBL swaps was related to Algo, and goBTC and goETH are in the next ranks.
USDC has a smaller share in STBL swaps.
The volume of staked STBL was the most on May 11th.
Number of staked when was the most on May 8th and May 9th.