flyingfish
LiveQuerying Flipside Queries
Aug 4, 2023 - An example dashboard to show how to get data from other FlipSide queries with the LiveQuery functionality.
ArmadaFi jitoSOL-USDC Performance
Mar 21, 2024 - Submission to the SuperTeam ArmadaFi bounty. https://earn.superteam.fun/listings/bounty/create-a-dashboard-2/
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
A brief look into gmStudio collections
Dec 21, 2022 - A brief look into the genArt collections launched in gmStudio
USDC-USDT volume bucketed by trade size
Oct 29, 2023 - https://twitter.com/durdenwannabe/status/1718475916828107153
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.
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?