kiacrypto
Getting Your Feet Wet, Part 1
Mar 5, 2022 - Make a table containing wallet addresses whose first transaction was 90 days ago or less. Analyze how active they have been since that first transaction, based on either 1) the number of transactions; 2) the number of protocols interacted with, or 3) the number of different types of transactions undertaken. (deposit, delegate, vote) Note: grand prize-winning submissions will assess at least two of the activity metrics above.
Top TOKE Holders
Jun 22, 2022 - Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
USDC Deposits
Jun 22, 2022 - Q1. In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
Flow vs L1s
May 30, 2022 - Q3. Create a dashboard comparing the following metrics between Flow, Solana, Ethereum, and Algorand. Visualize these metrics over time since May 9th. -Number of transactions -Transaction success rates -Number of unique wallets to make a transaction -Number of wallets that used the chain everyday since May 9th -Transaction fees How does Flow compare to these other chains and how do you think it will trend over time?
ETH Deposited or Withdrawn
Jun 29, 2022 - Q1. StarkNet is a layer 2 chain, that ensures interoperability with the Ethereum mainnet. People are using it to move real ETH to StarkNet and enjoy its higher speed of transaction and lower fees. How many ETHs have been deposited or withdrawn (bridged) so far from Ethereum to StarkNet or vice versa? and by how many depositors? Hint: Each deposit/withdrawal on StarkNet is done through the StarkNet proxy contract on Ethereum: 0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419. The logs will tell you more.
LoftyAI Tokenized Real Estate
Mar 3, 2022 - LoftyAI is a tokenized real estate platform(https://www.lofty.ai/). You can invest in property via tokens distributed by Lofty AI, each being worth $50. Rank the properties listed by LoftyAI based on total token investment price. (Each property has its own asset created by the address 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'). How many wallets have bought a token for at least one property? What wallet has invested in the most Lofty AI properties? How many properties are they invested in? Tips: The total token investment price is $50 multiplied by the total amount of tokens for the property(Asset_id). -Look at the assets with a creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
Insight of the Week
Feb 5, 2023 - The NEAR Foundation is running an "Insight of the Week" series. Keeping your analysis short and focused on excellent-quality visualization - provide the most fascinating or illuminating fact or insight that you can about the NEAR ecosystem, or any of the projects building on NEAR, over the past 7 to 14 days. When you tweet about the insight, don't just describe it - do your best to explain "why" what you chose is unusual, valuable, or noteworthy.
Most Popular Jupiter Swaps
Feb 26, 2022 - Jupiter is the best swap aggregator on Solana, meaning that it optimizes the best token swap rate across all decentralized exchanges for users. Since February 1st, what have been the 10 most popular tokens to swap away? Over that same timeframe, what have been the 10 most popular tokens to swap for? What are the 10 most popular swapping pairs (combination of swap away to swap for)? Define 'popular' as the number of swaps and create a visualization showing total number of swaps over that time frame, highlighting these most popular tokens.
New Addresses
May 29, 2022 - Q2. Draw a chart showing the number of new addresses every day on polygon(matic) network. New addressses are unique addresses that appeared for the first time in a transaction of Matic.
Tracking USDC & USDT on Solana
Jun 16, 2022 - Q2. What's the current market share for USDC and USDT on Solana relative to other stablecoins in the ecosystem (look into USDC, USDT, UXD, USDH, PAI, NIRV, UST, DAI, FRAX)? Create a visualization showing the amount of transaction volume for USDC vs. USDT etc. do display popularity within Solana. For USDC and USDT specifically, breakdown the transaction activity by contract and exchange flows (i.e. which dapps and addresses hold the majority of USDC and USDT and what do cumulative flows to and from exchanges look like over time)?
Magic Eden Volume Trends
Mar 12, 2022 - Create a visualization of Magic Eden total sales volume per day since January 1st. How has sales volume trended over time? Are there any trends to when sales volume seems to go up or down on certain days of the week or during certain times of the day? Are users more likely to trade a NFT during the week or the weekend? Hint: Magic Eden has changed recently to a new contract so you will need two ProgramIDs Old: MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8 New: M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K
New NFT Mints
May 17, 2022 - Q76. How many total new NFT projects have appeared on Magic Eden per day since the start of the new year (as in new projects that have minted that day)? Compare that to the total number of new NFT projects that were minted/created on Ethereum? Create a dashboard comparing the growth rates of the number of new NFT projects on Solana and Ethereum and understanding the amount of sales activity on ""new projects"" for each chain.