kipto
Governance Period 2 Payouts
Apr 10, 2022 - Q49. Let's look at the Algorand Period 2 Governance Rewards Payouts
Fact table for starting and stopping lending on Sushi
Mar 16, 2022 - We create a fact table to draw insights from Sushi's lending service Kashi.
Swapping for YLDLY on DEXs
May 22, 2022 - Q77. Let’s get a better understanding of how people are swapping Yieldly(YLDY: Asset ID: 226701642).
Question 2: Which liquidity pools and platforms are users using to acquire BANK tokens? Which tokens are being swapped most to acquire BANK tokens?
Mar 8, 2022 - Blockchain data always has a lot of noise, distinguishing the trading from the acquisition of BANK tokens permanently is hard. In this dashboard we simplify things and look at the on-chain decentralized exchange swaps where a token has been used to acquire the BANK token (0x2d94aa3e47d9d5024503ca8491fce9a2fb4da198). We sum up the transaction counts and the token value in USD from past 1000 days. Similarly, for the liquidity pools and the platforms, we look at the on-chain decentralized exchange swaps and sum the transaction counts and the USD amount (see code bottom to reproduce the analysis). Looking at the platforms, we see that 2 main platforms on ethereum mainnet are used: Sushiswap 55 % in USD value of transactions, Uniswap v2 and v3 45 % in USD value of transactions.
SOL OpenSea vs Magic Eden
Apr 12, 2022 - Q53. OpenSea launched its SOL compatibility on 4/6 - giving the SOL NFT landscape access to the largest source of NFT liquidity. However, Magic Eden remains the top NFT marketplace on SOL.
Transaction Fees (Osmosis)
May 23, 2022 - How many transaction fees are being paid out each day for the past 30 days? Does a certain type of transaction result in a greater amount of fees being collected?
ETH Staked
Jun 15, 2022 - Q9. What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
Top TOKE Holders
Jun 22, 2022 - Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
Looking For Swap Arbitrage
Mar 31, 2022 - Q42. Let’s see if we can find any wallets profiting from arbitrage on the Algorand DEXes. We specifically want to see if anyone is conducting arbitrage with USDT or USDC, Asset ID 31566704 or 312769. The period we will want to look at is From January 1st 2022 to the current. We will want to grab wallets swapping USDC or USDT to another asset then their next swap being back out of that other asset(with the same amount of it) back to USDT or USDC in their next transaction. If we find wallets conducting this behavior, let’s look if they end up with more USDT or USDC they started within the initial swap. If we find users doing this, let's look at the top 10 wallets successfully earning more USDT or USDC. What assets do we see them swapping for when they commit this arbitrage? Show and explain your methodology if we don't see this arbitrage occurring.