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 | 14 Jun, 04:47 am UTC | 14 Jun, 04:47 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 | 11 Jun 2026 | 14 Jun, 04:47 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 | 26 May 2026 | 14 Jun, 04:47 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 | 12 Jun 2026 | 14 Jun, 04:47 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 | 12 Jun 2026 | 13 Jun, 09:42 am UTC | 26,272 | PPAC daily metro PDF | daily |
| Computed retail price waterfall Recomputed after the retail-price scraper runs. | live | 12 Jun 2026 | 13 Jun, 09:44 am UTC | 288 | 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. Last run failed: HTTPSConnectionPool(host='fred.stlouisfed.org', port=443): Read timed out. (read timeout=30) | snapshot | 11 Jun 2026 | 13 Jun, 09:43 am UTC | 9,899 | EIA daily spot tail plus FRED Brent proxy history | daily |
| WTI spot history Checked-in history with official EIA/FRED source trail. Last run failed: HTTPSConnectionPool(host='fred.stlouisfed.org', port=443): Read timed out. (read timeout=30) | snapshot | 11 Jun 2026 | 13 Jun, 09:43 am UTC | 10,169 | EIA daily spot tail plus FRED WTI history | daily |
| Henry Hub natural gas Daily US natural-gas benchmark snapshot. Last run failed: HTTPSConnectionPool(host='fred.stlouisfed.org', port=443): Read timed out. (read timeout=30) | fallback | 26 May 2026 | 13 Jun, 09:44 am UTC | 7,378 | FRED DHHNGSP | daily |
| USD/INR Daily ECB rates transformed into USD/INR. | live | 12 Jun 2026 | 13 Jun, 09:42 am UTC | 39 | ECB euro reference rates, cross-derived | daily |
| US crude inventory Weekly US crude stock series excluding SPR. | live | 05 Jun 2026 | 13 Jun, 09:44 am UTC | 2,280 | EIA WCESTUS1 | weekly |
| Companies and comparables | ||||||
| Indian oil PSU stocks Daily OHLCV for oil and gas public-sector equities. | live | 12 Jun 2026 | 13 Jun, 09:44 am UTC | 7,809 | Yahoo Finance NSE quotes | daily |
| OMC quarterly fundamentals Quarterly revenue, income, and margin rows for listed oil and gas companies. | live | 31 Mar 2026 | 13 Jun, 09:44 am UTC | 42 | 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 | snapshot | Mar 2026 | 13 Jun, 09:44 am UTC | 2 | PPAC monthly report PDF | monthly |
| Global petrol prices Country-level gasoline price comparison. | live | 01 May 2026 | 13 Jun, 09:44 am UTC | 23 | TradingEconomics country gasoline table | monthly |
| ATF city prices Monthly aviation turbine fuel prices by city. | fallback | 01 Apr 2025 | 07 Jun, 07: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 | 07 Jun, 07:07 am UTC | 60 | IOCL petroleum product price publication | monthly |
| Reference tables | ||||||
| Central excise rates Reference tax table refreshed when the official source changes. | snapshot | 06 Jun 2026 | 07 Jun, 07:05 am UTC | 14 | PPAC excise table | reference |
| Dealer commission history Reference commission history used by the price waterfall. | snapshot | 01 Dec 2024 | 07 Jun, 07:05 am UTC | 46 | PPAC dealer/distributor commission table | reference |
| State VAT formulas State-level tax formula table used by explainers and computation. | snapshot | 06 Jun 2026 | 07 Jun, 07: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 |