kipto
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?
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.
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.
Solana Stables
May 18, 2022 - Q74. Track stablecoin activity on Solana since April 1st (not limited to but look into USDC, USDT, UST, USDH, UXD, PAI). What have been the flows between coins and what was the result of the UST depegging in the Solana ecosystem? What types of wallets hold a USDH, UXD, or PAI compared to a USDC and what are users doing with those coins?
Price + Circulating Supply
Jun 8, 2022 - Q3. Draw a chart showing MATIC’s circulating supply from the start till today. Compare it with MATIC’s price.
Solana NFT Deal Score to rule them all
Feb 10, 2022 - Do you want to buy an NFT? Sure. How do you know the listed price is fair and avoid getting rugged? The NFT deal app is redefining how to go about making your NFT purchases by using price history and machine learning and not only strict rarity-based metrics. To make the point, we will look Pesky Penguins, Thugbirdz, and SolanaMonkeyBusiness (SMB).
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?
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.
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?
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?
Tokenflow Trailblazers
Mar 22, 2022 - Q1. Dive into the Tokenflow data and tell us what you find.
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?
Distinct Wallets (zkSync)
Jun 17, 2022 - Q1. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
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.
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.
It's the Catalina Whale Mixer
May 18, 2022 - Q73. Catalina Whales are a popular NFT collection on Solana with an experienced team from the entertainment industry. Chart their sales history and unique holder trends over time.
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.
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.
ERC20 Tokens (zkSync)
Jun 17, 2022 - Q2. Users can also deposit ERC20 tokens into ZkSync. Which ERC20 tokens have been deposited the most (in $ volume and total count) in the last 60 days? Visualize and explain both findings.
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
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