Sapien
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.
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.
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.
Polygon-New Addresses
Jun 1, 2022 - In this dashboard, we will be discussing the number of new addresses every day on polygon(matic) network. In this case, we assume new addressses are unique addresses that first trigger a transaction or appeared for the first time in a transaction of Matic.
Flow Scavenger Hunt: Flowverse (June 29)
Jun 30, 2022 - By the end of this tutorial, I am able to Create a Dapper wallet, Fund my wallet and explore the Flowverse and build a dashboard showcasing projects that interest me.
Polygon NFT
Jul 15, 2022 - Q3. How popular are NFTs on Polygon? Track daily volume over the past month/year/etc. How many Polygon users started off with NFTs? Who made the most profit?
LUNA Market Cap
May 8, 2022 - In this analytics, we are going to discuss about the LUNA price and LUNA market cap trend over 30, 60, 90 days; the past year and all time. Market cap of a cryptocurrency is calculated by multiplying the price of the coin / token and its circulating supply. Market Cap (USD) = Circulating Supply (Coins / Tokens) * Price (USD per Coin / Token) In this project, circulating supply of LUNA was decided to include liquid and staked Luna tokens held in wallet addresses. The justification for the use of liquid and staked Luna as circulating, comes from CoinMarketCap's glossary definition of 'circulating supply' as follow. "The best approximation of the number of coins that are circulating in the market and in the general public’s hands". (source: coinmarketcap glossary)
StarkWare Scavenger Hunt
Jun 25, 2022 - By the end of this tutorial, I am able to Install a StarkNet wallet, Acquire GETH & mint TST and Swap tokens via myswap.
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.
Polygon Block Performance
Jul 26, 2022 - 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 Purchasing Behavior
Apr 27, 2022 - The dashboard shows the distribution of all Solana NFT sales on Solana. In specific, the pie chart below depicts the percentage of all sales have been above 1 SOL and above 10 SOL. Besides, the number of unique wallets that have made NFT purchase that was above 10 SOL and above 100 SOL are also illustrated in the second diagram.
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.
Transaction Failures
May 29, 2022 - In this analysis, we will establish the failed transaction rate for Osmosis over the last 4 months. Furthermore, we will also make a case for what is causing the failed transaction rate that we assess and provide recommendations to mitigate it.
UST-LUNA Highway
Apr 23, 2022 - The dashboard depicts the daily minted UST & burned LUNA and vice versa for first quarter of 2022, from 1 Jan 2022 to 31 March 2022. Both events are illustrated with chronological line graph as follow.
Pact Fi Scavenger Hunt
Jun 26, 2022 - Pact Fi is a decentralized automated market market(AMM Dex for short) on the Algorand network. What stands out most about Pact Fi is LP(Liquidity Pair: A pair of assets to provided by a wallet to allow users to trader between assets on a DEX) providers get 100% of liquidity pool fees back!
Algofi Scavenger Hunt
May 18, 2022 - In this tutorial, I should be able to: - Create an Algorand wallet and fund it with ALGO tokens - Swap ALGO using Algofi - Stake tokens using Algofi The transactions made are as follow.
Flow Scavenger Hunt: Flowverse
Jun 26, 2022 - By the end of this tutorial, I am able to Create a Dapper wallet, Fund my wallet and explore the Flowverse and build a dashboard showcasing projects that interest me.
Flow Scavenger Hunt: Dapper Wallet (May 31)
Jun 1, 2022 - By the end of this tutorial, I am able to create a Dapper wallet, fund my wallet, buy an NFT via NBA Top Shot and buy an NFT on Gaia.
Let it burn!
Apr 24, 2022 - The dashboard depicts the week that the most volume of Luna burning happened. The reason behind this event and its associated effect will also be discussed.
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)
Fuse Pool USDC Allocation
May 23, 2022 - Q2. How are the tokens in the USDC Vault being allocated into the various Fuse Pools?
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?
Top TOKE Holders
Jun 22, 2022 - Tokemak is a generalized crypto liquidity aggregator for decentralized exchanges (DEXs) that is designed to give users the ability to provide liquidity and earn incentivized yields for staking different crypto assets while controlling where liquidity is allocated via a decentralized market making system. In this dashboard, we will be identifying the top 10 holders of the TOKE token in January 2022. Next, we will also find out whether or not the holders keep their position as of current.
Flow Scavenger Hunt: NFTs and FLOATS (May 24)
May 25, 2022 - Flow is a new blockchain built for the next generation of apps, games, and the digital assets that power them.
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?
ParaSwap New Unique Users
May 7, 2022 - ParaSwap is middleware aggregating many decentralized exchanges (DEX) and other services in one comprehensive interface. In this dashboard, we will analyze the distribution of new unique addresses that have interacted with ParaSwap per day over the past two months specifically from 6 March 2022 to 7 May 2022.
Polygon vs Harmony
May 31, 2022 - In this dashboard, we are going to find out the average tx_fee and the average number of transactions per hour for both Polygon and Harmony. Also, a comparative study between these two networks will be made by taking 2 important metrics as consideration which are the average tx_fee and the average number of transactions per hour.
Top LDO Holders
Jun 2, 2022 - In this dashboard, we will be discussing on the the top 5 LDO holders on ethereum and where have their LDO come from. Did they buy it or was it an airdrop?
THORChain Scavenger Hunt (June 29)
Jun 30, 2022 - By the end of this tutorial, I am able to Set up a THORChain Wallet, Acquire RUNE from Thorswap and Participate in liquidity pools.
Genopets Staking
Jun 1, 2022 - In this dashboard, we will be creating a visualization regarding the amount of staked GENE token over time. Next, we will also find out the number of unique wallets that have staked GENE token since its inception on May 18th. The percentage of those stakers who have previously purchased a Genopets NFT will be calculated as well in this analysis. Finally, we will also discuss on the trends of the Genopets NFT collection.
Daily Transactions and Unique Addresses
Jul 13, 2022 - Q1. Count and plot the number of daily transactions and unique addresses on Polygon, beginning July 1, 2022.
Swapping goBTC and goETH on DEXs
May 21, 2022 - In this analytics, we will be looking at goBTC and goETH swaps across the DEXs since the beginning of April and get a better understanding of how wallets are swapping goETH and goBTC especially during the price crash in May.
Osmosis Scavenger Hunt
Jun 20, 2022 - By the end of this tutorial, I am able to create a Keplr wallet and fund it with ATOM tokens, Swap ATOM for OSMO using Osmosis and Stake tokens using Osmosis.
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.
Governance Period 2 Payouts
Apr 10, 2022 - The Governance Period 2 Payouts dashboard include how many reward payments were sent, the total amount of ALGO rewards paid out, the time elapsed from the first to the last rewards payment and the wallet which had the largest rewards payout and the associated amount. Lastly, a plot to show the distribution of rewards payouts is created.