sam | Flipside Analyst

    sam

    Joined Jun 24, 2021
    //
    71Upvotes
    Query
    unfortunate-blush
    ethereumethereum
    nft
    evm
    detailed-chocolate
    mantlemantle
    evm
    Practical SQL - element marketplace
    ethereumethereum
    evm
    squealing-yellow
    ethereumethereum
    evm
    borrower pool labels
    2024-06-02 12:48 PM
    ethereumethereum
    evm
    number of erc20 holders daily
    basebase
    l2
    evm
    2024-05-28 04:01 PM
    sick-crimson
    solanasolana
    swaps
    superrare - sovereign nft collection name and number of mints in that collection
    ethereumethereum
    evm
    Session 3: Price table, Joins & Unions
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    2024-05-13 12:37 AM
    ethereumethereum
    evm
    balances
    2024-05-05 07:39 PM
    ethereumethereum
    evm
    sample transaction hashes for various functions in sealed art market
    ethereumethereum
    evm
    gradual-azure copy
    ethereumethereum
    nft
    evm
    comparable-moccasin
    ethereumethereum
    evm
    2024-09-05 02:56 PM
    ethereumethereum
    evm
    defi
    borrows all time gfinch
    ethereumethereum
    evm
    2024-05-28 08:36 AM
    arbitrumarbitrum
    l2
    evm
    decoding univ2 and its forks using event logs
    inkink
    evm
    2024-05-22 03:28 PM
    ethereumethereum
    evm
    success
    Daily & latest erc20 holders
    bscbsc
    avalancheavalanche
    evm
    binance
    full manual decode traces
    polygonpolygon
    evm
    everyday-lavender
    axelaraxelar
    wormhole
    symbiosis
    stargate
    cbridge
    delicate-teal
    solanasolana
    CQ - Query 3: Balance of all assets in USD for a wallet
    ethereumethereum
    evm
    balances
    decoding strings and bytes copy
    ethereumethereum
    evm
    0924 Recreating nft transfers on base
    basebase
    l2
    evm
    Rarity sales / rarity x owners
    ethereumethereum
    nft
    evm
    2024-05-12 02:32 PM
    ethereumethereum
    nft
    evm
    monthly capital inflow from CEX - UST
    2024-08-12 03:43 PM
    kaiakaia
    evm
    Session 1 - Date Manipulation & Aggregates
    basebase
    l2
    evm
    beginner series - using decoded logs
    basebase
    ethereumethereum
    l2
    evm
    CQ - Query 1: Daily token holders for x token
    ethereumethereum
    evm
    balances
    Pool address mappings LQ
    aleoaleo
    zk
    2024-05-15 03:46 AM
    ethereumethereum
    polygonpolygon
    evm
    chief-maroon
    avalancheavalanche
    blastblast
    l2
    evm
    NFT (ERC 721) holders daily template query
    ethereumethereum
    nft
    evm