The Question :

Q2. Analyze user activity providing and removing liquidity from NFTX vaults. Which three vaults have seen the most activity over the past 60 days? Are there any similarities between these vaults or NFT projects? Explain and visualize your findings.

Method :

I used ethereum.core.fact_event_logs table.But the data in this table seems to have a problem. According to the question form, we have to check the last 60 days. The data in this table is only available until January 17.

Top NFTX vaults based on the staked amount :

1. purrnelopes country club
2. the genesis project
3. uwucrew

Top NFTX vaults based on the number stake action :

1. the genesis project
2. cryptophunksv2
3. winter bears

user activity removing liquidity NFTX vaults based on the number of unstake action :

1. BOOT
2. NFTX
3. xCYPHERWETH