ahkek76
Uniswap v3 early users
May 25, 2021 - There is not many user migrate to uniswap v3. Mostly are due to the high gas fees to add liquidity to uniswap v3
COMP APY EXPLORATION
May 16, 2021 - The APY changes due to to total supply and total borrows changes in compound finance.
34. - Gaming Tokens
Jan 30, 2022 - This dashboard track the top gaming tokens traded on sushiswap and some analysis on it
Sand land sale and sand token price movement
Jul 4, 2021 - Land are limited on sand and lesser and lesser land available as sales going on. Here we track the sale in eth and sand token of each Land Sale on sand If we put the chart of sand token according to the sale, we can see it is 80% correlated Next we also see the sand circulating supply , sand in cex and sand stake in uniswap v2
Have staking rewards impacted the amount of $RUNE bonded or in LPs?
May 24, 2022 - This dashboard give quick overview on changes of RUNE bonded and LPs after staking 2.0 launched
18. [Hard] Anchor Repayments
Jul 11, 2021 - Current debt outstanding sitting at 255 million and cumulative repay had reach 856 million! if we look further into the cumulative borrower and repayer of anchor. One find interesting that the number of borrower reached 216k people and number of repayer reached 50k. Total borrowed = 1.1billion Total borrower = 216k Total repay = 856 million Total repayer = 50k Ratio between repayer / borrower = 50k / 216k = 23.1% Ratio between repay / borrowed = 856 / 1100 = 77.8% Less Borrower Paying back MORE!!!
#3 Liquidity Journey
Nov 17, 2021 - This dashboard are showing the sushiswap lps in managing their liquidity in term of SLP, sushi and xsushi
#4 User Journey and Outflows
Nov 17, 2021 - This dashboard track number of users leaving sushi and where did they go
22. [Hard] New User Activity
Jul 18, 2021 - In this dashboard we will be tracking the user using terra bride from eth and from binance deposit and consider them as new user. Notice how the spike of new user inflow to terra on around 16 Mar 2021 Next we will dive deep into each protocol like anchor, mirror and terraswap to see their activity. After seeing all the chart , we can say the new user are main came for anchor protocol and less interested in mirror mAssets and at the same time the highest token provided in terraswap is also bluna and ANC token
3. [Hard] Token Activity
Dec 15, 2021 - This dashboard dive deep into PSP token activities. For simplicity we only focus on those who getting airdrop. What did they do with all the claimed PSP? Did they sell or stake it? We will go dive down into the dashboard
NFT Minted ALL TIME
Oct 16, 2024 - "This dashboard tracks and monitors NFT minting activity across various blockchains. It includes data on NFTs minted, minters, and new minters from different blockchains." Let me know if you'd like any further adjustments!
Token swap analysis and LPs percentage in top pools dashboard
May 31, 2021 - First we need to see the genuine volume by dex. Swap must be mostly from trader but not LP. For new LP, users can analyze which token being trade and swap the most in v3. This make them to aim joining pool with these token. Next to avoid being control by big whale, one need to notice the LPs percentage and gini index to make sure the liquidity concentrated in more LP hand.
$MEME Airdrop Status 🪂
Nov 5, 2023 - This dashboard track the distribution of $MEME airdrop status and claimer
Around & Around We Go (Circulating Supply)
Feb 23, 2022 - This dashboard simply track the LUNA supply statistic
$THOR Staking Distribution
May 24, 2022 - This dashboard track and compute out the current staking distributio of THOR
34. [Hard] DeFi Users vs. Newbies
Jul 4, 2021 - In this dashboard, we extract only uniswap v3 LP to comparing in their history. First is their wallet balance, From the spike in Feb, we seen tons of cETH is being held on their wallet. Uniswap v3 LP is also compound users. Next we check where else do they deposit to and we find out the top 5 protocol is harvest, weth, dydx, aave and compound. Next we see the trend of their uni holding in percentage. There is sudden spike in mid April which correlate with the uniswap v3 teaser showing up. Hence uniswap v3 user is coming from others protocol like compound or aave and only join in late on mid April.
122. [Hard] What Happens to the Loot
Dec 21, 2021 - This dashboard track the to what extend ANC stakers are selling their ANC. We will only look into top 100 stakers as they carry significant amount of ANC which can determine the movement of price (somehow)
92. [Loop] Airdrop Actually Claimed
Oct 20, 2021 - This dashboard track the airdrop on LOOP market
Hop Whales
Jun 22, 2022 - This dashboard will compare the native bridges for polygon, optimism, arbitrum and Hop bridges. For fairness we will only compare the bridges in ETH. We will also see the top transactions in bridging over their ETH to see whale behaviour.
34. [Hard] UST "Collateralization
Aug 4, 2021 - Since for each USDC there is one USD to be back by it. Hence we are looking into the collateral of UST to be back by 1 dollar value of LUNA. We will compared only the circulating supply of LUNA as it can be manipulate now on current market and affect the supply of UST. Luna is essential in maintaining the peg of UST to 1 dollar. The ideal ratio is always more value of LUNA to be back for each UST. If there is less value of LUNA to circulating supply of UST the system is considered as failure and each UST is not worth 1 usd. (the market cap of LUNA might be slightly incorrect due to some query problem)
1. [Easy] Inflows and Outflows on Polygon
Aug 25, 2021 - This dashboard we are tracking the inflow and outflow on polygon for both plasma and pos bridge
Moonbirds Crossovers - 6 bluechip NFT
May 2, 2022 - This dashboard analyze the moonbird holders crossover with other 6 bluechip NFT
69. [Hard] KRT vs UST Activity
Sep 14, 2021 - This dashboard will analyze most of the activity done by separable KRT and UST users. One come to Terra will go to staking, swap, provide liquidity or deposit on anchor for stable yield. We will go through one by one and see the difference between their behavior
24. 🍳 [Easy] Largest Liquidity Pools
Jun 11, 2021 - TVL of largest 3 liquidity pool in v2 is dropping and TVL of largest 3 pool in v3 is increasing And the trend is same for lp deposit and withdrawing LP action decreasing in v2 and increasing in v3
Anchor Dominance
Feb 13, 2022 - Anchor is a protocol built on terra blockchain which enables lending, borrowing and saving. More than half of Terra TVL is contributed by anchor protocol. This dashboard will track out the active anchor users over the past 90 days and determine their asset in anchor to wallet holding ratio
33. - Price Status Quo
Jan 29, 2022 - This dashboard track the movement of sushi price and compare it with others trend
0. Free Square Question _ Whale or retailer? Active or Passive investor? Long term investor or short term?
Aug 11, 2021 - Yearn Finance is a suite of products in Decentralized Finance (DeFi) that provides lending aggregation, yield generation, and insurance on the Ethereum blockchain. Yearn are providing vault v2 recently and these vaults benefit users by socializing gas costs, automating the yield generation and rebalancing process, and automatically shifting capital as opportunities arise. Simply put it will compounding your return but in a chepaer way to enable users to cut cost. So basically yearn function like a bank but with higher yield than normal. This dashboard we analyze the behavior and categorize the user to whale and retailers towards the usage of yearn vault. We simply separate into 2 which is whale (more than 100k deposit in single transactions) and retailers (less than 100k in single transactions) To ease the calculation and not making it too complex, we are only looking into popular 10 vault which is 4 stable coin and 6 non stable coin and users that are DIRECT deposit on Yearn ( not include zap in) (USDT, USDC, DAI, SUSD, WBTC, WETH, SNX, YFI, LINK, UNI)
1. [Easy] New Active Users
Dec 14, 2021 - This dashboard analyze the new active users from paraswap. Paraswap is a dex aggregator which enable to route for the cheapest with lowest slippage.
[3. [Easy 🍳] Transaction Fees ]
Jun 25, 2021 - Past 30 days transaction fess on swap and the highest currency on fess is ukrw