Yahoo Finance - VNQ and Individual Diversified REIT Ticker Pages

One template, two layers, an entire listed industry. Yahoo Finance publishes a quote page for every US-listed ticker, and for diversified real estate the anchor is VNQ - Vanguard Real Estate Index Fund ETF Shares - whose summary view exposes eighteen documented fields: Previous Close, Open, Bid, Ask, Day's Range, 52 Week Range, Volume, Avg. Volume, Net Assets, NAV, PE Ratio (TTM), Yield, YTD Daily Total Return, Beta (5Y Monthly) and net Expense Ratio, above Fund Family (Vanguard), Fund Category (Real Estate) and Inception Date 2004-09-23. Every individual diversified REIT ticker renders on the identical template, so one dictionary describes benchmark and cohort alike.

What lifts the record past a price feed is everything below the summary: the Top 10 Holdings table with Symbol, Company and % Assets - Vanguard Real Estate II Index at 14.41% and Welltower at 8.46% in the captured sample - the Sector Weightings comparison, Performance Overview rows for YTD, one-year and three-year returns against category, and a daily bar series with dividend and split events. Within Datadory's catalog of 1,744 datasets this record scores 7/10 against a 7.81 catalog mean, with all twenty-six field definitions verified during the August 2026 research pass. Get a sample of this dataset scoped to your tickers before you build anything on top of it.

Two shapes cover the whole record: one row per trading day, and one row per holding. These come straight from the record's own sample:

# daily bar shape -- one row per trading day, verbatim column names
timestamp_date : 2026-08-20
symbol         : VNQ
open           : 98.53
high           : 99.09
low            : 98.18
close          : 98.6
volume         : 2264600

timestamp_date : 2026-08-19
symbol         : VNQ
open           : 98.18
high           : 98.65
low            : 97.86
close          : 98.61
volume         : 2572200

timestamp_date : 2026-08-18
symbol         : VNQ
open           : 98.58
high           : 98.64
low            : 97.58
close          : 97.62
volume         : 2655400

# holdings snapshot shape -- top positions of the fund, verbatim column names

holding_symbol : VRTPX
company        : Vanguard Real Estate II Index
pct_assets     : 14.41%

holding_symbol : WELL
company        : Welltower Inc.
pct_assets     : 8.46%

Read the bars as three ordinary August sessions for the benchmark: 98.60 on 2,264,600 shares on 2026-08-20, 98.61 on 2,572,200 the day before, and 97.62 on 2,655,400 the day before that - an intraday range of 0.91 points on the newest bar, which is the kind of spread range-bound strategies live inside. The holding rows show why the top-ten table matters: Vanguard Real Estate II Index alone is 14.41% of assets, so anyone treating VNQ as a pure play on operating companies is really buying a fund-of-funds wrapper first. Delivered rows carry both shapes keyed on ticker, so the bar panel and the holdings snapshot join without reshaping.

Twenty-six documented fields, verified during the August 2026 research pass. Four groups organize them.

Quote snapshot - Previous Close, Open, Bid, Ask, Day's Range, 52 Week Range, Volume and Avg. Volume say where a ticker stands this session and how heavily it trades.

Fund profile - Net Assets, NAV, PE Ratio (TTM), Yield, YTD Daily Total Return, Beta (5Y Monthly) and net Expense Ratio describe the vehicle itself, with Fund Family, Fund Category and Inception Date pinning it to Vanguard, to Real Estate and to 2004-09-23.

Holdings and composition - Symbol, Company and % Assets name the positions; the Sector column carries the weightings comparison against the fund's own mix.

Historical bars - timestamp plus open, high, low, close, volume and adjclose, the adjusted close being the column that makes multi-year total-return math honest because dividends and splits are already folded in.

Beyond the verified core, total-return series, weekly and monthly resamples and sector-weighting history sit under additional fields on request: named at sampling, delivered as typed columns.

• Geography - listings worldwide with US exchanges primary, which suits the diversified REIT cohort: its roughly 100 to 200 tickers are US-listed, and the real estate ETFs around them trade on the same venues.
• Temporal - the fund profile anchors at VNQ's 2004-09-23 inception, so twenty-plus years of expense ratios, yields and net assets exist for the benchmark; bar depth runs from the latest session back through decades of daily history, with dividend and split events marked on the bars they affected.
• Granularity - a per-ticker quote snapshot layered over one row per ticker per session. The snapshot answers where a name stands now; the bar panel answers where it has been, and because both share one dictionary the same downstream code consumes them.

Set against the shelf, this is the record that sees the whole listed market at once - the demand datasets beside it see the tenants, not the tickers.

API, files, or your warehouse. Daily, weekly, or hourly.

A quote-page corpus fits wherever the work happens: the whole bar panel loaded to Snowflake, BigQuery or Redshift keyed on ticker x date so yesterday's rows append cleanly, filtered extracts served over API when a single screen needs one ticker, or a standing feed into your models so the NAV, yield and expense-ratio columns stay current. Cadence is yours to set and change - load the history once, then let new sessions accrue onto the same keys.

Every delivery ships the complete field dictionary above, sample rows for validation and any additional fields you requested pre-joined, so the first query you run is already shaped like the last one.

Ranked by how directly one scoped extract settles the day job:

1. Quant and portfolio teams - VNQ supplies the passive real-estate leg of allocation models, returns already sitting beside their category benchmarks.
2. Factor and backtest engineers - daily OHLCV with adjusted closes and corporate-action events removes the classic survivorship-of-prices trap from signal work.
3. Income strategists - Yield, NAV and net Expense Ratio rank a REIT peer set on distribution against running cost in one pass.
4. Data-product developers - the quote-strip fields users expect, delivered as rows keyed on ticker x date instead of pages to parse.
5. Market researchers - sector weightings give a market-composition read for background sections: which property types the listed market is rewarding.
6. Competitive intelligence teams - named peers with net assets, yield and expense ratio attached make side-by-side positioning slides a filter, not a project.

Investors and quants get benchmark and cohort under one dictionary - returns against category, beta against the market, holdings behind the ticker. Data scientists and ML engineers get a stable ticker x date panel with adjusted closes already resolved. Developers and data-product builders get the quote-strip fields every real-estate product front-ends, shaped for loading rather than parsing. Market researchers and consultants get sector weightings as a composition read for the markets they advise on. Competitive intel and product teams get named peers with scale fields attached. Start from the diversified REITs data hub, then see how the shelf ranks it on best diversified REITs datasets.

Grain note - the bar panel is one row per ticker per session, and it comes in two flavors that answer different questions: raw close for what the tape printed that day, adjclose for what a holder earned once dividends and splits are counted. Pick the wrong column and a decade-long chart quietly understates total return.

Snapshot note - holdings percentages and sector weightings describe the composition at their capture date, and compositions drift; treat weights as point-in-time and ask for the weighting history when a trend matters more than a position.

Where to go next - the rail below collects the deeper-history tape, the tenant-economics companions and the international cut. Browse the shelf on the best diversified REITs datasets ranking or the diversified REITs data hub. For terminology, start with what daily OHLCV history means or what dividend yield means.