Method :

I used solana.core.fact_swaps table for extracting Aurory swaps.

staking :

I used solana.core.fact_events and following filters for extracting number stakers and staked amount :

where program_id ='STkwf3sbMapjy7KV3hgrJtcVvY4SvRxWQ8pj4Enw1i5'

and INNER_INSTRUCTION:instructions[0]:parsed:info:mintAuthority = 'FysGks3izhgVhrUkub9QQWCTEVAdhkZKYSNK2F25maGD'

• The number of swaps from Aurory token has been on the rise since May 16, 2022, indicating users are selling their Aurory tokens.

• The volume of swaps from Aurory token has been on the rise since May 23, 2022, indicating users are selling their Aurory tokens.

• Total Aurory swaps from until today : 2.6 M $Aurory.
• Total Aurory swaps to until today : 2.3 M $Aurory.

• The swap volume in USD from Aurory has been increasing since April 11 and reached its peak on May 23. In the last week of May, users started buying Aurory tokens.

• The number of swappers has been decreasing since the beginning of 2022, and on April 11, the number of users who bought Aurory has grown significantly, and since that day, the number of traders has gradually decreased.

• The number of Aurory NFTs sold on April 11 has grown significantly.

• The sales volume of Aurory NFTs has been increasing since the second week of March 2022 and reached its peak in the second week of April and then decreased.
• Total Aurory NFT sales Volume : 159K $SOL .

• The sales volume in USD of Aurory NFTs has been increasing since the third week of March 2022 and reached its peak in the first week of May.
• Total Aurory NFT sales Volume in USD : $92.6 M.

• It does not seem that the sales volume of Aurory NFTs is correlated with the price of Aurory.

• The number of Aurory stake actions has been decreasing from the beginning of December 2021 to the third week of May 2022, and then it has grown significantly, although it has decreased again since the first week of January.

• The amount of Aurory staked in May 2022 had a significant trend and has since declined.

Concolusion :

From the above analysis, we obtained the following results :

1. The number of swaps from Aurory token has been on the rise since May 16, 2022, indicating users are selling their Aurory tokens.
2. The volume of swaps from Aurory token has been on the rise since May 23, 2022, indicating users are selling their Aurory tokens.
3. Total Aurory swaps from until today : 2.6 M $Aurory.
4. Total Aurory swaps to until today : 2.3 M $Aurory.
5. The swap volume in USD from Aurory has been increasing since April 11 and reached its peak on May 23. In the last week of May, users started buying Aurory tokens.
6. The number of swappers has been decreasing since the beginning of 2022, and on April 11, the number of users who bought Aurory has grown significantly, and since that day, the number of traders has gradually decreased.
7. The number of Aurory NFTs sold on April 11 has grown significantly.
8. The sales volume of Aurory NFTs has been increasing since the second week of March 2022 and reached its peak in the second week of April and then decreased.
9. Total Aurory NFT sales Volume : 159K $SOL .
10. The sales volume in USD of Aurory NFTs has been increasing since the third week of March 2022 and reached its peak in the first week of May.
11. Total Aurory NFT sales Volume in USD : $92.6 M.
12. It does not seem that the sales volume of Aurory NFTs is correlated with the price of Aurory.
13. The number of Aurory stake actions has been decreasing from the beginning of December 2021 to the third week of May 2022, and then it has grown significantly, although it has decreased again since the first week of January.
14. The amount of Aurory staked in May 2022 had a significant trend and has since declined.