Snowflake's Free Stock Prices vs. Paid: What's Different

with fruit_stand as (
    select code as ticker, date, close, volume
    from security_price_history_vw
    where exchange_code = 'US'
      and code in ('AAPL', 'MSFT', 'TSLA')
      and date between '2026-07-01' and '2026-07-31'
),
curated as (
    select
        ticker,
        date,
        max(iff(variable_name = 'Post-Market Close', value, null)) as post_market_close,
        max(iff(variable_name = 'Nasdaq Volume', value, null)) as nasdaq_volume
    from snowflake_public_data_free.public_data_free.stock_price_timeseries
    where ticker in ('AAPL', 'MSFT', 'TSLA')
      and date between '2026-07-01' and '2026-07-31'
    group by ticker, date
)
select
    f.ticker,
    f.date,
    f.close,
    c.post_market_close,
    round(100 * (c.post_market_close / f.close - 1), 2) as pct_gap,
    round(100 * c.nasdaq_volume / f.volume, 1) as nasdaq_volume_share
from fruit_stand f
join curated c
    on c.ticker = f.ticker and c.date = f.date
order by abs(pct_gap) desc;

select ticker, date, value as close
from public_data_free.stock_price_timeseries
where ticker = 'AAPL'
  and variable_name = 'Post-Market Close'
  and date >= '2026-01-01';

select code as ticker, date, close
from security_price_history_vw
where code = 'AAPL'
  and exchange_code = 'US'
  and date >= '2026-01-01';