pouya_22
Hacks, Scandals and Scams - 4. CEL token flows
Jul 25, 2022 - Celsius Network listed a $1.19 billion deficit on its balance sheet in a bankruptcy court filing a day after the cryptocurrency lender filed for Chapter 11. Currently Celsius owns a large portion of the CEL tokens. What are the top addresses swapping and transferring CEL? How have the CEL swap volumes changed over the past 90 days? How are Celsius wallets interacting with the CEL token?
Hacks, Scandals and Scams - 3. Whales On Alert
Jul 28, 2022 - Identify active wallets with a high balance of ETH (whales). Visualize the ETH transaction history of these whales in May and June 2022.
Aave - 7. AAVE and stAAVE movements
Aug 7, 2022 - Create visualizations showing the following: Daily AAVE supplied and withdrawn on Aave protocol. Daily AAVE staked and unstaked.
ETH Derivatives
Sep 11, 2022 - Consider the liquid staking ETH derivates from ankr, rocketpool and lido(aETH , rETH and stETH). What are some trends around the price volatility for these tokens? Swap activity?
Optimistic Bears
Aug 5, 2022 - Q9. Analyze Optimism during the month of July as markets were get turbulent, showing whatever metrics you care to unearth. You can choose any topic you’d like: How did the network perform? What about market performance? Were there significant inflows or outflows on bridges? Were there any notable patterns in user behavior?
True Freeze - 4. My Next Purchase
Jul 29, 2022 - What is the most common transaction (any transaction) users make after minting frETH?
Tornado Cash Addresses
Aug 10, 2022 - Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle. The addresses tied to the service have been publicly posted online. (Hint: we also have them in our crosschain address labels table as well). Using those addresses: Which of the Tornado Cash addresses received the most # of transactions in the last month, quarter, year Which addresses received the most transaction volume (worth) in the last month, quarter, year Over all the addresses, group the transactions into buckets by value. How many tx in the 0.01-0.1 ETH range went to Tornado? How many in the 0.1-1ETH range? How many in the 1-10ETH range? How many in the 10-100 ETH range? How many above 100 ETH? (split further if better)
HODL or Sell?
Jun 11, 2022 - Identify accounts that have staked ETH with Lido when the price of ETH was much higher or much lower than it is now. Have they held or sold their stETH?
Voting Activity
Jun 18, 2022 - Q1. The Lil Nouns DAO is controlled via onchain voting by token holders. Using the ethereum database, analyze voting activity on Lil Nouns proposals. Since voting is on chain and costs gas, are smaller holders excluded from the voting process? Visualize and analyze this question, along with any other trends you find that are relevant.
Axelar - Prime Protocol Launch
May 21, 2023 - Prime Protocol is web3’s first cross-chain native prime brokerage, allowing users to borrow assets on any chain backed by their complete portfolio of assets, powered by Axelar.
ETH Deposited or Withdrawn
Jun 29, 2022 - Q1. StarkNet is a layer-2 chain that ensures interoperability with 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?
Algorand Price Correlation
Jun 26, 2022 - Q109. Is the price of Algorand more closely correlated with the crypto market, and assets such as BTC or ETH, or is it more correlated with network usage such as number of transactions or ALGO transfers?
Layer 2 Blocks
Jun 29, 2022 - Q2. How many layer2 StarkNet blocks have been accepted on Ethereum (L1) chain so far? How much fees have been paid(generated) to Ethereum network? Has StarkNet contributed to saving in transaction fees for its users?
USDC Deposits
Jun 21, 2022 - Q1. In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
Bridge Users (Hop Protocol)
Jun 18, 2022 - Q1. How many unique users have bridged to L2s using Hop? What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.
Gain or Lose
Jun 15, 2022 - Q10. Of the stakers that have swapped ETH to stETH, how much ETH did they gain or lose depending on the peg of stETH to ETH at the time of the swap?
Flow vs Other L1s Pt (II)
Jul 19, 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.
NEAR Performance
Jul 21, 2022 - Q5. How does NEAR stock up to other L1s in terms of speed and performance? How fast is NEAR, and compare it with other blockchain speeds in terms of transactions per minute and percentage of transactions that fail.
Pooly NFTs
Jun 22, 2022 - Q2. How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
Bridger Destinations
Aug 1, 2022 - Q5. Where do people go when they bridge to Polygon from Ethereum? What are the 10 most popular first destinations for Polygon addresses that have just bridged from Ethereum?
Polygon Block Performance
Jul 26, 2022 - What is the average time between blocks on Polygon? What was the maximum and minimum recorded time between two blocks? How many transactions are done in a block on average? How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
Flash Bounty: Miners
Sep 8, 2022 - Analyze Ethereum miners in terms of number of blocks they have mined and low or high transaction count they have preformed.
Most Common Transactions
Jun 25, 2022 - Q2. What are the most common transactions for Metamask users? Create an analysis that shows the most common wallet activities and the most common platforms for those activities.
Cryptopunk Sales and Traders
Aug 29, 2022 - Which 10 wallets are the most successful Cryptopunk traders? Successful could either mean the wallet has accumulated a large balance from sales or has accumulated a large number of Punks. Explain your methodology and findings.
Inflows and Outflows (redux)
Oct 30, 2022 - What is the volume of ETH and three stablecoins of your choice that's moved between the Optimism network and the Ethereum network across the bridge? How has that changed over time? Note any interesting trends or outliers that you see.
Opensea Fees
Aug 1, 2022 - Q6. Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
wETH Deposit Rate
Jun 14, 2022 - Calculate the deposit rate of wETH over time on Osmosis. How does this compare to SushiSwap and Thorchain now? How does the wETH deposit rate compare to when wETH was a relatively new asset (or the protocol was relatively new)? Is Osmosis growing at a faster rate than Thorchain and Sushiswap?