Great blockchain insights with PARSIQ triggers for AXS
- Authors
- Name
- Pavel Fedotov
- @pfedprog
In this project we utilize PARSIQ Smart Triggers and Google Spreadsheets integration to track and visualize AXS token transfers on Ethereum and Binance Smart Chain that involves most liquid exchanges.
AXS is an Ethereum token that powers Axie Infinity, a blockchain-based game where players can battle, collect, and build a digital kingdom for their pets. AXS holders can claim rewards for staking their tokens, playing the game, and participating in governance. The token is available on multiple chains including Ethereum and Binance Smart Chain.
On April 28 2021 the game has made a significant update introducing Ronin Bridge, Axie Infinity Ethereum side chain. The contract has since become the crucial link in the Axie Infinity ecosystem and largely contributes to the price action of AXS. With the update the bridge has become the only available option for Axie marketplace, breeding, and morphing contracts.
The idea for the project comes from the fact that on the Binance Exchange the highest earning product in Locked staking is AXS with an estimated APY of 131.25% far outperforming any similar product on the exchange.
In order to justify such returns the company would usually rely on large inflows and minor outflows from the cryptocurrency. Therefore, monitoring the most liquid day-to-day endpoints provides an indicator of the success of the staking solution.
Trigger for Token transfer from or to Binance Account of SPL or AXS token on Ethereum
Apart from collecting the data from the transaction we collect data using Chainlink and CryptoRank.
stream _
from TokenTransfers
where (@from == AXScontract || @to == AXScontract || @from == Binance14 || @to == Binance14) && (@erc20.symbol == "AXS" || @erc20.symbol == "SLP")
process
let symbol = @erc20.symbol
let cryptorankFiatRate = getRate(symbol)
let fiat_value = @value * cryptorankFiatRate.value
let fiat_decimals = @erc20.decimals + cryptorankFiatRate.decimals
let eth_usd_pair = getChainlinkPriceFeedPair("ETH/USD")
let score_from = getScore(@from)
let score_to = getScore(@to)
emit {@action_type, @block_hash, @code_address, @from, @gas_used, @origin, @to, @value, fiat_value, fiat_decimals, eth_usd_pair, @tx_hash, symbol, @block_timestamp, @gas_price, score_from, score_to }
end
Trigger for Token transfer from or to Binance Accounts of AXS token on Bsc
stream _
from BscBEP20Transfers
where (@token.contract == ContractBSC) && (@from in BSCdata || @to in BSCdata)
process
emit { @from, @to, @value, @token, @transaction, @block }
end
User Data
Parsiq Primitives:
Parsiq Table:
Ethereum Axie Infinity Analysis
There are 231 AXS token transactions in our ethereum dataset. Only 46 are from Ronin and Binance accounts.
Meanwhile, the rest 80% are coming to Ronin and Binance accounts.
There are also more transactions to the native staking solution rather than Binance by a factor of 2. Nevertheless, when we analyze the volume of outflows vs. inflows the sum of outflows dominate.
This would indicate more incoming users and one or few significant withdrawals from Binance. We look at the more granular data and notice that one account is responsible for such bleak snapshot of AXS flows.
Furthermore, we plot full ethereum dataset value of transactions against time. When plotted the inflows have a lot of spikes and more numerous for Binance.
While the outflows are more steady.
This picture is very similar for only AXS. With two spikes in Binance outflows against 0 in Ronin Bridge.
We would need to further incorporate more data in our analysis to determine the scope of weekly and monthly flows in AXS token.
BSC AXS Analysis
In our BSC dataset we have 157 observations. The count of transactions is in favour of outflows from Binance Hot Wallets.
Whereas the sum of transferred AXS value out of Binance is nearly identical to the inflows.
Comparison of AXS on BSC and Ethereum
The volume of transactions is much greater on Ethereum of AXS than on Binance Smart Chain.
Score of the addresses (in-built PARSIQ function)
In our AXS dataset on Ethereum we also obtained scores for addresses by using getScore
in our trigger. What is interesting is that the system scores higher the Binance account (85) rather than Ronin Bridge (76). Besides, the average address that transacts to Ronin has score of 79. For Binance this figure is 80. For outflows the number is 79 for Ronin and 77 for Binance.
Further Resources and Related Posts
- GitHub repository for AXS PARSIQ triggers
- CryptoPunks with PARSIQ
- How to generate parsiq wallet triggers for CryptoPunks
- Axie Infinity Great Migration FAQ
- Python Notebook on Kaggle
- Blockchain Data Indexer with TrueBlocks
- Advanced Realized Volatility and Quarticity
- Machine Learning with Sklearn
- How to illustrate log returns vs simple returns
- A How to EfficientNet Classification