> ## Documentation Index
> Fetch the complete documentation index at: https://fruitstand.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Historical US Stock, ETF & Mutual Fund Prices in Snowflake

> Daily prices for 49,000+ US stocks, ETFs and mutual funds in Snowflake: raw and adjusted OHLC plus volume, back to 1962. Free 30-day trial.

> [!TIP]
>
> **Try it free for 30 days.** Get full use of the full daily price history for every stock, ETF and mutual fund during the trial, with raw and adjusted prices and the same daily updates subscribers get.

## Overview

The Historical Stock Prices listing delivers the complete daily end-of-day (EOD) price history for more than 49,000 US stocks, ETFs and mutual funds: 155 million daily price rows, back to 1962 for the oldest stocks, with no files to download and no APIs to call. Start with a free 30-day trial with full use of the data.

It's built for quant researchers, analysts and data teams who need clean daily prices next to their own data in Snowflake for returns, backtests, risk models and dashboards, without writing and maintaining a market data pipeline.

Data is standardized into two analytic‑ready views (security reference, daily price history) with raw open, high, low and close alongside split- and dividend-adjusted open, high, low and close, plus automated pipeline quality checks (unique grain, placeholder price removal, corporate-action restatement). You can query, join, backtest and build dashboards right away.

> [card] [Start your free 30-day trial on the Snowflake Marketplace](https://app.snowflake.com/marketplace/listing/GZTYZTG3LNFA)
>
> **Free for 30 days** with full use, then **\$100/month** flat rate — no pipelines to build.

**Pricing**: one flat subscription of \$100/month, billed monthly in advance through Snowflake. It includes both views, every stock, ETF and mutual fund with full history, and every daily refresh. There are no per-query, per-row or per-user fees; your own Snowflake warehouse pays for the queries you run.

* **Free 30-day trial** with full use of both views and every security
* **49,000+ US securities**: 17,369 common stocks, 496 preferred stocks, 5,963 ETFs and 25,639 mutual funds
* **155M+ daily price rows**, back to each security's first trading day: 1962 for the oldest stocks, 1973 for mutual funds, 1993 for SPY
* **Raw and adjusted OHLC**: as-traded open, high, low and close, plus versions adjusted for splits and dividends/distributions
* **Refreshed daily by 5:00 AM Pacific**, with every security's full history refetched and restated twice a week
* **One format for every asset class**, so stocks, ETFs and mutual funds can be analyzed with the same query
* **Automated pipeline quality checks** (unique grain, placeholder price removal, corporate-action restatement)

Fruit Stand also publishes [fund and ETF returns](https://fruitstand.dev/datasets/fund-returns.md), [FRED economic data](https://fruitstand.dev/datasets/fred-series.md), [earnings call transcripts](https://fruitstand.dev/datasets/earnings-call-transcripts.md) and [EIA energy data](https://fruitstand.dev/datasets/eia-energy-data.md) on the Snowflake Marketplace.

## What is end-of-day price data?

End-of-day price data records one bar per security per trading day: the open, high, low and close, plus the number of shares traded. Stocks and ETFs trade all day on an exchange, so each bar has a real range. Mutual funds don't trade intraday: each one publishes a single net asset value (NAV) per share after the market closes, and that NAV is the day's price.

Raw prices show what traded on the day, but they jump on splits and drop on ex-dividend dates. Adjusted prices restate history for every split and dividend since, so a price series stays continuous and can be used to measure total return. This listing carries both. The prices come from a commercial market data provider through its API; Fruit Stand loads, cleans and publishes them in Snowflake.

What's available, at a glance:

* **Stocks**: US common stocks on NYSE, NASDAQ, NYSE American and Cboe, plus OTC stocks (Pink, OTCQB, OTCQX and other OTC tiers)
* **Preferred stocks**: exchange-listed preferreds, trust preferreds and some baby bonds
* **ETFs**: US-listed exchange-traded funds and a few exchange-traded commodities
* **Mutual funds**: daily NAVs for US open-end mutual funds, plus some exchange-traded closed-end funds
* **Prices**: raw open, high, low, close and volume, and split- and dividend-adjusted open, high, low and close
* **Reference data**: name, exchange, security type, normalized asset class, ISIN and active/inactive status

## Coverage

As of November 2026:

| Asset class | Securities | Daily price rows | History |
| - | - | - | - |
| Common stocks | 17,369 | \~51.3M | From 1962 (e.g. KO, IBM, JNJ) |
| Preferred stocks | 496 | \~1.0M | From 1972 (PCG-PC) |
| ETFs | 5,963 | \~8.9M | From 1993 (SPY) |
| Mutual funds | 25,639 | \~93.9M | From 1973 |
| **Total** | **49,467** | **\~155.1M** | |

Counts are active securities. 11,242 of the stocks trade over the counter rather than on a national exchange; filter on `exchange` to keep or drop them. Half of all securities have history starting in 2013 or later; 2,679 stocks and 3,160 mutual funds have history from before 2000.

Every security is US-listed and priced in US dollars. Securities are keyed by `code` and `exchange_code` together, so exchanges outside the US can be added later without breaking existing queries.

**Not included**: intraday or real-time prices, securities listed outside the US, and price history for securities that have been delisted (see [Disclosures](#disclosures)).

## Schema

The listing's share has two secure views: `security_vw` (one row per security) and `security_price_history_vw` (one row per security per trading day). Join them on `code` and `exchange_code`, for example `code = 'AAPL'` and `exchange_code = 'US'`.

### `security_vw`

One row per security, including securities that have since dropped off the US symbol list.

| Column | Type | Description |
| - | - | - |
| `code` | `varchar` | Ticker symbol (e.g. `AAPL`, `BAC-PL`, `VFIAX`) |
| `exchange_code` | `varchar` | Exchange group the ticker belongs to (`US` for all US-listed securities) |
| `name` | `varchar` | Security name |
| `country` | `varchar` | Country of listing (`USA`) |
| `exchange` | `varchar` | Listing venue (e.g. `NYSE`, `NASDAQ`, `NYSE ARCA`, `BATS`, `PINK`, `NMFQS` for mutual funds) |
| `currency` | `varchar` | Trading currency (`USD`) |
| `type` | `varchar` | Security type as reported by the source: `Common Stock`, `Preferred Stock`, `ETF`, `ETC`, `FUND` or `Mutual Fund` |
| `asset_class` | `varchar` | Normalized asset class: `stock`, `etf` or `fund` |
| `isin` | `varchar` | International Securities Identification Number; null for about 14,000 securities |
| `is_inactive` | `boolean` | `true` once the security drops out of the daily US symbol list |
| `inactive_date` | `varchar` | Date the security was marked inactive, as `YYYY-MM-DD`; null while active |
| `src_created_at` | `timestamp_ltz` | When this security first arrived in the listing |
| `src_updated_at` | `timestamp_ltz` | When this row last changed, e.g. a name change or being marked inactive |

Use `asset_class` rather than `type` to filter by stocks, ETFs or mutual funds. The source's `type` labels aren't consistent (mutual funds come as both `FUND` and `Mutual Fund`), so `asset_class` is set from the symbol list each security came from.

### `security_price_history_vw`

One row per `(code, exchange_code, date)`, for each day the security traded.

| Column | Type | Description |
| - | - | - |
| `code` | `varchar` | Ticker symbol |
| `exchange_code` | `varchar` | Exchange group the ticker belongs to |
| `date` | `date` | Trading date |
| `open` | `float` | Opening price, as traded (NAV for mutual funds) |
| `high` | `float` | Daily high, as traded (NAV for mutual funds) |
| `low` | `float` | Daily low, as traded (NAV for mutual funds) |
| `close` | `float` | Official closing price, as traded (NAV for mutual funds) |
| `adjusted_close` | `float` | Closing price adjusted for splits and dividends/distributions |
| `adjusted_open` | `float` | Opening price adjusted for splits and dividends/distributions |
| `adjusted_high` | `float` | Daily high adjusted for splits and dividends/distributions |
| `adjusted_low` | `float` | Daily low adjusted for splits and dividends/distributions |
| `volume` | `number(38,0)` | Shares traded, adjusted for splits; 0 for mutual funds |
| `src_created_at` | `timestamp_ltz` | When this row was written to the listing |
| `src_updated_at` | `timestamp_ltz` | When this row last changed. Every row is rewritten by the twice-weekly full restatement. |

`open`, `high`, `low` and `close` are the prices as they traded on that day. `adjusted_close` is backward-adjusted for every split and dividend/distribution since, so use it for returns, charts and backtests.

`adjusted_open`, `adjusted_high` and `adjusted_low` apply the same day's adjustment factor to the raw prices: `adjusted_open = open * adjusted_close / close`, rounded to 4 decimals (null when `close` is 0). That gives you a full adjusted OHLC bar for every day, so candlestick charts, daily ranges and indicators like ATR stay continuous across splits and ex-dividend dates. They're calculated in the view from the current `adjusted_close`, so they're never out of step with it after a restatement.

`volume` is adjusted for splits only: after a 4-for-1 split, earlier volumes are multiplied by 4 so share counts are comparable across the split.

Mutual funds priced once a day (`exchange = 'NMFQS'`) have `open`, `high`, `low` and `close` all equal to the day's NAV and `volume` of 0. About 335 securities in the `fund` asset class are listed on NYSE, NASDAQ, NYSE American or Pink; these trade on an exchange and have real intraday prices and volume.

## Example queries

All example output below is real, pulled from the listing on **November 20, 2026 at 04:22 UTC**, when the latest trading date was November 18, 2026. Each query finished in under 3 seconds on an X-Small warehouse. Run the same queries yourself during the [free 30-day trial](https://app.snowflake.com/marketplace/listing/GZTYZTG3LNFA).

### Latest closing prices

The most recent close for a stock, an ETF and a mutual fund:

```sql theme={null}
select s.code, s.name, s.asset_class, p.date, p.close, p.adjusted_close, p.volume
from security_vw s
join security_price_history_vw p
  on p.code = s.code
 and p.exchange_code = s.exchange_code
where s.code in ('AAPL', 'SPY', 'VFIAX')
  and s.exchange_code = 'US'
qualify row_number() over (partition by s.code order by p.date desc) = 1
order by s.code;
```

| code | name | asset\_class | date | close | adjusted\_close | volume |
| - | - | - | - | - | - | - |
| AAPL | Apple Inc. | stock | 2026-11-18 | 352.45 | 352.45 | 34,209,928 |
| SPY | State Street® SPDR® S\&P 500® ETF Trust | etf | 2026-11-18 | 730.20 | 730.20 | 50,096,852 |
| VFIAX | VANGUARD 500 INDEX FUND ADMIRAL SHARES | fund | 2026-11-18 | 676.66 | 676.66 | 0 |

### Find securities by name

Every active Bank of America preferred stock:

```sql theme={null}
select code, name, exchange, isin
from security_vw
where type = 'Preferred Stock'
  and name ilike 'bank of america%'
  and not is_inactive
order by code;
```

First 6 of 15 rows:

| code | name | exchange | isin |
| - | - | - | - |
| BAC-PB | Bank of America Corporation | NYSE | |
| BAC-PE | Bank of America Corporation | NYSE | |
| BAC-PK | Bank of America Corporation | NYSE | US0605051954 |
| BAC-PL | Bank of America Corporation | NYSE | US0605056821 |
| BAC-PM | Bank of America Corporation | NYSE | US06053U6010 |
| BAC-PN | Bank of America Corporation | NYSE | US06055H2022 |

For more on preferreds, including how their tickers are spelled across data sources, see [Where to Get Preferred Stock Price History, With SQL](https://fruitstand.dev/blog/preferred-stock-price-history.md).

### Daily price history for one ticker

The last five trading days of SPY:

```sql theme={null}
select date, open, high, low, close, adjusted_close, volume
from security_price_history_vw
where code = 'SPY'
  and exchange_code = 'US'
order by date desc
limit 5;
```

| date | open | high | low | close | adjusted\_close | volume |
| - | - | - | - | - | - | - |
| 2026-11-18 | 733.37 | 735.06 | 726.795 | 730.20 | 730.20 | 50,096,852 |
| 2026-11-17 | 738.39 | 739.76 | 727.00 | 732.44 | 732.44 | 71,636,294 |
| 2026-11-16 | 749.66 | 749.82 | 738.07 | 739.95 | 739.95 | 69,207,282 |
| 2026-11-13 | 760.07 | 760.12 | 747.88 | 754.37 | 754.37 | 38,720,038 |
| 2026-11-12 | 753.98 | 763.04 | 753.67 | 757.12 | 757.12 | 37,460,600 |

SPY's full history, using the adjusted close on the last trading day of each month, so dividends are included:

**SPY adjusted close, month-end since 1993**

Apple over the last five years, using the adjusted close on the last trading day of each week:

**AAPL adjusted close, weekly**

### Year-to-date leaders on NASDAQ

The ten best-performing NASDAQ common stocks this year, among those that closed 2025 at $5 or more and averaged at least $50M a day in dollar volume:

```sql theme={null}
with px as (
    select s.code, s.name, p.date, p.close, p.adjusted_close, p.volume
    from security_vw s
    join security_price_history_vw p
      on p.code = s.code
     and p.exchange_code = s.exchange_code
    where s.exchange = 'NASDAQ'
      and s.type = 'Common Stock'
      and not s.is_inactive
      and p.date >= '2025-12-31'
)
select code, name,
       min_by(close, date) as close_2025_12_31,
       max_by(close, date) as latest_close,
       round((max_by(adjusted_close, date) / min_by(adjusted_close, date) - 1) * 100, 1) as ytd_return_pct
from px
group by code, name
having min(date) = '2025-12-31'
   and min_by(close, date) >= 5
   and avg(close * volume) >= 50000000
order by ytd_return_pct desc
limit 10;
```

| code | name | close\_2025\_12\_31 | latest\_close | ytd\_return\_pct |
| - | - | - | - | - |
| MRNA | Moderna Inc | 29.49 | 196.79 | 567.3 |
| TWST | Twist Bioscience Corp | 31.72 | 116.35 | 266.8 |
| TXG | 10X Genomics Inc | 16.31 | 57.07 | 249.9 |
| KOD | Kodiak Sciences Inc | 27.96 | 97.81 | 249.8 |
| SNDK | Sandisk Corp | 237.38 | 776.22 | 227.0 |
| ORKA | Oruka Therapeutics, Inc. | 30.31 | 95.74 | 215.9 |
| SYRE | Spyre Therapeutics Inc. | 32.76 | 101.46 | 209.7 |
| ELVN | Enliven Therapeutics Inc. | 15.40 | 44.89 | 191.5 |
| MXL | MaxLinear Inc | 17.43 | 49.53 | 184.2 |
| ACHC | Acadia Healthcare Company Inc | 14.19 | 37.59 | 164.9 |

### Annualized volatility comparison

One-year total return and annualized volatility (the standard deviation of daily log returns times the square root of 252) for two ETFs and three stocks:

```sql theme={null}
with r as (
    select code, date, adjusted_close,
           ln(adjusted_close / lag(adjusted_close) over (partition by code order by date)) as log_return
    from security_price_history_vw
    where code in ('SPY', 'QQQ', 'AAPL', 'KO', 'JNJ')
      and exchange_code = 'US'
      and date > dateadd(year, -1, current_date())
)
select code,
       round((max_by(adjusted_close, date) / min_by(adjusted_close, date) - 1) * 100, 1) as one_year_return_pct,
       round(stddev(log_return) * sqrt(252) * 100, 1) as annualized_volatility_pct
from r
group by code
order by annualized_volatility_pct desc;
```

| code | one\_year\_return\_pct | annualized\_volatility\_pct |
| - | - | - |
| AAPL | 30.3 | 25.0 |
| QQQ | 12.3 | 21.6 |
| JNJ | 36.8 | 21.3 |
| KO | 38.0 | 18.8 |
| SPY | 12.0 | 13.7 |

### More examples on the blog

* [Adjusted Close vs. Close: Which Stock Price to Use](https://fruitstand.dev/blog/adjusted-close-vs-close.md)
* [How to Calculate Stock Returns From Daily Prices in SQL](https://fruitstand.dev/blog/calculate-stock-returns-sql.md)
* [How to Calculate Rolling Returns and Max Drawdown in SQL](https://fruitstand.dev/blog/rolling-returns-max-drawdown-sql.md)
* [How to Backtest a Trading Strategy in Snowflake SQL](https://fruitstand.dev/blog/backtest-trading-strategy-snowflake.md)
* [How Do I Find Stock Splits and Reverse Splits in Price Data?](https://fruitstand.dev/blog/find-stock-splits-reverse-splits-sql.md)
* [How Do I Get Dividend History From Stock Prices in SQL?](https://fruitstand.dev/blog/dividend-history-from-stock-prices-sql.md)
* [Where to Get Daily NAV History for US Mutual Funds in SQL](https://fruitstand.dev/blog/mutual-fund-nav-history-sql.md)
* [How to Get a List of Every US Stock and ETF Ticker in SQL](https://fruitstand.dev/blog/list-every-us-stock-etf-ticker-sql.md)
* [Why Don't My Historical Stock Prices Match Yahoo Finance?](https://fruitstand.dev/blog/stock-prices-dont-match-yahoo-finance.md)

## Data Ingestion

Data is ingested into Snowflake with best practices in mind.

**1. Security universe**

Each run pulls the provider's current US symbol lists for stocks, ETFs and mutual funds, tags each security with its asset class, and merges them into the security reference table. A security missing from the latest lists is marked inactive with the date it dropped off.

**2. Daily prices**

On incremental days, one bulk call per date pulls the last 5 calendar days of prices for every active security, so a price that posts late fills in on the next run. Dividend and split feeds for the same days are checked first, and any security with a new corporate action gets its full history refetched instead, since the provider backward-adjusts the whole adjusted-close history whenever one posts.

**3. Raw snapshot**

Each batch is written to parquet in a dated S3 folder, kept apart by fetch type, then copied into Snowflake.

**4. Clean and publish**

Prices are merged into the price history table on `code`, `exchange_code` and `date`. Placeholder rows are flagged and kept out of `security_price_history_vw` (see [Data Quality](#data-quality)), and adjusted open, high and low are derived from the adjusted close in the view.

**5. Twice-weekly restatement**

On the Wednesday and Saturday runs, every active security's full price history is refetched and the price tables are rebuilt from scratch, which catches any restatement the incremental path missed.

**Refresh cadence**: the pipeline starts at 9:00 PM Pacific every day, and new data is available by 5:00 AM Pacific, covering the previous US trading session. The Sunday, Monday, Tuesday, Thursday and Friday runs are incremental; the Wednesday and Saturday runs restate every security's full history.

**Cross-region replication**: the listing is auto-fulfilled to other Snowflake regions daily at 5:00 AM Pacific. If you consume it from a region other than its primary region, each day's update arrives after that replication run.

## Data Quality

* **Unique grain**: every `(code, exchange_code, date)` must be unique in the price history, checked on both the internal table and the published table, and every `(code, exchange_code)` must be unique in the security reference. If the internal check fails, the run stops before the listing's tables are updated, and the previous day's data stays in place.
* **Required keys**: `code` and `exchange_code` are checked to never be null in both views, and `date` in the price history.
* **Placeholder price removal**: rows where the provider's adjusted close is 0 (a zero-filled day) or 999,999.9999 (its cap when the backward adjustment overflows) are flagged on every run and excluded from `security_price_history_vw` instead of being passed through as real prices.
* **Stub row removal**: a security's very first price row is excluded when it sits more than 4 days before the next one, a lone placeholder well ahead of where real trading begins.
* **Corporate-action restatement**: new splits and dividends trigger a full history refetch for that security, and the twice-weekly full restatement catches anything the incremental path missed.

Flagged rows are filtered out before they reach the view, so you don't need to exclude them in your own queries.

**Revisions**: `adjusted_close`, `adjusted_open`, `adjusted_high` and `adjusted_low` for past dates change every time a security has a new split or dividend, because the whole history is rescaled. Raw `open`, `high`, `low` and `close` can also be corrected by the provider. Only the current values are kept; there is no revision history. Use `src_updated_at` to find rows that changed on incremental days.

**Known quirks**:

* On the most recent date, some prices can be missing at first. In the November 20 pull, November 18 had 12,036 stock prices against 17,176 the day before; nearly all of the missing ones were OTC stocks. Each run re-pulls the last 5 days, so they fill in on later runs.
* A few tickers carry rows from before the current security existed. For example, `FRDM` (an ETF launched in 2019) has flat placeholder prices back to 1984. Check a ticker's early history before using it in a long backtest.
* The `fund` asset class includes some exchange-traded closed-end funds as well as open-end mutual funds; filter on `exchange = 'NMFQS'` for open-end funds only.

## Disclosures

Fruit Stand Data LLC is not endorsed by or affiliated with any of the underlying pricing data providers or exchanges. Use [contact@fruitstand.dev](mailto:contact@fruitstand.dev) for questions.

**Survivorship**: the price history covers securities currently on the US symbol list. When a security drops off it stays in `security_vw` with `is_inactive = true`, but it has no rows in `security_price_history_vw` (1,114 such securities as of November 2026). Backtests over older periods therefore carry survivorship bias.

**No-trade days**: when a security has no trades on a given day, no price row is produced for that date. Thinly traded securities can have gaps in their history.

## F.A.Q.

Frequently asked questions from our clients.

> [accordion] Is there a free trial?
>
> Yes. The listing comes with a free 30-day trial with full use: the full daily price history for every stock, ETF and mutual fund, raw and adjusted prices, and the same daily updates paying subscribers get. After 30 days it's \$100/month flat. Nothing is charged when the trial ends unless you choose to subscribe. [Start the trial on the Snowflake Marketplace](https://app.snowflake.com/marketplace/listing/GZTYZTG3LNFA).

> [accordion] What is end-of-day price data?
>
> One price bar per security per trading day: open, high, low, close and volume. For mutual funds, it's the net asset value the fund publishes once a day after the close. This listing has both the prices as they traded and versions adjusted for splits and dividends. See [What is end-of-day price data?](#what-is-end-of-day-price-data) above.

> [accordion] How often is the data refreshed?
>
> Every day, with new data available by 5:00 AM Pacific covering the previous US trading session. Five days a week this is an incremental update of the last 5 days of prices, plus a full refetch for any security with a new split or dividend. On the Wednesday and Saturday runs, every security's full history is refetched and restated.

> [accordion] When does replication across cloud regions happen?
>
> The listing is replicated to other Snowflake regions daily at 5:00 AM Pacific. If you consume this listing from a Snowflake region other than its primary region, expect each day's updated data to arrive after that replication run.

> [accordion] How far back does the historical data go?
>
> History starts at each security's own first trading day rather than a fixed cutoff. The oldest common stocks (for example KO, IBM and JNJ) start on January 2, 1962, preferred stocks in 1972, mutual funds in 1973, and SPY on January 29, 1993. Half of all securities have history starting in 2013 or later.

> [accordion] How is the data obtained?
>
> From a commercial market data provider's API: its US symbol lists, its daily end-of-day prices, and its dividend and split feeds. Fruit Stand loads it into Snowflake, removes placeholder rows, adds the adjusted open, high and low, and runs the checks listed under [Data Quality](#data-quality).

> [accordion] Why use this listing instead of a market data API?
>
> You can load prices into Snowflake from an API yourself. Doing it for every US stock, ETF and mutual fund means pulling 49,000+ full histories, then tracking every split and dividend, because each one rescales a security's whole adjusted history. You'd also need to catch placeholder prices, keep the universe current as tickers list and delist, and keep the pipeline running. This listing does all of that, so you can start querying right away, and the free 30-day trial lets you check it against your own use case first.

> [accordion] What does it cost to build this ourselves vs. buy the listing?
>
> Building it yourself means a market data subscription, a pipeline that pulls 155M+ rows of history, refetches any security with a new corporate action, restates everything regularly and checks each load, then someone to keep it running. That's weeks of engineering up front and ongoing maintenance after. The listing is \$100/month with all of it done, and the free 30-day trial lets you check it first.

> [accordion] What isn't included?
>
> Intraday and real-time prices, securities listed outside the US, and price history for delisted securities (they stay in `security_vw` as inactive, without prices). There are no fundamentals, dividend amounts or par values; dividends and splits are reflected only through the adjusted prices.

> [accordion] What's the difference between close and adjusted close?
>
> `close` is the price the security actually closed at that day. `adjusted_close` restates that price so it's comparable across splits and dividends: after a 2-for-1 split, for example, every earlier adjusted close is halved, and every dividend lowers the earlier adjusted prices by the payout ratio. Use `close` to see what traded on a given day, and `adjusted_close` for returns, charts and backtests. See [Adjusted Close vs. Close](https://fruitstand.dev/blog/adjusted-close-vs-close.md) for a walkthrough.

> [accordion] Are open, high and low adjusted too?
>
> Yes. `adjusted_open`, `adjusted_high`, `adjusted_low` and `adjusted_close` are all adjusted for splits and dividends/distributions, so you get a complete adjusted OHLC bar for every day. The raw `open`, `high`, `low` and `close` columns stay as traded. `volume` is adjusted for splits only.

> [accordion] Does this include mutual fund NAVs?
>
> Yes. 25,639 US mutual funds are included next to stocks and ETFs in the same view. For funds priced once a day (`exchange = 'NMFQS'`), each day's NAV is recorded as `open`, `high`, `low` and `close`, with `volume` of 0, and the adjusted columns fold in distributions. Filter with `asset_class = 'fund'`.

> [accordion] Is this intraday or real-time data?
>
> No. This is end-of-day data, one row per security per trading day, available by 5:00 AM Pacific the next morning.

> [accordion] Can I request other exchanges or countries to be made available in Snowflake?
>
> Yes! Securities are already keyed by exchange so that non-US listings can be added. Please reach out to [contact@fruitstand.dev](mailto:contact@fruitstand.dev) with your requirements.

> [card] [Start your free 30-day trial on the Snowflake Marketplace](https://app.snowflake.com/marketplace/listing/GZTYZTG3LNFA)
>
> Full use of every stock, ETF and mutual fund price history, then **\$100/month** flat rate.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.