PREVIEW / stock_1hour / 2026-01-27

all stock 1-hour files

  file:    by_date/stock_1hour/2026/2026-01-27.parquet
  size:    1.4 MB
  rows:    61,296
  symbols: 143

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2026-01-27 04:00:00	AAPL	Stock	257.45	257.45	256.02	256.02	24724.0
2026-01-27 05:00:00	AAPL	Stock	256.14	257.22	256.12	257.19	15571.0
2026-01-27 06:00:00	AAPL	Stock	257.21	258.66	256.97	258.53	90117.0
2026-01-27 07:00:00	AAPL	Stock	258.5	259.0	258.41	258.99	102992.0
2026-01-27 08:00:00	AAPL	Stock	257.4	259.8	254.772	259.24	446250.0
2026-01-27 09:00:00	AAPL	Stock	259.26	261.95	258.66	261.47	8240388.0
2026-01-27 10:00:00	AAPL	Stock	261.48	261.58	259.52	260.34	4573100.0
2026-01-27 11:00:00	AAPL	Stock	260.36	261.39	260.35	260.78	2741830.0
2026-01-27 12:00:00	AAPL	Stock	260.775	261.36	260.62	260.71	1960085.0
2026-01-27 13:00:00	AAPL	Stock	260.7	261.13	259.51	259.82	2556164.0
2026-01-27 14:00:00	AAPL	Stock	259.83	260.04	259.175	259.74	2416534.0
2026-01-27 15:00:00	AAPL	Stock	259.745	259.9667	258.21	258.27	4048607.0
2026-01-27 16:00:00	AAPL	Stock	258.28	258.45	257.2	257.6	6351655.0
2026-01-27 17:00:00	AAPL	Stock	257.52	258.3	257.45	258.09	59028.0
2026-01-27 18:00:00	AAPL	Stock	258.11	258.57	257.86	258.12	42798.0
2026-01-27 19:00:00	AAPL	Stock	258.01	259.0845	257.8667	258.9972	36038.0
2026-01-27 04:00:00	MSFT	Stock	474.0	474.93	473.51	474.3	24261.0
2026-01-27 05:00:00	MSFT	Stock	474.38	475.03	474.0	474.48	7326.0
2026-01-27 06:00:00	MSFT	Stock	474.6	474.6	473.71	473.81	12213.0
2026-01-27 07:00:00	MSFT	Stock	473.8	473.85	472.94	473.4	19048.0
2026-01-27 08:00:00	MSFT	Stock	474.51	474.94	472.5	472.8	100460.0
2026-01-27 09:00:00	MSFT	Stock	472.7733	478.1799	472.0	477.69	3879881.0
2026-01-27 10:00:00	MSFT	Stock	477.7	478.86	475.85	478.01	2944453.0
2026-01-27 11:00:00	MSFT	Stock	478.027	480.89	477.96	480.54	2420508.0
2026-01-27 12:00:00	MSFT	Stock	480.56	481.17	478.36	480.705	1859889.0
2026-01-27 13:00:00	MSFT	Stock	480.705	482.87	480.075	482.7	1661309.0
2026-01-27 14:00:00	MSFT	Stock	482.73	482.73	480.8	481.81	1626574.0
2026-01-27 15:00:00	MSFT	Stock	481.81	482.0	480.2	480.585	3038113.0
2026-01-27 16:00:00	MSFT	Stock	480.63	481.25	480.24	481.14	3893595.0
2026-01-27 17:00:00	MSFT	Stock	481.13	481.5	480.58	481.5	20919.0
2026-01-27 18:00:00	MSFT	Stock	481.48	481.99	481.4	481.75	16567.0
2026-01-27 19:00:00	MSFT	Stock	481.66	482.5	481.61	482.5	31490.0
2026-01-27 04:00:00	NVDA	Stock	187.35	187.58	187.12	187.54	119477.0
2026-01-27 05:00:00	NVDA	Stock	187.56	187.79	187.53	187.58	60051.0
2026-01-27 06:00:00	NVDA	Stock	187.6	187.66	187.34	187.46	65441.0
2026-01-27 07:00:00	NVDA	Stock	187.42	187.96	187.08	187.08	216986.0
2026-01-27 08:00:00	NVDA	Stock	187.3	187.9015	187.01	187.29	791526.0
2026-01-27 09:00:00	NVDA	Stock	187.3	187.79	185.7	187.64	15300465.0
2026-01-27 10:00:00	NVDA	Stock	187.64	189.795	187.49	189.35	23302234.0
2026-01-27 11:00:00	NVDA	Stock	189.36	190.0	189.19	189.6599	14417188.0
2026-01-27 12:00:00	NVDA	Stock	189.65	190.0	189.06	189.2099	11433318.0
2026-01-27 13:00:00	NVDA	Stock	189.2099	189.78	188.9	189.35	10474184.0
2026-01-27 14:00:00	NVDA	Stock	189.345	189.48	188.95	189.28	12018595.0
2026-01-27 15:00:00	NVDA	Stock	189.27	189.72	188.47	188.533	14946955.0
2026-01-27 16:00:00	NVDA	Stock	188.56	189.68	188.12	188.82	11036698.0
2026-01-27 17:00:00	NVDA	Stock	188.849	189.05	188.52	188.87	214947.0
2026-01-27 18:00:00	NVDA	Stock	188.83	188.96	188.8	188.86	125680.0
2026-01-27 19:00:00	NVDA	Stock	188.85	189.5869	188.85	189.5	308142.0
2026-01-27 04:00:00	AMZN	Stock	239.55	240.1	239.52	239.6	14493.0
2026-01-27 05:00:00	AMZN	Stock	239.68	239.87	239.48	239.5	10970.0

> showing 50 of 61,296 rows — these rows as CSV

> unlock the full archive -- $79 one-time