Description of work:

In this Bounties we want to examine whether important news events make more people convert to SCRT? to do this, we review the following, then review the important news

• Look at the volume of swaps to SCRT over the past three months
• Check the do periods of high volume swaps into SCRT line up with major international news events?
• Check pattern in SCRT swap volume

Note:

• To address this question, we use the [fact_swaps] table and [osmosis] schema.
• SCRT token address is ibc/0954E1C28EB7AF5B72D24F3BC2B47BBB2FDF91BDDFD57B74B99E133AED40972A
• To find the names of other tokens, first in the [fact_swaps] table we find the addresses of all the from_currency from which a swap was made to the SCRT, then we join the [dim_labels] table based on the address and get the project_name

1 ---> Swaps to SCRT over the past three months

To do this:

• In the [fact_swaps] table, we get a list of addresses of tokens swapped to SCRT ---> [to_currency = 'ibc/0954E1C28EB7AF5B72D24F3BC2B47BBB2FDF91BDDFD57B74B99E133AED40972A']
• Then get number of swap and swap volume by day and by token (from swap)

The charts above show the number of swaps and the volume of swaps to SCRT in the last three months. According to the results, it is clear that:

• The highest number of swaps is in late Mar and early Apr. The reason could be the following news:
  • defiyield_app
• The number of swaps has been declining since Apr 10
• The volume of swaps in the last three months shows an almost constant trend. Except on May 11, 12 and 13, when we see the largest volume of swaps to SCRT. The highest swap volume to SCRT is seen in the 12th May. After checking the data, it is found that UST with 402.38B swap volume to SCRT had the highest swap volume on this day, and this shows that due to the fall of LUNA and UST in 11th and May 12 Swap volume to SCRT increased sharply.
  • Terra Luna CRASHES over 85%
• According to the number of swaps and the volume of swaps, it can be seen that the number of swaps has decreased sharply since June 8, and no swaps have been performed since June 9th, 10th and 11th, and there is no data. The reason for this is Attackers have exploited a bug in LP Osmosis.
  • Attackers have exploited a bug in the Osmosis
  • Osmosis Chain Halted Amid Possible $5M Exploit
  • Osmosis to Cover Possible $5M Exploit Loss, Chain to Remain Halted for 2 Days
  • osmosiszone

SCRT

• Secret Token (SCRT) is the native coin of Secret Network. It is similar to Monero (XMR), Dash (DASH) and other privacy coins in that the recipient, balance and transaction amount can be encrypted. The programmable privacy provided by Secret Network ensures anonymity and confidentiality. SCRT holders must create a viewing key if they wish to reveal their balance to third parties.

• In addition to functioning as a currency, SCRT is also used to pay for fees required to use apps on Secret Network and for on-chain governance. Users must “stake” SCRT tokens to become secret nodes and help secure the network. The tokens are also required to participate in the governance of the network and to vote on proposals that decide its future.

• As of November 2021, SCRT has a circulating supply of 150 million tokens. For a nascent coin, it has an impressive market cap of almost $1.4 billion.

According to the above results, it is clear that:

• The highest number of swaps to SCRT is from OSMO, ATOM, USTC and JUNO, respectively.
• The largest swap volumes to SCRT are from ATOM, USTC, OSMO and axlUSDC, respectively.