0-MID
Daily stETH Metrics
Jun 5, 2022 - Q3. Find the following stETH metrics: Daily volume of stETH? Average stake size? Number of stakers over time? Average time staked? Staking/unstaking per day?
Limit Swap Orders
Mar 3, 2022 - In this dashboard we will try to extract the numberof limit orders placed in Sushi Swap and understand its popularity.
Orca + Jupiter Volumes
Mar 15, 2022 - Compare user interaction with Jupiter and Orca through Sol exchange
Governance Period 2 Payouts
Apr 14, 2022 - Q49. Let's look at the Algorand Period 2 Governance Rewards Payouts How many reward payments were sent? And what was the total amount of ALGO rewards paid out? How much time elapsed from the first to the last rewards payment? What wallet had the largest rewards payout and how much did they receive? Create a plot to show the distribution of rewards payouts
Algorand Foundation New CEO Staci Warden
Mar 16, 2022 - Appointment of Algrand's new CEO and its impact on Algo's input and output from centralized exchanges
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.
Katana Covered Call Vault Popularity
Mar 27, 2022 - Review and Compare 5 Katana Covered Call Vault
Solana NFT Championship
Oct 9, 2022 - A dashboard about NFT Sports Collections and Sports Collection Champion
Untitled Board
Nov 24, 2022 - An exploration of the state of opensea market in Solana network during FTX chaos period.
Kashi TVL
Apr 9, 2022 - Q65. What is the Total Value Locked (TVL) by liquidity pool on Kashi? draw a weekly chart for 2022. what are the top 10 pools?
stETH Most Common Pools
Apr 22, 2022 - Use the ethereum_core tables to determine the pools most commonly used to swap in and out of stETH. What are the most common pairs? Which pools are most often used?
Is Another USDC Coming?
May 28, 2023 - An exploration of the circle throw on Avalanche... $EUROC!
Flipside's World Cup of Bounties Side Quest: LaLiga Golazos
Dec 6, 2022 - Comparison of the popular Flow and Algorand collections with the LaLiga Golazos collection.
Inflows and Outflows
Sep 12, 2022 - Investigating the volume of input and output of Ethereum and USDC and USDT stable coins between Optimism and Ethereum networks
Sushi vs Uni on L2
Oct 16, 2022 - Compare the market share of Sushiswap and Uniswap on the following L2 chains. Polygon, Arbitrum, Optimism. Use measures such as number of trade or number of swaps, etc.
Open Analytics Bounty: Optimism (October 1)
Oct 6, 2022 - All about Stargate Interchain Project on Optimism Network
Wallet Balances & Ecosystem Growth
Oct 22, 2022 - New flipside table story in osmosis database about osmo balance
Open Analytics Bounty: Optimism (August 14)
Aug 20, 2022 - An exploration of Synthetix defi platform staking and borrowing on the Optimim network
Open Analytics Bounty: Optimism (August 28)
Sep 2, 2022 - A look at the largest NFT market of the Optimism network
Open Analytics Bounty: Avalanche (August 8)
Aug 13, 2022 - Examining the Aave V3 lending protocol on the Avalanche network
Gains Network vs GMX
Nov 5, 2022 - Review of 2 trading platforms on Arbitrum and Polygon networks.
Metamask vs. Other Platforms
Jun 26, 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.