Josh956
Impact of Terra integration on new wallets created
Apr 19, 2022 - Q67. Show the daily number of new Thorchain wallets created in the 10 days prior to and after the integration of LUNA and UST
IL Protection Over Time
May 13, 2022 - Q88. With highly volatile prices recently, more IL protection has been paid out on THORChain. How do recent days or weeks compare to historical amounts?
Top Lido Stakers
Apr 22, 2022 - Use the ethereum_core tables to identify the top stakers using Lido. Do research on these addresses, can you identify any of these accounts using a mix of off and on-chain data?
Terra LFG
Mar 11, 2022 - Create a dashboard that updates daily to display the Luna Foundation Guard yield reserve. As well, provide at least one visualization and one metric that you think is related to the yield reserve’s growth or depletion.
Staking Yield
Mar 13, 2022 - Create a dashboard to display and compare staking yield for at least three L1s of your choice over the past 60 days. (Ethereum, Terra, Solana, Algorand, Harmony, Polygon).
Staking APY
Oct 13, 2021 - This dashboard describes the amount of rewards earned staking vs the rewards earned from airdrops.
Ecosystem Anchor
Mar 12, 2022 - Create a graph to show either a) the token price (over a time period of your choosing) OR b) a bubble chart with total value locked, for all the Terra projects that depend on Anchor to create their yield.
Stablecoin Popularity
Feb 2, 2022 - Create a visualization comparing USDC, USDT, and UST (wormhole) usage in transactions throughout the month of January. Has UST seen more adoption in the Solana ecosystem this month? How do you expect this trend to continue? Why?
125. Anchor Users
Dec 27, 2021 - Depicting the number of users over time of the Anchor protocol
USDC Transfer Volumes
Apr 11, 2022 - Compare USDC transfer volumes on Algorand, Solana, Ethereum in 2022.
Flow Comparison- What's happening?
May 1, 2023 - FLOW is a blockchain focused on NFTs, specifically sports.. but then why is it doing so poorly when compared to other major blockchains with NFT platforms? Let's explore.
HODL or Sell (that is the question)
Apr 6, 2022 - Q8. In a time period of your choice, identify accounts that have staked ETH with Lido when the price of ETH was much higher or much lower than it is now. Have they held or sold their stETH?
Yield Maximization 2
Mar 10, 2022 - Of the people who have used Sushi's lending service on ethereum, show the top 50 addresses that have realized the most profit (ROI) considering gas fees. what where they lending? for how long?
Luna Price Volatility Comparisons
Feb 26, 2022 - A common talking point on Twitter is that LUNA is resistant to broader market downturns, when compared to other leading cryptocurrencies. Assess this claim, using data drawn from a time period of your choosing. In making your argument, acknowledge the unknowns and address potential criticisms of your chosen position. Additionally, clearly define your definition of stability or resistance to broader market pressures, as well as your benchmarks for comparison (i.e. what are you comparing LUNA to, and how does it perform vs. its peers/competitors?)
Memes Kum & Go- Or do they?
May 13, 2023 - Are memes temporary, or here to stay? Read on to find out about the potential risks vs. rewards in the meme token market
Who's That Going Across My Bridge (Redux)
Apr 18, 2022 - Q186. Pick one bridge from Terra and a destination of your choice. (e.g. Shuttle bridge Terra <-> Ethereum or Wormhole Terra <-> Solana). Assess the daily and cumulative amount of UST that goes through that bridge, both inflow and outflow. How many users are using the bridge on a daily basis? How many transactions take place on a daily basis?
8. [Hard] Borrow and Supply
Aug 31, 2021 - Exploring the variable and stable rates of various assets
Whale Transaction Volume
Feb 9, 2022 - Show the daily swap volume of wallets with over 1 million Sushi tokens. How has this volume changed over time? How has the number of ‘whales’ changed over time?
Song That Own Itself(STOI) Airdrop #3
Apr 4, 2022 - Q44. Let's look at how many wallets have claimed the STOI Song #3 “Million Scars” Airdrop. How many users have claimed the airdrop? Chart the STOI Song #3 airdrop token distribution by day.
Aave Flashloans- How do users interact with stables vs. nonstables?
Feb 25, 2023 - This dashboard will explore how users interact with stablecoins vs. volatile tokens when utilizing flashloans on Aave. Are stablecoins or volatile tokens used more frequently? How does this impact premiums?
19. Sushi Wen Moon?
Dec 26, 2021 - Explaining a DEX, and figuring out which one you should invest in- If any
Member Roles
Mar 10, 2022 - Question 1: A member is a user who has 35,000 or more $BANK tokens in their wallet (not counting members with Guest passes). A whale is a user who has over 150,000 $BANK tokens in their wallet. Show the number of members and whales on Bankless DAO over time (not counting Guest Passes for members).
Uniswap - 26. Gas guzzler
May 3, 2022 - How much of the total daily Ethereum gas fees are related to Uniswap usage since the start of 2022?
Validator Voting vs. Investor Inclinations
Apr 25, 2022 - Analyze the last 5 governance proposals. Out of the total Luna that voted in favor, how many % are from validators vs. retail investors for each proposal and on average?
Tracer Usage
Mar 1, 2022 - How many people (addresses) have voting rights in tracer? How much of that has been deposited in major decentralized exchanges(DEX)? what is the breakdown per DEX
The Path to Decentralization
Jan 31, 2023 - Create a stylish, refined dashboard that enables viewers to assess both individual validators on NEAR, and validation as a whole (bonus points if you find a way to enable parameters or dropdowns that display different validators).
Forefront Holder Distribution
Mar 30, 2022 - Forefront has ownership tiers based on the number of tokens that you hold. These tiers provide access to different tools and community features. Create a histogram of token ownership amounts to understand the percentage of holders that buy tokens to provide access to these tiers. Where are token amounts most commonly distributed? In your opinion, does this token model make more or less sense than say gated NFT ownership? Why?
Guide to NFT creation
Aug 25, 2021 - A step by step guide on how to create your first NFT! Link to my flipside-inspired Opensea NFT: https://opensea.io/assets/matic/0x2953399124f0cbb46d2cbacd8a89cf0599974963/21244763551107703025699048789139479928214961482923793986279601155175402700801/
Optimistic Bears
Aug 7, 2022 - Q9. Analyze Optimism during the month of July as markets were get turbulent, showing whatever metrics you care to unearth The
Algorand Donations
Mar 10, 2022 - Algorand is a carbon negative blockchain and the carbon operations produce is often offset by tree planting. Gilbert the Goanna(https://algoanna001.com/) is Goanna #001 from the Al Goanna NFT collection and an organization that has planted over 40,000 trees. Recently they reached the benchmark of 200K ALGOs in donations for tree planting(https://twitter.com/Gilbertgoanna01/status/1498135551588769798).
$RUNE Upgrades
Jun 27, 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. Have you seen an uptick in the amount of $RUNE being upgraded recently? Look at both the $RUNE volume + number of wallets. What is the trend over time + also how much is ETH vs BNB?
Flash Bounty: Miners Moving?
Sep 15, 2022 - How have miners reacted to the fast-approaching merge? Have they stopped mining in recent weeks? Show evidence of miners either stopping work or continuing to mine.
2. [Easy] Aave Liquidity Concentration
Aug 24, 2021 - After studying transaction patterns surrounding the liquidity of AAVE, I found it may be more insightful to investigate the largest contributions to the overall liquidity of the network.
Validator Pageant
Mar 13, 2022 - Select one validator outside the top 10 and make a case for why newcomers to Terra should delegate to that validator. Define any metric of your choosing that marks a good validator (airdrops, voting, community benefits, uptime); assess the average for the full set of ~130 validators (i.e. if you pick airdrops, assess how many of them offer an airdrop); and assess how your chosen validator performs based on that metric.
Flow Topshot
Jul 26, 2022 - Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume. This week, focus specifically on the play_type column in the flow.core.dim_topshot_metadata table. What play_types do users hold most, and how much volume in sales do these play_types generate? Include any other transactional metrics you can think of.