kaperotictoc
Users' Behavior on FLOW
Jun 19, 2022 - Q11. What are users swapping for? What activities are the most common for users on Flow right now? Create a visualization on what’s causing spikes in swapping behavior.
User Activity
Jun 14, 2022 - 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.
NBA Playoff Usage
Jun 28, 2022 - Analyze the start of the NBA playoffs (mid-April) and determine whether it had an impact on Flow transaction volume. What about NBA Top Shots?
Do Whales Have Diamond Hands?
Jun 21, 2022 - Q12. Does the swap behavior of OSMO whales differ from everyday users? How does it differ? Create visuals showing what whales swap to and from compared to a normal Osmosis user.
Bridge Transactions (Across)
Jun 22, 2022 - Q1. Analyze bridge transactions via the Across bridge over the last two weeks. What assets are users bridging from Ethereum, and to what chains? Across transaction event data is undecoded in the Ethereum core tables. Users can use these functions to parse and decode the data: regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data ethereum.public.udf_hex_to_int()
Highest Sales Volume
Jun 12, 2022 - Q1. Which 3 NFT collections have the most total sales volume in the last 60 days on NFTX? These are transactions where someone redeems their NFTX tokens for a specific NFT. Hint: You can find these sales in ez_nft_sales. Visualize your findings.
$RUNE Upgrades
Jun 28, 2022 - Q.107 There has been a big push for users to upgrade their ETH.RUNE + BNB.RUNE -> native RUNE, as the wrapped versions will be depreciated.
Active Wallets on Terra
May 3, 2022 - Define "Active Wallets" on Terra. Based on your definition, display the active wallets by day, month, and Year-To-Date in 2022.
Distinct Wallets (zkSync)
Jun 18, 2022 - Q1. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
Flow vs Other L1s Pt (II)
Jul 18, 2022 - How does Flow compare to other L1s in terms of user retention? Is a user who made a transaction previously likely to make another transaction a week or a month later? Compare and contrast this type of activity vs other L1s like Solana and Ethereum.
Swapping goBTC and goETH on DEXs (May 17)
May 21, 2022 - Q72. goETH and goBTC are wrapped forms of ETH and BTC minted by algoMint. Let's look at goBTC and goETH swaps across the DEXs since the beginning of April and get a better understanding of how wallets are swapping goETH and goBTC - especially during the price crash in May.
Hot Contracts on Osmosis
Jul 12, 2022 - Q20. A lot of new contracts are being deployed on Osmosis lately.
Solana Stables
May 17, 2022 - Q74. Track stablecoin activity on Solana since April 1st (not limited to but look into USDC, USDT, UST, USDH, UXD, PAI). What have been the flows between coins and what was the result of the UST depegging in the Solana ecosystem? What types of wallets hold a USDH, UXD, or PAI compared to a USDC and what are users doing with those coins?
DEX Popularity: Tinyman, Algofi, Pactfi
May 20, 2022 - Q70. Since the beginning of April, how has the growth of AlgoFi and Pact impacted swaps on Tinyman? Show us how the Algorand DEX ecosystem is changing as each DEX grows.
Collateral Impact (May 13)
May 18, 2022 - How does the volume on MakerDAO (in terms of DAI minting) change as more collateral tokens are added to the platform? Which tokens have impacted volume the most?
$RUNE Movement from Crypto.com
Jun 21, 2022 - Show the in + outflow from cryto.com to native wallets over time. Are there any trends?
MNDE Locked In Governance
May 4, 2022 - Create a line chart showing the total amount of MNDE tokens locked in governance over time. What percentage of the current circulating supply does this represent?
Swap Increase on May 11 & 12
Jun 9, 2022 - On May 11th and 12th we saw a spike in number of swaps and volume across the DEXs. Breakdown what happened? What were users swapping from and to? Were users swapping from ALGO to stables? Was the average swap size bigger than normal? Is this tied to the price of ALGO?
FLOW Usage During the NBA Playoffs
Jul 12, 2022 - Q19. Analyze the NBA Conference Finals (May 17th- May 29th) and determine whether it had an impact on NBA Top Shot's volume.
Daily Transactions and Unique Addresses
Jul 13, 2022 - Count and plot the number of daily transactions and unique addresses on Polygon, beginning July 1, 2022.
Hot Ball of Money (Solana NFTs)
Jun 15, 2022 - Compare Solana NFT sales activity on "new" collections to the activity on more established collections within the ecosystem.
New Wallets In May
Jun 16, 2022 - Q101. How many wallets have a balance greater than 1 ALGO? And how many of those wallets sent or received a transaction in May? How many new wallets were created in May? What % of total wallets with more than 1 ALGO is this? Additionally, show the distribution of ALGO holdings for these new wallets. What is the average ALGO holding of these new wallets? What other ASAs do these new wallets from May hold? How many of these wallets have performed a swap? Finally, note anything else interesting about these wallets! Why are these wallets being created and what are they doing on Algorand?"
Solana Outages
Jun 9, 2022 - Solana experienced another outage on 6/1 where validators were forced to restart the network. The network experienced a similar problem back on 5/1. After the restart happens during these outages, how do users on the network generally respond?