PREVIEW / stock_1hour / 2025-06-09

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-06-09.parquet
  size:    1.4 MB
  rows:    62,875
  symbols: 405

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
2025-06-09 04:00:00	AAPL	Stock	205.0	205.08	204.45	204.89	20454.0
2025-06-09 05:00:00	AAPL	Stock	204.82	204.86	204.69	204.76	7413.0
2025-06-09 06:00:00	AAPL	Stock	204.77	204.9	204.42	204.5	13564.0
2025-06-09 07:00:00	AAPL	Stock	204.53	205.47	204.5	205.19	41559.0
2025-06-09 08:00:00	AAPL	Stock	204.57	205.4795	204.11	204.78	174534.0
2025-06-09 09:00:00	AAPL	Stock	204.75	205.55	203.98	204.83	4026109.0
2025-06-09 10:00:00	AAPL	Stock	204.85	206.0	204.53	204.7199	4797728.0
2025-06-09 11:00:00	AAPL	Stock	204.72	204.94	204.2612	204.46	2725322.0
2025-06-09 12:00:00	AAPL	Stock	204.47	204.91	203.73	204.7	3991952.0
2025-06-09 13:00:00	AAPL	Stock	204.71	205.2999	200.02	202.465	17180910.0
2025-06-09 14:00:00	AAPL	Stock	202.45	202.6677	200.63	201.52	7737962.0
2025-06-09 15:00:00	AAPL	Stock	201.5399	202.355	200.84	201.44	8269746.0
2025-06-09 16:00:00	AAPL	Stock	201.435	201.59	201.1774	201.45	6897473.0
2025-06-09 17:00:00	AAPL	Stock	201.55	201.72	201.336	201.6285	98248.0
2025-06-09 18:00:00	AAPL	Stock	201.629	201.75	201.5663	201.65	49050.0
2025-06-09 19:00:00	AAPL	Stock	201.66	201.79	201.6048	201.75	57639.0
2025-06-09 04:00:00	MSFT	Stock	468.85	470.2	468.85	470.07	8083.0
2025-06-09 05:00:00	MSFT	Stock	470.35	470.38	469.7	469.71	2618.0
2025-06-09 06:00:00	MSFT	Stock	469.77	469.77	469.2	469.2	2974.0
2025-06-09 07:00:00	MSFT	Stock	469.81	469.85	469.45	469.63	1558.0
2025-06-09 08:00:00	MSFT	Stock	469.8797	469.9121	468.12	468.86	17114.0
2025-06-09 09:00:00	MSFT	Stock	468.99	471.225	468.62	469.405	1001474.0
2025-06-09 10:00:00	MSFT	Stock	469.56	471.15	469.484	470.05	851892.0
2025-06-09 11:00:00	MSFT	Stock	470.07	471.2	469.75	470.63	659076.0
2025-06-09 12:00:00	MSFT	Stock	470.64	472.46	470.0	471.91	620969.0
2025-06-09 13:00:00	MSFT	Stock	471.91	472.9	471.7	472.57	483953.0
2025-06-09 14:00:00	MSFT	Stock	472.56	473.43	472.3763	473.35	579828.0
2025-06-09 15:00:00	MSFT	Stock	473.345	473.43	471.83	472.76	1868310.0
2025-06-09 16:00:00	MSFT	Stock	472.71	472.75	471.16	471.5	4052722.0
2025-06-09 17:00:00	MSFT	Stock	471.5	471.7	471.11	471.6	9959.0
2025-06-09 18:00:00	MSFT	Stock	471.77	472.273	471.5734	471.6	2201.0
2025-06-09 19:00:00	MSFT	Stock	471.75	471.87	471.41	471.63	3938.0
2025-06-09 04:00:00	NVDA	Stock	142.3	142.65	142.05	142.45	311595.0
2025-06-09 05:00:00	NVDA	Stock	142.46	142.5	142.31	142.44	114873.0
2025-06-09 06:00:00	NVDA	Stock	142.43	142.44	142.13	142.23	152218.0
2025-06-09 07:00:00	NVDA	Stock	142.23	142.8	142.18	142.72	442675.0
2025-06-09 08:00:00	NVDA	Stock	142.26	143.58	141.366	143.28	2380940.0
2025-06-09 09:00:00	NVDA	Stock	143.28	144.7	142.9	143.624	25336482.0
2025-06-09 10:00:00	NVDA	Stock	143.63	145.0	143.4001	144.235	26997322.0
2025-06-09 11:00:00	NVDA	Stock	144.24	144.61	142.3978	142.835	26693144.0
2025-06-09 12:00:00	NVDA	Stock	142.84	143.05	141.94	142.6946	17674354.0
2025-06-09 13:00:00	NVDA	Stock	142.69	143.0451	141.97	142.315	10987987.0
2025-06-09 14:00:00	NVDA	Stock	142.315	143.03	142.16	142.815	10551850.0
2025-06-09 15:00:00	NVDA	Stock	142.815	142.97	142.19	142.55	17370954.0
2025-06-09 16:00:00	NVDA	Stock	142.55	142.73	142.48	142.66	11370416.0
2025-06-09 17:00:00	NVDA	Stock	142.66	142.76	142.57	142.74	264881.0
2025-06-09 18:00:00	NVDA	Stock	142.73	142.84	142.69	142.7699	185046.0
2025-06-09 19:00:00	NVDA	Stock	142.77	142.95	142.62	142.678	315873.0
2025-06-09 04:00:00	AMZN	Stock	213.65	214.08	213.51	214.0	18321.0
2025-06-09 05:00:00	AMZN	Stock	214.07	214.32	213.92	214.15	11772.0

> showing 50 of 62,875 rows — these rows as CSV

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