Source operations
Sanjaya freshness board
Live quote paths, official snapshots, scraper runs, row counts, and source dates for the public data surface.
| Dataset | Status | Source as of | Last run | Rows | Source | Cadence |
|---|---|---|---|---|---|---|
| Runtime markets | ||||||
| Brent futures Best free delayed futures/FX quote selected at request time. | delayed | 29 Jul, 08:11 am UTC | 29 Jul, 08:11 am UTC | - | OilPrice.com delayed Brent futures | Runtime request-time quote fetch; public market quotes are provider-delayed. |
| WTI spot Free delayed quote providers were unavailable during this request. | snapshot | 27 Jul 2026 | 29 Jul, 08:11 am UTC | - | Sanjaya checked-in official snapshot | Checked-in official snapshot, used only when live quote providers are unavailable at request time. |
| Henry Hub spot Free delayed quote providers were unavailable during this request. | snapshot | 20 Jul 2026 | 29 Jul, 08:11 am UTC | - | Sanjaya checked-in official snapshot | Checked-in official snapshot, used only when live quote providers are unavailable at request time. |
| USD / INR Free delayed quote providers were unavailable during this request. | snapshot | 28 Jul 2026 | 29 Jul, 08:11 am UTC | - | Sanjaya checked-in official snapshot | Checked-in official snapshot, used only when live quote providers are unavailable at request time. |
| Daily price spine | ||||||
| Metro petrol/diesel RSP Official metro pump-price PDF parsed into city/product rows. | live | 29 Jul 2026 | 29 Jul, 07:13 am UTC | 26,648 | PPAC daily metro PDF | daily |
| Computed retail price waterfall Recomputed after the retail-price scraper runs. | live | 29 Jul 2026 | 29 Jul, 07:13 am UTC | 536 | Sanjaya materialisation from RSP, excise, VAT, and dealer commission | computed |
| Market history | ||||||
| Brent spot history Checked-in history; runtime cards use the delayed futures layer above. | live | 27 Jul 2026 | 29 Jul, 07:13 am UTC | 9,938 | EIA daily spot tail plus FRED Brent proxy history | daily |
| WTI spot history Checked-in history with official EIA/FRED source trail. | live | 27 Jul 2026 | 29 Jul, 07:13 am UTC | 10,206 | EIA daily spot tail plus FRED WTI history | daily |
| Henry Hub natural gas Daily US natural-gas benchmark snapshot. | fallback | 20 Jul 2026 | 29 Jul, 07:13 am UTC | 7,415 | FRED DHHNGSP | daily |
| USD/INR Daily ECB rates transformed into USD/INR. | live | 28 Jul 2026 | 29 Jul, 07:13 am UTC | 71 | ECB euro reference rates, cross-derived | daily |
| US crude inventory Weekly US crude stock series excluding SPR. | snapshot | 17 Jul 2026 | 29 Jul, 07:13 am UTC | 2,286 | EIA WCESTUS1 | weekly |
| Companies and comparables | ||||||
| Indian oil PSU stocks Daily OHLCV for oil and gas public-sector equities. | live | 29 Jul 2026 | 29 Jul, 07:13 am UTC | 8,106 | Yahoo Finance NSE quotes | daily |
| OMC quarterly fundamentals Quarterly revenue, income, and margin rows for listed oil and gas companies. | live | 30 Jun 2026 | 29 Jul, 07:13 am UTC | 45 | Yahoo Finance financial statements | quarterly |
| Official reports | ||||||
| PPAC monthly petroleum statistics Official monthly production, refining, import, and export statistics. Last run failed: Monthly Report URL not found on PPAC homepage | fallback | Mar 2026 | 29 Jul, 07:13 am UTC | 2 | PPAC monthly report PDF | monthly |
| Global petrol prices Country-level gasoline price comparison. Last run failed: 405 Client Error: Not Allowed for url: https://tradingeconomics.com/country-list/gasoline-prices | live | 20 Jul 2026 | 29 Jul, 07:13 am UTC | 44 | TradingEconomics country gasoline table | monthly |
| ATF city prices Monthly aviation turbine fuel prices by city. Last run failed: No ATF price data found from any source | fallback | 01 Apr 2025 | 26 Jul, 06:06 am UTC | 72 | IOCL aviation fuel price publication | monthly |
| Commercial LPG city prices Monthly 19 kg commercial LPG cylinder prices by city. | fallback | 01 Apr 2025 | 26 Jul, 06:08 am UTC | 60 | IOCL petroleum product price publication | monthly |
| Reference tables | ||||||
| Central excise rates Reference tax table refreshed when the official source changes. | snapshot | 24 Jul 2026 | 26 Jul, 06:05 am UTC | 28 | PPAC excise table | reference |
| Dealer commission history Reference commission history used by the price waterfall. | snapshot | 01 Dec 2024 | 26 Jul, 06:05 am UTC | 46 | PPAC dealer/distributor commission table | reference |
| State VAT formulas State-level tax formula table used by explainers and computation. | snapshot | 24 Jul 2026 | 26 Jul, 06:05 am UTC | 74 | PPAC VAT/sales-tax/GST table | reference |
| Timeline events Manual chronology for excise, policy, and crisis annotations. | snapshot | 15 Feb 2026 | - | 9 | Curated Sanjaya chronology | reference |