Sapien
USDC Deposits
Jun 21, 2022 - PoolTogether is an Ethereum-based lottery platform that lets users deposit cryptocurrency into pools to buy tickets. Each pool holds a weekly drawing that awards a prize pool to up to five winners, but your tickets do not expire following the drawing. Instead, the tickets roll over to the next drawing, the next one after that, and so on and so forth until you win or withdraw your funds from the pool. In this dashboard, we will be discussing on the amount of USDC deposited into PoolTogether using Ethereum network and the average deposit amount per user in the May 2022.
Aave - 7. AAVE and stAAVE movements
Aug 11, 2022 - Visualizations showing the Daily AAVE supplied and withdrawn on Aave protocol & Daily AAVE staked and unstaked.
Hacks, Scandals and Scams - 3. Whales On Alert
Jul 28, 2022 - In this dashboard, we are going to identify active wallets with a high balance of ETH (whales). Also, we will visualize the ETH transaction history of these whales in May and June 2022.
ETH Staked
Jun 15, 2022 - In this dashboard, we will be discussing on the total amount of ETH that has been staked with Lido. Also, we will also illustrate the daily amount of ETH staked with Lido in the past 3 months. Lastly, we are going to analyze the trend based on the graph.
Pooly NFTs
Jun 22, 2022 - The Pooly Collection is a limited edition set of NFTs owned by people supporting PoolTogether Inc. in defending against the lawsuit. In this dashboard, we will be finding out how many Pooly NFTs have been minted thus far and by how many unique wallets. Lastly, we will also compute the average Pooly NFTs held by each collector.
ETH Deposited or Withdrawn
Jun 26, 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?
Total Metamask Users
Jun 25, 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? (Lido Staking in this analysis)
Layer 2 Blocks
Jun 29, 2022 - Q2. How many layer2 StarkNet blocks have been accepted on Ethereum (L1) chain so far? How much fees have been paid(generated) to Ethereum network? Has StarkNet contributed to saving in transaction fees for its users?
Prizes
Jun 22, 2022 - Q3. In the past 60 days, how many PoolTogether prizes have been awarded and claimed? What’s the USD value of these prices?
Opensea Fees
Jul 31, 2022 - Q6. Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
Distinct Wallets (Optimism Bridge)
Jun 16, 2022 - Optimism is a layer 2 chain, meaning it functions on top of Ethereum mainnet (layer 1). Transactions take place on Optimism, but the data about transactions get posted to mainnet where they are validated. It’s like driving in a less crowded side street while benefiting from the security of a highway. In this dashboard, we are going to discuss on the number of distinct wallets who have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days and finally visualize on the findings.
Voting Activity
Jun 18, 2022 - Lil Nouns is a project fork of Nouns DAO on the Ethereum blockchain. Lil Nouns is a generative, 32x32 pixel character NFT that generates once every fifteen minutes. Each Lil Noun NFT is auctioned every fifteen minutes for the rest of time. The Lil Nouns DAO is the governing body of the overall Lil Nouns ecosystem and is essentially run by every single Lil Nouns NFT holder as they all vote on any governing issues in which we will be discussing in this analysis. In this dashboard, we will analyze voting activity on Lil Nouns proposals and the number of unique voters over total unique holder as of current since voting is on chain and costs gas.
Bridge Users (Hop Protocol)
Jun 19, 2022 - Hop is a scalable rollup-to-rollup general token bridge. It allows users to send tokens from one rollup or sidechain to another almost immediately without having to wait for the networks challenge period. It works by involving market makers (referred to as Bonder) who front the liquidity at the destination chain in exchange for a small fee. In this dashboard, we will be focussing on bridging activity whereby only the bridge contract addresses will be used instead of the Bonder contract addresses.