bababaoyu38
Stablecoins on Kashi
Jul 11, 2022 - Q102. Analyze the behavior of stablecoins on Kashi markets. Which ones are being deposited for lending? Which ones as collateral? Do this for both polygon and Ethereum. You can use the cross-chain sushi ez_lending and ez_borrowing. Note: Currently the polygon data is only showing the recent months. We will back-fill the data in the future. Make sure your dashboard mentions the starting date on polygon data.
Algorand Price Correlation
Jun 29, 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?
The Law Offices of NEAR
Aug 3, 2022 - Q7. Provide your best assessment of the number of smart contracts deployed on NEAR and clearly outline your methodology (after all, contract lawyers love clearly specified terms).
Open Analyitics Bounty: Arbitrum
Aug 4, 2022 - Flipside Crypto has built pathways and provides the tooling for you to develop deep and thorough crypto analysis. Now, we want to see what you can do with them. Submit any dashboard you think is worthy of being shared with our partners, and with the world. We’ll select the best for payment and amplification through our social and content channels. (Please note that many dashboards submitted to this bounty will not be rewarded with payment — only the best of the best will do here.) As you dive in and work through your analyses, we would love to see what insights you find and dashboards you develop. Feel free to submit your work via this bounty card for internal review. Elite tier work will be shared out on our social channels and to partners highlighting the analyst. Be sure to use the Arbitrum tables, which can be found under the "Arbitrum"
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
Tornado Cash Addresses
Aug 10, 2022 - Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle. The addresses tied to the service have been publicly posted online.
The Bridge from Ethereum to Solana
Jun 16, 2022 - Q1. Create a visualization of the volume of assets being bridged from Ethereum to Solana over time via Wormhole. What does the average profile / size of wallets bridging to Solana from Ethereum look like (what is the average value of assets being bridged over)? What have been the most popular bridged assets from Ethereum to Solana and has that changed over time?
Raydium Swaps
Apr 3, 2022 - Q44. Raydium is an automated market maker (AMM) built on the Solana blockchain that shares liquidity with the Serum decentralized exchange. Create a visualization comparing the quantity of swaps and number of unique wallets on Rayidum, Jupiter, and Orca since January 1st. What have been the ten most popular tokens to swap and swap for on Raydium during that time period? What tokens have become more popular over time?
Friktion's Crab Strategy
Apr 24, 2022 - Friktion recently launched a new product offering, Volt #03 - a volatility yield strategy for stablecoins in crab markets. For more information. reference this twitter thread https://twitter.com/friktion_labs/status/1516835223576719376 And Friktion's helpful medium article: https://medium.com/friktion-research/harvest-volatility-yield-with-friktion-volt-03-2ba2c9df028b And a link to the Volt: https://app.friktion.fi/crab Track the deposit activity into the Crab Volt. How many unique wallets have used the strategy since April 11th? What other Friktion Volts have these wallets used since March 1st? What is the crossover between the Volt #1 Bitcoin strategy and the Crab Volt? Why would a wallet prefer to use this Crab Volt instead of the other products?
Metamask vs. Other Platforms
Jun 25, 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.
Tracking USDC & USDT on Solana
Jun 16, 2022 - Q2. What's the current market share for USDC and USDT on Solana relative to other stablecoins in the ecosystem (look into USDC, USDT, UXD, USDH, PAI, NIRV, UST, DAI, FRAX)? Create a visualization showing the amount of transaction volume for USDC vs. USDT etc. do display popularity within Solana. For USDC and USDT specifically, breakdown the transaction activity by contract and exchange flows (i.e. which dapps and addresses hold the majority of USDC and USDT and what do cumulative flows to and from exchanges look like over time)?
Hot Contracts on Osmosis
Jul 12, 2022 - Q20. A lot of new contracts are being deployed on Osmosis lately. Since the beginning of May, answer the following questions: What are the top ten most popular contracts on Osmosis? What is the cumulative total of contracts launched on Osmosis, and have there been any spikes since the Terra crash or other noteworthy events?
USDC Transfer Volumes
Apr 15, 2022 - Q51. Compare USDC transfer volumes on Algorand, Solana, Ethereum in 2022.
How does BTC funding affect rates?
Aug 12, 2022 - Supply and lending rates for at least five tokens in Aave V2, and total amount of Wrapped BTC supplied over time. Measure the correlation between USDC borrow rates and total wBTC supplied.
AAVE and stAAVE movements
Aug 11, 2022 - Daily AAVE supplied and withdrawn on Aave protocol. Daily AAVE staked and unstaked.
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?
Onboarding with Solana NFTs
Jun 15, 2022 - Q85. It has been said that Solana NFTs have become a powerful onboarding tool into the Solana ecosystem. Is this narrative true? Which NFTs have captured the most first time users of the Solana blockchain? What kinds of activities do these wallets tend to do after buying their first NFT? Do you think the NFT growth on Solana will spill over into Defi?
Velodrome Health
Aug 16, 2022 - Create at least 3 metrics on Velodrome with a description for each that showcase traction and success in a data-driven manner.
Solport vs. Magic Eden
Apr 3, 2022 - Q48. Solport - a NFT marketplace on Solana - launched a V2 on March 12th that includes various new features for marketplaces. Beginning on March 12th, compare the NFT sales volume on Solport to Magic Eden's sales volume. How many unique wallets have used Solport over that timeframe compared to Magic Eden? Solport is strongly connected to the NFT collection 'Taiyo Robotics', which incentivizes holders to increase Solport's adoption. Compare Taiyo Robotics sales on each marketplace. Do sellers care more about growing their own marketplace or capitalizing on the access to liquidity? Hint: Use solana.fact_nft_sales and solana.dim_nft_metadata Hint: ME V2 programId: M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K Hint Solport programId: SPf5WqNywtPrRXSU5enq5z9bPPhREaSYf2LhN5fUxcj
RUNE bonded + slashed amounts
Jun 13, 2022 - How much RUNE is bonded, how much RUNE has been slashed from those bonds (total and or over time)?
Swapping goBTC and goETH on DEXs
May 18, 2022 - goETH and goBTC are wrapped forms of ETH and BTC minted by algoMint. Let's look at goBTC and goETH swaps across the DEXs since the beginning of April and get a better understanding of how wallets are swapping goETH and goBTC - especially during the price crash in May.
What's going on with Avalanche?
Jul 22, 2022 - What's going on with Avalanche? This is an open-ended bounty, what we call a Free Square, and it’s an opportunity for you to show us what you’ve got. Any topic is fair game; The goal here is to explore the data in creative ways and show off your explorations with visualizations (or even a tool/frontend if you’ve got eyes on the grand prize).
Rand Gallery NFT Sales
May 4, 2022 - Rand Gallery is one of the largest NFT marketplaces on Algorand. Let’s take a deeper look into rand gallery’s history and the performance of the marketplace. 1) Show Daily NFT sale volume in # of sales, ALGOs, and USD over time. 2) Show how much Rand Gallery has earned in fees daily and accumulated over time. 3) How many NFTs have been sold through Rand Gallery and what is the total -volume in ALGOs of NFT sales. 3) What was the biggest NFT sale in both ALGOs and USD. What was the NFT?
What's going on with Optimism?
Jul 22, 2022 - What's going on with Optimism? This is an open-ended bounty, what we call a Free Square, and it’s an opportunity for you to show us what you’ve got. Any topic is fair game; The goal here is to explore the data in creative ways and show off your explorations with visualizations (or even a tool/frontend if you’ve got eyes on the grand prize).
LUNA Staking and Trends
May 8, 2022 - Over the past 30/60/90 days and the past year, how much LUNA has been staked per day? What is the staking percentage (LUNA staked/Circulating Supply), and how has it changed over time?
What makes a Top Shots moment valuable? (Part I)
Jul 25, 2022 - Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume. This week, focus specifically on the play_type column in the flow.core.dim_topshot_metadata table. What play_types do users hold most, and how much volume in sales do these play_types generate? Include any other transactional metrics you can think of.
The Red Planet
Apr 3, 2022 - Q174. Define and assess two key metrics for the performance of Mars Protocol since launch. How is Mars doing, according to these metrics? Some example key metrics include: 1) Number of depositors and borrowers 2) Net LUNA and UST deposited and borrowed 3) Leverage farming strategies
Open Analytics Bounty: Avalanche
Jul 28, 2022 - Flipside Crypto has built pathways and provides the tooling for you to develop deep and thorough crypto analysis. Now, we want to see what you can do with them. Submit any dashboard you think is worthy of being shared with our partners, and with the world. We’ll select the best for payment and amplification through our social and content channels. (Please note that many dashboards submitted to this bounty will not be rewarded with payment — only the best of the best will do here.) As you dive in and work through your analyses, we would love to see what insights you find and dashboards you develop. Feel free to submit your work via this bounty card for internal review. Elite tier work will be shared out on our social channels and to partners highlighting the analyst. Be sure to use the Avalanche tables, which can be found under the "Avalanche"
Pooly NFTs
Jun 21, 2022 - Q2. How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
Crazy Goose Flock and $CRUMB Token
Jun 9, 2022 - Q97. Crazy Goose Flock is one of the strongest growing NFT communities on Algorand. Let’s look at the holders of the CGF! Chart the holder breakdown of the CGF NFTs. How many holders hold more than one CGF NFT? Who holds the most CGF? Show the wallet balance distribution of CGF holders. Are there any whales holding a CGF? Also chart the wallet creation date for crazy goose flock holders. Are the wallets who hold CGF newer or older? The Crazy Goose Flock are also airdropping their community utility token to CGF holders. Show these airdrop transactions. Who are the biggest $CRUMB holders? https://twitter.com/CrazyGooseFlock/status/1531039099372584962?s=20&t=ZM0LBiWXBRfykqaAi16YEA https://twitter.com/CrazyGooseFlock/status/1528842444762238976?s=20&t=wE7H9RYDUER1ZiNzWUcRgg
Yesterday was… Well let’s not talk about yesterday, let’s analyze it.
May 11, 2022 - You’re looking to rebuild your bags and we’re looking for some analysis, but we want to know what you want to know about yesterday. Make a dashboard on any topic that strikes your curiosity, tweet it, mention @flipsidecrypto, and we’ll put 20 LUNA in your bag.
$RUNE Distribution
Apr 22, 2022 - Calculate the distribution of $RUNE holdings by address. Include RUNE that is in liquidity pools. (e.g. if I have 100 $RUNE in my wallet and LP 50, I should still be considered to be holding 100). In terms of charts, feel free to create a histogram or whichever visual you think works best! Hint: use thorchain.transfers and thorchain.liquidity_actions
Bubblegoose Ballers Mint
Jun 15, 2022 - How many unique wallets minted a Bubblegoose Baller NFT and how many NFTs did these wallets purchase on average? How many NFTs were purchased with ETH using Crossmint? Identify any notable trends in minting activity and secondary market sales in the days following the launch. Which group(s) was most likely to "diamond fin" their NFTs?
