Flash - Delphi
Nov 9, 2021 - The ask: We’re working on giving Delphi insights on some Terra data. A DappRadar report had mentioned that 2M daily unique active wallets interact with dapps, we want to see that stats on Terra alone. tl;dr: Query on-chain data to find the number of daily active wallets on Terra from the past 90 days and give an analysis on findings.
The Flipside Helpdesk
Mar 15, 2023 - This is "THE BEST" Dashboard to teach you everything about Flipside's Data Application.
1. CRV Token Uses
Sep 13, 2021 - What else do people do with the CRV token (besides vote-lock)? Reminder: provide at least two visualizations to support your answer.
Sample Hamas Dataset
Oct 27, 2023 - Can crypto-twitter OSINT outperform the WSJ’s chain analysis? Sample Data sold @ https://app.sollinked.com/AqsKuYXToEGneeKLFAxuXyPKHE4RCmgbXS4anj6NEfpr/content
Flow Mega Dashboard
Mar 18, 2023 - Made this dashboard for the Flow Blockchain as an example to illustrate all the different techniques we can use based on "The Flipside Helpdesk".
zkSync - Chainbase Hackathon
Oct 28, 2023 - Analysis done on zkSync using chainbase api to extract data...
Flow - 1. Hackathon Results
Mar 18, 2023 - Analysis of the Flow hackathon impact and the corresponding results.
Stat of the week - Polygon Gas
Feb 18, 2023 - Polygon's average gas price has been increasing in the last few days. Lets take a deeper dive into what's going on..
The Typical Minter - Godmode Edition
Jun 8, 2022 - Analyze the Ethereum profile of those who minted during the first hour after launch. How many of them moved the minimum .1 ETH into their minting wallet vs. already had at least .1 ETH in that wallet? How many of them have been active in NFT purchases over the past six months? Can you construct a “typical minter” profile/profiles based on their wallet behavior?
Opensea Fees
Aug 17, 2021 - 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.
9. [Easy] Claimed Token Distribution
Dec 18, 2021 - What’s the average amount of ENS claimed from the airdrop? Create a histogram that shows claim size distribution.
Terra6 - Best Yield-Farming Opportunities for Terra assets on Ethereum
Jun 25, 2021 - Create a dashboard of the best yield-farming opportunities for Terra assets on Ethereum. Please note you will have to use the Flipside ETH tables (documentation provided here: https://app.gitbook.com/@flipside-crypto/s/flipside-docs/our-data/tables/table-schemas)
Uniswap - Increase/Decrease Liquidity Frequency
Jun 17, 2021 - How many times have unique wallets increased liquidity (using lp_actions) in the past week? How about decreased liquidity?
Terra Mega Dashboard
Oct 15, 2023 - Requested by https://x.com/Levana_protocol/status/1713467396470509613?s=20. Maintained for TerraGrowthDAO
Terra - Analysis of fees
Jun 24, 2021 - On Terra, transaction fees generated by token swaps work to maintain the peg of stablecoins to their associated fiat currency. How many fees are being paid out each day for the past 30 days? Do we see any big differences between the different stablecoins?
Yearn - Treasure Hunt
Jul 30, 2021 - - Show your acquisition of YFI - Show confirmation of a deposit
30. [Easy] Net Liquidity
Dec 17, 2021 - - How much liquidity is being added and removed from the THORChain pools over time? - Is there a noticeable trend?
Inflows and Outflows on Polygon
Aug 16, 2021 - What is the volume of ETH and a stable coin of your choice that's moved between the Polygon network and the Ethereum network across the bridge? How has that changed over time?
9. [Hard] Bridger Destinations
Sep 13, 2021 - Where do people go when they bridge to Polygon from Ethereum? What are the 10 most popular first destinations for Polygon addresses that have just bridged from Ethereum? What has this been for each day in the past month? Bonus: Use a network graph