janan
Rune Upgrades
Jan 8, 2022 - 39.[thorchain] What is the ratio of the number of ETH.RUNE upgrades vs BNB.RUNE upgrades? How has that ratio changed over time? Hint: use thorchain.upgrades
Optimism NFT Purchasing Behavior
Oct 18, 2022 - Show the distribution of all NFT sales on Optimism by price. What percentage of all sales have been above .01 ETH? Above .1 ETH? 1 ETH?
Moonbirds Mint Distribution
Apr 22, 2022 - What was the mint distribution of the Dutch Auction? Plot the distribution at various price points and/or the mints over time with the cost.
TOKE Holders
Jun 22, 2022 - Identify the top holders of the TOKE token in January 2022, have they kept their position today?
Dodge, Duck, Dip, Dive and $DOGE
Jan 22, 2022 - What % of the swaps made this week involved $DOGE?
Rune Upgrades
Jun 28, 2022 - Have you seen an uptick in the amount of $RUNE being upgraded recently? Look at both the $RUNE volume + number of wallets. What is the trend over time + also how much is ETH vs BNB?
NEAR Gas Guzzlers
Jul 23, 2022 - What contracts are users spending the most gas on to use? How has this changed over the past week? Past month?
Network Load
Dec 6, 2021 - What is the highest number of swaps THORChain has handled in a single minute? What is the highest number of swaps in a single minute broken down by each day? Hint Use thorchain.swaps
Swap Size Distribution
Dec 4, 2021 - What is the distribution of the size of swaps on THORChain? How does that differ based on the chain?
Uniswap - 16. UNI Market Correlation
Mar 31, 2022 - Does the price of UNI correlate with the price of ETH? Compare this with the correlation of UNI to other DEX coins (such as AAVE, SUSHI, or anything else you find suitable)
$RUNE Movement from Crypto.com
Jun 20, 2022 - Q104. Show the in + outflow from cryto.com to native wallets over time. Are there any trends?
Number of Users of THORChain Bridges by asset
Oct 27, 2021 - Show the number of users interacting with THORChain broken down by chain. HINT: Use upgrades table
[Easy] Brace for (Meteor) Impact
Dec 15, 2021 - Measure the impact of Levana Meteors! -How many meteors are there? -What is the breakdown/count of Legendary, Ancient, Rare, and Common? -How many have been cracked, and how many remain uncracked?
Moonbirds gas fees
Apr 22, 2022 - Q6. How much gas was spent minting? Was any gas lost due to failed transactions? How does it compare to other recent launches?
8. [Easy] Multiple Domains
Dec 18, 2021 - How many wallets have multiple domains? Are holders more likely to have one domain or multiple domains?
stETH vs. ETH
Apr 1, 2022 - Q6. How has the price of stETH compared to ETH? Are there any events that triggered a big difference in price between the two tokens?
Swap Volume vs. LP Reward
May 2, 2022 - Chart the weekly swap volume and LP rewards on the same chart. What is the relationship between the two?
Fees Rises vs Aave average deposits and borrows
Nov 10, 2021 - As gas prices have continued to rise, how have average deposit and borrow amounts changed in response?
Bridgesplit and MonkeDAO's DAOJONES
Feb 22, 2022 - Bridgesplit enables any unique asset to become liquid and yield generative via NFT-collateralized lending, indexes, and more. Essentially, Bridgesplit allows for NFT fractionalization. In partnership with MonkeDAO, a Solana Monkey Business NFT (the MonkeDAO mascot) was fractionalized on 12/6 and trading began soon after. Create a chart showing daily transaction volume and the number of distinct wallets that transacted with DAOJONES. When was the peak amount of trading volume and seemingly ""hype"" around DAOJONES? What was the most amount of distinct wallets that made a transaction with DAOJONES in a day? Provides some insights around why these numbers peaked when they did.
LIQUIDITY
Nov 7, 2021 - Of the wallets that have supplied liquidity in THORChain pools, what percentage have removed at least some of the liquidity? Hint: use liquidity_actions
Lido Rocket Pool Comparison
Apr 27, 2022 - Use the ethereum_core tables to compare deposits to Lido and Rocket Pool
Synth Mints + Burns
Apr 11, 2022 - Q58. Show the minting + burning of synthetic assets over time.
Dai Volume
Jan 16, 2022 - How does the daily volume of DAI transactions compare to other stablecoins? What is DAI most used for?
Untitled Board
Sep 10, 2022 - Do certain miners prefer mining blocks with lower transaction count? Do certain miners only mine blocks with high transaction count? You can define what can be considered low or high transaction count based on the transaction count distribution
31. [Easy] Net Liquidity
Dec 18, 2021 - How much liquidity is being added and removed from the THORChain pools over time? Is there a noticeable trend? Hint: use thorchain.liquidity_actions
Solana Fees
Feb 9, 2022 - One of the main advantages for a user of Solana is the extremely low fees relative to other blockchains. Create a visualization showing transaction fees per day accumulated since the beginning of January. Also create a visualization that shows transaction fees per transaction on each day. Do fees ever seem to spike or is it consistent?
Gain or Lose
Apr 5, 2022 - Q9. Of the stakers that have swapped ETH to stETH, how much ETH did they gain or lose depending on the peg of stETH to ETH at the time of the swap? Repeat the same analysis for stakers who have swapped stETH to ETH; how much ETH did they gain or lose?
Outbound Traffic
Mar 17, 2022 - Create a dashboard to track the outflows of LUNA and UST to Osmosis, Secret, Axelar, and Injective. What conclusions can you draw from the outflows thus far?
New Active Users
May 9, 2022 - Q1. Show the number of new unique users (wallets) per day that transacted with ParaSwap over the past two months.
Stargate Fishes & Whales
Apr 27, 2022 - 1 billion Stargate tokens were minted at genesis and will be the entire finite supply of STG. Define the terms fish and whale in terms of Stargate token ownership (in your opinion). What proportion of users fall into each of the categories you defined (fish and whale). Note: Use the new ethereum_core data
ETH Staked
Jun 14, 2022 - Q9. 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?
Rand Gallery NFT Sales
May 1, 2022 - Rand Gallery is one of the largest NFT marketplaces on Algorand. Let’s take a deeper look into the rand gallery’s history and the performance of the marketplace.
Price Correlation
Dec 11, 2021 - Is there any kind of correlation between the prices of $RUNE, $XRUNE, $THOR? Hint: use thorchain.prices for $RUNE and ethereum.token_prices_hourly from $THOR and $XRUNE
Active Wallets on Terra
May 1, 2022 - Define "Active Wallets" on Terra. Based on your definition, display the active wallets by day, month, and Year-To-Date in 2022.
Unique Users Algorand
Apr 5, 2022 - Compare the number of unique wallets that have sent a transaction since February 1st on Algorand vs Solana vs Ethereum vs Terra. How does user adoption seem to be trending for Algorand compared to these other major chains? Does it appear that market conditions are slowing down growth or activity on the networks?