janan
Forefront Curators
Mar 30, 2022 - Forefront has token-permissioned governance and curation channels that require holders owning at least 1000 FF tokens. Create a visualization of the number of curator roles in Forefront over time. Are more curators being added over time? In your own words, how could Forefront incentivize growth in curator roles?
Anchoring LUNA
Dec 26, 2021 - Compare Anchor liquidations with LUNA price over time, discuss any potential correlations
Airdrop Stats
Dec 5, 2021 - How many wallets were eligible for the airdrop? How many addresses have claimed the airdrop? What percentage of all ENS that has been airdropped been claimed?
Untitled Board
Sep 4, 2022 - Analyze deposits and withdrawals into BendDAO over the past month. Provide metrics such as total ETH volume and unique wallets, and explain any interesting findings.
32. [Easy] LP Duration
Dec 18, 2021 - Of the users currently LP-ing, how long have they been LP-ing on THORChain? Hint: use thorchain.liquidity_actions
Anchor Deposits and Borrows by day
Dec 24, 2021 - How have the average and total borrows and deposits on Anchor changed over time? - Average of Borrows - Average of Deposits - Total of Borrows - Total of Deposits
Biggest Losers
Jan 27, 2022 - Who lost the most upside by redeeming their PEOPLE tokens instead of selling them? Build a future proof query that shows how much they would make by selling them now. Build another query that shows how much they would have made if they had sold the top (if we reach a new high, the query should identify that as the new top)
Moonbirds mint analysis
Apr 22, 2022 - Q7. What was the distribution at mint? How many wallets minted? Who minted the most? Use the Ethereum_core schema.
Unique Buyers and Sellers
May 1, 2022 - Are more people joining or leaving the Moon Birds community? Look at unique buyers and sellers over a period of time
Monthly Swap Volume
Nov 13, 2021 - Show the total monthly swap volume on Sushiswap over the past year. How has the swap volume changed over time? Do the same for Uniswap. How do the changes in swap volume over time compare in the two DEX’s?
Lexus Nexus Hunt
Nov 19, 2021 - This Dashboard will shows off the transactions I've already done.
Net Synth Amounts
May 1, 2022 - Show the net synth amounts (mints - burns) for each chain and each asset? Are there any patterns?
Anchor Deposits and Borrows
Jan 19, 2022 - Select a time period (minimum 1 month). Using visuals, compare borrow volume and deposit volume over that time period. BONUS: What relationship can you identify between borrows and deposits? What might be driving this relationship?
Voting Records
Jan 18, 2022 - Select two Terra Validators of your choice and compare their voting history (governance votes). Off-chain data can be used to support your answer, but you must also utilize Flipside data in your answer to be eligible for full payment. BONUS: Can you find any proposals where your chosen validators voted differently? Why do you think this might be the case?
Anchor Collateralization
Jan 29, 2022 - How much of the collateral provided on Anchor is bLUNA vs. bETH? How has this changed over the past 90 days?
Magic Eden vs OpenSea vs Random Earth
Mar 24, 2022 - Q39. Create a dashboard highlighting at least 3 metrics comparing marketplace performance and adoption between Magic Eden on Solana, OpenSea on Ethereum, and Random Earth on Terra since January. What has been the rate of change of these metrics since the start of the new year and are there any signs of growth of a certain marketplace or ecosystem of NFTs? Highlight the 5 most popular NFT collections for each marketplace over that timeframe in terms of sales volume. Is the turnover rate (number of transactions) for collections on Magic Eden noticeably higher than on OpenSea and Random Earth? Provide some insights on these findings.
11. ENS Claims vs Price
Dec 24, 2021 - Is ENS just for cred? Or do people actually use their ENS-addresses? Look at all addresses with an ENS registration in the last 6 months, what percent of those addresses have done transactions?
Popular Algorand Assets To Swap On DEXes
Mar 24, 2022 - Q35. Let’s use the new Algorand.Swaps table to look at what ASAs(Algorand Standard Assets) are popular to swap for in 2022. A swap is performed on a decentralized exchange(DEX) such as Tinyman. Using the swap_to_asset_id field, let's see what assets users are swapping to. Count the number of swap_to_asset_id for each asset in 2022. What are the top 10 most popular assets users have swapped to in 2022. Let’s see how popular ASAs are different on each DEX based on what pools they have. Break out the most popular ASAs to swap to by DEX and create a bar chart for each DEX showing the number of swaps for each popular asset.
Active Daily Wallets
Feb 28, 2022 - Algorand Q30: Let's look at daily active addresses on Algorand. -Compare the number of active daily wallets for the month of January 2022 to December 2021 and January 2021. What day had the most active number of wallets in January 2022? Was there an event on Algorand associated with this date? Tip: -Use the transaction participation table to look at addresses associated with transactions.
Pooly NFTs
Jun 21, 2022 - How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
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.
1. [Easy] Angel has risen
Dec 23, 2021 - How much has been donated to Angel's charity wallet so far this year? Create a visualization of your choice to show the donations either a) over time or b) by top donor.
Volume of THORChain Bifrost Activity by Asset
Oct 27, 2021 - Show the volume of non-native rune being upgraded to native RUNE, broken down by chain (ETH + BNB) HINT: use the Upgrades table
Member Roles
Mar 6, 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).
Voting Activity
Jun 20, 2022 - Q1. The Lil Nouns DAO is controlled via onchain voting by token holders. Using the ethereum database, analyze voting activity on Lil Nouns proposals. Since voting is on chain and costs gas, are smaller holders excluded from the voting process? Visualize and analyze this question, along with any other trends you find that are relevant.
Opensea Fees
Aug 1, 2022 - Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.