Waiting for Aurory

Aurory is one of the most highly anticipated games to come out on any chain. Create a dashboard highlighting wallet trends around both the tokens and NFTs.

What is Aurory?

Aurory is a gaming studio first, and a crypto company second. Our team of industry veterans are here to bring the same AAA quality experience that we all love from web2, but with a dash of seamless web3 asset ownership enabled by low fees and quick transactions on Solana.

Questions

Does the price of Aurory token has positive correlation with volume of nft sales? How have token staking and nft expedition patterns changed in the bear market? What have wallets been doing with their airdropped NFTs?

Method

First I use the solana.core.fact_swaps table with the filter SWAP_FROM_MINT = 'AURYydfxJib1ZkTir1Jn1J9ECYUtjb6rKQVmtYaixWPP' and SWAP_TO_MINT = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' As of May 1 , I got the NFT price. Then using solana.core.dim_labels and solana.core.fact_nft_sales tables I got the daily sales volume from May 1.
from table flipside_prod_db.solana.fact_events with filter program_id = 'STkwf3sbMapjy7KV3hgrJtcVvY4SvRxWQ8pj4Enw1i5' I got the stick transactions Then by joining the flipside_prod_db.solana.fact_transactions table and filter PRE_TOKEN_BALANCES[0]:mint = 'xAURp5XmAG7772mfkSy6vRAjGK9JofYjc3dmQDWdVDP' I got the number of stackers and the daily stake volume.
from table solana.core.fact_nft_mints with filter PURCHASER = 'NFTsPae8pUuvKHiUHpXfZaQwwbiVPw6dPCWpwfvrwR6' I got the airdrops Then I joined with the 'solana.core.fact_events table based on the tx_id and compared their behavior regarding airdrop sales or hold.

Does the price of Aurory token has positive correlation with volume of nft sales?

Yes.price of Aurory token has positive correlation with volume of nft sales.

On May 5, when the sales volume was 2.5k, the price was the highest.

Stake activities

In the bearish market, the volume and number of stick transactions has increased.

What have wallets been doing with their airdropped NFTs?

As seen in the charts below

The behavior of users in taking Airdrop is to hold.

Only 13.2% sell their airdrops and 83% keep them.

On May 31, there were about 667 airdrops.

Conclusion

Price of Aurory token has positive correlation with volume of nft sales.
In the bearish market, the volume and number of stick transactions has increased.
The behavior of users in taking Airdrop is to hold. Only 13.2% sell their airdrops and 83% keep them.