CowSwap - Market Mover?
Apr 21, 2022 - question: Has CowSwap shifted the token exchange market? Show the number of swaps that are done on CowSwap compared to other DEXs over the past several months. What DEXs are the users of CowSwap coming from? To answer these questions, I decided to compare the number of cowswap transactions with the number of valid decentralized exchanges since the beginning of the year. I used Table ethereum_core.fact_event_logs to do this
Withdraw to my wallet or to my Bentobox?
Apr 28, 2022 - What percentage of users choose to withdraw directly to their wallet rather than withdrawing to bentobox when they perform a borrowing or when they withdraw from lending? Hint: look for ""LogWithdraw"" events. This event will show you what token is withdrawn from your bento address to your wallet address. In order to make sure this has been a lending or borrowing operation, you need to make sure you can find a ""Kashi medium risk"" token in other events of the same transaction.
THORChain $RUNE Upgrades
Jun 26, 2022 - Q.107 There has been a big push for users to upgrade their ETH.RUNE + BNB.RUNE -> native RUNE, as the wrapped versions will be depreciated.
Sushiswap Sushi Treasury
Jun 29, 2022 - Q97. What are the in-flows and outflows from sushi treasury? Analyze the trends. Build a dashboard.
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.
Avalanche Swaps vs Transfers (USDT & USDC)
Apr 4, 2023 - USDC and USDT are always the two most used stablecoins in all networks, in this dashboard I intend to check the performance of these two stablecoins on the Avalanche network and compare them from the beginning of 2023. (By changing the date in the parameter, you can change the date of the check your interest)
2022 Retrospective
Dec 21, 2022 - Let’s explore some key indicators of the health of the Web3 industry.
Flow Bounties Trending NFT Projects
Jun 13, 2022 - Create a visualization showing NFT sales volume on Flow since May 9th. Which NFT projects are trending on Flow right now and what is the general trend of NFT sales over the last month? Do the projects that are trending seem to have common wallets or is there not much crossover between buyers/sellers?
Flash Bounty: Yesterday was… Yesterday was… Well let’s not talk about yesterday, let’s analyze it.
May 10, 2022 - You’re looking to rebuild your bags and we’re looking for some analysis, but we want to know what you want to know about yesterday. Make a dashboard on any topic that strikes your curiosity, tweet it, mention @flipsidecrypto, and we’ll put 20 LUNA in your bag.
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.
NFT wash trading on Solana Chain
Mar 21, 2023 - NFT wash trading increases by 126% in February: The NFT market saw an uptick in wash trading following a recovery in NFT marketplace trading volume, which hit $1.89 billion in February.
Optimism Velodrome Health
Aug 15, 2022 - Q10. Create 3 dashboards on Velodrome with a description for each that showcase traction and success in a data-driven manner.
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?
Open Analytics Bounty: ETH (November 13)
Nov 17, 2022 - Open Analytics Bounty: ETH (November 13)
Optimism CEXs
Mar 30, 2023 - In this dashboard, I intend to check the amount of deposits in the Optimism network on three exchanges( Binance & Kucoin & Coinbase)
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.
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.
Solana Network Performance Dashboard
Jul 13, 2022 - Q95. Create a dashboard displaying Solana network performance over time.
Open Analytics - 16. Optimism
Feb 18, 2023 - In this dashboard, I intend to review Quests NFT collection, which is one of the best NFT collections since the beginning of the new year. And I have investigated the impact of the OP price on this collection.
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?
Staking goBTC and goETH for Rewards
May 21, 2022 - Q73. AlgoMint launch rewards programs with multiple protocols throughout the Algorand ecosystem so we want to understand where is the best place to stake goBTC and goETH to earn rewards? Let’s look at where other wallets are staking their goETH and goBTC to get an understanding where we should stake ours. Look at items such as mint and burn actions over time as well as the amount of goBTC and goETH being staked over time to help us determine where the most popular place to stake your goETH and goBTC. Additionally, are there any places not listed that you can stake your goETH and goBTC for rewards and are users staking them there? Tips Pact LPs Algo/goBTC Algo/goETH AlgoFi LPs goETH/STBL goBTC/STBL Tinyman LPs ALGO/goBTC Algo/goETH Folks Finance Deposit goBTC goETH
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.
WBTC performance / 2023
Mar 15, 2023 - In this dashboard, I have reviewed the performance of wbtc since the beginning of the new year.
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
Blocto or Dapper or JoyRid ?
Apr 7, 2023 - As I know, currency wallets are one of the most important tools in the cryptocurrency market. And each network apart from the public wallets also have the number of wallets for their own network, in this dashboard I intend to check the performance of three selected wallets on the Flow network in 2023.
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 - 2. Solana Open Analytics
Dec 12, 2022 - Open Analytics Bounty: Solana (December 9)
World Cup of Bounties
Nov 15, 2022 - Flipside's World Cup of Bounties Side Quest: Fifa+ Collect Collection Scorecard
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.
Open Analytics Bounty: Solana (November 26)
Dec 1, 2022 - Open analytics bounties are all about deep dive dashboards into one specific topic.
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?
Algorand Pact Fi Scavenger Hunt
Jun 27, 2022 - Pact Fi is a decentralized automated market market(AMM Dex for short) on the Algorand network. What stands out most about Pact Fi is LP(Liquidity Pair: A pair of assets to provided by a wallet to allow users to trader between assets on a DEX) providers get 100% of liquidity pool fees back!