NFTerra , Part 1: NFT sales on RandomEarth.io
Dec 12, 2021 - This analytics is done to visualize the NFT sales dynamics on Randomearth.io for the moth of December as of 12th December 2021. NFT stands for “non-fungible token,” and it can technically contain anything digital, including drawings, animated GIFs, songs, or items in video games. Non-fungible means it is individual. The opposite, fungible, has examples like bitcoin. One bitcoin can be swapped for another; they are identical. Randomearth.io is a marketplace that provide platform for buying and selling NFTs on the Terra Ecosystem. They also act as NFT launchpad.
New User inflow on Terra
Oct 22, 2021 - In this analytics, I am going to share the number of new user inflow. To measure this, I counted the number of users on the first date that show non-zero balance on their wallet. The explanation can be found on this article and the SQL code
First Time Deposits at Mango Markets
Feb 20, 2022 - In this analytics, we will discuss the Number of new users making deposits into Mango Markets, Amount of SOL Deposited, and Average SoL Deposited. This analytics will focus on cases after 10th February 2022.
THORchain: Nett Liquidity
Dec 18, 2021 - In this analytics, I will attempt to visualize the Nett liquidity of RUNE for LPs on THORchain
Lockdrops Keep Fallin' On My Head
Jan 27, 2022 - This analytics is done to discuss Lockdrop and Astro Token Price
Swap Size of Assets on Thorchain
Dec 5, 2021 - In this, analytics, I will attempt to visualize the distribution of offered assets on Thorchain.
$OP Airdrop (Redux)
Nov 12, 2022 - This dashboard is created to visualize the Volume of $OP airdrop and how many address are receiving it.
AAVE - Gas Prices and Deposit/Borrow Amounts
Nov 6, 2021 - In this analytics, I will attempt to visualize the Gas Price In relation to Deposit and Borrow amounts. For simplification, I will limit the data gathered from Ethereum Mainnet and cases since June 2021 till early November. the gas Price is also represented in terms of per 100,000 for visualization.
Liquidity-Thorchain
Nov 7, 2021 - This analytics is done to visualize the percentage wallets that have removed at least some of the liquidity
Terra: New Validators
Dec 11, 2021 - This analytics is done to measure the metrics of new validators of Terra ecosystem from the past 60 days ( as of 12th Oct 2021). Validators run full nodes, participate in consensus by broadcasting votes, commit new blocks to the blockchain, and participate in governance of the blockchain. Validators are able to cast votes on behalf of their delegators.
Open Analytics Bounty: Avalanche
Aug 5, 2022 - This Dashboard is done to give the general overview of NFT environment on Avalanche. Towards the end , I attempted to identify the most profitable address & and address that has most sell txn address. The idea is to lists high performance NFT user address that allows me to copytrade their NFT purchase
Thorchain Wealth Distribution
Nov 6, 2021 - This analytics is done to visualize the wealth distribution on Thorchain
Swaps metric by pool on Thorchain
Nov 2, 2021 - This Analytics is done to visualize the swap metrics on Thorchain.
LUNA & Drawdowns
Apr 13, 2022 - Evaluate the price performance of LUNA following liquidation-inducing drawdowns. What is the average time (days) for LUNA to recover its previous price level. How does this period change relative to the size of the drawdown (in percentage terms)?
Wormhole User Personas
Jan 11, 2022 - This analytics is done to visualize the kind of investors/users of Wormhole users on Terra. The interest of this study is to determine the LUNA balance in their wallet since January 2022. Is it Liquid, Staked or Both?
MINE Staking Over Time compared to LUNA
Oct 31, 2021 - In this analytics we will compare MINE staked in Pylon governance compared to Luna staked to validator nodes.
Liquidity Provision
Nov 1, 2021 - In this analytics, I will tabulate the daily metrics of each LP in terms of liquidity volume added/removed and The number of unique address that added or remove LP .
THORChain Network Shutdown
Nov 24, 2021 - In this analytics, I am going to analyze the user behavior on Thorchain for the month of November. This is due to the Thorchain operation being halted on 12th Nov till 17th Nov. It became online again on 18th Nov This analytics is focusing on address that remove liquidity after Thorchain become operational again on 18th Nov.
Collateralization ratio of Top 10
Oct 31, 2021 - We will visualize the collateralization ratio of Top 10 AAVE staker
Transactions on Wormhole: UST
Jan 10, 2022 - This analytics concerns the metrics of transaction made on Wormhole, a bridge platform to transfer assets across chains. We are specifically going to study the metrics in terms of transaction count, number of user and the volume. For simplicity, this study concerns with UST as the asset to be studied. This is because UST has much more utility in other blockchain than LUNA, thus why it is chosen as case study.
THORswap Airdrop
Nov 24, 2021 - This analytics is done to visualize the airdrop use among the recipient on Ethereum Network.
Daily Volume of Luna and UST across Terra-Ethereum bridge
Sep 23, 2021 - The analysis of daily volume of Luna and UST, observed in Terra to Ethereum bridge.
Staking Yield, Mvmt 1: The Basics
Jan 18, 2022 - This analytics is done to study the relation between staking rewards and LUNA price. "Staking" is an operation where a user delegates and lock their LUNA to a validators certain amount of time. Validators that receives stake gains voting power based on their LUNA delegations. Stakers earns fees when they staked LUNA, they`e paid in LUNA, USTs and other stablecoins.
THORchain: LP Duration
Dec 19, 2021 - This analytics is done to measure the duration of users who have provided LP using RUNE on THORchain.