PITBRIDGE / SYNTHETIC FINANCIAL DATA

What was known
when the decision was made?

Explore rolling-window features and their source membership

Availability-aware SQL snapshots with publication, ingestion, revision and record-level lineage.

15Decisions
45Feature lookups
11Unsafe future-data selections
16Selections changed

Independent replay: SQLite output matches the Python enumeration oracle. deleted: 3 · no_history: 17 · not_available: 4 · selected: 16 · stale: 5

Inspect the leakage counterexample

The unsafe comparison filters only event time and takes the highest revision. It intentionally ignores availability, tombstones and freshness; it is never exported as a training feature.

DecisionSourceFeatureSafe valueSafe statusUnsafe valueUses future knowledge?
SME-A-1banknet_inflow—no_history—False
SME-A-1taxinvoice_revenue—not_available180000True
SME-A-1utilitykwh1800.0selected1800False
SME-A-2banknet_inflow50000.0selected—True
SME-A-2taxinvoice_revenue100000.0selected180000True
SME-A-2utilitykwh1800.0selected1800False
SME-A-3banknet_inflow—deleted—False
SME-A-3taxinvoice_revenue100000.0selected180000True
SME-A-3utilitykwh1800.0selected1800False
SME-A-4banknet_inflow—deleted—False
SME-A-4taxinvoice_revenue180000.0selected220000True
SME-A-4utilitykwh1800.0selected1800False
SME-A-5banknet_inflow—deleted—False
SME-A-5taxinvoice_revenue220000.0selected220000False
SME-A-5utilitykwh—stale1800False
SME-B-1banknet_inflow—no_history—False
SME-B-1taxinvoice_revenue—not_available90000True
SME-B-1utilitykwh—stale1300True
SME-B-2banknet_inflow30000.0selected30000False
SME-B-2taxinvoice_revenue—not_available90000True
SME-B-2utilitykwh—stale1300True
SME-B-3banknet_inflow30000.0selected30000False
SME-B-3taxinvoice_revenue—not_available90000True
SME-B-3utilitykwh—stale1300True
SME-B-4banknet_inflow30000.0selected30000False
SME-B-4taxinvoice_revenue90000.0selected90000False
SME-B-4utilitykwh1300.0selected1300False
SME-B-5banknet_inflow30000.0selected30000False
SME-B-5taxinvoice_revenue90000.0selected90000False
SME-B-5utilitykwh—stale1300False
SME-C-1banknet_inflow—no_history—False
SME-C-1taxinvoice_revenue—no_history—False
SME-C-1utilitykwh—no_history—False
SME-C-2banknet_inflow—no_history—False
SME-C-2taxinvoice_revenue—no_history—False
SME-C-2utilitykwh—no_history—False
SME-C-3banknet_inflow—no_history—False
SME-C-3taxinvoice_revenue—no_history—False
SME-C-3utilitykwh—no_history—False
SME-C-4banknet_inflow—no_history—False
SME-C-4taxinvoice_revenue—no_history—False
SME-C-4utilitykwh—no_history—False
SME-C-5banknet_inflow—no_history—False
SME-C-5taxinvoice_revenue—no_history—False
SME-C-5utilitykwh—no_history—False

Trace each selected observation

Knowledge time = max(publication, ingestion). Every selected observation was available at or before the decision. A later historical correction cannot overwrite an earlier snapshot.

DecisionSourceFeatureRecordRevisionEvent timeAvailable time
SME-A-1utilitykwhpower-a12026-02-01T00:00:00.000000+00:002026-02-03T00:00:00.000000+00:00
SME-A-2banknet_inflowcash-a12026-02-10T00:00:00.000000+00:002026-02-11T00:00:00.000000+00:00
SME-A-2taxinvoice_revenuetax-a-v112026-01-31T00:00:00.000000+00:002026-02-06T00:00:00.000000+00:00
SME-A-2utilitykwhpower-a12026-02-01T00:00:00.000000+00:002026-02-03T00:00:00.000000+00:00
SME-A-3taxinvoice_revenuetax-a-v112026-01-31T00:00:00.000000+00:002026-02-06T00:00:00.000000+00:00
SME-A-3utilitykwhpower-a12026-02-01T00:00:00.000000+00:002026-02-03T00:00:00.000000+00:00
SME-A-4taxinvoice_revenuetax-a-v222026-01-31T00:00:00.000000+00:002026-03-11T00:00:00.000000+00:00
SME-A-4utilitykwhpower-a12026-02-01T00:00:00.000000+00:002026-02-03T00:00:00.000000+00:00
SME-A-5taxinvoice_revenuetax-a-feb12026-02-28T00:00:00.000000+00:002026-03-20T00:00:00.000000+00:00
SME-B-2banknet_inflowcash-b-v222026-02-10T00:00:00.000000+00:002026-02-13T00:00:00.000000+00:00
SME-B-3banknet_inflowcash-b-v222026-02-10T00:00:00.000000+00:002026-02-13T00:00:00.000000+00:00
SME-B-4banknet_inflowcash-b-v222026-02-10T00:00:00.000000+00:002026-02-13T00:00:00.000000+00:00
SME-B-4taxinvoice_revenuetax-b12026-01-31T00:00:00.000000+00:002026-03-01T00:00:00.000000+00:00
SME-B-4utilitykwhpower-b12026-02-01T00:00:00.000000+00:002026-03-02T00:00:00.000000+00:00
SME-B-5banknet_inflowcash-b-v222026-02-10T00:00:00.000000+00:002026-02-13T00:00:00.000000+00:00
SME-B-5taxinvoice_revenuetax-b12026-01-31T00:00:00.000000+00:002026-03-01T00:00:00.000000+00:00

Replay locally

pitbridge verify --out demo checks file hashes, recomputes every snapshot through both implementations, and compares all derived evidence. Hashes detect accidental edits; they are not a digital signature.