DeFi_reinds | Flipside Analyst

    DeFi_reinds

    Joined Sep 21, 2021
    //
    0Upvotes
    Query
    Anchor bAssets contract addresses
    Staking yield
    On-chain stats comparison
    arbitrumarbitrum
    ethereumethereum
    optimismoptimism
    l2
    evm
    TerraBridge activities
    Katana wLUNA vault share claims
    Data exploration: Orca transfers to Coinbase
    Data exploration: Al Goannas asset IDs
    Overtime volume - Top 10 games by volume
    optimismoptimism
    l2
    evm
    Data check: Orca txn to Coinbase but recipient is Coinbase
    Metamask users' ETH holdings statistics as at 24 June 2022
    ethereumethereum
    evm
    Algorand selected protocols transactions as a % of all transactions
    ANC usage by borrowers only
    #3 profitable trader
    optimismoptimism
    l2
    evm
    Test
    Sports label troubleshooting (missing tx in schema)
    optimismoptimism
    l2
    evm
    Sample query
    Total number of swaps and unique wallets
    Algorand selected protocols transaction type
    Top 10 $TOKE holders in January 2022 and their $TOKE balance as of 20 June 2022
    ethereumethereum
    evm
    UST outflow to Solana via Wormhole
    Top 10 most popular Raydium swap for tokens
    Data exploration: Osmosis swap txn example (ATOM to OSMO)
    osmosisosmosis
    ibc
    Solana average daily TPS June 2022
    solanasolana
    Validators count
    Anchor deposit
    LUNA price and market cap last 90 days
    FIDA transfers to Coinbase
    Lil Nouns voters and gas price
    ethereumethereum
    evm
    NounsDAO functions
    ethereumethereum
    evm
    Al Goannas sales and volume (asset ID breakdown)
    Nodes slashed the most
    Algorand selected protocols total transactions fee
    ETH to stETH swaps: gain or lose v1 (excluding Curve pool)
    sushisushi
    balancerbalancer
    synthetixsynthetix
    uniswap
    swaps
    Failed transactions analysis (by msg type)
    Top 10 buyers by volume ($NEAR)
    Optimism ETH daily deposits and withdrawals
    ethereumethereum
    evm
    Data exploration: event_name
    ethereumethereum
    nft
    evm
    Curve pool stETH dominance
    Metrics 2: Liquidity (daily metrics)
    optimismoptimism
    velodrome
    l2
    evm
    dex
    Data exploration: Ethereum dex