janan
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?
Untitled Board
Nov 16, 2022 - Earlier this year, Optimism offered an airdrop to users. Let’s examine the airdrop after a few months. How many users claimed optimism airdrop? How much of total airdrop was claimed? How many wallets are still holding tokens from airdrop? How much of users delegated their OPs? Feel free to provide any information that you think is related to token price.
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.
Mirror Assets Transaction Volume
Nov 21, 2021 - Analyze the aggregate and per asset transaction volume in the last 90 days. Note any trends in the data.
Fuse Pool USDC Allocation
May 21, 2022 - How are the tokens in the DAI Vault being allocated into the various Fuse Pools?
Flow vs Other L1s
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.
Avalanche BTC.b Bridgooors
Mar 15, 2023 - Let's look at wallets that have used the BTC.b bridge on Avalanche and what they are doing with it. Look at what chains users are bridging the BTC.b to with Layer0. Additionally, some other items to look at: What contracts and protocols are they using on Avalanche? How many transactions have they made on Avalanche? Are they swapping for other assets on Avalanche?
Secondary NFT Market Mega Dashboard
Oct 5, 2022 - Quix is Optimism's popular NFT marketplace, let's jump in and see the metrics about this marketplace, find out the most expensive collection of this platform, and illustrate the timing of the sales happening.