ahkek76
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
103. [Elite] From Terra, With Love
Dec 1, 2021 - This dashboard analyze and track the volume and transaction of wormhole bridge from terra mainly UST. Wormhole introduced cross-chain bridge capable to bridge between solana, ethereum, bsc, polygon and terra. We will look into those bridge UST to analyze on their behavior
49. [Hard] Anchor Impact on UST
Aug 25, 2021 - This dashboard we are tracking the overall ust supply vs total ust deposit on anchor and trying to compute the percentage of it
55. [Hard] Terra-UNI Airdrop Recipients
Aug 31, 2021 - MIR airdrop for both UNI holder and LUNA staker is to encourage activities on mirror protocol. This acts as incentives for them to prodive liquidity or even perform trades over mirror protocol. This dashboard will track the users that claiming the airdrop and analysis regarding that.
Validator Pageant - galactic punk validators
Mar 12, 2022 - This dashboard analyze our favorite new validator which are not the top 10 validators on terra
6. [Easy] Number of LPs
Oct 27, 2021 - This dashboard track the number of LPs by pool today and daily
52. [Easy] Multiple Delegations
Aug 24, 2021 - This dashboard we compared the number of delegator that delegate once, delegate more than once and delegator who delegate to same validator the second time
State of the State
Mar 6, 2022 - This dashboard are trying to evaluate the UST peg graph on terra console by flipside
33. [Easy] Anchor Collateral Ratio
Aug 4, 2021 - This dashboard analyze the collateral ratio and the behavior on anchor
47. [Hard] Uniswap Volume Projections
Aug 15, 2021 - This dashboard we analyze the past swap history on uniswap compared to other metric to see if there is any correlated and from there we hope we can predict the coming swap volume based on historical data.
49. Node RUNE in/outflows
Feb 9, 2022 - The emission curve on thorchain had being reduced starting block 3704556 and we will see the swapping volume of rune by those node operator.
54. [Hard] Delegator Churn
Aug 31, 2021 - Delegator churn give meaning of redelegate or delegate to other choices. In terra delegator churn means redelegate their luna to other validators. In this dashboard we will track the redelegation activities.
5. Curated vs. Playground vs. Factory
Sep 7, 2021 - This dashboard track all 3 type of art block project by comparing the volume in transaction, unique buyers, average price and total token available.
40. Common LP Pairs
Jan 12, 2022 - This dashboard track those common lp that provide more than 1 pool on thorchain
21. [Elite] THORSwap Airdrop
Dec 1, 2021 - This dashboard track the thorswap airdrop and their post-behavior. We will look into and compare both and separate completely to solely airdrop owner and solely ido buyer to ease our differentiation
17. [Hard] Compare Native Swaps to Terra Swaps
Jul 11, 2021 - The first table showed the top 10 pools each 5 pools from native swap and others 5 from terraswap (capital letter = native swap, smaller letter = terraswap). Next we only extract the volume for the past 7 days and plot out the ratio of both swap. The ratio of volume swap by terraswap vs native swap sit at 99% and above. Next chart showing which pool has the most volume swapped. Top 3 pool is by terraswap which is (ukrw-uusd, ukrw-uluna, uluna-umnt) Finally we see the unique trade on each pool Top 2 pool which had the most number of unique trade is uluna-uusd and UST to LUNA. Here we could see the adoption of luna by small retailers which only comprised a small volume on the pools. However, the pairs ukrw- uusd had only 1000 unique traders and had the highest volume. This is a sign of WHALE in trading the currency here.
121. [Hard] Top Anchor Users: Part 1
Dec 21, 2021 - Anchor protocol is powerful in term of their mechanics behind the stable yield of 19% apy. In this dashboard we will look into the top anchor users.
Realized APY - ETH & THOR pool performance
May 17, 2022 - This dashboard track and compute the average realized APY for ETH and THOR pool
10. [Easy] How is UST Being Used?
Jul 4, 2021 - Top 5 protocol in UST usage including mirror, anchor and terraswap. The highest volume come from mirror as people are minting synths asset on mirror and trade against UST and mAsset. Next goes to Anchor which people deposit to earn the stable 20% apy on UST.
66. [Easy] Gas Used vs Gas Limit
Sep 12, 2021 - This dashboard compared the gas used vs gas limit on LUNA vs ETH on largest transactions. Gas used is the amount of gas had being used in confirming the transactions Gas limit is the maximum amount of Gas that a user is willing to pay for performing this action or confirming a transaction. If users want to confirm their transactions fast, they will increase their gas near to gas limit for faster confirmation and vice versa
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.
Steady As She Goes
Mar 1, 2022 - This dashboard give a quick overview of LUNA price action compared to some other cryptocurrencies
LP Size Distribution
May 3, 2022 - This dashboard track and analyze those current LP size distribution
4. Art Blocks Collections
Sep 8, 2021 - This dashboard track the art block playground project that is undervalue among the 7 collection
Scavenger hunt - polygon
Aug 21, 2021 - 1 . Deposit matic from other wallet 2. deposit matic into aave
126. [Hard] Liquidation Risk
Dec 25, 2021 - This dashboard track the liquidation over ANCHOR and spot the next trend
32. [Easy] Anchor Deposits
Aug 3, 2021 - This dashboard track and analyze anchor deposit on UST
#3 Liquidity Journey
Nov 17, 2021 - This dashboard are showing the sushiswap lps in managing their liquidity in term of SLP, sushi and xsushi
39. [Easy] Active Addresses
Aug 10, 2021 - Here we track to see the total addresses that are active on JUNE 30 from Q1 2020 which they had delegated
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.
33. - Price Status Quo
Jan 29, 2022 - This dashboard track the movement of sushi price and compare it with others trend
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
Beginner bounty for compound
Jun 16, 2021 - 52. Average Loan Amount 53. Who is most in debt? 54. Supplied Token Comparison I submit all question together
Flash bounty LTV ratio
Jan 16, 2022 - This dashboard track the stat of anchor borrower for all the LTV stats including average LTV, median LTV, 90 percentile, 10 percentile of LTV. Liquidations stats of anchor users also included in this dashboard. All the data will be for the latest 90 days
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)