banbannard
Anchor Dominance
Feb 16, 2022 - What is the “Anchor dominance” for wallets on Terra? For active Terra wallets*, how much of their total asset value is held in Anchor at the time of analysis?
New Users on Algorand vs. Ethereum vs. Solana vs. Terra
May 4, 2022 - Algorand, Ethereum, Solana and Terra What trends do you see?
Lido Rocket Pool Comparison
Apr 25, 2022 - Use the ethereum_core tables to compare deposits to Lido and Rocket Pool
Top Pool Analytics
Jan 10, 2022 - For the top 10 Sushi liquidity pairs (by liquidity) show the following: liquidity, 24 hour volume, 7 day volume, 24 hour fees, 7 day fees, and one year fees as a percentage.
LP Size Distribution
May 1, 2022 - What is the current distribution of LP size for each pool? You will have to use both 'add_liquidity' and 'remove_liquidity' to determine which LPs are stil current.
Limit Swap Orders
Feb 28, 2022 - How popular is the limit order functionality in sushiswap? How many users have used it so far by placing limit orders?
Friktion Bitcoin Volt
Mar 19, 2022 - Provide some insight on how this type of strategy works. For users that have deposited BTC into the Friktion BTC Covered Call Volt since January 28th (Epoch 6), what other DeFi protocols have those wallets interacted with? How many unique wallets have deposited into this BTC Volt and list the top 10 wallets in terms of amount deposited since Epoch 6. Has the Volt become more popular over time for "whales" or the average Solana wallet?
LP-er Retention
Apr 24, 2022 - Take a look at thorchain addresses that have ever added liquidity. Group them by the month of their first date of adding liquidity. What % are still providing liquidity in the THORChain ecosystem? How does it look if you filter those that provided at least $10,000 in liquidity?
Wallets Investigation - Transactions, Interactions and Transfers
Aug 10, 2022 - [DAILY UPDATED] This dashboard tracks Metaplex wallets' transactions, interactions and transfers
GMT Airdrop
Mar 20, 2022 - Create a graphic showing the wallets that received the GMT airdrop and highlight the top recipients of the airdrop. What have recipients done with the airdrop? Are these "trailblazers" holding their airdrop or are they selling? Have the top recipients been more or less likely to hold onto their tokens?
Swap Sizes
Feb 5, 2022 - Show the daily average swap size over time for the 10 largest liquidity pools (in terms of value locked). How has this swap size changed over time? Why might this be?
Have staking rewards impacted the amount of $RUNE bonded or in LPs?
May 29, 2022 - Before Staking 2.0, users participated in single-sided staking that rewarded LP-ers via emissions. Now, $THOR stakers receive a liquid token of their staked allocation, in addition to a percentage of fees from swaps. Chart an analysis on Staking 2.0’s effect on the pendulum incentive. What’s been the impact on the flow of funds into staking from LPs or bonded $RUNE, (have users been swapping from $RUNE to $THOR and staking?), and how that might be affecting the ratio of capital in LPs vs in bonds.
Fun Facts of Tensor! 🎉
Jul 13, 2023 - All Tensor data in this dashboard is as of July 16th, 2023. If you find this dashboard helpful, please leave a ❤️ to show your support!
Transaction Failure
Mar 20, 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.
⚡ Streaming Swaps
Aug 11, 2023 - An Overview of Streaming Swaps on THORChain. If you find this dashboard helpful, please leave a ❤️ to show your support!
Solana TPS
Feb 22, 2022 - One of Solana's main features is its speed compared to other blockchains. Blockchain performance is usually measured in Transactions per Second (TPS). Measure the TPS of Solana in February (non votes) and 'Successful TPS' per day and create a chart showing how TPS has fluctuated during that time period.
DEX Performance Dashboard
Nov 5, 2023 - This dashboard helps in the understanding of the DEX landscape, allowing for more informed decision-making and a deeper understanding of decentralised finance trends and opportunities.
Flipside GodMode NFT
Jun 8, 2022 - This dashboard will go through Ethereum profile of those who minted during the first hour after GodMode's launch
New NFT Mints
May 16, 2022 - How many total new NFT projects have appeared on Magic Eden per day since the start of the new year (as in new projects that have minted that day)? Compare that to the total number of new NFT projects that were minted/created on Ethereum? Create a dashboard comparing the growth rates of the number of new NFT projects on Solana and Ethereum and understanding the amount of sales activity on ""new projects"" for each chain.
Bubblegoose Ballers Mint
Jun 15, 2022 - How many unique wallets minted a Bubblegoose Baller NFT and how many NFTs did these wallets purchase on average? How many NFTs were purchased with ETH using Crossmint? Identify any notable trends in minting activity and secondary market sales in the days following the launch. Which group(s) was most likely to "diamond fin" their NFTs?
Orca User Growth
May 23, 2022 - Orca, a popular decentralized exchange on Solana seems to have been gaining significant adoptions over the last few months, especially compared to other exchanges. Create a visualization showing Orca adoption in terms of swap volume and number of unique wallets compared to at least two other popular Solana exchanges and Uniswap on Ethereum? What can explain this increase in adoption? Provide some insights on this trend and the types of users using Orca (hint look into which popular app on Solana is using Orca).
DAI Volume (May 13)
May 14, 2022 - How does the daily volume of DAI transactions compare to other stablecoins? What is DAI most used for?
Content Bounty: Terra -> Osmosis
May 23, 2022 - Are Terra projects interested in migrating over to Osmosis? What is most important to Terra developers when looking for a chain to migrate to and why might Osmosis be a good choice?