rajs
True Freeze - 1. Early Redemptions
Jul 29, 2022 - True Freeze users can pay a fee to unlock their ETH early. What is the sum of fees paid for early unlocks? So far, what percentage of locked ETH was unlocked early?
MakerDAO - MKR Committed Over Time
Jun 28, 2022 - Please design a dashboard for each of the three votes, where you plot MKR committed over time. Plot redelegation events, especially from Rune Christensens address, where you visualize who got delegated how much and how this influenced the outcome of the polls
True Freeze - 5. Metrics on True Freeze
Jul 29, 2022 - Produce a dashboard showing metrics on True Freeze. At a minimum, visualize: • the daily volume of ETH frozen, • the daily number of transactions to freeze ETH, and • daily early redemptions.
Algorand - Algorand Price Correlation
Jun 27, 2022 - Q109. Is the price of Algorand more closely correlated with the crypto market, and assets such as BTC or ETH, or is it more correlated with network usage such as number of transactions or ALGO transfers? How does this compare to other networks such as Solana? Note your findings and anything else that may be interesting in relation to Algorand's price movement!
StarkWare - ETH Deposited or Withdrawn
Jun 29, 2022 - Q1. 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?
Flipside Crypto: Nouns DAO
Jun 12, 2022 - Part 1: Analyze the mint and secondary NFT marketplace activity for Nouns DAO. Can we conclude if there are certain types of traits (body, accessory, etc.) that are causing some Nouns to sell or mint for more than others? Part 2: Who is typically settling Nouns auctions? Does the winner settle the auction, or does an eager new bidder settle the current auction to begin the next auction?
Uniswap NFT Aggregator
Dec 19, 2022 - Show daily transaction volumes on Uniswap's NFT aggregator. Describe in your own words the benefits of using this marketplace to trade NFTs. Pay close attention to the accuracy of your data. (see https://crypto.news/dune-analytics-finds-false-data-on-uniswaps-nft-aggregator/) Optionally, you may also show some of the following data: Gas savings (if any) on the Uniswap NFT aggregator compared to other NFT aggregators on the same chain. Genie users USDC airdrop statistics. (Contextual information on the above can be found here.)
Ethereum - Total Metamask Users
Jun 23, 2022 - Q1. How many total Metamask wallet holders are there? What’s the average value of ETH held in wallets? What percentage of wallets are engaging in a higher order activity, like staking?
Lil Nouns bounties - Voting Activity
Jun 21, 2022 - Q1. The Lil Nouns DAO is controlled via onchain voting by token holders. Using the ethereum database, analyze voting activity on Lil Nouns proposals. Since voting is on chain and costs gas, are smaller holders excluded from the voting process? Visualize and analyze this question, along with any other trends you find that are relevant.
Flow vs Other L1s Pt (II)
Jul 19, 2022 - How does Flow compare to other L1s in terms of user retention? Is a user who made a transaction previously likely to make another transaction a week or a month later? Compare and contrast this type of activity vs other L1s like Solana and Ethereum.
Opyn - Long vs Short Option Contracts
Jun 30, 2022 - Q2. How many long vs short option contracts have been bought on opyn? What’s their value? Has there been any liquidations?
NEAR Performance
Jul 18, 2022 - Q5. How does NEAR stock up to other L1s in terms of speed and performance? How fast is NEAR, and compare it with other blockchain speeds in terms of transactions per minute and percentage of transactions that fail.
Pool Together Bounties - Pooly NFTs
Jun 21, 2022 - Q2. How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
Velodrome Health
Aug 17, 2022 - Q10. Create at least 3 metrics on Velodrome with a description for each that showcase traction and success in a data-driven manner. Most importantly, your insights should help our readers answer the question "How healthy is this project?"
Sushiswap Bounties - Celsius Swaps
Jun 22, 2022 - Q95. 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?
Polygon Block Performance
Jul 25, 2022 - What is the average time between blocks on Polygon? What was the maximum and minimum recorded time between two blocks? How many transactions are done in a block on average? How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
Liquid Staking ETH Platforms Analysis
Sep 5, 2022 - Consider all possible liquid staking ETH platforms. Then, find out the following: How much ETH was staked over time? How many unique depositors are there? How likely are depositors to use multiple platforms vs using a single platform? Are depositors Dollar cost averaging their ETH into the platforms? What is the avg/median/max/min/distribution of ETH deposits? Compare all the metrics above between the various ETH staking methods/platforms
Untitled Board
Oct 15, 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? Do you think that there is a limit to how high a floor for a NFT collection on Optimism can reach compared to on Ethereum?
Untitled Board
Nov 2, 2022 - Through its bounty program, Flipside Crypto pays analysts for their insights and data analytics. Can you track down bad actors who "farm" Flipside rewards? Look for participants that collect multiple times for the same bounty or hunt. For instance, you might discover that different addresses transfer all of their token incentives to the same address. If these addresses are generating the same dashboards or finishing the same hunts, they might be bounty farmers. To find these bounty farmers, you are free to employ any means that is both legal and reasonable. Because it may harm their reputation, we advise you not to publish users' identities unless you are confident they are bounty farmers.
ZK Sync Bounties - 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.
AAVE and stAAVE movements
Aug 12, 2022 - Create visualizations showing the following: Daily AAVE supplied and withdrawn on Aave protocol. Daily AAVE staked and unstaked.
Terra - 10. Light as a Feather
Jan 23, 2023 - The announcement of Station has generated hype in the Terra community. Has this type translated to an increase in activity? Define and visualize at least 2 metrics for ecosystem activity and analyze them in the week before and after the Station. Did the launch have any measurable impact? Are there other factors that might be in play affecting the metrics you’ve chosen?
Optimism Bridge Bounties - Bridge Volume (Optimism Bridge)
Jun 17, 2022 - Q2. Compare user bridge volume on the Optimism Native Token Bridge vs. another Mainnet <-> Optimism Bridge of your choosing (e.g. Hop). Can we conclude if there are differences in the types of users or transactions using the native bridge vs. the non-native bridge?
Lil Nouns bounties - Secondary Sales Activity
Jun 20, 2022 - Q2. How many Lil Nouns have been sold on a secondary exchange within 24 hours of being minted? Are there any common traits among these Lil Nouns? Which Lil Noun’s have the biggest difference (positive or negative) between their mint price and secondary sale price? Visualize and analyze your findings.
Hop Bounties - Bridge Users (Hop Protocol)
Jun 18, 2022 - Q1. How many unique users have bridged to L2s using Hop? What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.
Untitled Board
Nov 4, 2022 - How centralized or decentralized is NEAR, really? Choose at least two distinct measures of decentralization that can be explored with on-chain data; clearly define those metrics; and outline how NEAR performs based on those metrics. In your view, is NEAR becoming more centralized or decentralized over time?
ZK Sync Bounties - 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.