SUSHI Noobs II
Jun 19, 2022 - Q94. What is the first thing new users do when they acquire SUSHI?
FLOOR Tokens
Jun 30, 2022 - Q2. In the last 90 days, what are users doing with their FLOOR tokens?
Token Reactor Rankings
Jun 22, 2022 - Q2. Rank the token reactors by their TVL, analyze the pattern of liquidity (withdrawals, deposits) on the top ones. Is there a reason why some reactors have more liquidity than others?
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
Prizes
Jun 21, 2022 - Q3. In the past 60 days, how many PoolTogether prizes have been awarded and claimed? What’s the USD value of these prices?
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?
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.
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?
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
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.
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!
Layer 2 Blocks
Jun 26, 2022 - Q2. How many layer2 StarkNet blocks have been accepted on Ethereum (L1) chain so far? How much fees have been paid(generated) to Ethereum network? Has StarkNet contributed to saving in transaction fees for its users?
