Case Study
Invezo relies on QuestDB for fast crypto market analytics
QuestDB is the backbone behind analytical capabilities at Invezo, which aims to become Bloomberg for digital assets.
- Massive market data throughput
- Few things create data like markets. QuestDB helps Invezo manage it.
- Real-time in no time
- Real-time-liness is essential to capture market opportunities.
- Extended SQL
- The familiarity of SQL meets the raw power of time-series specialized functions
- Avg ingested rows/sec
- 3M+
- Write speed vs InfluxDB
- 10x
- Compression ratio
- 6x
- Cloud up-time
- 99.99999%
Advanced Market Analytics
Invezo Analytics Platform
Invezo pulls on-chain and off-chain metrics to understand crypto asset behavior, offering superior charting capabilities and providing an API.
- Real-Time Analytics
- Low-latency API and high-throughput ingestion power Invezo's data visualization.
SELECT ts, sum(value)FROM 'twitter_mentions'WHERE symbol='btc' AND ts >= dateadd('d', 14, now)SAMPLE BY 10m
Real-Time Reactor Monitoring
High-Throughput Queries for Safety and Efficiency
The graph above is generated with this simple SQL query. How simple? See how QuestDB and its powerful-yet-familiar SQL extensions compare to other data storage engines. Below compares MongoDB with QuestDB, both the query and execution time.
MongoDB, runs in 5.4/sec
def basic_aggregation(): pipeline = [ { "$match": { "metadata.pair": "btc-usdt", "metadata.exchange": "binance" } }, {"$sort": {"time": -1}}, {"$limit": 50000} ] results = col.aggregate( pipeline, hint="Main Index", allowDiskUse=True ) return list(results)
start = time.time()basic_aggregation()print(time.time() - start)QuestDB, runs in .1/sec
SELECT ts, first(open), max(high), min(low), last(close) FROM 'ohlc_all' WHERE pair = 'btc-usd' SAMPLE BY 5m LIMIT 50000 Live Market Data Analytics
Instant insights for crypto markets
QuestDB provides the analytics power to Invezo's charting and API solutions.
- 5x Faster Ingestion
- Supercharged ingestion rates for massive data.
- Low-Latency Queries
- Query execution time reduced from minutes to milliseconds.
- Fully Hosted
- QuestDB Cloud handles management and monitoring.
"Our customers value a low-latency API, so speed is extremely important to us. With QuestDB, our ingestion rate is 5x faster and query execution time went from minutes to milliseconds"
Fully Hosted Analytics
QuestDB Cloud powers Invezo
QuestDB Cloud offloads management and monitoring responsibilities, allowing Invezo to focus on its core business and deliver a low-latency API.
"We started with AWS RD but the database was too slow. We then looked into MongoDB, which recently released time-series capabilities. Here again, slow ingestion and queries made our application unusable. In addition, we had a crack at InfluxDB but their query language "Flux" was a show stopper because it is unintuitive."
