Columns and types
These columns come from the same versioned logical catalog used by the query validator and engine. They describe the fields you can query. Some historical rows have missing values; fields absent from older shards can return typed NULL.
| start_date | DATE |
| end_date | DATE |
| duration_days | INTEGER |
| date_range_bucket | VARCHAR |
| interval | VARCHAR |
| cadence | VARCHAR |
| asset_class | VARCHAR |
| traded | BOOLEAN |
| percent_change | DOUBLE |
| sharpe_ratio | DOUBLE |
| sortino_ratio | DOUBLE |
| max_drawdown | DOUBLE |
| avg_drawdown | DOUBLE |
| ulcer_index | DOUBLE |
| ulcer_performance_index | DOUBLE |
| win_rate | DOUBLE |
| profit_factor | DOUBLE |
| avg_trade_pnl | DOUBLE |
| dollars_sold | DOUBLE |
| total_dividends | DOUBLE |
| total_fees | DOUBLE |
| risk_free_rate | DOUBLE |
| baseline_percent_change | DOUBLE |
| baseline_sharpe_ratio | DOUBLE |
| baseline_max_drawdown | DOUBLE |
| alpha_pct | DOUBLE |
| alpha_sharpe | DOUBLE |
No matching rows. Clear the filter to see all records.
Current logical schema for lake.backtest_proprietary_results
Coverage and timing
The logical view is backed by canonical manifest-resolved data. Query this name rather than guessing a physical database collection or object-storage path.
Backtest corpus: performance-only rows for runs on creator-owned data. NO IDENTIFIERS AND NO JOIN KEY, deliberately: no `backtest_uuid`, `portfolio_uuid` or `experiment_id`. It cannot be joined to any other table, and the strategies behind it cannot be identified or reconstructed. Never try to hydrate from it or link a row here to a row anywhere else. Without `experiment_id` the deduplication rule cannot be applied, so cloned runs count more than once. Treat any aggregate here as indicative and say so; never present it beside a deduplicated number as if the two were comparable.
Run a limited query
Use a registered API key with lake scope. Select needed columns, bind user-supplied values and restrict dates when the table has a time dimension. Query results are durable parts with a schema and manifest rather than an unbounded in-memory array.
This reference documents the schema and its meaning. Run queries in your signed-in workspace; this page does not execute SQL or show private results and datasets.
SELECT "start_date", "end_date", "duration_days"
FROM lake.backtest_proprietary_results
LIMIT 20;