Moving to Earn in the Bear Market
Method
-
For Minting stats I used solana.core.fact_nft_mints table for stepN with 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' AS PURCHASER, I calculated it for three duration : Total, last 60 days, last 30 days. And for genopets I used this table to with
'GenoS3ck8xbDvYEZ8RxMG3Ln2qcyoAN8CTeZuaWgAoEA' AS PURCHASER
-
for volume, I collected the item address for stepN from
solana.core.fact_nft_mints table, then with solana.core.fact_nft_sales table I calculated the sale volume of stepN NFT items. And for genopets I collected the address of the items from
solana.core.dim_labels table
-
for tokens flow data, I Used solana.core.fact_transfers table and calculated daily total transferred amount, count of transfers and average amount
-
for finding genopets active user data, I used solana.core.fact_transactions table and token contract of gene, each user had contact with this contract I considered it as active user. For stepN I used this table and this address : ‘STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK’, users that had contact with this address are active users of stepN
Information:
- for genopets: the count of transfers that create a jump on Jun 20, 2022 in KI token flow was only 6 TX, from that we can conclude that this transfers belongs to the project
- for stepN: most of the transfers count of StepN belongs to GST Token,
- there was decrease in count of transfers for both of the projects due to condition of market,