flyingfish
JLP AUM Cap Raises
Apr 2, 2024 - JLP Minting and Burning data for the last 5 AUM Cap raises.
ArmadaFi jitoSOL-USDC Performance
Mar 21, 2024 - Submission to the SuperTeam ArmadaFi bounty. https://earn.superteam.fun/listings/bounty/create-a-dashboard-2/
USDC-USDT volume bucketed by trade size
Oct 29, 2023 - https://twitter.com/durdenwannabe/status/1718475916828107153
LiveQuerying Flipside Queries
Aug 4, 2023 - An example dashboard to show how to get data from other FlipSide queries with the LiveQuery functionality.
A brief look into gmStudio collections
Dec 21, 2022 - A brief look into the genArt collections launched in gmStudio
Pink Drainer Ethereum Scam Stats (Flipside version)
Jun 5, 2023 - This dashboard is a fork from the official ScamSniffer Dune Dashboard https://dune.com/queries/2510569
LiveQuery Github Suggestion
Jun 19, 2023 - A simple example to show the "duplication" of related queries when a user needs to show intermediate results along aggregated data.
ZK Sync Bounties - Distinct Wallets (zkSync)
Jun 14, 2022 - Q1. - How many distinct wallets have deposited ETH into ZkSync in the last 60 days? - How much ETH was deposited by day?
Pool Together Bounties - 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?
zkSync Scavenger Hunt
Jun 14, 2022 - This serves as an introduction to the ZkSync ecosystem by bridging ETH from Mainnet to a L2 and executing a ETH-USDC swap on ZigZag DEX
NFTX Bounties - Highest Sales Volume
Jun 10, 2022 - Q1. Which 3 NFT collections have the most total sales volume in the last 60 days on NFTX?
Solana Educational Bounties: Swap Volume on Solana Educational Bounties: Swap Volume on Orca
May 16, 2022 - As an introduction to 'flipside_prod_db.solana.fact_swaps' table the objective of this dashboard is to analyse the SOL-USDC swap token flow in some of the Solana ecosystem DEXes. Although the request was to compare ORCA and Jupiter trends, data for swaps in Raydium are included as some price discrepancies were noticed in the Jupiter swap data.
Distinct Wallets (zkSync) HOW IT STARTED
Jun 17, 2022 - Q1. - How many distinct wallets have deposited ETH into ZkSync in the last 60 days? - How much ETH was deposited by day?
Most Popular ASA's Held By Wallets Created in 2022
May 19, 2022 - In this analysis we are looking at the most popular ASA's that are held by wallets created in 2022.
Analysis of volume, swap count and swap size in the WBTC/WETH and USDC/WETH pools in SushiSwap
May 14, 2022 - Submited as part of the Ethereum Educational Bounties: Ethereum_Core Tables Walkthrough (Beginner Level) Note: - Date parameters should be inserted in the format "YYYY-MM-DD"
Bar Chart Width (not a bug)
Jun 20, 2023 - With STACK disabled, the bar width defaults to the width for 8 categories user can set in the "Settings" section of the chart editor. When there is no "Group By Value" defined it should set to the 1 group bar width.
Bridge Users (Hop Protocol)
Jun 21, 2022 - Q1. - How many unique users have bridged to L2s using Hop? - What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? - Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.