Description of work

In this question, we want to examine whether different news has an effect on the amount of swap to SCRT or not? To do this, we can consider the following criteria:

• Volume of swaps to SCRT over the past three months
• Matching high volume swaps into SCRT with major international news events.
• pattern in SCRT swap volume

Volume of swaps to SCRT over the past three months

To answer this question, we first obtain the volume and number of SWAPs to SCRT from the [fact_swaps] table in the osmosis schema.

Then we join the result with [dim_labels] to find the name of the tokens swapped to SCRT

• On May 11 and 12, Bitcoin experienced a major price drop, reaching its lowest level since 2021. This huge price drop, along with the problem in the Terra blockchain that causes the free fall of the Luna and UST prices, which destroyed its $ 40 billion markets, came as a huge shock to cryptocurrencies. The largest volume of swaps to SCRT on these dates has been by a large margin to the USTC because a shock to the cryptocurrency market caused the de-peg of this stable coin and its devaluation, which caused many people who have this stable coin swap it to other assets.

• the number of swaps and volumes of swaps have decreased sharply since June 7, and no swaps have been performed since June 9th, 10th, and 11th! the network has been exploited, draining its liquidity pools for approximately $5 million. Developers have halted the Osmosis blockchain to prevent further damage. osmosis twitter

The highest volume of swap to SCRT belongs to ATOM (6.95T SCRT), followed by USTC with a very small difference(6.84T SCRT), followed by Osmo with a large margin (2.69T SCRT).