Pipo
Historic Angel Protocol Delegation
Aug 17, 2021 - Angel Protocol is building a world where all charities are financially free.
How stable are the stablecoins on Terra?
Jun 28, 2021 - As shown in graph 1 we can confirm that stablecoins on Terra are very stable. We can see in graph 2 how Luna exchange rate varies across the different stablecoins to stabilize them. In graph 3 taking UST as reference, we can see that this stablecoin has performed remarkably well in the last 6 months showing almost no fluctuations from peg except for some days.
ERC20 Tokens (zkSync)
Jun 17, 2022 - * Analysis is based on the last 60 days and figures for all charts reflect deposits into ZkSync. I took the Top 10 ERC20 tokens.
Measuring Risk
Aug 3, 2021 - New users coming to Terra network is the basis to grow the ecosystem long term. As the network continues growing the risk of having less users constitute a huge challenge for both sustainable price, build of trust and keeping the community involved. Hence, new users are a good way of measuring risk for each of Terra’s protocols. To understand the dynamics of the different protocols within Terra ecosystem we could see what is the relationship between new users and new protocol launches (in this case Terraswap, Anchor and Mirror). On the other hand, delegators play an essential role in the Terra ecosystem. For those Luna holders that decide not to run validations themselves, they can actually delegate their tokens to validators who run the nodes. In return they will get rewarded. Delegators also play an active role in keeping validators accountable. Once they stake their tokens delegators have to keep an eye so that validators behave properly (maintaining Uptime of 100%, reasonable commissions, self-delegate as much as possible and not having a very high voting power). Ideally the delegator should aim to keep this as top priority, thus the ecosystem will be more decentralized and validations will run smoothly and everyone in the community will get rewarded their fair share. That said, it would be interesting to see what are the total volumes transacted in each protocol broken down by delegators and non-delegators. As we get to understand the dynamics of volumes transacted between them, we can also establish this as a metric to measure risk in each protocol. Low delegator volumes against non-delegators could eventually be a problem for the sustainability of the Terra ecosystem medium and long term.
Whale Spotting
Jul 3, 2021 - As shown in graph 1, whales are defined as delegator addresses having more than $1M in amount staked in the last 60 days. As shown in graph 2, whales are defined as delegator addresses having more than $100K in amount staking rewards in the last 60 days. As shown in graph 3 and 4, whales are defined as addresses having more than $100K daily average on swapped amount in the last 60 days. *All figures in USD
Terra-UNI Airdrop Recipients
Aug 31, 2021 - Assumptions: Unique transactions ID in Uniswap v2 refers to unique UNI holders in regards to original Mirror airdrop to UNI holders and all addresses in Uniswap v2 are holders of UNI tokens. Those addresses that can claim are actually stakers in regards to original Mirror airdrop to LUNA stakers.
Polygon Scavenger Hunt: Bentobox
May 25, 2022 - Unfortunately things didn't go according to plan, but I tried several things which let me immerse myself even more into the Sushiswap ecosystem!
Supplied Token Comparison
Jun 16, 2021 - Graph below is based on the most recent timestamp (2021-06-16 at 5:00am).
Validator Ranking
Jul 10, 2021 - Graph 1 shows us Top10 validators by rewards received throughout last month. Even though the same trend is reflected going into July, we can see in graph 2 that from all Top10 validators throughout June, only one, in this case Mr. K (highlighted in red), was Out of Top10 during July month to date. (currently sitting at number 13 in terms of volume). Certus One increased its rewards getting into the Top10 this month as shown in the volume (highlighted in purple). Comparing those validators that were Top 10 and out of Top 10 throughout June in graph 3 and 4 respectively, overall we can see that their behavior over a span of 2 months is quite flat, getting steady rewards throughout this time. We could highlight though two validators, in this case “Orion.Money” who showed a steady growth since the first week up till the last week of June and “hashed” who had a big drop the last two weeks (both in graph 3). *Figures based on Luna tokens
Governance Proposal Types
Aug 25, 2021 - For this analysis I considered as standard governance proposals all other proposals that are not text proposals.
Voting Behavior
Jul 7, 2021 - For latest 5 proposals, proposal 4 had the most voting counts; 148 voters, 2 against proposal.
My Terra Explorer Hunt journey...
Jun 25, 2021 - ... a lot of fun and impressive low and fast transactional fees as well as user-friendly protocols.
Unique Users
Jul 27, 2021 - I defined a user as an address with a non-zero balance. The date they join the Terra ecosystem is actually the first day where the address had a non-zero balance. To understand how many unique new users have been onboarding to Terra per day, I decided to consider all new users from the start of the year. For Mirror and Anchor I used a slightly different approach. I considered the user’s join date as the first date the user (sender address) showed any kind of activity. This will help us understand the user activity for both apps.
User activity in NFTX vaults
Jun 13, 2022 - A couple of definitions to keep in mind for this analysis: * Data based on the last 60 days. * Liquidity from NFTX vaults refers to transfers and trades. * Total sales volume refers to transactions where someone redeemed their NFTX tokens for a specific NFT. * I decided to filter down to the Top 10 NFT projects in terms of Total Value Locked in the NFTX platform to analyse user activity. * Due to missing fields in the ethereum.core.fact_event_logs table, below a snapshot of the Top 10 NFT projects by TVL. '0xb47e3cd837dDF8e4c57F05d70Ab865de6e193BBB' --> cryptopunks '0x8a90CAb2b38dba80c64b7734e58Ee1dB38B8992e' --> doodle 0x521f9C7505005CFA19A8E5786a9c3c9c9F5e6f42' --> wizard '0x7Bd29408f11D2bFC23c34f18275bBf23bB716Bc7' --> meeb '0x5Af0D9827E0c53E4799BB226655A1de152A425a5' --> mylady '0x059EDD72Cd353dF5106D2B9cC5ab83a52287aC3a' --> sqgl '0xe785E82358879F061BC3dcAC6f0444462D4b5330' --> wow '0x60E4d786628Fea6478F785A6d7e704777c86a7c6' --> mayc '0x34d85c9CDeB23FA97cb08333b511ac86E1C4E258' --> otherdeed '0xFF9C1b15B16263C61d017ee9F65C50e4AE0113D7' --> loot * Due to missing fields in the ethereum.core.ez_nft_sales table, as reflected in the second graph, 'null' refers to the Moshi Mochi project.
KRT vs. UST Users
Aug 25, 2021 - * Total USD volume and average number of transactions for both UST and KRT holders are based on balance on August 25th 2021.
Self-Validating
Jul 26, 2021 - After investigating Top 5 validators based on amount of LUNA rewards as shown in first graph I decided to only consider ‘staking/MsgDelegate’ as msg_type to keep the analysis simple. *All data based on last 2 months.
ETH Interest
Aug 31, 2021 - *Data based on last 180 days across all AAVE versions, WETH and ETH tokens combined.
stETH vs ETH
Jun 8, 2022 - stETH is a token that represents staked ether in Lido, combining the value of initial deposit + staking rewards. stETH tokens are pegged 1:1 to the ETH staked with Lido and can be used as one would use ether, allowing users to earn Eth2 staking rewards whilst benefiting from Defi yields.