kiacrypto
Pleasure to Burn
Feb 28, 2022 - How much LUNA has been burned over the past 30 days? How has the supply of UST changed over the same time period? Display both of these, using visualizations.
Sushi Treasury
Jun 27, 2022 - Q97. What are the in-flows and outflows from sushi treasury? Analyze the trends. Build a dashboard. Hint: Treasury: 0xe94b5eec1fa96ceecbd33ef5baa8d00e4493f4f3 Operations multisig: 0x19b3eb3af5d93b77a5619b047de0eed7115a19e7 Sushi house: 0x7b18913D945242A9c313573E6c99064cd940c6aF
Gas Efficiency
Jun 8, 2022 - Q88. Which one of the sushi services consumes the most gas per transaction? The services to include in your comparison are : -Adding liquidity -Removing liquidity -Adding an asset for lending -Borrowing -Removing an asset from lending -Repaying a loan -Swapping Hint: each of these activities have a special event that only appears for that activity. For instance repaying a loan generates the “LogRepay” event.
Swap Volume and Ukraine War
Apr 18, 2022 - Q68. How has the Ukraine war affected the swap volume on Sushi and Uniswap? Has there been a surge in demand for a particular token?
Sushi Activity on Ethereum
Jun 27, 2022 - Q96. How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lendings? Hint: use the tables in Sushi schema: ethereum.sushi.
Where’s The Pot of Gold?
Mar 23, 2022 - What % of the bAsset market cap for bLUNA and bETH is locked as collateral on Anchor? Show where else bLUNA/bETH is being held, and explain why you think this is.
Governance Reaction to Terra
May 22, 2022 - The period between May 8th - May 13th was a busy week for Osmosis governance. What was the community response like to these proposals? How quickly did these proposals hit quorum compared to the last two months of proposals? What was the voter turnout for these proposals vs the last two months of proposals? Hint: Use the msg_attributes table and select transactions that have an appropriate msg_type for delegator voting.
NFT Buying Behavior on Flow
Jun 12, 2022 - Q10. Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to on Ethereum and Solana. Is there more or less "whale" activity on Flow compared to each of the other chains? What do "whales" tend to focus on in Flow? How common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains, or do wallets tend to hold onto their NFTs? Are wallets more interested in new projects, or already existing projects on Flow?
Secondary Sales Activity
Jun 18, 2022 - Q2. How many Lil Nouns have been sold on a secondary exchange within 24 hours of being minted? Are there any common traits among these Lil Nouns? Which Lil Noun’s have the biggest difference (positive or negative) between their mint price and secondary sale price? Visualize and analyze your findings.
Active Wallet Addresses
Jun 20, 2022 - Q105. We are interested in knowing how many users are currently in the ecosystem. In this case, how many are holding $RUNE in their wallet or have an open LP position. What is this number currently, and how has it trended over time? Hint: use thorchain.liquidity_actions and thorchain.transfers
Head to Head
Mar 30, 2022 - Excluding the respective foundations, what are the top 10 addresses by amount of UST held? What are the top 10 addresses by amount of DAI held? Do you have any guesses to whom those addresses belong?