Daily stETH Metrics
Oct 10, 2021 - Below are the analytics I have gathered regarding stETH from the database
Crypto-Cosmology: Wormhole Part 1
Nov 23, 2021 - In this analytics, I am going to visualize the traffic and metrics of Users who utilizes Wormhole to send crypto across different crypto eco-system/ Chains.
143. Liquidity Space Voyage / Mini-Terra Tutorial
Dec 18, 2021 - This analytics is done to measure the migration of LP from Terraswap to Astroport. Terraswap is a placeholder swap instrument for Terra Ecosystem. A dedicated swap instrument was released on 6th December 2021; Astroport.fi. Thus, we are going to study the migration of lp, bLUNA-LUNA from Terraswap to Astroport.
Sushiswap Weekly Fees
Nov 20, 2021 - This Analytics is done to analyze the weekly fees of transaction to sushiswap. For simplification, we are going to consider transactions with to_label=sushiswap.
THOR assets: Price Correlation
Dec 14, 2021 - This analytics is done to visualize the average daily price change of RUNE, XRUNE and THOR.
Swapping
Oct 28, 2021 - In this analytics we will analyze the metrics of swapping based on pool and day
140. Anchor Collateralization
Jan 30, 2022 - This analytics is done to visualize the amount of collateral provided on Anchor; bLUNA or bETH. ANchor allows user to borrow UST by offering collateralized borrowing. We are going to study the change in the collateral metrics for the past 90 days
It's the Catalina Whale Mixer
May 14, 2022 - Catalina Whale is a NFT project acting as Web 3 entertainment-franchise on Solana. It was hyped as it was brought by experienced team. Recently, an announcement was made that CWM holders are entitled to Whitelist of Bubblegoose Ballers, which may caused the increase in aftermarket floor price
ANC: What Happens to the Loot?
Dec 18, 2021 - In this analytics, I am going to visualize the the factor that impact of ANC stakers, selling their ANC tokens. The factor that is suspected here is Luna Price. Case to be disvussed here is limited from 1st OCT 2021 for simplification
Stablecoin Arbitrage on Jupiter
Mar 20, 2022 - Arbitrage is a trading strategy that take advantage when there is a price difference/ exchange rate of asset pairs on different markets. This analytics is done to study the arbitrage trading dynamics on Jupiter, a dex swaps aggregator on Solana Ecosystem. This study concerns with case that starts form 1st February 2022.
100. [Very Easy] Verify Flipside's Validator Activity!
Oct 25, 2021 - Hi, in this analytics, I will attempt to measure the inflow and outflow of LUNA at Flipside Validator address
Lexus Nexus Hunt
Nov 19, 2021 - This analytics is to visualize my transactions to acquire PSI and provide PSI_UST liquidity
Do Whales Have Diamond Hands?
Jun 19, 2022 - Part A - Discuss the outcome of the study Part B- Methodology
Solana Stables
May 15, 2022 - Stablecoin is a crypto prodduct offered to provide hedging by retaining their values in real world paper money price, typically the USD. When a stablecoin fails to retain this valuation, it is said to lose its peg. Recently, UST, a Terra Stablecoin, crashes on Ethereum, causing people to redeem their UST to avoid loses.
Top Anchor Users: Part 1
Dec 18, 2021 - This Analytics is done to measure the Power Users of Anchor. Anchor is a collateral lending instrument for Terra ecosystem.
HALO:LBP Analysis, Part 2
Dec 29, 2021 - This analytics is done to visualize the participants of HALO LBP activity and how they utilize the instruments in Terra ecosystem
What Happens To Liquidated Collateral
Apr 13, 2022 - Q179. What do users do with liquidated collateral after winning a bid? Possible actions are: sell, swap (i.e. bLUNA->LUNA), hold, deposit into Anchor, etc.
State of the Art
Mar 6, 2022 - Terra Dashboard 2.0 This dashboard is made to measure your bags based on the whole entire Terra Ecosystem. ( change your address in the SQL to see your measure)
Sunchaser Hunt
Oct 10, 2021 - Hi, below I have provided my prove of transaction in Apollo DAO for Sunchaser Hunt
Transactions fee per asset on Mirror
Nov 20, 2021 - In this analytics, I will attempt to visualize the fee per asset transaction on Mirror. We are only condisering 5 mAsset for simplification; mBABA, mTWTR, mSLV, mGME, and mQQQ. This SQL is failed to visualize as chart due to failure of converting variable to real values(FEE)