PREVIEW / stock_1hour / 2026-01-20

all stock 1-hour files

  file:    by_date/stock_1hour/2026/2026-01-20.parquet
  size:    1.5 MB
  rows:    65,132
  symbols: 147

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-20 04:00:00	AAPL	Stock	253.83	253.83	251.16	251.33	64073.0
2026-01-20 05:00:00	AAPL	Stock	251.34	251.6	251.04	251.17	32372.0
2026-01-20 06:00:00	AAPL	Stock	251.25	252.69	251.25	252.42	50890.0
2026-01-20 07:00:00	AAPL	Stock	252.35	252.83	251.88	252.3	60851.0
2026-01-20 08:00:00	AAPL	Stock	251.61	253.89	251.01	251.8735	257832.0
2026-01-20 09:00:00	AAPL	Stock	251.72	255.53	251.5	252.58	5953652.0
2026-01-20 10:00:00	AAPL	Stock	252.49	252.76	250.85	251.55	4713382.0
2026-01-20 11:00:00	AAPL	Stock	251.57	252.13	250.35	251.19	2826549.0
2026-01-20 12:00:00	AAPL	Stock	251.2	251.28	250.08	250.27	2308627.0
2026-01-20 13:00:00	AAPL	Stock	250.24	250.5	248.24	248.52	3429773.0
2026-01-20 14:00:00	AAPL	Stock	248.54	248.68	246.8091	246.955	3911172.0
2026-01-20 15:00:00	AAPL	Stock	246.95	247.22	243.42	246.69	15079089.0
2026-01-20 16:00:00	AAPL	Stock	246.69	247.0101	246.2	246.9144	14502601.0
2026-01-20 17:00:00	AAPL	Stock	246.89	247.18	246.7	247.18	61693.0
2026-01-20 18:00:00	AAPL	Stock	247.18	247.3	246.69	246.78	49517.0
2026-01-20 19:00:00	AAPL	Stock	246.78	247.6	246.78	247.46	37346.0
2026-01-20 04:00:00	MSFT	Stock	453.55	456.71	451.53	452.0	42007.0
2026-01-20 05:00:00	MSFT	Stock	451.89	452.93	451.5	452.25	26842.0
2026-01-20 06:00:00	MSFT	Stock	452.43	452.79	451.77	452.44	15194.0
2026-01-20 07:00:00	MSFT	Stock	452.66	454.03	452.45	453.4	28847.0
2026-01-20 08:00:00	MSFT	Stock	453.75	456.3	450.66	450.8	211477.0
2026-01-20 09:00:00	MSFT	Stock	451.0	454.6	448.55	453.54	3387049.0
2026-01-20 10:00:00	MSFT	Stock	453.48	454.78	451.9843	454.19	2561490.0
2026-01-20 11:00:00	MSFT	Stock	454.19	456.8	453.89	455.35	1734000.0
2026-01-20 12:00:00	MSFT	Stock	455.33	455.56	453.05	453.7	1095091.0
2026-01-20 13:00:00	MSFT	Stock	453.67	454.25	452.49	452.845	1027515.0
2026-01-20 14:00:00	MSFT	Stock	452.87	454.72	452.65	454.49	1301155.0
2026-01-20 15:00:00	MSFT	Stock	454.495	455.335	453.61	454.66	2363533.0
2026-01-20 16:00:00	MSFT	Stock	454.79	455.8539	454.32	454.86	5690775.0
2026-01-20 17:00:00	MSFT	Stock	454.95	455.48	454.52	454.75	26467.0
2026-01-20 18:00:00	MSFT	Stock	454.87	455.17	454.05	454.4118	7469.0
2026-01-20 19:00:00	MSFT	Stock	454.4106	455.66	454.41	455.63	13332.0
2026-01-20 04:00:00	NVDA	Stock	181.8	183.69	180.0	180.8	540930.0
2026-01-20 05:00:00	NVDA	Stock	180.83	181.64	180.69	181.3	188014.0
2026-01-20 06:00:00	NVDA	Stock	181.34	181.92	181.34	181.88	158021.0
2026-01-20 07:00:00	NVDA	Stock	181.95	182.89	181.7	182.31	474354.0
2026-01-20 08:00:00	NVDA	Stock	182.4	185.765	180.01	181.595	2013646.0
2026-01-20 09:00:00	NVDA	Stock	181.58	182.3786	179.58	179.95	31485659.0
2026-01-20 10:00:00	NVDA	Stock	179.92	181.85	179.6	180.595	26893252.0
2026-01-20 11:00:00	NVDA	Stock	180.5995	181.26	179.56	180.0701	20828920.0
2026-01-20 12:00:00	NVDA	Stock	180.07	180.22	179.27	179.8	16886365.0
2026-01-20 13:00:00	NVDA	Stock	179.8	180.09	178.9	179.75	14129208.0
2026-01-20 14:00:00	NVDA	Stock	179.75	179.98	179.15	179.5699	11087024.0
2026-01-20 15:00:00	NVDA	Stock	179.57	179.605	177.61	178.21	26932249.0
2026-01-20 16:00:00	NVDA	Stock	178.22	179.0	177.86	178.7335	22607137.0
2026-01-20 17:00:00	NVDA	Stock	178.75	178.95	178.07	178.87	279957.0
2026-01-20 18:00:00	NVDA	Stock	178.87	179.24	178.61	178.74	375678.0
2026-01-20 19:00:00	NVDA	Stock	178.74	179.25	178.7346	179.22	258266.0
2026-01-20 04:00:00	AMZN	Stock	235.15	235.39	231.14	231.62	67892.0
2026-01-20 05:00:00	AMZN	Stock	231.55	232.28	231.32	231.78	32269.0

> showing 50 of 65,132 rows — these rows as CSV

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