DeFi_reinds | Flipside Analyst

    DeFi_reinds

    Joined Sep 21, 2021
    //
    0Upvotes
    Query
    Swap MATIC for WETH
    Data exploration: terra daily balances
    Data exploration: staked ANC
    Prototype: New users with at least 1 txn
    Stake SPEC in governance
    Transaction status over time (hourly)
    Anchor dominance (address-level analysis)
    Data exploration: swaps
    Daily IL protection by pool in the last month
    Moonbirds mint analysis: Top 5 minters
    Astroport vs. Terraswap volume
    Moonbirds mint analysis: Distribution
    Staked Luna
    Octorand Gen2 holders as at 26 May 2022
    ASTRO price
    Active addresses with $RUNE balance
    3. Protocol activities
    Top 20 smart contracts (ranked by transaction count) SUPERSEDED
    Daily active addresses with $RUNE balance
    Top 2 Mars smart contracts
    Successful bids (by collateral)
    Data exploration: Wormhole tokens
    LUNA price and market cap last 1 year
    #5 profitable trader summary
    optimismoptimism
    l2
    evm
    Data exploration: depositor address
    Daily first time deposits at Mango Markets
    daoSOL-SOL LP unique wallets
    UST burned vs. UST minted
    Block txn count distribution (1 month after Upgrade)
    ethereumethereum
    evm
    Number of unique signers
    solanasolana
    Data exploration: Mars Protocol txn: Borrow
    Wallets holding Al Goannas as at 25 May 2022
    ANC usage by LP stakers and borrowers
    Sample query from @Multipartite
    Claim transactions
    optimismoptimism
    l2
    evm
    Number of applications called
    Octorand Gen2 sales and volume
    Jupiter swap Feb 22 analysis
    Aave flashloans
    Data exploration: Provide liquidity to anc-ust pool