hesam
Saber Locked Over Time
Mar 27, 2022 - First, using solana.fact_gov_actions table, I displayed and listed the amount of SBR locked in the governance over time since January 1st and then the amount taken exit of it, and finally compared the two in a chart.
Net Synth Amounts
Apr 29, 2022 - I Showed the net synth amounts (mints - burns) for each blockchain and each asset.
Solana NFT Project Feature
Jul 20, 2022 - Choose a NFT project from the following list and create a dashboard with the new Flipside dashboard layout that can refresh once a day highlighting at least 4 metrics of your choosing that helps show the "health" of the project. Note any noticeable trends or current events for the project. Highlight how liquidity is flowing in and out of the project and what types of buyers and sellers are interacting with the project. Note: A tip will be given out for the best dashboard of each unique project (assuming it is deserving) along with a grand prize for the overall best dashboard among all projects. (The Pesky Penguins was selected)
NEAR Gas Guzzlers
Jul 27, 2022 - What contracts are users spending the most gas on to use? How has this changed over the past week? Past month?
ETH Merge: Actually Good?
Sep 29, 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 prove 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.
L1 Unique Users
Mar 17, 2022 - This dashboard is presented in 4 main steps: A) Compare the number of unique wallets that have sent a transaction since February 1st on Solana vs Ethereum vs Terra B) Display unique wallets by day C) Compare On Chart D) Conclusion
Show Us Your Moves
Feb 16, 2022 - I have listed some items that I saw in the UI and UX of the site in the desktop and mobile versions, along with the image and the solution for you.
Song That Own Itself(STOI) Airdrop #3
Apr 7, 2022 - First I showed the number of users who claimed Airdrop. And then I listed a chart of the daily distribution of STOI token and displayed it on the chart.
What's Going on with FTX?
Nov 9, 2022 - It's been a hectic few days in crypto — especially when it comes to FTX. Show us what's been going on on-chain by analyzing relevant data and presenting it in an original dashboard. 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 under this heading is fair game; The goal here is to explore the data in creative ways and use it to show what has been happening in recent days. Good luck!
Cross-chain Anchor
Mar 30, 2022 - Compare the Earn sides of Anchor protocol on Terra vs. Avalanche. And at the end, the answer to a few questions
NFTs in 2022
Jan 5, 2023 - A retrospective on the NFT market in 2022. NFT project with the highest volume of trades in 2022? Which NFT project had the largest mint by dollar? Which NFT project decreased the most in value this year? Which NFT project gained the most value this year? What was the price of the highest-selling individual NFT? Which NFTs had the longest hold time this year? Which NFT project had the least amount of NFTs listed for sale on an exchange? Which project had the most NFTs listed for sale on an exchange? BONUS: share this 2022 NFT highlight on Twitter and @Flipsidecrypto and any NFT projects who should see your analysis on their performance this year.
Average Age of Synth Holders
Apr 14, 2022 - In this dashboard, a graph of the number of days how long synth holders keep their synth by users is displayed. Percentage used.
Bridgesplit and MonkeDAO's DAOJONES
Feb 23, 2022 - In the first step, I showed a graph of the number of daily transactions and the number of separate wallets that had transactions in DAOJONES, and then I showed these issues in two graphs. The first chart depicts the time of hype well and attractively. The figures are well drawn on the chart and are distinguishable.
Yesterday was…
May 11, 2022 - Yesterday was bad ... Yesterday was bad ... Yesterday was bad ...
Anchor Emissions
Feb 23, 2022 - First of all, I made a list of all those who borrowed at least a UST from Anchor, and then I did 2 reviews: A) Comparing the amount of UST borrowed with the average price of bitcoin in the last 3 months B) Comparing the amount of UST borrowed from Anchor with the amount of dollar deposits in the anchor earn in the last 3 months Finally, I'm offering an interesting insight into Anchor borrowers.
Transactions by Protocol
Jul 14, 2022 - Using the following App ID lists from Folks Finance, AlgoFi, Tinyman, and AlgoDex, lets look at what percent of transactions their app calls and associated transactions(transactions in the same tx_group_id) make up on the Algorand blockchain. How have the number of transactions changed over time for each Protocol? Also how much in fees have been spent on transactions relating to each protocol? Other things that can be explored are what type of transactions are each protocol producing, or has the price of ALGO been an influence on the number of transactions produced by each protocol.
ERC20 Tokens (zkSync)
Jun 17, 2022 - In this dashboard, I show ERC20 tokens have been deposited the most (in $ volume and total count) in the last 60 days.
Arbitrum Scavenger Hunt: Odyssey Pt. 1
Jun 27, 2022 - Welcome to the Arbitrum Odyssey! Arbitrum has announced the Odyssey initiative to invite users to explore the Arbitrum ecosystem. Users that participate stand to receive exclusive NFTs (and possibly ~fingers crossed~ an airdrop at some point!). We hope this scavenger hunt will help you find an easy and enjoyable entry point into the ecosystem. Each step of this scavenger hunt is aligned with steps required to participate in the Arbitrum Odyssey.
Fault Tolerant Staking
Apr 13, 2022 - In this article, we have defined Fault Tolerant Staking (FTS) and examined its advantages and disadvantages, and also explained at the end what problems FTS can solve.
StarkWare Scavenger Hunt (July 6)
Jul 7, 2022 - By this hunt, i learned install a starknet wallet, Acquire GETH, Swap tokens via myswap
User Segmentation Analysis
Jan 3, 2023 - Last week we analyzed how users join pools, single or double-sided, which showed that most users join two-sided. This means that most users are already engaged within the Osmosis ecosystem. Let's analyze a typical user journey through Osmosis. Analyze the following: The most common ways of entering Osmosis (Axelar (Satellite) or elsewhere). The most common asset transferred into Osmosis for first transfer. Stay or leave: What do wallets do when they first come to Osmosis? Join to swap and then transfer that asset out? Join to stake OSMO? Join to swap and then LP? Which assets are most commonly swapped for and transferred out? Which assets are most commonly swapped for and then LP'd? Calculate the above from both a volume and # of user standpoint. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
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.
Overtime Markets - Profitable Traders
Aug 25, 2022 - Thales is a protocol that allows for the creation of peer-to-peer parimutuel markets that anyone can join. A Parimutuel Market is a market where the collateral is locked in a pool and the final payout to participants is not determined until after the market-settling event finalizes. There are several types of markets, including Up and Down markets, ranged markets, exotic markets, and Overtime Markets. Overtime markets is a fully on-chain sports AMM with Chainlink sport feeds, allowing users to bet on Soccer, Football, MMA, and Baseball. For this bounty we will be focused on the Overtime volume on Optimism. Single tx example: https://optimistic.etherscan.io/tx/0x2072d57af9eb255993f0307d9713a2518ba7686cee15a47d6af1ba07031fa865 For more information on Thales and Overtime Markets, see https://thalesmarket.io/ & https://overtimemarkets.xyz/#/markets Identify the 5 most profitable traders on Overtime Markets in the last two weeks. How much has each wallet won by sport?
ETH Merge: Selling Event?
Sep 29, 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.
ETH Removed
Sep 16, 2022 - Examine user behavior in recent weeks leading up to the merge on at least 3 major protocols. Have there been any changes in the amount of ETH removed from protocols like Uniswap and Aave? Note any trends or outliers you find.
Velodrome Locks
Jul 18, 2022 - Analyze new locks created on Velodrome Finance. Analyze new locks created on Velodrome Finance. What durations are most common? Which wallets have locked the most in the last 4 weeks? Which pools are wallets voting for with their locked tokens most often? For more information on Velodrome, please visit: https://docs.velodrome.finance/
User Behavior (redux)
Oct 26, 2022 - How is user behavior different on Optimism compared to L1? Specifically, create a comparison between swaps and transactions on ETH mainnet vs Optimism, looking for things like daily swap volume, daily active users, and average volume swapped (use a single DEX for your comparison, either Uniswap or Sushiswap). L2 is far cheaper, but by how much? What are the average fees for a swap on Optimism compared to ETH Mainnet? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Bridger Destinations
Aug 1, 2022 - Where do people go when they bridge to Polygon from Ethereum? What are the 10 most popular first destinations for Polygon addresses that have just bridged from Ethereum?
Pool of The Week
Dec 8, 2022 - Since the start of November, the Osmosis Support Labs team has run the Pool of the Week program, highlighting important and/or new pools within the ecosystem. What kind of impact has this program had on the liquidity of these pools? Track LP volume in and out of these pools based on the following dates: 11/11/22 Pool 833 - stOSMO / OSMO. 11/15/22 Pool 837 - IST / OSMO. 11/22/22 Pool 840 - BNB / OSMO. 11/29/22 Pool 634 - wETH.grv / OSMO. For each pool track from date above to present. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
SuperFluid Validating
Dec 20, 2022 - There are 16 SuperFluid Staking pools currently available on Osmosis (1, 678, 704, 712, 674, 722, 9, 604, 497, 812, 584, 3, 481, 42, 463, 15). What impact would a slashing event have on the OSMO liquidity of these pools? Analyze the distribution of superfluid-staked OSMO across these pools. Which validators have the most SFS OSMO in total, and per pool? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Infamous 82
Dec 11, 2022 - Governance in the Cosmos Hub has gotten spicy, to say the least. Despite gaining the support of some of the most influential names in the space, Prop #82 was rejected after more than 1/3 of voters chose "NoWithVeto". Take a look at governance behavior surrounding Proposal #82 - specifically first time voters and vote switching. Is it possible to identify any key "swing voters" (ie ATOM whales or influential validators) that really turned the tide of the vote? Were any of them first-time voters? What is the average wallet size (in ATOM) of the people voting? Of the people who changed their vote? Further, is Prop #82 significantly different than other proposals from an engagement perspective? Analyze voting for Cosmos #82 vs. other recent governance proposals in the Hub. Has overall governance participation increased or decrease since Prop #82? Finally, have ATOM holders re-delegated their staked ATOM as a result of the vote? Highlight any interesting patterns in re-delegation activity. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Hot Contracts on Osmosis
Jul 12, 2022 - 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?
$AXL Token Recap
Dec 1, 2022 - Since the $AXL token launch, how have wallets that bought $AXL used it? Are most wallets hodling or trading? What is the average holding period for wallets buying $AXL in the last month? Generally speaking, have users kept $AXL on exchange (in their Osmosis wallet) or have they bridge to other places? Analyze $AXL balances on Osmosis as compared to native on Axelar. How have these balances changed over time? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Ultimate On-Chain Exchange Dashboard
Nov 19, 2022 - We’ve launched our new Algorand database and now it’s time to dive into the new DEFI tables. The challenge here is to build the Ultimate On-chain Exchange Dashboard that will keep Algorand ecosystem users informed about the exchanges in the algorand ecosystem and allow them to compare their options.
Axelar Bridge
Nov 25, 2022 - In previous bounties, we have tracked token flows using Satellite. Today, let's take that a step further and plot out user types and their behavior leveraging Axelar's bridge. How often are people using Satellite - one-time transfers into IBC or more consistent/steady streams? Does this vary based on wallet size? Does this vary based on the ecosystem they are bridging from/to? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Optimistic Bears (Redux)
Nov 9, 2022 - Analyze Optimism during the recent bear as markets were turbulent, showing whatever metrics you care to unearth. You can choose any topic you’d like: How did the network perform? What about market performance? Were there significant inflows or outflows on bridges? Were there any notable patterns in user behavior? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!