sam | Flipside Analyst

    sam

    Joined Jun 24, 2021
    //
    65Upvotes
    @sem1d5 (っ◔◡◔)っ 🌲ɯɐs🌲#0575
    DashboardsQueries
    NounsDAO Current Holdings ETH and stETH

    sam- Jul 13, 2023

    ethereumethereum
    evm
    balances
    Which validator was redelegated to the most?

    sam- Jul 8, 2022

    count of people who borrowed, then deposit into anchor

    sam- Feb 25, 2023

    manual decoding - event logs

    sam- Feb 4, 2024

    ethereumethereum
    evm
    liquidity added to curve - labeled edition

    sam- Nov 1, 2023

    ethereumethereum
    evm
    glp mints

    sam- Feb 20, 2023

    avalancheavalanche
    evm
    Top 10 claimer for those that collected them all (5 airdrops)

    sam- Feb 23, 2023

    number of distinct 'users' of Chai in the past 1 year

    sam- Mar 3, 2023

    balance table for any erc20 tokens

    sam- Feb 20, 2023

    ethereumethereum
    evm
    balances
    Top 10 gas guzzlers - etherscan replicate

    sam- Jul 3, 2023

    ethereumethereum
    evm
    CQ - Query 2: Daily number of NFT (erc721) holders for a given collection

    sam- Jan 19, 2024

    ethereumethereum
    nft
    evm
    balances
    number of chai payment transactions

    sam- Feb 28, 2023

    ts average sales price copy

    sam- Mar 10, 2024

    flowflow
    topshot
    nft
    Most tokens bought by usd amount and swap count

    sam- Mar 4, 2023

    osmosisosmosis
    prices
    swaps
    ibc
    Example curve 3pool transactions

    sam- May 30, 2023

    ethereumethereum
    evm
    NFT minting skill building bounty 5 - Finiliar nft mints

    sam- Feb 8, 2023

    ethereumethereum
    evm
    Nft mint/sale flip profits - raw table - using milady as example

    sam- Mar 4, 2023

    ethereumethereum
    nft
    evm
    Flatten example to get amounts

    sam- Nov 1, 2023

    ethereumethereum
    evm
    Curve event names for curve3pool

    sam- May 30, 2023

    ethereumethereum
    evm
    Top 10 legendary owners

    sam- Jan 29, 2023

    usdt, usdc, trx transfers received by addresses from ASO - 34/23​ ​ ​(excluded inter transfers) - amount

    sam- Nov 9, 2023

    2022-12-13 09:10 AM

    sam- Jan 28, 2023

    chainlinkchainlink
    ethereumethereum
    oracle
    evm
    Terrarian, skulls, royalty, sales and number of sales

    sam- Nov 11, 2021

    Blast Thruster Fi Swap events copy copy

    sam- Mar 2, 2024

    blastblast
    l2
    evm
    number of addresses who have claimed loop

    sam- Jan 24, 2023

    Balance assets% of UST-3pool

    sam- Mar 7, 2023

    Price of Mir

    sam- Apr 22, 2022

    after completely unstaking, how many sold MINE for UST

    sam- Feb 16, 2023

    Number of stablecoins in the past 6 months

    sam- Jun 6, 2022

    Top 5 IBC assets transferred OUT in the past 30 days

    sam- Jan 29, 2023

    Swapping of UST to Luna - slippage, liquidity

    sam- May 18, 2022

    CQ - Query 3: Balance of all assets in USD for a wallet

    sam- Oct 28, 2023

    ethereumethereum
    evm
    balances
    Average ratio - for low slippage

    sam- Jul 21, 2022

    Daily amount of Luna staked vs luna price

    sam- Feb 16, 2023

    monthly new loans

    sam- Jan 18, 2024

    ethereumethereum
    nft
    evm
    Number of users based on number of swaps

    sam- May 30, 2023

    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    Whale outflow after Mirror Genesis airdrop

    sam- Jun 17, 2022

    average number of validators delegated per delegator

    sam- Jan 12, 2023

    NounsDAO Holdings over time

    sam- Jul 13, 2023

    ethereumethereum
    evm
    balances
    CQ - Query 1: Daily token holders for x token

    sam- Jul 29, 2023

    ethereumethereum
    evm
    balances