PREVIEW / stock_1hour / 2026-03-27

all stock 1-hour files

  file:    by_date/stock_1hour/2026/2026-03-27.parquet
  size:    1.3 MB
  rows:    59,720
  symbols: 87

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-03-27 04:00:00	AAPL	Stock	254.06	254.11	253.33	253.58	10250.0
2026-03-27 05:00:00	AAPL	Stock	253.26	253.47	252.99	253.35	4236.0
2026-03-27 06:00:00	AAPL	Stock	253.15	253.29	252.56	252.56	3974.0
2026-03-27 07:00:00	AAPL	Stock	252.75	253.0	252.2	252.78	15769.0
2026-03-27 08:00:00	AAPL	Stock	253.2	254.71	252.06	252.62	44083.0
2026-03-27 09:00:00	AAPL	Stock	252.9	255.37	252.3	254.9	4072755.0
2026-03-27 10:00:00	AAPL	Stock	254.86	255.493	251.8	253.28	5271123.0
2026-03-27 11:00:00	AAPL	Stock	253.27	253.43	251.97	252.725	2414330.0
2026-03-27 12:00:00	AAPL	Stock	252.73	252.9	251.69	252.42	2073754.0
2026-03-27 13:00:00	AAPL	Stock	252.42	252.65	249.35	249.81	2928208.0
2026-03-27 14:00:00	AAPL	Stock	249.81	249.94	248.61	248.66	2627043.0
2026-03-27 15:00:00	AAPL	Stock	248.66	249.37	248.07	248.61	5114542.0
2026-03-27 16:00:00	AAPL	Stock	248.61	248.8	247.5	247.75	8178367.0
2026-03-27 17:00:00	AAPL	Stock	247.89	248.22	247.64	248.22	19070.0
2026-03-27 18:00:00	AAPL	Stock	248.01	248.2	247.8	248.0	10046.0
2026-03-27 19:00:00	AAPL	Stock	247.9	247.95	247.25	247.25	33811.0
2026-03-27 04:00:00	MSFT	Stock	367.0	367.0	365.46	365.55	43869.0
2026-03-27 05:00:00	MSFT	Stock	365.4	365.77	364.69	365.06	31585.0
2026-03-27 06:00:00	MSFT	Stock	364.88	365.52	363.89	364.24	20811.0
2026-03-27 07:00:00	MSFT	Stock	364.05	364.8	362.65	362.95	76710.0
2026-03-27 08:00:00	MSFT	Stock	363.0	368.26	361.8	361.9	211197.0
2026-03-27 09:00:00	MSFT	Stock	361.8052	363.0	357.44	357.46	4786448.0
2026-03-27 10:00:00	MSFT	Stock	357.49	360.45	356.58	359.8645	4999843.0
2026-03-27 11:00:00	MSFT	Stock	359.9	360.96	359.105	360.22	2814733.0
2026-03-27 12:00:00	MSFT	Stock	360.25	360.71	359.2	359.7	2392261.0
2026-03-27 13:00:00	MSFT	Stock	359.72	360.1	358.46	358.85	2181167.0
2026-03-27 14:00:00	MSFT	Stock	358.845	359.33	357.57	357.81	2353241.0
2026-03-27 15:00:00	MSFT	Stock	357.81	358.04	356.51	356.65	4854980.0
2026-03-27 16:00:00	MSFT	Stock	356.64	357.31	356.4	357.01	4985660.0
2026-03-27 17:00:00	MSFT	Stock	357.01	357.35	356.8	356.9	47031.0
2026-03-27 18:00:00	MSFT	Stock	356.92	357.0	356.4	356.48	48665.0
2026-03-27 19:00:00	MSFT	Stock	356.48	356.49	356.07	356.15	50366.0
2026-03-27 04:00:00	NVDA	Stock	172.7	173.05	171.8	171.96	209625.0
2026-03-27 05:00:00	NVDA	Stock	171.98	172.08	171.3	171.54	156376.0
2026-03-27 06:00:00	NVDA	Stock	171.55	171.93	170.73	170.98	229384.0
2026-03-27 07:00:00	NVDA	Stock	171.08	171.5	170.6	171.16	487045.0
2026-03-27 08:00:00	NVDA	Stock	171.39	173.79	170.58	170.67	1644939.0
2026-03-27 09:00:00	NVDA	Stock	170.66	170.97	168.16	168.4129	26216564.0
2026-03-27 10:00:00	NVDA	Stock	168.41	169.39	167.55	168.67	27892999.0
2026-03-27 11:00:00	NVDA	Stock	168.68	169.94	168.25	169.55	18320061.0
2026-03-27 12:00:00	NVDA	Stock	169.56	169.64	168.37	168.865	12270726.0
2026-03-27 13:00:00	NVDA	Stock	168.865	169.27	167.605	167.875	12672316.0
2026-03-27 14:00:00	NVDA	Stock	167.87	168.28	167.31	167.465	12934063.0
2026-03-27 15:00:00	NVDA	Stock	167.46	167.93	167.01	167.46	22286533.0
2026-03-27 16:00:00	NVDA	Stock	167.47	168.49	167.2	167.5	17344985.0
2026-03-27 17:00:00	NVDA	Stock	167.5	167.5	167.25	167.29	272787.0
2026-03-27 18:00:00	NVDA	Stock	167.2936	167.2937	167.0	167.0291	302099.0
2026-03-27 19:00:00	NVDA	Stock	167.03	167.055	166.45	166.6	494043.0
2026-03-27 04:00:00	AMZN	Stock	208.11	208.43	207.65	208.02	14251.0
2026-03-27 05:00:00	AMZN	Stock	207.68	207.94	207.0	207.43	15229.0

> showing 50 of 59,720 rows — these rows as CSV

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