DeFi_reinds | Flipside Analyst

    DeFi_reinds

    Joined Sep 21, 2021
    //
    0Upvotes
    Query
    Polygon tx and address count since earliest available data
    polygonpolygon
    evm
    Block tx count distribution
    ethereumethereum
    evm
    Solana Wormhole reciepient txn
    Data exploration: erc20 balances for contract address
    Data exploration: Staking to the MonkeDAO validator
    Block performance
    optimismoptimism
    l2
    evm
    Data check: Anchor gov staking
    Top 10 destinations (test)
    ethereumethereum
    polygonpolygon
    evm
    Whale wallet received transactions: ERC20 and ETH token transfers addresses
    Orca transfers to Coinbase on peak day (1 Feb 2022)
    Example query: THORChain Categorize Swaps As One or Two-Sided
    3. Provide liquidity to ATOM/OSMO pool
    osmosisosmosis
    ibc
    Part 1: Project interactions
    Biggest block time
    Al Goannas sales and volume
    Daily number of unique programs used
    solanasolana
    Total LDO as at 30 May 2022
    Data exploration: withdraw
    Moonbirds mint query check
    Data exploration: Solana labels
    Step 2: Deposit DAI on AAVE
    arbitrumarbitrum
    l2
    evm
    Data exploration: Solana labels
    Anchor borrowers table
    Avalanche deposits
    Voting record differences
    Data exploration: stETH swap txn with origin address
    ethereumethereum
    evm
    Block performance comparison
    arbitrumarbitrum
    ethereumethereum
    optimismoptimism
    l2
    evm
    Data exploration: msg_events
    Metrics 1: Swaps (by pool)
    optimismoptimism
    swaps
    velodrome
    l2
    evm
    Top error message analysis
    Optimism: Top 5 destinations after bridging
    ethereumethereum
    optimismoptimism
    l2
    evm
    On-chain stats
    optimismoptimism
    l2
    evm
    Jupiter stablecoin swaps to UST
    Data exploration: Terra oracles
    Component 1: Active addresses
    LDO token transfers
    Whale wallet received transactions: ERC20 and ETH tokens
    Staked LUNA voting YES (Validator vs. Retail Investor)
    Validator staked balance
    Data exploration: Claim liquidation from Orca UST example