Largest Tokemak DEX Pools
Jun 22, 2022 - Q3. What are the largest dex pools for TOKE (UNI, SUSHI, etc.)? What is the behavior of TOKE holders on these token pools currently?
Secondary Sales Activity
Jun 17, 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.
Bridge Volume (Optimism Bridge)
Jun 15, 2022 - Q2. Compare user bridge volume on the Optimism Native Token Bridge vs. another Mainnet <-> Optimism Bridge of your choosing (e.g. Hop). Can we conclude if there are differences in the types of users or transactions using the native bridge vs. the non-native bridge?
Algorand Price Correlation
Jun 27, 2022 - Q109. Is the price of Algorand more closely correlated with the crypto market, and assets such as BTC or ETH, or is it more correlated with network usage such as number of transactions or ALGO transfers? How does this compare to other networks such as Solana? Note your findings and anything else that may be interesting in relation to Algorand's price movement!
ETH Deposited or Withdrawn
Jun 25, 2022 - Q1. Starknet is a layer 2 chain, like polygon, that ensures interoperability with Ethereum mainnet. People are using it to move real ETH to starknet and enjoy its higher speed of transaction and lower fees. How many ETHs have been deposited or withdrawn (bridged) so far from Ethereum to starknet or vice versa? and by how many depositors?
Bridge Transactions (Across)
Jun 19, 2022 - Q1. Analyze bridge transactions via the Across bridge over the last two weeks. What assets are users bridging from Ethereum, and to what chains? Across transaction event data is undecoded in the Ethereum core tables. Users can use these functions to parse and decode the data: regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data ethereum.public.udf_hex_to_int() Hint: A user begins a bridge transaction by calling the deposit function on the SpokePool contract from the origin chain. Ethereum SpokePool contract : 0x4D9079Bb4165aeb4084c526a32695dCfd2F77381
SUSHI Noobs II
Jun 19, 2022 - Q94. What is the first thing new users do when they acquire SUSHI?
Polygon Hard Fork
Feb 20, 2023 - ETH-scaling project Polygon completed a hard fork last month in hopes of reducing gas fees, as well as disruptive chain reorganizations known as "reorgs,” according to Coindesk. Let’s dive into the network’s health and performance leading up to and since the hard fork.
Hop Whales
Jun 18, 2022 - Q3. Are whales choosing Hop to go to L2s? Or are they choosing the native bridges? Compare Hop vs the native bridges for Polygon, Optimism, and Arbitrum over the following metrics: unique users on each, frequency of use, and the average amount of assets moved on each?
ERC20 Tokens (zkSync)
Jun 15, 2022 - Q2. ZkSync is a scaling solution for Ethereum that is live on mainnet. Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design. You can read more about ZkSync here. Users can also deposit ERC20 tokens into ZkSync. Which ERC20 tokens have been deposited the most (in $ volume and total count) in the last 60 days? Visualize and explain both findings.
Bridge Volume (Hop Protocol)
Jun 18, 2022 - Q2. How much volume has Hop bridged to Polygon, Optimism, and Arbitrum compared to those protocols’ native bridges? What is Hop’s total TVL? Create an analysis on the Hop’s TVL and how it’s changed over a time period of your choosing.
Sushi Activity on Ethereum
Jun 25, 2022 - Q96. How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lendings?
Celsius Swaps
Jun 18, 2022 - Q95. Find out about the swapping behaviour of Celsius network on both Sushi and Uniswap. Which tokens did they swap the most. From which one of their wallets did they conduct most of the swaps? Hint: you can find all addresses belonging to Celsius network by querying this table: flipside_prod_db.crosschain.address_labels
