Mikey_
Polygon - Daily Transactions and Unique Addresses
Jul 9, 2022 - Count and plot the number of daily transactions and unique addresses on Polygon, beginning July 1, 2022.
Polygon Block Performance
Jul 24, 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?
Solana NFT Project Feature
Jul 18, 2022 - 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.
Aave - 7. AAVE and stAAVE movements
Aug 5, 2022 - Create visualizations showing the following: Daily AAVE supplied and withdrawn on Aave protocol. Daily AAVE staked and unstaked.
Aave - 8. How does BTC funding affect rates?
Aug 11, 2022 - Create a dashboard that shows: Supply and lending rates for at least five tokens in Aave V2, and Total amount of Wrapped BTC supplied over time. Provide analysis on the volatility of rates. Measure the correlation between USDC borrow rates and total wBTC supplied.
What's going on Bebop?
Nov 2, 2022 - Detail of Bebop's new contract on both Ethereum and polygon
Untitled Board
Sep 19, 2022 - Using a combination of fact_transactions, event_logs and the traces table, create a raw table that shows all ‘settle auction’ transactions with this NFT contract address for all TokenIds. The table would have the following: tokenId Winning bidder address How much ETH was sent to the Superrare Treasury address How much ETH did the seller receive
Total Value Locked
Jun 30, 2022 - What is the total value locked in the Opyn Squeeth (osQETH) contract? And where does osqeth draw its value from?
ALGORAND - Transactions by Protocol
Jul 14, 2022 - Using the following App ID lists from Folks Finance, AlgoFi, Tinyman, and AlgoDex, lets look at what percent of transactions their app calls and associated transactions(transactions in the same tx_group_id) make up on the Algorand blockchain.
Polygon NFT
Jul 16, 2022 - How popular are NFTs on Polygon? Track daily volume over the past month/year/etc.
Distinct Wallets (zkSync)
Jun 16, 2022 - Count of distinct wallets have deposited ETH into ZkSync in the last 60 days & deposited ETH by day
NFL All Day Tournament [Round 1]
Sep 10, 2022 - For the first round of this tournament, create an analysis that shows top-line NFL All Day metrics and stats. Chart total sales and sales volume growth, user analysis, player. Track metrics by player and position, and see if there are any notable spikes in sales so far this preseason.
Opensea Fees
Jul 30, 2022 - Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
Top TOKE Holders
Jun 22, 2022 - Identify the top holders of the TOKE token in January 2022, have they kept their position today?
The Unstakeeeeers -- Osmosis
Jul 16, 2022 - How frequently do users on Osmosis unstake their Osmosis? What do they do with the OSMO once unstaked?
ETH Deposited or Withdrawn via starkgate
Jun 25, 2022 - StarkNet is a layer-2 chain that ensures interoperability with Ethereum mainnet. People are using it to move real ETH to starknet and enjoy its higher speed of transaction and lower fees.
poolTogether
Jun 22, 2022 - In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
Distinct Wallets (Optimism Bridge)
Jun 15, 2022 - distinct wallets that deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days
$RUNE Upgrades
Jun 27, 2022 - There has been a big push for users to upgrade their ETH.RUNE + BNB.RUNE -> native RUNE, as the wrapped versions will be depreciated. 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?
Total Metamask Users
Jun 23, 2022 - 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?
FLOW Usage During the NBA Playoffs
Jul 11, 2022 - Analyze the NBA Conference Finals (May 17th- May 29th) and determine whether it had an impact on NBA Top Shot's volume.
Quixotic NFT Dashboard
Aug 3, 2022 - Create a secondary market dashboard for NFT sales on Quixotic, the largest NFT marketplace on Optimism! Include any data you think is relevant in our Optimism tables and tell us the most interesting trends you can find with the secondary NFT market.
Defi : God Of Risks
Nov 24, 2022 - A review of price of the CRV in Nov.22 and The reasons of it, and Aave protocol.
Bridger Destinations
Jul 29, 2022 - Where do people go when they bridge to Polygon from Ethereum? What are the 10 most popular first destinations for Polygon addresses that have just bridged from Ethereum?