Database coverage#
/v1/metano authWhat the market database covers: first and last session, row counts, how many symbols, and whether the latest session has published yet.
Response fields
first_datestringThe earliest session with bar data, YYYY-MM-DD.
last_datestringThe most recent session loaded. Scans, stats and alerts answer as of this day unless asked otherwise. To judge freshness, read data_stale rather than comparing this with today — it already knows the market's calendar.
data_stalebooleanThe session that should have published has not arrived. NSE closes at 15:30 IST and the daily data lands during the evening, so this turns true after 17:00 IST on a trading day whose session is still missing, and false again when it loads. Weekends never raise it, and neither do the market holidays we have been told about.
bar_rowsnumberOHLCV rows in the database, across all symbols and history.
metric_rowsnumberRows of derived per-session metrics — returns, RSI, moving averages and the rest of the column vocabulary.
symbol_countnumberInstruments in the database.
metric_yearsnumberHow many years back the derived metrics reach. Bars go back further — to first_date — but scans need metrics, so this is the scannable window.
built_atstringWhen the database was built, RFC 3339 in UTC.
fno_first_date, funda_first_date, dividend_first_date, insider_first_date, deals_first_datestringoptionalWhere each store's record begins. Prices reach back to 1995; these do not, so a scan that reaches further back than a store is matching against nothing.
fno_last_date, dividend_last_date, insider_last_date, deals_last_datestringoptionalThe most recent session each store holds. One that trails last_date has not caught up with the session.
fno_symbols_on_lastnumberSymbols with an F&O row on fno_last_date.
pe_coverage, shp_coverage, sector_coverage, quarter_symbols, calendar_symbols, dividend_coverage, insider_symbolsnumberHow many symbols carry each kind of data: a P/E, a shareholding pattern, a sector, at least one quarter of results, at least one calendar entry, a dividend in the trailing year, and at least one insider disclosure.
curl -s "https://api.patternsradar.com/v1/meta"{
"first_date": "1995-01-02",
"last_date": "2026-08-14",
"bar_rows": 14162010,
"metric_rows": 5834290,
"symbol_count": 2412,
"metric_years": 10,
"data_stale": false,
"fno_first_date": "2000-06-12",
"funda_first_date": "2016-01-13",
"dividend_first_date": "2012-01-03",
"dividend_last_date": "2026-08-28",
"insider_first_date": "2015-11-19",
"insider_last_date": "2026-10-16",
"deals_first_date": "2004-01-04",
"deals_last_date": "2026-10-01",
"built_at": "2026-10-17T09:18:01Z",
"fno_last_date": "2026-10-16",
"fno_symbols_on_last": 218,
"pe_coverage": 1660,
"shp_coverage": 2200,
"sector_coverage": 2310,
"quarter_symbols": 2396,
"calendar_symbols": 3180,
"dividend_coverage": 750,
"insider_symbols": 2496
}{
"type": "https://patternsradar.com/docs/api/errors#rate_limited",
"title": "too many requests",
"status": 429,
"detail": "too many requests — slow down or upgrade your plan",
"instance": "/v1/meta",
"code": "rate_limited",
"request_id": "6d0b7f3a9c214e08"
}