backtest-database-schema-for-point-in-time-queries SKILL.md skillA
backtest-database-schema-for-point-in-time-queries from himanshuj16/algo-trading-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.
mdr add himanshuj16/algo-trading-skills/backtest-database-schema-for-point-in-time-queries@v1.1.0Pins v1.1.0 in mdr.lock. Pin the fingerprint instead.
- Audit grade
- A, 17 of 17 checks passed
- Kind
- SKILL.md skill
- Repository
- himanshuj16/algo-trading-skills
- Path
skills/backtest-database-schema-for-point-in-time-queries/SKILL.md- Versions recorded
- 5
- Latest version
- v1.1.0, committed Sep 3, 2026
- First version recorded
- Jul 30, 2026
- Size
- 6,006 bytes
- Repository stars
- 50
- License
- Apache-2.0
Use when designing the storage layer for backtest data, so as-of queries are native: two independent time axes let a query ask what was known on a date rather than what the table holds today. The join engine itself is point-in-time-database-for-ml-training-data.
Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.
What the file says
## When to Use Invoke this skill when building data infrastructure for backtesting. Standard database tables return the latest value for a query, silently introducing lookahead bias. A point-in-time (PIT) schema stores records on two independent time axes, so queries like "what was the P/E ratio of AAPL as known on 2023-01-15?" return only data available at that historical moment. The two axes follow the SQL:2011 temporal vocabulary: | Axis | Column | Meaning | |---|---|---| | Knowledge time | `known_at` | When the value became **externally known** (vendor publication / filing release). Not the DB insert time. | | Valid (application) time | `valid_from` | When the value **came into effect** in the real world (e.g. fiscal period end). | ## When NOT to Use - **Market price bars** already carry their own event timestamp and are not restated; a PIT knowledge axis adds cost without benefit. Use ordinary time-series storage. - **Live trading reads of current state** — as-of machinery is for reconstructing the past. Query the latest row directly. - Four sibling skills cover adjacent ground; pick by what you are building: …
Read the whole file at its exact version.
How to install
mdr add himanshuj16/algo-trading-skills/backtest-database-schema-for-point-in-time-queries@sha256:c8058896662c57feThe line at the top of this page pins the label v1.1.0, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.
[](https://markdownregistry.com/a/art_5jh57tx42pp6rskj)
2 badge image fetches in 30 days. What the badge shows.
Versions
The registry has recorded 5 versions of this file, between Jul 30, 2026 and Sep 3, 2026, about one every 9 days.
| version | committed | commit | size | audit | |
|---|---|---|---|---|---|
| v1.1.0 latest | 2026-09-03 | 8527a51 | 6,006 B | A | view · diff |
| v1.1.0 | 2026-09-03 | 64e8b01 | 5,902 B | A | view · diff |
| v1.1.0 | 2026-08-13 | 097e217 | 5,839 B | A | view · diff |
| v1.0.0 | 2026-08-07 | 89d1436 | 1,936 B | A | view · diff |
| v1.0 | 2026-07-30 | dfc60c7 | 1,934 B | A | view |
Audit of the latest version
- pass: Frontmatter block present
- pass: Frontmatter declares a name
- pass: Frontmatter declares a description
- pass: Size between 200 bytes and 200 KB (6006 bytes)
- pass: No zero-width or bidi control characters
- pass: No instruction hidden inside an HTML comment
- pass: No link to an exfiltration or paste host
- pass: No credential-shaped string
- pass: No instruction to send local credentials anywhere
- pass: No text hidden with inline styles
- pass: No prompt-injection phrasing
- pass: No curl or wget piped into a shell
- pass: No recursive delete of root, home or parent
- pass: No instruction to read or print local credentials
- pass: No base64 blob over 200 characters
- pass: No link to a raw IP address
- pass: No script tag
Source
himanshuj16/algo-trading-skills · 50 stars · license Apache-2.0 · pushed 2026-09-14 · branch main
API
GET https://markdownregistry.com/api/v1/artifacts/art_5jh57tx42pp6rskj GET https://markdownregistry.com/api/v1/resolve?ref=himanshuj16/algo-trading-skills/backtest-database-schema-for-point-in-time-queries GET https://markdownregistry.com/api/v1/blob/c8058896662c57fe8f41c7155b705e07c6174cd14d87681594accbb681d9b9d4
Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.
Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.