THE HARD PART“Indexing 250M+ Ethereum addresses across 4 trillion+ rows while still serving live updates over WebSockets. The main endpoint went from 94 seconds to 2.4.”
PandaTerminal is a crypto analysis and trading platform for professional traders. ChartIQ integration gives it the charting depth of an institutional terminal, with over 100 technical indicators. High net-worth clients paid for it: $700K+ in revenue.
The piece I'm most attached to is the Ethereum wallet analysis tool. It covers 250+ million addresses across more than 4 trillion rows, and its main endpoint went from 94 seconds to 2.4 after I rebuilt how the data was read (a 97.45% cut). Designing the AWS infrastructure (ECS, RDS, Lambda) also brought running costs down 57%.
Under the hood it moves billions of data points over WebSockets through Node.js and Redis, and talks to 200+ APIs across both traditional finance and DeFi.