Intro:

Aurory is a highly anticipated P2E game on Solana. In this bounty, we want to create a dashboard to track the preferences of wallets that participated on tokens and NFTs of this project.

The used metrics are:

• Impact of price of token on Sale amount of NFTs
• NFT expedition during bear market
• Token staking during bear market
• Features of wallets join expedition (fish or whale)
• sale of Aurorian NFTs after unstake
• Airdrop of Aurorian

Method:

• Token price-→ Use swap table and estimate price based on swap to USDC
• Sale amount of NFT-→ solana.core.fact_nft_sales for CONTRACT_NAME='Aurory'
• NFT expedition-→ solana.fact_transactions by programid='EXpwP3pqPzA4arF8i89w7smtvxHzyYETmCpPspLPrR7J'
• Token staking-→ solana.fact_transactions by programid='STkwf3sbMapjy7KV3hgrJtcVvY4SvRxWQ8pj4Enw1i5'
• Wallets features (fishes or whales)-→ define whales with sale amount>=500
• Airdrop of Aurorian-→ solana.core.fact_events with sender address=NFTsPae8pUuvKHiUHpXfZaQwwbiVPw6dPCWpwfvrwR6

Outcomes:

• The USD price of Aurory token started decreasing since start of April and decreased more from May 10 due to the market downturn.
• The sale amount of Aurorian follows the stable pattern but On April 14 and 17 jumped to higher level with maximum happened on 17 with more than 26k SOL as sale amount.
• In general we could see that the sale amount of Aurorian NFTs has same pattern as Aurory token.
• Define start of bear market after market downturn on May 11 and assume that we are now in the bear market of cryptocurrency.
• The NFT expedition on Bear market is decreased as can be seen in comparison with regular market condition.
• despite NFT expedition, the token staking are increasing in bear market.
• The users joined on NFT expedition are more likely fishes than Whales.
• The unstaking of NFTs and selling them on Market increased in bear market by users.
• The number of wallets received airdrop Aurory is about 19265 unique wallets and based on my search they want to kept them instead of selling.