USDC Deposits
Jun 21, 2022 - Q1. In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
Metamask vs. Other Platforms
Jun 22, 2022 - Q3. How many users are swapping via MetaMask vs other platforms? How much volume have these users done? Chart a comparison between the two, and show the following metrics over a time period of your choosing: transaction volume, average amount swapped, and a comparison of fees.
Hop Bridge Volume
Apr 19, 2022 - How many Matic token were bridged in 2022 per day from ethereum to layer2 using Hop?
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
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?
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
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?
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.
