CryptoIcicle
ENS-12. [Easy] Opensea ENS Sales
Jan 1, 2022 - Make a dashboard that is set to update daily showing a leaderboard of the most expensive recent ENS sales on Opensea. Make sure to include the domain names and the sale amounts. HINT use the table ethereum.nft_events.
THOR-18. [Easy] Wealth distribution
Nov 6, 2021 - What is the distribution of wealth within the THORChain ecosystem? Show a histogram of the breakdown Hint: use transfers
NEAR-5.Performance
Jul 16, 2022 - Q5. How does NEAR stock up to other L1s in terms of speed and performance? How fast is NEAR, and compare it with other blockchain speeds in terms of transactions per minute and percentage of transactions that fail.
SUSHI-8. Swap Volume
Dec 7, 2021 - Compare swap volume on the top 10 pools -- what is the best stablecoin pool and any differences you notice between Ethereum and Polygon
Terra-125. [Easy] Anchor Users
Jan 2, 2022 - How many new users has Anchor attracted in the last 3 months? How many remain active participants? Bonus points for additional metrics that categorize user behavior (ie -- Earn vs Borrow vs Supply vs ANC Staking, etc)
Solana-55.Marinade's Non-fungible Chefs
Apr 17, 2022 - -- Create a bar chart illustrating the pace of minting activity since the launch on April 4, 2022. -- Create a pie chart showing the distribution of Chef NFTs by Level (as outlined above). -- How many whales (L5) are out there, ready to participate in governance?
Algo-109.Folks Finance TVL
Jun 30, 2022 - -- Q109. Calculate the TVL on Folks Finance- broken out by deposited and borrowed. -- Use their markets/total deposited page(https://app.folks.finance/markets), their homepage(https://folks.finance/), -- and contracts(https://docs.folks.finance/developer/contracts) to guide your analysis. -- Note any interesting findings about major TVL shifts or anything else you find/
Sushi-91.Swap Token Pairs on Polygon
Jun 13, 2022 - -- Q91. Create a document that includes all addresses for all Swap pairs on polygon for sushi, plus the addresses of the two tokens belonging to each pair. If you are using sources from sushi github, please include the link.
Forefront-4.Forefront Participation Incentives
Apr 17, 2022 - Q4. Compare the incentives for participating in Forefront with at least two other social tokens/DAOs of your choice citing two metrics of your choice. In terms of payout opportunities and upside, does the S2 Forefront seem optimal for encouraging development? Create a dashboard showing payouts aggregated for each role type and if each role has influenced what contributors do with their payments? What are some methods that would encourage payments to be reinvested into Forefront besides just time? Hint: Find all contributor addresses in the dashboard here https://www.forefront.club/dashboard Hint: treasury address 0x2Fb9F0ef424b24a8D293999298F392a33Fe6A8b5
Flash-Monthly Active Users
Mar 2, 2022 - "Monthly Active Users (MAU) is an estimate of addresses involved in a transaction that month, not including validators or oracle voting transactions. MAU is calculated through the previous month."
Sushi-93.SUSHI Noobs
Jun 19, 2022 - Q93. From which address do users acquire their first $SUSHI token ? is it CEX ? DEX ? Dual LP Staking Rewards ? Airdrop ?
[Curve-3] [Free Square Question] Curve Weekly Volume Breakdown
Sep 20, 2021 - Overall - For the past 10 weeks, what has been the overall weekly swap volume for Curve ? - For the past 10 weeks, what has been the week over week change in swap volume for Curve ? Top5 (ranking determined by most recent week) - For the past 10 weeks, what has been the weekly swap volume of the Top5 Pools for Curve ? - For the past 10 weeks, what has been the week over week change in swap volume of the Top5 Pools for Curve ?
[Terra-68] Chai Volume
Sep 13, 2021 - Has the volume of Chai being transacted with changed over the past 6 months? Provide visualizations as well as analysis to explain the patterns of how Chai's volume has changed over time.
Exchange Flows in the Bear
Aug 13, 2022 - Let's understand whether the bear market and recent issues with CeFi products have changed centralized exchange users' behavior Explore trends in exchange withdrawal (specifically, moving money from CEX addresses onto the chain) patterns over the last 6 months. Have those withdrawals increased? Has the typical size of them changed? Most important: are people creating new wallets to take custody of their CeFi deposits?Also have a look at what people do after a withdrawal: are they holding their withdrawn tokens? Or are they fiat-on-ramping so they can swap, provide liquidity, buy NFTs, etc.hint: find centralized exchange addresses in [chainname].core.dim_labels where label_type = 'cex' and label_subtype = 'hot_wallet'
7. [Hard] Bridging to Harmony - What happens next?
Mar 12, 2022 - -- Create a visualization showing what do users do after bridging to harmony via shuttle bridge in the last 90 days. -- Provide insights on what happens next.
Active Wallets on Terra
May 1, 2022 - Define "Active Wallets" on Terra. Based on your definition, display the active wallets by day, month, and Year-To-Date in 2022.
Flow vs Other L1s Pt (II)
Jul 16, 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.
Tinyman 1.1 Launch Pools
Jan 25, 2022 - -- How many pools have been created? -- (Tip: Look for TX_GROUP_IDs that contain both an application call to APP_ID 552635992 -- and an asset configuration transaction.) -- What are the most popular pairs to provide liquidity to by number of wallets? -- Now, let's build a table to show current total liquidity provided to each pool.
Stargate User Growth
Apr 23, 2022 - -- How many unique users are staking capital on Stargate on Ethereum each day since its inception? -- What might this suggest about the protocol's growth?
ETH Merge: Actually Good?
Sep 30, 2022 - -- Recently, ETH devs and observers have opined on Twitter regarding whether the Merge was good or bad for the Ethereum network. -- We want you to prov11e one side or the other, with the help of Flipside data. -- Demonstrate whether the Merge had positive or negative effects on the network. -- Include least three queries and visualizations in your submission.
Terra-Yet Another Acme Question
Apr 19, 2022 - -- Q184. Refer to submissions for #175 - your own, or those of others. -- Pick your favorite Terra metric or visualization and recreate your own version.
EMS-2. [Hard] Post Airdrop Behavior
Dec 9, 2021 - What percentage of claimed ENS has remained in their original wallet? What % of the total airdropped ENS has been claimed on each day? Lastly, are top ENS airdropped wallets more likely to sell or hold their ENS than the average wallet? Note: This question is somewhat similar to question 1. We suggest completing them together to save some time!