CryptoIcicle
Hacks, Scandals and Scams - 4. CEL token flows.
Jul 28, 2022 - Celsius Network listed a $1.19 billion deficit on its balance sheet in a bankruptcy court filing a day after the cryptocurrency lender filed for Chapter 11. Currently Celsius owns a large portion of the CEL tokens. What are the top addresses swapping and transferring CEL? How have the CEL swap volumes changed over the past 90 days? How are Celsius wallets interacting with the CEL token? Hint: Here is the list of Celsius Wallets Identified by @lawmaster on twitter: https://app.flipsidecrypto.com/velocity/queries/c5c1ca1b-5299-4105-aed5-7968e2426d94
Flash Bounty: Merge Open Analytics
Sep 24, 2022 - We want to know all about the merge — and we’re turning to you for the answers. Take a deep dive into the ETH merge and switch to POS with this Open Analytics Bounty. This is a chance to explore the topic without any specific prompt, just a direction and a reward. It’s your chance to have your brain follow your heart — got a spark of interest, or a loose thread, or a weirdly-specific question gnawing at the back of your mind? Follow it as far as you can!
Metamask-2.Most Common Transactions
Jun 25, 2022 - -- Q2. What are the most common transactions for Metamask users? -- Create an analysis that shows the most common wallet activities and the most common platforms for those activities.
Solana-103.Going Down The Wormhole
Aug 9, 2022 - -- Q103. Create a dashboard that can refresh daily with metrics that provide a detailed picture of Wormhole activity -- both from Ethereum to Solana and from Solana to Ethereum. -- How are tokens being bridged from chain to chain and which actions seem to be popular among users of Wormhole? -- What actions seem to influence bridging behavior? -- What are users doing before and after bridging? -- Do users seem to think that bridging is safe or more risky relative to transfers to centralized exchanges?
Flash Bounty: Post Merge Behavior
Sep 24, 2022 - -- The merge has occurred. How have users responded in days that followed? -- Analyze any notable trends or outliers you can see since ETH switched to POS. -- Compare this to user behavior in the days and weeks leading up. -- What major changes can you see?
Exchange Flows in the Bear
Aug 13, 2022 - Let's understand whether the bear market and recent issues with CeFi products have changed centralized exchange users' behavior Explore trends in exchange withdrawal (specifically, moving money from CEX addresses onto the chain) patterns over the last 6 months. Have those withdrawals increased? Has the typical size of them changed? Most important: are people creating new wallets to take custody of their CeFi deposits?Also have a look at what people do after a withdrawal: are they holding their withdrawn tokens? Or are they fiat-on-ramping so they can swap, provide liquidity, buy NFTs, etc.hint: find centralized exchange addresses in [chainname].core.dim_labels where label_type = 'cex' and label_subtype = 'hot_wallet'
ETH Merge: Actually Good?
Sep 30, 2022 - -- Recently, ETH devs and observers have opined on Twitter regarding whether the Merge was good or bad for the Ethereum network. -- We want you to prov11e one side or the other, with the help of Flipside data. -- Demonstrate whether the Merge had positive or negative effects on the network. -- Include least three queries and visualizations in your submission.
Sushi-95.Celsius Swaps
Jun 19, 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
In the News - 13. DYDX Unlock
Jan 26, 2023 - DYDX holders are bracing for a massive event next month, as 105% of the circulating supply will be distributed to investors and team members. Have holders begun preparing for this massive unlock? If so, what actions are they taking to prepare? How do you expect the market to react in the weeks leading up to and following the unlock? Back up your assertions with data.
ETH Derivatives
Sep 13, 2022 - Consider the liquid staking ETH derivates from ankr, rocketpool and lido(aETH , rETH and stETH ). What are some trends around the price volatility for these tokens? Swap activity?
stETH/ETH Fluctuation
Jun 11, 2022 - -- Analyze the price of stETH in ETH denomination and find meaningful correlations that explain its fluctuation. -- Possible correlations could be with ETH’s price in USD, ETH’s gas price, volume in the curve pool, -- Curve stETH/ETH pool composition, etc.
ETH Merge: Selling Event?
Sep 30, 2022 - -- Was the Merge a selling event? Why or why not? -- Were miners the source of sell pressure? Show any wallets miners have transferred ETH into, -- along with any other visualizations you think will add to your analysis.
Sushi-104.Celsius and Sushi
Jul 12, 2022 - -- Q104. Find out what Celsius platform has done on sushi (swaps, lending, LP'ing, farming). -- Make sure to use cross-chain tables as much as possible to capture data on all chains. -- currently, we have swaps, lending, and borrowing data cross-chain. -- Hint: you can find all addresses belonging to Celsius network by querying this table: flipside_prod_db.crosschain.address_labels -- NOTE: This bounty will be paid on the ETH network. Please give your Sushiswap address on ETH when submitting
Lido-11.HODL or Sell?
Jun 13, 2022 - -- Q11. Identify accounts that have staked ETH with Lido when the price of ETH was much higher or much lower than it is now. -- Have they held or sold their stETH?
Lido-10.Gain or Lose
Jun 13, 2022 - -- Q10. Of the stakers that have swapped ETH to stETH, how much ETH did they gain or lose -- depending on the peg of stETH to ETH at the time of the swap?
Metamask-3.Metamask vs. Other Platforms
Jun 25, 2022 - -- Metamask vs. Other Platforms -- 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.