esi69
Osmosis Stablecoin Dominance
Jun 26, 2022 - Q20. Compare the transaction volume for USDC, USDT, and DAI on Osmosis. Is there a stable coin that Osmosis users prefer?
Optimistic Bears
Aug 10, 2022 - Q9. Analyze Optimism during the month of July as markets were get turbulent, showing whatever metrics you care to unearth.
Across Protocol Airdrop
Nov 30, 2022 - The ACX airdrop took place this week. Create an analysis of the Across protocol bridge volumes, airdrop distribution and TVL.
True Freeze - 7. FRZ Airdrop Activity After Claim
Aug 23, 2022 - Approximately 230,000 addresses are eligible to claim FRZ. What percentage of all eligible addresses have claimed the airdrop? After claiming their allotment in the FRZ airdrop, what do participants do with their FRZ tokens?
WBTC performance . 2023 .
Mar 15, 2023 - In this dashboard, I have reviewed the performance of wbtc since the beginning of the new year.
Sushiswap Sushi Treasury
Jun 29, 2022 - Q97. What are the in-flows and outflows from sushi treasury? Analyze the trends. Build a dashboard.
Open Analytics Bounty: ETH (November 13)
Nov 17, 2022 - Open Analytics Bounty: ETH (November 13)
Blockchain Analytics Course - 2. NFT Mints
Aug 23, 2022 - Using the table ethereum.core_ez_nft_mints, select one or a few recent project mints and determine how “successful” they were. How success is defined is up to you! You could look at: volume of ETH spent, number of NFTs minted, unique addresses minting the project, fees spent in ETH by minters.
Machi Big Brother Whale NFTs .
Mar 7, 2023 - Open Analytics - 23. Ethereum Whale sells 1,010 NFTs in 48 hours: Nifty Newsletter, Feb. 22–28
WBTC performance / 2023
Mar 15, 2023 - In this dashboard, I have reviewed the performance of wbtc since the beginning of the new year.
Open Analytics - 4. Ethereum
Dec 23, 2022 - For this dashboard I have chosen the new Trey Ratcliff's 1k1k #233 - 1,000 Photos from 1,000 Places Around the World collection. Because I think photography projects are very interesting and they are progressing.
2022 Retrospective
Dec 21, 2022 - Let’s explore some key indicators of the health of the Web3 industry.
WBTC performance 2023
Apr 6, 2023 - In this dashboard, I have reviewed the performance of wbtc since the beginning of the new year. Wrapped crypto or wrapped tokens are digital assets that; represent the exact value of an original cryptocurrency from a different blockchain or follow a different token standard to the chain its on. WBTC and WETH are good examples of the former and latter respectively.
Optimism Bridge Bounties Distinct Wallets (Optimism Bridge)
Jun 16, 2022 - Q1. How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days? Visualize your findings.
ZK Sync Bounties Distinct Wallets (zkSync)
Jun 13, 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.
the effect of ETH & OP price on the Inflows and Outflows Layer 2
Mar 10, 2023 - Open Analytics - 26. Optimism
StarkWare Layer 2 Blocks
Jun 27, 2022 - 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?
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 27, 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.
Open Analytics Bounty: ETH (October 23)
Oct 23, 2022 - Open Analytics Bounty: ETH (October 23)
International Women's Day Spotlight / 8 March
Mar 11, 2023 - World of Women NFT is top collection
Hop Bounties Bridge Users (Hop Protocol)
Jun 19, 2022 - 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.
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.
ZK Sync Scavenger Hunt
Jun 14, 2022 - Overview By the end of this tutorial, you should be able to: Create a zkSync wallet Migrate ETH to zkSync Swap for USDC
Ethereum 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?
Flow NFT Wallet Behavior Comparison
Jul 19, 2022 - Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to Ethereum and Solana. Is there more or less "whale" activity on Flow compared to each of the other chains?
World Cup of Bounties
Nov 22, 2022 - Sorare is a digital, playables and collectibles platform where users can compete across futbol, NBA, and MLB in a fantasy sport setting. Build a dashboard that covers the Sorare project
Ethereum 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).
Pool Together Bounties Pooly NFTs
Jun 22, 2022 - How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
Solana Realms vs Snapshot
Aug 31, 2022 - Building off previous recent bounties on Realms and Snapshot, create a dashboard that shows how Realms and Snapshot are growing and used in comparison to one another. Feel free to build off previous bounty work on these platforms.
Flow 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.
Open Analytics Bounty: ETH (November 27)
Dec 2, 2022 - Open analytics bounties are all about deep dive dashboards into one specific topic.
StarkWare ETH Deposited or Withdrawn
Jun 27, 2022 - 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?
Open Analytics Bounty: ETH (November 6)
Nov 11, 2022 - Open Analytics Bounty: ETH (November 6)
Flash Bounty: Art Gobblers
Nov 2, 2022 - Art Gobblers is a pre-reveal NFT project that generates "goo" when you feed it (upload) art you've created. Some say the project is revitalizing NFTs in the bear market - Compare various metrics across NFT activity to support or oppose that idea. Then evaluate how the project's metrics stack up to other top NFT collections before their art reveals.