Crazy_Kid
MIM & Its Peg Over The Last Few Weeks
Feb 10, 2022 - Magic Internet Money (MIM) is an ERC-20 token that is soft-pegged to USD. It is minted by the Abracadabra.money, a decentralized platform. Abracadabra uses interest-bearing tokens as collateral to mint MIM. Interest-bearing tokens that can currently be used as collateral include liquidity provider (LP) tokens from Convex, Curve, Yearn, among others. Loan liquidations in Abracadabra differ from other stablecoin/lending protocols like MakerDAO, such that each collateralized debt position (CDP) is unique and has its own liquidation price. When the liquidation price for an individual CDP is crossed, a liquidator can buy the position by paying off any outstanding MIM.
Celsius Swaps
Jun 22, 2022 - Find out about the swapping behaviour of Celsius network on both Sushi and Uniswap. Which tokens did they swap the most. From which one of their wallets did they conduct most of the swaps?
Total Value Locked in Bentobox
Mar 23, 2022 - What is the total value locked in Bentobox across Polygon and Ethereum chains? Which chain brings the most activity to Bentobox?
Fuse Pool USDC Allocation
May 26, 2022 - How are the tokens in the USDC Vault being allocated into the various Fuse Pools?
New Addresses - Polygon
Jun 1, 2022 - 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.
UST LUNA Highway
Apr 22, 2022 - 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?
Covered Call for Luna in Friktion
Feb 20, 2022 - Friktion is a new DeFi portfolio management project running on smart contracts on the Solana network. The project is seen as a new profit-seeking opportunity, helping users to maximize profits and monitor profit fluctuations in different markets. Friktion offers a covered call strategy for numerous assets, including LUNA.
ETH Staked - Lido
Jun 13, 2022 - What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
Unique Users Growth in Governance and non Governance Periods
Feb 7, 2022 - Community Governance enables all Algo holders to participate in the decision making process on the growth and development of the Algorand ecosystem. The Governance approach for the Algorand community is designed for simplicity and maximum participation. There are four quarterly Governance periods per calendar year. Each governor must commit to keeping a certain Algo balance for each quarterly Governance period. There will be at least one voting session in each period. Governors must vote in each voting session, but can choose to use a simplified UI to “vote with the Foundation”. Every measure to be voted on will have an information pack explaining it. Compliant Governors can claim rewards for their service at the end of each quarterly Governance period. Reward levels are tied to the Algo commitment of a governor.
LPs & Concentration of Capital - SushiSwap
Apr 4, 2022 - How concentrated are Sushiswap's liquidity pools in terms of liquidity provider participation? How has the concentration evolved over time? How many pools are dominated by one single LP that holds more than 50% of funds?
Distribution of Swaps in $RUNE and USD Values
Sep 5, 2022 - Q. Show the distribution of swap sizes in both $RUNE and USD, both for all pools as well as broken down by pool.
Swaps to $THOR
May 31, 2022 - On May 4th, $THOR staking was enabled that yielded rewards for stakers based on THORSwap volume. Did we see a spike of swaps to $THOR around that time? Has there been any noticeable change in $THOR swapping since that event?
Net Bonding Flow
May 10, 2022 - Show the net bonding amount over time. You can show a line chart with the cumulative amount bonded over time or a chart showing weekly or monthly net changes (or a visualization of your choice!)
People Token from the Secondary Market
Jan 26, 2022 - Constitution DAO (2021-2021) was an experiment in a single-purpose DAO (Decentralized Autonomous Organization) which intended to buy a rare copy of the U.S. Constitution at a Sotheby’s auction on Nov. 18 2021, then turn it into a formal non-profit run by the DAO’s donors. Constitution DAO crowdfunded close to $47 million in Ether, through a campaign carried out over social media. Someone wishing to join Constitution DAO was supposed to buy a token- People token, in exchange for ETH at a 1 ETH : 1,000,000 $PEOPLE ratio; the more tokens one owns, the more votes that person gets. But the collective didn’t prevail at auction—the document instead went to billionaire Ken Griffin and the team behind it decided to end the project and make full refunds available to the community in the same ratio of ratio of 1,000,000:1. People were also given the option to keep their PEOPLE tokens and do with them as they please.
Algorand Governance Period 2
Mar 17, 2022 - Through this dashboard we will be analyzing the votes cast during the 2nd governance period on Algorand to decide on the creation of a new tier of Expert Governors (xGovs). We will also see how much ALGOs were committed by the wallets in the governance period.
Mona Lisa- Lil Pump ft Soulja Boy MFT
May 26, 2022 - Opulous is a launchpad for music NFTs, where you can take ownership in artists’ songs, albums, and artworks and earn royalties from them. One of the first songs released was Mona Lisa- Lil Pump ft Soulja Boy -Show us the distribution of the number of shares each MFT holder has for the asset(725937713). -Have all the shares been claimed? Show the claims of the MFT shares over time so we can understand the effectiveness of the claims process -Have any wallets exchanged their shares? If they did, how much did they exchange them for? -Note any other interesting findings!
Gas Fees in Uniswap & SushiSwap in the last 2 Months
Feb 2, 2022 - As the Ethereum network is a decentralized blockchain with no singular entity or authority overseeing its operation, a mechanism is put in place to avoid the network from being congested or spammed with transactions. This mechanism charges senders of transactions with a small fee called gas fee which is then used to reward miners who validate transactions on the network. Gas fees are paid in Ethereum's native currency, ether (ETH). Gas prices are denoted in gwei, which itself is a denomination of ETH - each gwei is equal to 0.000000001 ETH (10-9 ETH). The word 'gwei' itself means 'giga-wei', and it is equal to 1,000,000,000 wei. Wei is the smallest unit of ETH. The gas fee is deducted from the remaining ETH balance of your address and not from the amount of ETH or tokens that you are sending. The total fee for a transaction is calculated with the given formulae according to the latest London upgrade in the network: Gas Fees = Gas units (limit) * (Base fee + Tip), where, Gas Limit is the maximum amount of gas a user is willing to pay for a transaction, Base Fee is the the minimum amount of gas required to include a transaction on the Ethereum blockchain and the Tip/Priority Fee the additional fees users pay to the miners in order to prioritize their transaction. Uniswap and SushiSwap are decentralized exchanges built on the Ethereum blockchain.
Swaps For Bank Tokens
Mar 8, 2022 - In this dashboard we will be looking at the platforms and liquidity pools that users used to acquire BANK tokens - the native token of Bankless DAO. We will also see which all tokens were swapped in exchange for Bank tokens.
THORChain and $vTHOR Overlap
May 24, 2022 - What % of $THOR staking wallets also are currently LP-ing on THORChain?
Lofty AI Platform Dashboard
Jul 14, 2022 - Q. Create a visually appealing dashboard using the new multicolumn layout or the visualization tool of your choice to illustrate all the properties(assets), the tokenized revenue Lofty has generated through sales, and the total asset value that Lofty AI manages.
Standardized Swap Volume
May 17, 2022 - A few weeks ago we did a question on standardized TVL. Now we’d like to see a similar analysis looking at swap volume in a way that neutralized the impact of price changes. Feel free to look at this any way you’d like, but one idea is to fix asset prices at their current value and apply that price historically to all the tokens that were swapped. Show this metric by week or month (or both!)
$RUNE Movement from Crypto.com
Jun 21, 2022 - Show the in + outflow from cryto.com to native wallets over time. Are there any trends?
Synth Utilization
Apr 13, 2022 - Calculate the synth_utilisation of each pool and chart over time.
Most Popular Swaps on Jupiter
Feb 27, 2022 - Jupiter is the key liquidity aggregator for Solana, offering the widest range of tokens and best route discovery between any token pair. Through this dashboard we will see the most popular swaps on Jupiter since the start of February 2022. We will be looking at the top 10 coins swapped away, swapped for and the 10 most popular swapping pairs. Here the metric for popularity is the no. of swaps - higher the swaps, more the popularity.
Daily Average of Swap Sizes of Top Ten Liquidity Pools in Terms Of Locked Value
Feb 9, 2022 - Swapping is the process of directly exchanging one crypto asset for another without having to conduct a crypto-to-fiat exchange. You can exchange any cryptocurrency for another even if the pair is not live on the spot market. This eliminates paying transaction fees more than once. SushiSwap is one of the decentralized exchanges (DEX) that provides coin swapping facility. SushiSwap is also non-custodial, which means that unlike centralized exchanges - SushiSwap does not need to possess your tokens in order for you to be able to trade them. Instead, SushiSwap allows users to trade trustlessly, peer-to-peer, with liquidity that is supplied by other users. This means that new projects can easily connect to their desired markets as long as some entity is willing to provide the liquidity. To be a liquidity provider, holders of any token need to supply equal parts liquidity for that token (sometimes called the quote token), and a second token (usually ETH, or a stable coin). In return, these holders receive SushiSwap liquidity provider (SLP) tokens that represent their share of the pooled liquidity for that token pair. The existence of this pooled liquidity gives other traders access to the underlying tokens in exchange for a small fee, which is distributed proportionately to all of the liquidity providers.
IL Protection Over Time
May 17, 2022 - With highly volatile prices recently, more IL protection has been paid out on THORChain. How do recent days or weeks compare to historical amounts?
stETH Most Common Pools
Apr 27, 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?
IL Protection By Pool
May 17, 2022 - Which pools have paid out the most IL protection in the last week? Month?
Votes in Solana Per Block From the Start Of Feb 2022
Feb 12, 2022 - Here, the avg no. of vote transactions per block per day in Solana will be compared against the avg no. of non vote transactions per block per day.
DAI Volume
May 18, 2022 - How does the daily volume of DAI transactions compare to other stablecoins? What is DAI most used for?
Luna Distribution for Active Wallets
Feb 9, 2022 - Luna is the Terra protocol’s native staking token that absorbs the price volatility of Terra. Luna is used for governance and in mining. Users stake Luna to validators who record and verify transactions on the blockchain in exchange for rewards from transaction fees. The more Terra is used, the more Luna is worth.
ETH Deposited or Withdrawn - Starkware
Jun 29, 2022 - StarkNet is a layer 2 chain, that ensures interoperability with the Ethereum mainnet. People are using it to move real ETH to StarkNet and enjoy its higher speed of transaction and lower fees. How many ETHs have been deposited or withdrawn (bridged) so far from Ethereum to StarkNet or vice versa? and by how many depositors?
Staking Yield in Terra & Comparison of Staking Yield of Luna with its Price
Jan 17, 2022 - Before we discuss the staking return in Terra it is important to understand what a moving average is. Moving average in simple terms is the mean of a series of data points over a period of time. The moving average helps to smoothen out fluctuating data and makes it easier to see the trend(up or down). There are two types of moving averages- the Simple Moving Average(SMA) and the Exponential Moving Average(EMA). SMA is simply the value of a data point divided by the no of days, i.e. the the arithmetic mean of the value over a period of days, giving equal weightage to all the data points. EMA is similar to SMA, it also calculates the arithmetic mean over a period of days, but more weightage is given to the most recent data points.
LP Size Distribution
May 3, 2022 - What is the current distribution of LP size for each pool?
Sushi Activity on Ethereum
Jun 29, 2022 - How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lendings?
Sablier Cash Streams
Apr 23, 2022 - Out of all streams of cash created on Sablier, how many have been cancelled before their stop time?