Aave - 6. Aave User Dashboard
Aug 11, 2022 - Create a dashboard that allows a viewer to input a user address and explore their borrowing and lending activity. Include metrics like total origination, loan revenue, outstanding debt, etc.
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.
Flow vs Other L1s
Jun 19, 2022 - Q13. 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
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.
Metamask vs. Other Platforms
Jun 25, 2022 - Q3. How many users are swapping via MetaMask vs other platforms? How much volume have these users done? Chart a comparison between the two, and show the following metrics over a time period of your choosing: transaction volume, average amount swapped, and a comparison of fees
Sushi Treasury
Jun 29, 2022 - Q97. What are the in-flows and outflows from sushi treasury? Analyze the trends. Build a dashboard.
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).
Open Analytics Bounty: Snapshot (August 16)
Aug 20, 2022 - Eeverything about Snapshot; The proposal voting manager
SUSHI Noobs II
Jun 22, 2022 - Q94. What is the first thing new users do when they acquire SUSHI?
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.
Hacks, Scandals and Scams - 4. CEL token flows.
Jul 28, 2022 - 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?
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.
Distinct Wallets (Optimism Bridge)
Jun 17, 2022 - How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days? Visualize your findings.
Distinct Wallets (zkSync)
Jun 16, 2022 - How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
Sushi Activity on Ethereum
Jun 26, 2022 - Q96. How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lendings?
Total Metamask Users
Jun 24, 2022 - Q1. How many total Metamask wallet holders are there? What’s the average value of ETH held in wallets? What percentage of wallets are engaging in a higher order activity, like staking?
Stablecoin Dominance
Jun 29, 2022 - Q20. Compare the transaction volume for USDC, USDT, and DAI on Osmosis. Is there a stable coin that Osmosis users prefer? Extra credit: Is stablecoin dominance the same on Osmosis as it is on Sushiswap and Thorchain? Why might this be or not be the case?
Pooly NFTs
Jun 21, 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?
Stable Coins Lent on Kashi
Jun 15, 2022 - Draw a chart showing the TVL of Stable coins on kashi pairs across all markets.
Bridge Volume (Hop Protocol)
Jun 21, 2022 - Q2. How much volume has Hop bridged to Polygon, Optimism, and Arbitrum compared to those protocols’ native bridges? What is Hop’s total TVL? Create an analysis on the Hop’s TVL and how it’s changed over a time period of your choosing.
Bridge Users (Hop Protocol)
Jun 20, 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.
Bridge Volume (Optimism Bridge)
Jun 17, 2022 - Q2. Compare user bridge volume on the Optimism Native Token Bridge vs. another Mainnet <-> Optimism Bridge of your choosing (e.g. Hop). Can we conclude if there are differences in the types of users or transactions using the native bridge vs. the non-native bridge?
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?
Layer 2 Blocks
Jun 30, 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?
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.