kipto
Katana Covered Call Vault Popularity
Mar 27, 2022 - Q43. Katana currently has 5 covered call vaults with a TVL of over $1 million (SOL, mSOL, BTC, ETH, wLUNA). What has been the rate of change of deposits and withdrawals for each of these vaults since the beginning of February? What vaults seem to be gaining in popularity the most? What percentage of wallets that have deposited into a covered call vault have also deposited into another vault? Which vaults seem to have the most crossover?
Gard.Money Algorand’s First Algorithmic Stablecoin
Apr 21, 2022 - Q55. GARD is the world's first algorithmic stablecoin on Algorand's blockchain. Let’s look at the collateral debt positions(CDP) users are taking on. This is where users put ALGOs up as collateral and in turn get GARD(Asset ID 684649988) in return. Gard is a stable coin pegged to $1 in value.
Bridge Transactions (Across)
Jun 22, 2022 - Q1. Analyze bridge transactions via the Across bridge over the last two weeks. What assets are users bridging from Ethereum, and to what chains?
The Octorand Universe
May 26, 2022 - Q81. Octorand is a virtual world of opportunity built on top of the Algorand blockchain. Octo Primes are the only form of life existing in the world of Octorand. You can collect these Octo Primes, transform them to increase their value and trade them through the inbuilt marketplace.
Top Lido Stakers
Apr 20, 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?
Unique Users (Osmosis)
Jun 6, 2022 - Q7. How many unique wallets are active on Osmosis per day? How has this changed over time? What has been the largest event that has brought the most wallet activity to Osmosis?
Gas as a proxy of activity
Jun 8, 2022 - Q89. How much did sushi users pay for gas in 2022? Is there a correlation with the price of ETH? Can you comment on the spikes in the chart?
New Addresses in Polygon
May 31, 2022 - Q2. Draw a chart showing the number of new addresses every day on polygon(matic) network. New addressses are unique addresses that appeared for the first time in a transaction of Matic.
RocketPool: User Profile - LIDO vs. RocketPool
Apr 24, 2022 - Q19. Lido is another application that also offers ETH2 liquid staking. Compare and contrast activity on RocketPool vs. Lido over the past three months. Is one growing more quickly than the other? Can we conclude if one of these applications is better for users than the other? Are there different types of users using RocketPool compared to Lido, or are the user profiles similar? Visualize and explain your conclusions.
Token Activity
May 7, 2022 - Q3. What do people do with their PSP tokens? Once people acquire PSP tokens what do they do with them? Do they stake them? How long do they hold them for? Show the journey of PSP tokens.
Tokenflow Trailblazers
Mar 22, 2022 - Q1. Dive into the Tokenflow data and tell us what you find.
Sushi Price vs Volume last 30 days
Feb 14, 2022 - By looking at the price of the Sushi token and volume on Sushiswap over the past 30 days. We try to answer does the price of the Sushi token seem to impact volume on Sushiswap? Sushi token prices had a steady decline in early January. The hourly transaction counts (moving average of 24h) to and from Sushiswap laggingly show also decreasing tendency. We will look at the token price, and transaction counts from and to Sushiswap filtering the Ethereum Mainnet udm_event data to have Sushiswap either in the from_label or to_label. We see that some protocols did make huge transactions however overall the transaction volume laggingly followed the price decline both having calmed down for now.
Tokens moving in and out from Ethereum/Solana/Polygon
May 10, 2022 - Yesterday was… Well let’s not talk about yesterday, let’s analyze it.
stETH Most Common Pools
Apr 20, 2022 - Use the ethereum_core tables to determine the pools most commonly used to swap in and out of stETH. What are the most common pairs? Which pools are most often used?
Polygon vs Harmony
May 31, 2022 - Q1. Draw a chart comparing Polygon with Harmony on the following metrics: 1. Average tx_fee 2. Average number of transactions per hour.
Friktion Bitcoin Volt
Mar 22, 2022 - Q41. Friktion is a new DeFi portfolio management project that helps users maximize profits by generating yield. The Friktion BTC Covered Call Volt is one such yield opportunity for interested participants who want to generate income while holding BTC.
Net $THOR Staked
May 23, 2022 - Q91. Since vTHOR and THOR Staking 2.0 was released in May, we’re interested in finding out more about how the community has embraced the staking rewards.
Metaplex Bot Free
May 7, 2022 - Q72. Solana experienced another network downtime due to intense botting of a NFT mint. Solana has been working on a creative solution to deal with this botting issue called Quic, but Metaplex, the infrastructure protocol for Solana NFTs decided to implement a ""bot tax"" to help alleviate this issue. The summary is that bots will now have to pay a .01 SOL penalty for every transaction. Since this was implemented on April 29th, how many bot transactions and thus how much SOL has Metaplex captured? Display when these transactions occurred over time and if there were certain wallets that have been discovered to be guilty of botting the network.
Let it burn!
Apr 27, 2022 - Find the week that the most volume of Luna burning happened. What caused this event? Show some effects of this burning had on Terra ecosystem by your opinion.
New to the Menu
Apr 13, 2022 - Q64. What are the 10 most recent assets (coins) supported by sushi?
Genopets Staking
Jun 1, 2022 - Q78. Genopets is a move-to-earn game reminiscent of Pokemon Go on Solana.
Forefront Curators
Apr 16, 2022 - Q2. 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?
Stablecoin Pegs
May 13, 2022 - How have USD-pegged stablecoins across different chains, and with different backing mechanisms, fared through the last 5 days?
DAI on the Market (May 13)
May 15, 2022 - Q3. Analyze large shifts in the amount of DAI on the market over the past year. What might have caused these shifts? Are these events related to Maker directly? Are they related to the crypto ecosystem as a whole? Provide metrics to support your analysis.
Wildlife Warriors NFT Drop
Jun 23, 2022 - Q105. Wildlife Warriors was a project established by Steve Irwin in 2002 as a way to include and involve other caring people to support the protection of injured, threatened or endangered wildlife. They recently had an NFT drop(https://twitter.com/wildwarriors) on Algorand to support the project. Lets look at the wallets that own one of these NFTs.
SOL Staker Activity
Apr 11, 2022 - Q52. How frequently are SOL stakers interacting with DeFi protocols over the past month? Which protocols are they interacting most with? Which actions are they mostly taking? Staking? Farming? Swapping? Mining?
IL Protection Over Time
May 17, 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?
![[Solana NFT Project Feature] Catalina Whales](https://res.cloudinary.com/dsr37ut2z/image/url2png/c_crop,g_north_west,h_600,q_auto,w_1200,x_0,y_0/v1675667383/https://next.flipsidecrypto.xyz/previews/dashboards/1db8c4d4-e66e-4373-b1ce-23c4ff29798e%3Ftype%3Dcover "[Solana NFT Project Feature] Catalina Whales")
[Solana NFT Project Feature] Catalina Whales
Jul 20, 2022 - Choose a NFT project from the following list and create a dashboard with the new Flipside dashboard layout that can refresh once a day highlighting at least 4 metrics of your choosing that helps show the "health" of the project. Note any noticeable trends or current events for the project. Highlight how liquidity is flowing in and out of the project and what types of buyers and sellers are interacting with the project.
Fuse Pool DAI Allocation
Mar 18, 2022 - Q1. How are the tokens in the DAI Vault being allocated into the various Fuse Pools?
State of the State
Mar 9, 2022 - Inspecting the Terra-pages made by Flipside https://consoles.flipsidecrypto.com/terra/overview/index
$THOR Staking Wallets
May 23, 2022 - Q90. Since vTHOR and THOR Staking 2.0 was released in May, we’re interested in finding out more about how the community has embraced the staking rewards. How many unique wallets have staked $vTHOR? Chart this number over time.
LUNA Staking and Trends
May 7, 2022 - Q203. Over the past 30/60/90 days and the past year, how much LUNA has been staked per day? What is the staking percentage (LUNA staked/Circulating Supply), and how has it changed over time?
Lost Anchor Funds
May 5, 2022 - There has been an increase in reports of new Anchor users losing funds. This dashboard analyzes a few of such transactions and tries to detect suspicious behavior. Furthermore, we try to dig deeper into how did these new users lose their funds and how could the loss of funds be prevented in the future?
Transaction Failures (Osmosis)
May 27, 2022 - Q6. Establish the failed transaction rate for Osmosis over the last 4 months. Make a case for what is causing the failed transaction rate that you assess and provide recommendations to mitigate it.
