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
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?
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
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.
What's going on Bebop?
Nov 2, 2022 - Detail of Bebop's new contract on both Ethereum and polygon
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.
Uniswap new NFT aggregator
Dec 16, 2022 - In this article we're gonna deep dive into Uniswap new NFT aggregator
NEAR Performance
Jul 20, 2022 - How does NEAR stock up to other L1s in terms of speed and performance?
Distinct Wallets (zkSync)
Jun 16, 2022 - Count of distinct wallets have deposited ETH into ZkSync in the last 60 days & deposited ETH by day
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.
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.
