sam | Flipside Analyst

    sam

    Joined Jun 24, 2021
    //
    68Upvotes
    Query
    bETH provided
    number of borrowing and borrowers - luna - mars bank
    Untitled Query
    Untitled Query
    Gas used and wanted for the top 10 Sending Luna transactions since August 2021
    2023-06-07 02:48 AM
    sum of providing liquidity
    superrare settle auction - internal transactions
    ethereumethereum
    evm
    Day 6: Nexus protocol airdrop top 10
    Practical SQL - element marketplace
    ethereumethereum
    evm
    Blur top lenders and borrowers
    ethereumethereum
    nft
    evm
    ens
    domains
    lender over time
    ethereumethereum
    evm
    count of people who borrowed, then deposit into anchor
    2024-06-02 12:48 PM
    ethereumethereum
    evm
    strictly selling MINE for UST
    ASO 19/23 raw usdt,usdc,trx transfers to addresses
    elegant-cyan
    aleoaleo
    zk
    balance table for any erc20 tokens
    ethereumethereum
    evm
    balances
    block balance
    ethereumethereum
    evm
    balances
    Get started: ez transfer tables
    ethereumethereum
    nft
    evm
    Using dim dates to fill in date gaps
    ethereumethereum
    evm
    Gmx liquidations on avalanche
    avalancheavalanche
    evm
    2024-05-31 06:26 AM
    blastblast
    l2
    evm
    Session 2 - Joel
    ethereumethereum
    evm
    2024-07-18 01:33 AM
    ethereumethereum
    nft
    evm
    Rewards sent by flashbots - top address = Lido
    ethereumethereum
    evm
    supply for 99c
    solanasolana
    token
    Honey query test
    solanasolana
    usdt, usdc, trx transfers received by addresses from ASO - 34/23​ ​ ​(excluded inter transfers) - amount
    Session 3 - Joel
    basebase
    ethereumethereum
    l2
    evm
    Ranking dexes
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    Session 1 - Joel
    ethereumethereum
    evm
    Swapping of UST to Luna - slippage, liquidity
    abi -> function sig
    2024-06-14 07:58 AM
    uniswap
    kyberswap
    hashflow
    maverick
    dodo
    Net USD change buy vs sell RUNE before Thorchain exploit
    0924 Recreating nft transfers on base
    basebase
    l2
    evm
    Trader joe swap
    avalancheavalanche
    evm
    net GLP minted - redeem
    avalancheavalanche
    evm
    Active Liquidity provider of Drift on Meteora copy copy
    solanasolana
    staking