flipside

    Pipo | Flipside Analyst

    Pipo

    Joined Jun 16, 2021
    //
    1Upvotes
    DashboardsQueries
    Query
    [8] Staking Summary (L60D)
    Active users txs in last 90 days (Arbitrum)
    arbitrumarbitrum
    l2
    evm
    Terra Labels
    [58] Bonded vs Unbonded LUNA balance
    Average fee paid per swap on Ethereum
    Failed tx vol arbitrum by day
    arbitrumarbitrum
    l2
    evm
    Net incentive analysis
    ethereumethereum
    evm
    Daily Balance by Platform (Top 100 Pools)
    Number of Al Goanna’s each wallet holds.
    PoolTogether USDC total deposits
    ethereumethereum
    evm
    [2] Aave Liquidation concentration
    [33] Anchor running debt
    [36] Swaps delegators vs non-delegators volume
    [14] Top10 Validators CM
    [17] Terra Swaps Trades_Traders
    [22] Anchor liquidations
    Q1. What are users doing with stETH from Lido by pool?
    Copy of Test ETH Number of Trades
    Difference staking analysis
    ethereumethereum
    evm
    [13] Validator Slashing broken down by validator
    Copy of Largest Tokemak Dex Pools
    POLY [7] Polygon Fees
    [20] Staked LUNA (delegated - undelegated)
    Q.109 Price cryptos
    ethereumethereum
    evm
    TOKE token behaviour Top 3 users activity
    [8] Rewards Summary (L60D)
    [57] TerraSwap TVL Top 5
    TOP 500 Pools Average Daily Balance in last 30 days
    [23] Tax Rate macro dynamics
    Q1. Comparison Top holders January vs today Dashboard
    Q.110 Al Goanna sales by NFT
    [7] TerraSwap Liquidity and Swap vol. change L3M
    MFT shares over time
    [10] UST Transaction count by label L60D
    Metamask wallets engaging in staking
    ethereumethereum
    evm
    [65] Avg delegated rewards
    [12] Liquidations L90D on Anchor
    Total number of slashing events and funds jailed
    Example with row_number and partition
    [12] Total Liquidations on Anchor L90D