Downloads

valan_sample_1k_fin_awards.parquet

Parquet · 43 KB · 1,000 awards

valan_sample_1k_fin_awards.csv

CSV · 223 KB · identical content

valan_sample_loader.py

Python reference loader · pandas + pyarrow

README.md

Usage rules · PIT discipline · compliance notes

python valan_sample_loader.py valan_sample_1k_fin_awards.parquet

Scope — read first

This is a curated investable-only slice (investable_flag = TRUE on every row). In the full universe only ~17% of awards (12.3M of 71.9M) carry a tradable ticker — do not extrapolate coverage from this file. It demonstrates the schema, identity resolution, and point-in-time mechanics, not the live hit-rate.
award_value is in local currency (AUD, BRL, CZK, EUR, HUF, PLN, USD in this slice). Never sum across currencies.

Point-in-time / forward-bias — read before backtesting

ticker_as_of with pit_confirmed = TRUE — the ticker as of the award date, sourced from a genuine dated listing window. Forward-bias-free. Use this for backtests.
ultimate_parent_ticker — the supplier's current ownership rollup (who owns it today), not as-of the award. Useful for screening; look-ahead present.
The reference loader keeps these strictly separate rather than hiding the split inside the rollup. The same discipline applies in the full feed: a ticker is either genuinely point-in-time or honestly NULL — never a current value dressed as as-of.

Compliance — verified at export

PII-clean: email PII removed, verified zero. Business-contact phones retained as published procurement data.
No PRC-sourced data (ccgp_* sources and buyer_country='CN' excluded). Russia/Belarus excluded on/after 2022-02-24.
CUI/radioactive rows excluded from the standard feed. No sanctioned buyer or supplier present in this slice.

What the full feed adds

The sample is one table. The full feed is six: fin_awards (71.9M financial-modelled awards), master_awards (71.9M text-rich awards with titles, descriptions, and source URLs), fin_tenders / master_tenders (25M open solicitations — the forward pipeline), entity_dim (312,156 resolved companies, LEI-bridged), and subcontract_graph (3.3M sub→prime edges). Daily refresh, manifest with SHA256 checksums per table, delivery as S3 parquet. Full schema: valan.io/data-dictionary.

For full-feed access or institutional enquiries: john@valan.io

Sample the Feed

Downloads

What the full feed adds