metrics.graphql

# 📊 Lido Protocol & User GraphQL Queries
# Run these queries in your Ponder GraphQL Playground (http://localhost:42069/graphql)

# ==========================================
# PART 1: PROTOCOL METRICS (DASHBOARD)
# ==========================================

# 1. Snapshot: Current Protocol Health
query ProtocolHealth {
  liquidStakingProtocols(limit: 1) {
    items {
      totalValueLockedETH
      totalValueLockedUSD
      totalPoolCount
      totalStakerCount
      lastUpdatedTimestamp
    }
  }
}

# 2. Trends: Daily APY & TVL Evolution
query DailyAPYandTVL {
  poolDailySnapshots(orderBy: "timestamp", orderDirection: "desc", limit: 30) {
    items {
      date
      rewardAPY
      totalValueLockedETH
      totalSupply
      dailyVolumeETH
    }
  }
}

# 3. Financials: Protocol Revenue
query FinancialsHistory {
  financialsDailySnapshots(orderBy: "timestamp", orderDirection: "desc", limit: 30) {
    items {
      date
      totalValueLockedUSD
      dailyTotalRevenueUSD
      cumulativeTotalRevenueUSD
      dailyProtocolSideRevenueUSD
    }
  }
}

# ==========================================
# PART 2: USER WIDGETS & TRACKING
# ==========================================

# 4. Widget: "My Staking Position"
# Shows a specific user's balance and lifetime stats.
# Replace $userId with the lowercase address (e.g. "0x123...").
query MyPortfolio($userId: String!) {
  accountPosition(id: $userId) {
    balance           # Current shares balance (need to multiply by exchange rate for ETH value)
    totalDeposited    # Lifetime ETH deposited
    totalWithdrawn    # Lifetime ETH withdrawn
    depositCount
    firstDepositTimestamp
    lastActivityTimestamp
  }
}

# 5. Widget: "My Activity Feed"
# Fetches recent actions for a specific user.
query MyActivityFromDeposits($user: String!) {
  deposits(where: { from: $user }, orderBy: "timestamp", orderDirection: "desc", limit: 10) {
    items {
      hash
      amount
      timestamp
      blockNumber
    }
  }
}

query MyActivityFromWithdrawals($user: String!) {
  withdraws(where: { from: $user }, orderBy: "timestamp", orderDirection: "desc", limit: 10) {
    items {
      hash
      amount
      timestamp
      blockNumber
    }
  }
}

# 6. Widget: "Whale Leaderboard"
# Shows top stakers by balance. Great for gamification/analysis.
# Note: Balance here is raw shares. To get ETH amount, multiply by current Exchange Rate from ProtocolHealth.
query TopStakers {
  accountPositions(orderBy: "balance", orderDirection: "desc", limit: 10) {
    items {
      account
      balance
      totalDeposited
    }
  }
}

# 7. Analytics: User Retention / Cohorts
# Analyze users based on when they first joined (First Deposit).
query UserCohorts {
  accounts(orderBy: "firstDepositTimestamp", orderDirection: "asc", limit: 50) {
    items {
      id
      firstDepositTimestamp
      depositCount
      lastActivityTimestamp
    }
  }
}