flyingfish
LiveQuerying Flipside Queries
Aug 4, 2023 - An example dashboard to show how to get data from other FlipSide queries with the LiveQuery functionality.
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.
JLP AUM Cap Raises
Apr 2, 2024 - JLP Minting and Burning data for the last 5 AUM Cap raises.
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.
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?
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?
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.
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"