Software and Data Engineer π
On-Chain Data Analyst π
Code - Python, JS, Java | CI/CD | Data analysis | App Design | Crypto
May 24, 2022 β’ 12 tweets β’ 5 min read
The following analysis is meant to analyse the behavior of users during and after the depeg event of UST. Coincidentally, in the same days @osmosiszone started listing a new stablecoin: USDC. The question is whether users have swapped away from UST and moved to USDC
1/ π§΅
Let's start by looking at the amount of tokens swapped on the UST/OSMO pair. We can see that the amount swapped of both tokens used to range below 20M. After the depeg event however, the trading volume spiked to 120M UST and 40M OSMO.
2/
May 3, 2022 β’ 9 tweets β’ 4 min read
Astro is looking to become a major aspect of the Terra ecosystem in the future. That is why we need to leverage the ability to access on-chain data to inspect what happens in gov (thanks @flipsidecrypto)
I therefore built this PoC dashboard (real data, tho) for @astroport_fi 1/
Astroport page gives already a lot of information on each specific proposal, but does not allow to compare them.
Let's plot the results from each proposal. Have most of the proposals passed? With what ratio of for/against votes? Which have been the most controversial ones? 2/
Mar 28, 2022 β’ 9 tweets β’ 4 min read
Today the $xPRISM - $PRISM has finally offered some interesting arb opportunities again
Today $xPRISM has been cheaper than $PRISM itself - although $xPRISM allows to redeem 1.03 $PRISM after 21 days of unstaking.
This got me thinking: who has created this unbalance? π§΅
1/
To investigate this, we need to start thinking at how the price in the pool might have gotten that cheap
If xPRISM is cheap in the pool with PRISM - it must be because someone has deposited a large amount of xPRISM and withdrawn the corresponding amount of PRISM
2/
However, we can try to understand more of what happened:
- How many users sold their tokens?
- How many bought?
- Who are these users? Had they participated in the lockdrop?
Let me show u what I found π§΅
Let's start with some numbers:
Number of ASTRO tokens sold/bought
- 19.3m ASTRO tokens were sold
- 8.5m ASTRO tokens were bought
A net of 10.7m ASTRO tokens were sold on the market
I looked into some of users behaviours and patterns
- What have users decided to deposit?
- How much UST have users performed?
- What have Phase 1 top depositors deposited in Phase 2?
Let's dive into what the on-chain data shows π§΅π
First of all:
- 18109 total users have participated in Phase 2 of the lockdrop.
Dec 23, 2021 β’ 18 tweets β’ 6 min read
The recent days have seen some volatility in the bLuna-Luna pair.
This presents some arbitrage opportunities.
How often do these occur?
When should you take advantage of them?
When should you not?
This is what we are going to explore in this π§΅
What is arbitrage?
Arbitrage, in the case of AMM and Liquidity Pools, can occur when the unbalance in the pool allows one token to be traded cheaper than it should. In that case arbitrageurs can take advantage of this unbalance and restore balance while making a profit
Dec 21, 2021 β’ 8 tweets β’ 3 min read
In the second part of phase 1 of the @astroport_fi lockdrop users could only withdraw the LP tokens they had deposited.
And guess what. They have. The question is:
How many?
From which pools?
From which lockup periods?
Let's see π§΅π
We counted 555 unique addresses taking advantage of this withdrawing part of phase 1.
What pools have users withdrawn from?
bLuna-Luna is by far the pool from which the most funds have been withdrawn: $5.5m UST and over 250 users withdrawing
I think it is time to make a retrospective analysis of how it went. Ready?
Let me show you π§΅π
NΒ° users: 7215
When was their first interaction?
- Almost 300 users have bid right at the start, at an average price of $0.96
- The second wave happened after 9 hours. This was triggered by the price dropping below $0.20 and the buying pressure raised the average price to $0.32
Problem: locking $UST in Pylon pools is a big commitment given the relatively long timeframes. We are talking about - what it feels like - ages in the crypto space.
Right now users have no way to sell or trade their position in the pool, in case they need to. Once you are in, you are in. You just gotta wait until your lock up period is over.
Nov 21, 2021 β’ 5 tweets β’ 2 min read
So TFL is burning 88 millions of $Luna to $UST to fund different initiatives, most notably Ozone.
Well, you think that is running smoothly?
I thought so too π§΅
And it actually did. Like a swiss clock, every 800th block the community address (terra10kjnhhsgm4jfakr85673and3aw2y4a03598e0m) has been burning 520,000 $Luna for $UST.