Discover expert insights on leading blockchains and protocols.
Orbiter & Pika Discord Hack
May 31, 2023 - on may 30th, Pika Protocol's discord got hacked and many users lost their fund due to connecting their wallet to a malicious smart contract that asked for approval of certain tokens on Various networks. Roughly 24 hours later, same hacker(s) take control of Orbiter finance discord and performed same actions leading to another wave of users getting hacked. I Couldn't get in touch with orbiter team and their community to ensure hacker's wallets are the ones that was used for Pika discord hack, but based on hourly volume of stolen funds, I am assuming that second wave belongs to Orbiter users (note that pika bars are near 0 before orbiter discord hack) Anyways, this may not be 100 percent accurate and I appreciate if you can send me some sample tx of Orbiter users stolen funds.
Blockchain Analytics Course - 1 . Comparing DEXes
Aug 26, 2022 - Using the table ethereum.core.ez_dex_swaps, describe any correlations in activity between Uniswap and Sushiswap.
![curve curve](https://res.cloudinary.com/dsr37ut2z/image/upload/assets/project-icons/curve.png)
Mirror TVL on Ethereum
May 5, 2021 - The purpose of this dashboard is to display Total Value Locked for Mirror and mAssets on the Ethereum Network. All values have been standardize to $USD
Levana Launch - Airdrop receivers + MM stats
Dec 22, 2023 - Levana token has gone through a turbulent launch.
![Nouns Contest by @foddersack Nouns Contest by @foddersack](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Nouns Contest by @foddersack
Jun 13, 2022 - We are analyzing which traits are more desirable and mint the most. Outliers will be eliminated and shown. Link to the layer3 contest here: https://beta.layer3.xyz/contests/flipside-analytics-nouns-dao Part 1: Analyze the mint and secondary NFT marketplace activity for Nouns DAO. Can we conclude if there are certain types of traits (body, accessory, etc.) that are causing some Nouns to sell or mint for more than others? Part 2: Who is typically settling Nouns auctions? Does the winner settle the auction, or does an eager new bidder settle the current auction to begin the next auction?
Daily Active User
Oct 16, 2022 - What does a Daily Active User look like on Osmosis? First, plot out how many DAUs there are on Osmosis. For this exercise, consider a DAU would be any wallet transacting on Osmosis a majority of days every week. Once you have the DAUs, what does their activity look like? Do they LP more or swap more? How often do they transfer tokens into Osmosis? Where are these transfers coming from?
MetaMask Versus UniSwap and SushiSwap
Jun 25, 2022 - In this dashboard we are going to see some information about Metamask users and compare them to other well known platforms of UniSwap and SushiSwap...
![curve curve](https://res.cloudinary.com/dsr37ut2z/image/upload/assets/project-icons/curve.png)
Comparison of WETH-USDC & WBTC-WETH SushiSwap Pools (1 April 2022 - 15 April 2022)
Jul 22, 2022 - A comparative analysis of the swap count and volume in the WETH-USDC & WBTC-WETH pools on SushiSwap, from 1 April 2022 to 15 April 2022 (inclusive)
![curve curve](https://res.cloudinary.com/dsr37ut2z/image/upload/assets/project-icons/curve.png)
![Token Reactor Rankings Token Reactor Rankings](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Token Reactor Rankings
Jun 22, 2022 - Rank the token reactors by their TVL, analyze the pattern of liquidity (withdrawals, deposits) on the top ones. Is there a reason why some reactors have more liquidity than others?
Voting Activity for Osmosis Proposal #466
Mar 23, 2023 - Osmosis Prop #466 was the first ever expedited vote on Osmosis. An expedited governance proposal must exceed 66.6% quorum within the first 24 hours of the voting period in order to succeed. In this dashboard, let's look into its Voting Activity and how long it take to reach quorum. Also we will be looking into the other Trends like Voting Power, Nakamoto Co-efficient etc.,
Flow User Activity
Apr 13, 2023 - Track how the Flow blockchains daily active users have evolved over time. What about monthly? All-time wallets?
Top 10 Cryptopunks Wallet
Aug 31, 2022 - Which 10 wallets are the most successful Cryptopunk traders? Successful could either mean the wallet has accumulated a large balance from sales or has accumulated a large number of Punks. Explain your methodology and findings.
![Solend Demographics Dashboard Solend Demographics Dashboard](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Solend Demographics Dashboard
Aug 1, 2022 - Q101.Solend is the leading lending protocol on Solana. What are the demographics of the Solend userbase?
Fuse Pool USDC Allocation
May 22, 2022 - In this analysis, Rari Capital's USDC Vault allocations into its various Fuse Pools have been evaluated.
![ETH.RUNE upgrades vs BNB.RUNE upgrades ETH.RUNE upgrades vs BNB.RUNE upgrades](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
ETH.RUNE upgrades vs BNB.RUNE upgrades
Jan 8, 2022 - What is the ratio of the number of ETH.RUNE upgrades vs BNB.RUNE upgrades? How has that ratio changed over time?
EVM - 6. Continued Growth?
Jan 30, 2023 - As noted in a recent piece in Cointelegraph, “Ethereum layer-2 networks, such as Polygon, Arbitrum, and Optimism, have gone through an explosive growth phase over the past couple of months, a trend that is set to continue in 2023.” Specifically, there’s been a notable increase in the amount of daily active users, volume traded, and more. Will this growth continue into the new year? Or will L2 growth stagnate as 2023 continues to progress? Back up your assertions with data.
![1. [Easy] Airdrop Stats 1. [Easy] Airdrop Stats](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
1. [Easy] Airdrop Stats
Dec 9, 2021 - This dashboard track the wallet and airdrop claimed by percentage
![Terra Bounty - Anchor Dominance Terra Bounty - Anchor Dominance](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Terra Bounty - Anchor Dominance
Feb 16, 2022 - In this dashboard we will look at the "dominance of Anchor." Anchor is a protocol designed to offer users a low volatility savings product. Currently the protocol targets ~20% APY. With such an attractive product offering (at least relative to traditional finance savings products), it is worth understanding how users are engaging. To do this, we will look at the wallet share that Anchor has for 'active' terra wallets. We define active having transacted on the Terra blockchain within the past 30 days. We define the amount of share in Anchor by looking at the total USD of 'aUST' which is a claim depositors have to the staking rewards from their deposited UST. Below we see that for the average active terra user, about 33% of wallet share is held in aUST, or deposited in Anchor. That seems like a popular savings product!
![Distinct Wallets (zkSync) Distinct Wallets (zkSync)](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Distinct Wallets (zkSync)
Jun 17, 2022 - Q1. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
![Sushiswap
Celsius Swaps Sushiswap
Celsius Swaps](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Sushiswap Celsius Swaps
Jun 19, 2022 - In this dashboard, we examine the transactions of the Celsius network, along with the details of the wallet address of this network and the most token that has been swaped in Sushi and Uniswap.
![Solend Demographics Solend Demographics](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Solend Demographics
Jul 31, 2022 - Q101.Solend is the leading lending protocol on Solana. What are the demographics of the Solend userbase?
Daily Stats on Squid router
Jun 4, 2024 - a review of the transaction volume, value and chain activities on Squid router 13th June