flyingfish
JLP AUM Cap Raises
Apr 2, 2024 - JLP Minting and Burning data for the last 5 AUM Cap raises.
LiveQuerying Flipside Queries
Aug 4, 2023 - An example dashboard to show how to get data from other FlipSide queries with the LiveQuery functionality.
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?
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.
USDC-USDT volume bucketed by trade size
Oct 29, 2023 - https://twitter.com/durdenwannabe/status/1718475916828107153
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.
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"
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.
ArmadaFi jitoSOL-USDC Performance
Mar 21, 2024 - Submission to the SuperTeam ArmadaFi bounty. https://earn.superteam.fun/listings/bounty/create-a-dashboard-2/
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
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