degenliquid
  • Getting Started
    • Overview
    • Philosophy
  • Architecture
    • Trade Collection
    • Database Schema
    • Ranking & Filtering Logic
    • Realtime Trade Streaming
    • Strategy Pools (Coming Soon)
  • V1 Scope
    • What's inside
  • Tech Stack
  • Security & Ethics
  • Vision
Powered by GitBook
On this page
  1. Architecture

Database Schema

Key PostgreSQL tables:

  • spot_trades → All raw spot trades from the Hyperliquid websocket

  • wallets_leaderboard_daily → Daily top 20 wallets (based on PnL, win rate, and consistency)

  • watched_wallets → Aggregated list of high-performing wallets with metadata (total trades, win ratio, avg holding time, etc.)

  • copy_signals → Timestamped and normalized trades from watched wallets, ready to be broadcasted or consumed

PreviousTrade CollectionNextRanking & Filtering Logic

Last updated 29 days ago