Mikey_
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?
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
Distinct Wallets (zkSync)
Jun 16, 2022 - Count of distinct wallets have deposited ETH into ZkSync in the last 60 days & deposited ETH by day
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
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?
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.