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 | 27 Apr, 07:37 pm UTC | 27 Apr, 07:47 pm UTC | - | OilPrice.com delayed Brent futures | Runtime quote fetch with a short Sanjaya cache; public market quotes are provider-delayed. |
| WTI futures Best free delayed futures/FX quote selected at request time. | delayed | 27 Apr, 07:47 pm UTC | 27 Apr, 07:47 pm UTC | - | Stooq delayed futures/FX | Runtime quote fetch with a short Sanjaya cache; public market quotes are provider-delayed. |
| Natural gas Best free delayed futures/FX quote selected at request time. | delayed | 27 Apr, 07:47 pm UTC | 27 Apr, 07:47 pm UTC | - | Stooq delayed futures/FX | Runtime quote fetch with a short Sanjaya cache; public market quotes are provider-delayed. |
| USD / INR Best free delayed futures/FX quote selected at request time. | delayed | 27 Apr, 10:00 am UTC | 27 Apr, 07:47 pm UTC | - | Stooq delayed futures/FX | Runtime quote fetch with a short Sanjaya cache; public market quotes are provider-delayed. |
| Daily price spine | ||||||
| Metro petrol/diesel RSP Official metro pump-price PDF parsed into city/product rows. | live | 27 Apr 2026 | 27 Apr, 08:45 am UTC | 25,896 | PPAC daily metro PDF | daily |
| Computed retail price waterfall Recomputed after the retail-price scraper runs. | live | 27 Apr 2026 | 27 Apr, 08:46 am UTC | 40 | 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. | snapshot | 23 Apr 2026 | 27 Apr, 08:45 am UTC | 9,875 | EIA daily spot tail plus FRED Brent proxy history | daily |
| WTI spot history Checked-in history with official EIA/FRED source trail. | snapshot | 23 Apr 2026 | 27 Apr, 08:46 am UTC | 10,144 | EIA daily spot tail plus FRED WTI history | daily |
| Henry Hub natural gas Daily US natural-gas benchmark snapshot. | fallback | 20 Apr 2026 | 27 Apr, 08:46 am UTC | 7,353 | FRED DHHNGSP | daily |
| USD/INR Daily ECB rates transformed into USD/INR. | snapshot | 24 Apr 2026 | 27 Apr, 08:45 am UTC | 5 | ECB euro reference rates, cross-derived | daily |
| US crude inventory Weekly US crude stock series excluding SPR. | snapshot | 17 Apr 2026 | 27 Apr, 08:46 am UTC | 2,273 | EIA WCESTUS1 | weekly |
| Companies and comparables | ||||||
| Indian oil PSU stocks Daily OHLCV for oil and gas public-sector equities. | live | 27 Apr 2026 | 27 Apr, 08:46 am UTC | 7,503 | Yahoo Finance NSE quotes | daily |
| OMC quarterly fundamentals Quarterly revenue, income, and margin rows for listed oil and gas companies. | live | 31 Dec 2025 | 27 Apr, 08:46 am UTC | 35 | Yahoo Finance financial statements | quarterly |
| Official reports | ||||||
| PPAC monthly petroleum statistics Official monthly production, refining, import, and export statistics. | snapshot | Feb 2026 | 27 Apr, 08:46 am UTC | 1 | PPAC monthly report PDF | monthly |
| Global petrol prices Country-level gasoline price comparison. | live | 01 Mar 2026 | 27 Apr, 08:46 am UTC | 23 | TradingEconomics country gasoline table | monthly |
| ATF city prices Monthly aviation turbine fuel prices by city. | fallback | 01 Apr 2025 | 26 Apr, 12:45 pm 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 Apr, 12:47 pm UTC | 60 | IOCL petroleum product price publication | monthly |
| Reference tables | ||||||
| Central excise rates Reference tax table refreshed when the official source changes. | snapshot | 24 Apr 2026 | 26 Apr, 05:40 am UTC | 4 | PPAC excise table | reference |
| Dealer commission history Reference commission history used by the price waterfall. | snapshot | 01 Dec 2024 | 26 Apr, 05:40 am UTC | 46 | PPAC dealer/distributor commission table | reference |
| State VAT formulas State-level tax formula table used by explainers and computation. | snapshot | 24 Apr 2026 | 26 Apr, 05:40 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 |