![Solana-New User Activity Solana-New User Activity](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Solana-New User Activity
Feb 12, 2022 - For new users, what is the most common first program that users interact with on Solana (as in what is the most popular first transaction for a new wallet)? What is the average number of transactions a "new wallet" makes in their first 24 hours? (New wallet defined when a wallet makes its first transaction). Do you think this is more or less than other chains? Note: Limit this analysis to the month of February.
EVM - 7. Derivative Daze
Feb 6, 2023 - Derivatives DEX Gains Network recently crossed a major milestone, with more than $1.5 million in trading volume on Arbitrum, fueling further interest in derivatives trading on the platform. Building on this Dune dashboard, create a dashboard that shows the following data for Gains Network and any other derivatives trading markets you can find: Total volume Total traders Total trade fees Trade volume over the past day/month/three months Traders over the past day/month/three months
Liquid Staking ETH Platforms Analysis
Sep 1, 2022 - -- Consider all possible liquid staking ETH platforms. Then, find out the following: -- How much ETH was staked over time? -- How many unique depositors are there? -- How likely are depositors to use multiple platforms vs using a single platform? -- Are depositors Dollar cost averaging their ETH into the platforms? -- What is the avg/median/max/min/distribution of ETH deposits? -- Compare all the metrics above between the various ETH staking methods/platforms
![Algo-69.Borrowing On Folks Finance Algo-69.Borrowing On Folks Finance](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Algo-69.Borrowing On Folks Finance
May 20, 2022 - Q69. Let’s look at borrows on Folks.Finance a borrowing and lending protocol built on Algorand. We want to get an understanding of how what assets users most want to borrow, how often borrows are happening, and the average collateral ratio between the collateral offered and the asset that is borrows. Ultimately, we want to get a better understanding of what people are borrowing, and what the collateral ration looks like.
![Algo-76.Algorand NFTs Algo-76.Algorand NFTs](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Algo-76.Algorand NFTs
May 26, 2022 - Q76. Let’s look at the Algorand NFT scene from a high level How many wallets(distinct) currently hold an NFT? How many wallets(distinct) have created an NFT?(Tip: Look at the creator Address on the asset) Create a distribution of the number of NFTs held per wallet for wallets that hold at least 1 NFT. What’s the average amount of ALGOs NFT holders have, is this more or less than non NFT holders? How many active wallets/what percent of wallets hold at least 1 NFT? Do we see new wallets joining algorand and buying NFTs or is it mostly older wallets buying/holding NFTs? How many total, non-closed NFTs are on the algorand network? Show their creation over time using asset created_at. How many NFTs use the ARC3 vs ARC69 standard? Make sure to write an analysis based on each of the findings above! Note any other interesting findings about wallets that hold NFTs! Tip: All NFTs have a supply of 1 and 0 decimal places For NFTs configured to the arc69 stanard, look at asset_configuration transactions such as 6Z5R47GSIMQC4JDCTRAPLPC5BTNCC5K5DJ2QKSACW4KV5RZFZDQQ and decode the note using try_base64_decode_string(tx_message:txn:note::string). Tou will find in the note the asset has been configured to the arc69 community standard: https://github.com/algokittens/arc69. For assets configured to the arc3 standard look for transactions who’s asset url ends with #arc3 https://github.com/algorandfoundation/ARCs/blob/main/ARCs/arc-0003.md
![UST-LUNA Highway UST-LUNA Highway](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
UST-LUNA Highway
Apr 19, 2022 - -- UST-LUNA Highway -- Q182. Over a time period of your choosing, display the following: -- -daily minted UST and burned LUNA -- daily burned UST and minted LUNA -- What are some trends you can observe for each of the charts above?
NEAR - 6. NEAR Foundation Transparency Report: Q3, 2022
Jan 10, 2023 - Each quarter, the NEAR Foundation publishes data to help the NEAR community understand the health of the ecosystem as part of their NEAR Foundation Transparency Report. We want your help in making the NEAR ecosystem even more transparent. How can you improve on the existing Transparency Report? Explain which metrics should be taken into consideration and why. Then, analyze those metrics over the last several weeks and draw your own conclusions on the health of the NEAR ecosystem.
Wallet Balances & Ecosystem Growth
Oct 26, 2022 - -- With the launch of Flipside's new Balances table, let's take a look at how the story of Osmosis can be told through wallet balances. -- Provide insights into following metrics: -- How has the ratio of liquid to staked OSMO changed overtime? -- Are the top 100 OSMO holders the same now as they were at the start of the year? -- What is the current average OSMO per wallet? How has that value changed over time? Plot average OSMO/wallet against user growth. -- Do wallets normally hold a majority of OSMO, or another token? How has this changed over time? -- BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
EVM - 8. Up The Mountain
Feb 16, 2023 - An Avalanche has been building up steam as of late — the price of AVAX rose by nearly 100% in the month of January and BTC hodlers have been moving holdings to the Avalanche chain. What’s been fueling this growth over the past month — and what does the future hold for Avalanche? Will this growth continue into the new year? Or will growth stagnate as 2023 continues to progress?
![Osmo-11.wETH Deposit Rate Osmo-11.wETH Deposit Rate](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Osmo-11.wETH Deposit Rate
Jun 13, 2022 - -- Q11. Calculate the deposit rate of wETH over time on Osmosis. -- How does this compare to SushiSwap and Thorchain now? -- How does the wETH deposit rate compare to when wETH was a relatively new asset (or the protocol was relatively new)? -- Is Osmosis growing at a faster rate than Thorchain and Sushiswap? -- Hint: There are two types of wETH on Osmosis, wETH from the Gravity Bridge (gwETH) and WETH from the Axelier Bridge (axlWETH).
BendDAO Metrics
Sep 8, 2022 - -- Q1. 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
![Aave - 3. AAVE positions in Euro stablecoins around July 13th. Aave - 3. AAVE positions in Euro stablecoins around July 13th.](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Aave - 3. AAVE positions in Euro stablecoins around July 13th.
Jul 29, 2022 - -- Aave - 3. AAVE positions in Euro stablecoins around July 13th. -- On July 13th, for the first time in 20 years the Euro reached 1:1 parity with the U.S. Dollar. -- Show daily or hourly positions (supply and borrow) of Euro stablecoins on AAVE before and after July 13th. -- If appropriate, you may set your data to refresh daily.
![Aave - 2. Borrow Durations Aave - 2. Borrow Durations](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Aave - 2. Borrow Durations
Jul 29, 2022 - -- How long on average and median do wallets borrow on AAVE? -- Measure this duration across at least three different tokens. -- Compare the borrow duration on AAVE with at least one other lending platform like Compound.
ETH Merge: Selling Event?
Sep 30, 2022 - -- Was the Merge a selling event? Why or why not? -- Were miners the source of sell pressure? Show any wallets miners have transferred ETH into, -- along with any other visualizations you think will add to your analysis.
![curve curve](https://res.cloudinary.com/dsr37ut2z/image/upload/assets/project-icons/curve.png)
Node Performance
Oct 4, 2022 - -- What is the performance of pooled validators re: slashes and slash points v. classic validator ops? -- (possibly implies newer people entering the playing field?)
![Terra-169.Transaction Failure - Reason Terra-169.Transaction Failure - Reason](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Terra-169.Transaction Failure - Reason
Mar 21, 2022 - Establish the failed transaction rate for Terra over a time period of your choosing. Is this analysis correct? Additionally, make a case for what is causing the failure transaction rate you assess, and provide recommendations to mitigate it.
Toke-1.Top TOKE Holders
Jun 23, 2022 - -- Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
![Uniswap V3 Fee Volatility Uniswap V3 Fee Volatility](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Uniswap V3 Fee Volatility
Aug 14, 2021 - What has the day over day change in fee generation been for Uniswap V3 over the past 1 month?
NEAR - 11. Insight of the Week - NFT Creators & Honorary Bored Ape
Feb 5, 2023 - The NEAR Foundation is running an "Insight of the Week" series. Keeping your analysis short and focused on excellent-quality visualization - provide the most fascinating or illuminating fact or insight that you can about the NEAR ecosystem, or any of the projects building on NEAR, over the past 7 to 14 days. When you tweet about the insight, don't just describe it - do your best to explain "why" what you chose is unusual, valuable, or noteworthy.
![Hot-12.How Many Times was Hop used? Hot-12.How Many Times was Hop used?](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Hot-12.How Many Times was Hop used?
Apr 23, 2022 - -- Q12. How many times was the hop protocol used in 2022 in order to bridge funds to layer2? -- Use Ethereum_core schema. -- Hints: -- contract address for ethereum bridge for Matic : 0x22B1Cbb8D98a01a3B71D034BB899775A76Eb1cc2 -- MATIC contract address on ethereum: 0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0 -- Event name that sends token from user's wallet to the bridge is 'Transfer' -- Event name that sends token from the bridge to the layer 2 wallet is 'TransferSentToL2'
11.Solana-Solend SOL Lending/Borrowing
Feb 15, 2022 - Since February 5th, How much SOL has been supplied by lenders? How much SOL has been borrowed? Are there any noticeable trends in the net flows during this time? Provide insights and a visualization on the day-to-day trends of SOL and lending vs borrowing. How many SOL withdrawals and repayments happened during that timeframe on Solend? (Hint do small txs on Solend to identify the accounts you need)
Solana-79.Tracking GMT into StepN
May 26, 2022 - Q79. StepN has remained the fastest growing Web3 app in the world, currently picking up tremendous hype for its move-to-earn concept. Track the flow of GMT into the app. How are users acquiring GMT? Is by swapping using a DEX like Jupiter, or do flows seem to be coming from centralized exchanges? How often is GST (the token earned in the game) swapped for GMT? What other actions are wallets that are sending GMT into the app doing? Additionally, where do SOL inflows into the app seem to be coming from? Does it seem like most StepN users were already active within the Solana ecosystem, or is there a lot of activity that originated from inflows from centralized exchanges? Essentially, is StepN onboarding users into Solana? Create visualizations showing these inflows of GMT and SOL into the StepN app and if the announcement of Coinbase adding StepN to their list of tokens sparked additional interest from sources outside of the Solana ecosystem."
WETH/THOR Pool
Sep 13, 2022 - -- Q111. ThorSwap just recently partnered with Sushiswap to create an Onsen farm for ETH-THOR LP providers to stake their liquidity to earn extra rewards. -- Previously ThorSwap offered their own contract for the same purpose but this switch allows for higher rewards as well as lower slippage for the users. -- Show how users reacted to this change: -- - How many funds has been moved from the old contract to the new one? How much is still left in the old one? -- - How many unique wallets did already move their liquidity over? How many still have to switch?
![$RUNE Distribution $RUNE Distribution](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
$RUNE Distribution
Apr 23, 2022 - -- Calculate the distribution of $RUNE holdings by address. -- Include RUNE that is in liquidity pools. (e.g. if I have 100 $RUNE in my wallet and LP 50, I should still -- be considered to be holding 100).
Osmosis - 2022 Stablecoin of choice ?
Jan 26, 2023 - Submit a deep dive dashboard that explores a specific topic in detail using Osmosis data. Open Analytics (OA) bounties are bounties without specific prompts, just a direction and a reward. It’s your chance to have your brain follow your heart — got a spark of interest, or a loose thread, or a weirdly-specific question gnawing at the back of your mind? Follow it as far as you can!
EVM - 4. The “Flippening” Comparison
Jan 19, 2023 - -- It finally happened. The great Flip everyone’s been waiting for — Optimism and Arbitrum have officially surpassed Ethereum in combined transaction volume. -- (What, you were expecting some other flippening?) -- Use this historic event to compare and contrast these two major L2 chains. -- Include metrics such as total and average transaction volume, average transaction size, active users, new users added, and anything else you find relevant to this comparison.
NEAR Tournament Round 3: The Financial District
Aug 7, 2022 - Provide and explore key health metrics, as well as detailed data on at least 1 key project.
NEAR Tournament Round 2: Local Government
Aug 2, 2022 - -- NEAR Tournament Round 2: Local Government -- Every city has its governors, and the City of NEAR is no different. -- Assess the state of governance on NEAR, with an eye toward assessing its decentralization.
Aave - 8. How does BTC funding affect rates?
Aug 11, 2022 - Create a dashboard that shows: Supply and lending rates for at least five tokens in Aave V2, and Total amount of Wrapped BTC supplied over time. Provide analysis on the volatility of rates. Measure the correlation between USDC borrow rates and total wBTC
![Bot Swappers Bot Swappers](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Bot Swappers
Apr 24, 2022 - -- Define bot swappers. -- How does the behaviour of bots differ from average swappers? -- For instance in terms of number of swaps, or in terms of distribution of swaps over a day. -- What percentage of swaps were executed by bots in the past 30 days? -- What pools and what pairs were most popular among bot swappers in the past 30 days.
NEAR - 7. Weekly Report - Redux
Jan 14, 2023 - Each week, the NEAR Foundation publishes data to help the NEAR community understand the ecosystem's health as part of their Transparency Report. We want your help in making the NEAR ecosystem even more transparent. How can you improve on the existing NEAR Transparency report? Explain which metrics should be taken into consideration and why. Then, analyze those metrics over the last several weeks and draw your own conclusions on the health of the NEAR ecosystem. Grand prize-winning dashboards will go above and beyond the existing report, allowing readers to get the best possible snapshot of NEAR, its users, and its ecosystem.
![Solana-Foundation-2.Tracking USDC & USDT on Solana Solana-Foundation-2.Tracking USDC & USDT on Solana](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Solana-Foundation-2.Tracking USDC & USDT on Solana
Jun 17, 2022 - -- Q2. What's the current market share for USDC and USDT on Solana relative to other stablecoins in the ecosystem -- (look into USDC, USDT, UXD, USDH, PAI, NIRV, UST, DAI, FRAX)? -- Create a visualization showing the amount of transaction volume for USDC vs. USDT etc. do display popularity within Solana. -- For USDC and USDT specifically, breakdown the transaction activity by contract and exchange flows -- (i.e. which dapps and addresses hold the majority of USDC and USDT and what do cumulative flows to and from exchanges look like over time)? -- Reference these older dashboards by ltirrell and adriaparcerisas as examples: -- https://app.flipsidecrypto.com/dashboard/stablecoin-popularity-UOlg-v -- https://app.flipsidecrypto.com/dashboard/solana-stables-EJCpX0
![Algo-38.ASA Dex Degens Algo-38.ASA Dex Degens](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Algo-38.ASA Dex Degens
Mar 22, 2022 - Q38. Let's look at DEX wallet behavior with the algorand.swaps table to get an idea of how many swaps wallets are being conducted and see how many ASAs wallets are trading. Chart the distribution of the number of swaps wallets have conducted in 2022(Count the number of swaps a wallet has performed create a distribution of these wallets). Chart the distribution of the number of ASAs a wallet has swapped for (Count the number of assets a wallet swapped for and create a distribution of the number of assets per wallet).
![Tracking top Solana NFT Collections Tracking top Solana NFT Collections](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Tracking top Solana NFT Collections
Apr 24, 2022 - -- Track sales volume and average sales price across marketplaces for the following NFT collections: -- Solana Monkey Business (hint you will need to use the SMB marketplace programId) -- -DeGods -Degen Ape Academy -Shadowy Super Coders -Aurory -Stoned Ape Crew -Cets on Creck -Taiyo Robotics -SolGods -Portals -Boryoku Dragonz -Catalina Whale Mixer -The Famous Fox Federation -Galactic Geckos -Thugbirdz -Mindfolk -Solsteads -Astrals -Pesky Penguins -Meerkat Millionaires Country Club -- How much wallet crossover is there between some of the top collections? -- What is the average time between buying and selling for each each collection? -- How likely are wallets to buy back into a collection after selling?
Solana-81.Smart Money NFT Traders
Jun 6, 2022 - -- Q81. Which wallets have made the most SOL off NFT mints and NFT trades since the start of the new year? -- What types of actions have led to being a profitable NFT trader on SOL? -- Is there a pattern behind their NFT trading strategy and can you define some of these traders as "smart money"? -- Do you think you need to be a "whale" to do well trading SOL NFTs, or can anyone have success in this market?
![Algo-Defly Token Launch Algo-Defly Token Launch](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Algo-Defly Token Launch
Feb 11, 2022 - Defly(https://defly.blockshake.io/) is a mobile wallet and swapping platform that is currently being developed on the network. They recently had there token presale and liquidity pools have been provided for swaps on Tinyman. Chart the number of Defly Swaps by day on Tinyman What was the biggest swap for Defly on Tinyman? Chart the distribution of Defly among in wallets. Tips: -Defly asset ID is 470842789 Here is a Defly Tinyman swap example: https://algoexplorer.io/tx/group/7fT9AYyUiLqVZGX8sZyRlYrQC8W8VoPysU6Kz%2FasrYs%3D Tinyman Defly Contract Address: XLNMBK3GMC4YEF562DMEOZEYTNDWJLQRN2GFQ3MGLVNIJTOTVGVD75DVKM
![143. Liquidity Space Voyage / Mini-Terra Tutorial 143. Liquidity Space Voyage / Mini-Terra Tutorial](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
143. Liquidity Space Voyage / Mini-Terra Tutorial
Jan 30, 2022 - Since the launch of Astroport, many have moved their liquidity from Terraswap pools to Astroport pools. Plot the total value of TVL that might have moved from Terraswap to Astroport for the LUNA/bLUNA pair by showing the total withdrawals from Terraswap and deposits to Astroport since Astroport launched.
![Flow-9.Crossover with NBA Top Shot Flow-9.Crossover with NBA Top Shot](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Flow-9.Crossover with NBA Top Shot
Jun 12, 2022 - -- Q9. Which Flow NFT projects appear to have the most crossover of buyers with NBA Top Shot addresses? -- Is NBA Top Shot an effective onboarding tool in getting users interested into other Flow collections? -- Does this crossover tend to come from Top Shot "whales", or does the crossover come from average to smaller players? -- How can Flow projects better attract liquidity from Top Shot players?
![Lil-Nouns-2.Secondary Sales Activity Lil-Nouns-2.Secondary Sales Activity](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Lil-Nouns-2.Secondary Sales Activity
Jun 17, 2022 - -- Q2. How many Lil Nouns have been sold on a secondary exchange within 24 hours of being minted? -- Are there any common traits among these Lil Nouns? Which Lil Noun’s have the biggest difference (positive or negative) -- between their mint price and secondary sale price? Visualize and analyze your findings. -- Hint: This query looks at Nouns traits. You will need to modify it for Lil Nouns!
![Flow-4. Flow Speed Flow-4. Flow Speed](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto,w_300/assets/backgrounds/dashboard-bg.png)
Flow-4. Flow Speed
Jun 4, 2022 - -- Q4. One of Flow's main features is its speed compared to other blockchains. -- Blockchain performance can be measured as Transactions per minute. -- Measure the transactions per minute of Flow since May 9th and 'Successful transactions per minute' and create a chart showing how that metric -- has fluctuated during that time period. -- What types of events have raised or decreased the blockchain's performance over that time period? -- Are there bursts of transaction volume or interest on the chain? Compare Flow's speed to at least two other blockchains.
Solana-Wormhole Hack
Feb 8, 2022 - This week a hacker managed to exploit the Wormhole contract and steal 120K wETH. Jump Crypto was able to restore the liquidity after a few hours, but for a brief period on 2/2 this created imbalances and a difficult situation since the stolen wETH backed all ETH on Solana. Create a dashboard showing the transaction volume change in the 2 most popular ETH pools on Solana compared to the previous week's volume. Can you visualize panic in the market? How long did it take for activity in that pool to stabilize?