Reader for the Lastra columnar time-series format
Maintainer(s):
mrmx
Installing and Loading
INSTALL lastra FROM community;
LOAD lastra;
Example
SELECT * FROM read_lastra('data.lastra') LIMIT 10;
About lastra
Reads Lastra (.lastra) columnar time-series files with per-column codec selection. Designed for financial tick data (OHLCV), IoT sensor readings, and strategy execution results.
Supported codecs: ALP (adaptive lossless floating-point), Gorilla (XOR), Pongo (decimal-aware), delta-varint (timestamps), ZSTD (binary).
Features row groups with per-group timestamp statistics for efficient temporal range queries — only row groups overlapping the WHERE clause are decoded.
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| read_lastra | table | NULL | NULL |
Overloaded Functions
This extension does not add any function overloads.
Added Types
This extension does not add any types.
Added Settings
This extension does not add any settings.