markoo
Mega Dashboard Polygon ecosystem.
Jul 29, 2022 - How familiar are you with Polygon network and its ecosystem and do you have any information about it? In this dashboard, we answer many of your questions
zkSync Scavenger Hunt
Jun 14, 2022 - To encode and create a table, the transaction recorded on L1 Ethereum needed to be displayed. That's why the Commit tx hash code was put in the query. For more details, I will put the link of the completed transactions.
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).
Liquid Staking ETH Platforms Analysis - Markoo
Sep 1, 2022 - Consider all possible liquid staking ETH platforms. Then, find out the following: How much ETH was staked over time?
Solana Since The Mango Hack
Oct 16, 2022 - What has been happening in the Solana defi ecosystem since the Mango Markets Hack? Has activity increased? Decreased? Are users flocking to any particular defi apps? Are they leaving the ecosystem? Chart flows in and out of centralized exchanges from the Solana ecosystem. Has staking behavior changed on Solana since the hack?
StarkWare Scavenger Hunt - Markoo
Jun 26, 2022 - I created an argent wallet and added some test tokens to it and swap transactions on myswap.xyz
Cryptopunk Sales and Traders - Markoo
Aug 30, 2022 - Which 10 wallets are the most successful Cryptopunks 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.
Polygon Bridger Destinations from Ethereum
Jul 27, 2022 - The most popular destination for those who bridge from Ethereum to Polygon is to Wrapped ETH (WETH), regardless of whether they bridged for the first time or not. It's also very popular to bridge to a Stablecoin (USDC/USDT) or swap with QuickSwap.
OpenSea Fees
Jul 28, 2022 - Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions. Show fees earned in USD total, and also by token amounts. Also show the top 10 NFT’s generating fees for Opensea on Polygon.
Distribution of Swaps in $RUNE and USD Values
Sep 5, 2022 - Show the distribution of swap sizes in both $RUNE and USD, both for all pools as well as broken down by pool.
Open Analytics Bounty: Optimism (Oct 11) (Markoo)
Oct 11, 2022 - Submit any dashboard you think is worthy of being shared with our partners, and with the world. We’ll select the best for payment and amplification through our social and content channels.
Sushi Pairs on Avalanche and BSC
Aug 6, 2022 - Let's dive deep into Sushi pairs on Avalanche and BSC Create a document that includes all addresses for all Swap pairs on Avalanche and the BSC for sushi, plus the addresses of the two tokens belonging to each pair. Create a document that includes all addresses for all Kashi pairs on Avalanche and the BSC for sushi, plus the addresses of the two tokens belonging to each pair. Ideally, define which one is the main asset and which one is the collateral.
Overtime Markets - Volume
Aug 23, 2022 - Analyze the total volume on Overtime Markets over the past two weeks. Which games received the most activity, both in total users and total $ volume? Which sports are receiving the most bets in total dollar volume on a daily basis? Explain your findings.
Optimistic Bears (Markoo)
Aug 7, 2022 - Analyze Optimism during the month of July as markets were get turbulent.
Tracking Realms DAOs - Markoo
Aug 17, 2022 - We now have Solana Realms governnace data! Their team would love to be able to see a list of DAOs / multisigs built on SPL Governance, and understand their: - Number of Members (assuming unique voters is what he means here) - Total Votes - Number of Proposals - Date of Last Proposal - Date of Creation
Velodrome Health-Markoo
Aug 15, 2022 - Create 3 dashboards on Velodrome with a description for each that showcase traction and success in a data-driven manner.
Open Analytics Bounty: Optimism (Oct 11) (Markoo)
Aug 24, 2022 - Submit any dashboard you think is worthy of being shared with our partners, and with the world. We’ll select the best for payment and amplification through our social and content channels.