![flyingfish | Flipside Analyst flyingfish | Flipside Analyst](https://res.cloudinary.com/dsr37ut2z/image/upload/w_1200,f_auto/v1694731511/jgysk6zo01ofbsie9izg.png)
flyingfish
LiveQuerying Flipside Queries
Aug 4, 2023 - An example dashboard to show how to get data from other FlipSide queries with the LiveQuery functionality.
JLP AUM Cap Raises
Apr 2, 2024 - JLP Minting and Burning data for the last 5 AUM Cap raises.
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
USDC-USDT volume bucketed by trade size
Oct 29, 2023 - https://twitter.com/durdenwannabe/status/1718475916828107153
![curve curve](https://res.cloudinary.com/dsr37ut2z/image/upload/assets/project-icons/curve.png)
![LiveQuery Github Suggestion LiveQuery Github Suggestion](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
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.
ArmadaFi jitoSOL-USDC Performance
Mar 21, 2024 - Submission to the SuperTeam ArmadaFi bounty. https://earn.superteam.fun/listings/bounty/create-a-dashboard-2/
A brief look into gmStudio collections
Dec 21, 2022 - A brief look into the genArt collections launched in gmStudio
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.
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?
gmDAO Royalties
Jun 28, 2022 - This dashboard assumes a flat 2.5% royalty for every sale on all collections. Earnings from minting and auction sales are not included in the calculations.
![curve curve](https://res.cloudinary.com/dsr37ut2z/image/upload/assets/project-icons/curve.png)
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?