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)
Top Lending-Borrowing combo APY on Compound vs Mainnet
Oct 27, 2021 - In this analytic I am trying measure the top 8 APY on compound vs mainnet
Mind Your Ps and Ys
Mar 30, 2022 - Q173. Make your case for the relative value of pLUNA or yLUNA! Define the key inputs to the relative valuation for each; various methods of valuation (discounted flows, comparables, growth-based models) will be accepted as long as you make a reasonable case for them and support them with evidence.. Over a time period of your choosing, how has pLUNA or yLUNA’s price changed as these key inputs have changed? Note: Grand prize winners will assess both pLUNA and yLUNA.
Transaction from Terra to Wormhole
Nov 27, 2021 - In this analytics, I am going to analyze the UST transfer metrics through Wormhole from Tera to Other chains. Wormhole is a communication bridge between Solana and other top decentralized finance (DeFi) networks. Wormhole allows existing projects, platforms, and communities to move tokenized assets seamlessly across blockchains to benefit from Solana's high speed and low cost.
MonkeDAO Whale Voters
Apr 13, 2022 - A month ago, the MonkeDAO pressed the Solana Monkey Business team for various changes to be made to the royalty and NFT structure to foster growth for the collection. Ultimately this resulted in the first NFT on-chain vote on Solana to accept or reject the SMB team's proposal, with a 'no' likely resulting in a separation of the two groups. In the end, the MonkeDAO voted to unify with the SMB team and to grow their relationship together.
End of Year CEX Transfers
Jan 18, 2022 - This analytics is done to visualize the Token flow volume in December and comparing the Early December volume vs End of December Volume
Who is getting Aave Rewards?
Oct 3, 2021 - Hi, I am going to share the debt loan relations regarding CRV-AAVE collateralized pool that is used for lending. This case study considers data samples from 1st Sept 2021. From the table below, we can see that there are only 2 liquidity provider for AAVE-CRV, that is; 0x19256c009781bc2d1545db745af6dfd30c7e9cfa and 0xcbd75d63f98c5ff5d7157edf06abef8a8325c24d The first liquidator provided lending for DAI and USDC token while the later only provided USDC
Thorchain Weekly ROI
Oct 26, 2021 - This analytics is done to measure the Weekly return made on LPs on Thorchain
Max Number of Txn in a minute
Dec 5, 2021 - In this analytics, I will attempt to visualize the max number of txn happening in a minute on Thorchain. This is useful to measure Thorchain capacity to handle high traffic transactions
Airdrop Summary
Oct 12, 2021 - In this analytics I will attempt to summarize about airdrops being claimed by addresses on Terra. For simplification, the case to be discussed is airdrop rewards from Anchor Mariner Hunts and Mirror Hunts. The token distributed after 5th Oct 2021. This can be traced by referring transfers from terra13v8hmfld6747h7fx9gzzqvv80qwz24uvcqwrap, which the address that distributes the airdrops
Levana Participation and transfer Transaction metrics
Nov 13, 2021 - This analytics is done to visualize the percentage of position in Levana Meteors event and the address` remaining transfers position since 90 days. This will show how much address have how much investment in Levana meteors.
Volume of BNB and ETH upgraded to native on Thorchain
Oct 27, 2021 - In this analytics, I will attempt to measure the volume of BNB and ETH upgraded to native Thorchain token from 1st Oct 2021