SQL Playground

Query Hyperliquid data directly with ClickHouse SQL (read-only)

Back to Traders

Example Queries

Query Editor
Press Cmd/Ctrl + Enter to execute
Read-only access • Only SELECT queries allowed
Pro Tips
  • Use LIMIT to keep result sets manageable
  • Copy table schemas and use AI (ChatGPT/Claude) to help write complex queries
  • Use formatDateTime() to format timestamps nicely
  • Queries timeout after 30 seconds - optimize with proper WHERE clauses
  • Join fills and trader_stats tables for powerful insights
  • Wallet addresses in results are clickable links to trader details