kiacrypto
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.
Lido Rocket Pool Comparison
Apr 27, 2022 - Q13. Use the ethereum_core tables to compare deposits to Lido and Rocket Pool Hint: rETH contract: https://etherscan.io/token/0xae78736cd615f374d3085123a210448e74fc6393 Lido sETH contract: https://etherscan.io/txs?a=0xae7ab96520de3a18e5e111b5eaab095312d7fe84
Volume Scoring with NBA Top Shot
Jun 3, 2022 - Q5. NBA Top Shot allows users to buy, sell, and collect NBA NFTs that showcase influential “Moments” minted on the FLOW blockchain. Create a visualization tracking the total sales volume traded on NBA Top Shot since May 9th by day. How many unique wallets have made a trade on Top Shot over that timeframe? How do those metrics compare to sales volume and unique users of Magic Eden on Solana and OpenSea on Ethereum?
Open Analytics - 3. Solana: Comparing 0% Royalty collections Vs. Non-royalty collections on Solana
Dec 23, 2022
Most Popular Centralized Exchange For Algorand Wallets
Feb 24, 2022 - Let's look at the popularity of centralized exchanges(CEX) when it comes to Algorand. Chart the volume of ALGOs moved to each CEX by day since the beginning of 2021. Chart the volume of ALGOs moved from each CEX by day over time since the beginning of 2021. Are there any notable days of volume for any of the CEXs? What happened?
Sushi Farming
Apr 6, 2022 - Q61. How many farms are there on Ethereum, Polygon and harmony. And what is the TVL per farm? which farms offer the most TVL? How has this changed over time?
Top TOKE Holders
Jun 22, 2022 - Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
The Rise of DeGods
Mar 30, 2022 - DeGods have risen to become one of the most valuable NFT collections on Solana with an extremely devoted community. Create visualizations showing sales volume and unique wallet purchases since January 1st on Magic Eden. Using the NFT metadata, are there certain traits that have become more popular over time in anticipation of DeadGods? $DUST is the token created by DeGods for NFT auctions and will be a necessity for modifying the DeGod art to a DeadGod. Who is swapping for $DUST on Jupiter? Is it correlated with the wallets that have purchased the most DeGods? What do you think will happen to the price of the DeGods collection and $DUST when DeadGods launches on March 31st? Explainer on DeadGods: https://twitter.com/DeGodsNFT/status/1506097466071871495 Explainer on $DUST: https://twitter.com/DeGodsNFT/status/1482314189595033601 Hint: Use fact_nft_sales, fact_swaps, and dim_nft_metadata
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
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.
