PREVIEW / stock_1hour / 2023-12-19

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-12-19.parquet
  size:    1.4 MB
  rows:    60,983
  symbols: 1,268

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
2023-12-19 04:00:00	AAPL	Stock	195.76	196.0	195.76	195.91	1558.0
2023-12-19 05:00:00	AAPL	Stock	195.9	195.94	195.8	195.85	825.0
2023-12-19 06:00:00	AAPL	Stock	195.83	196.19	195.75	196.17	14192.0
2023-12-19 07:00:00	AAPL	Stock	196.07	196.52	195.98	196.5	48476.0
2023-12-19 08:00:00	AAPL	Stock	195.89	197.0	195.51	196.65	764383.0
2023-12-19 09:00:00	AAPL	Stock	196.55	196.655	195.89	196.5782	4537946.0
2023-12-19 10:00:00	AAPL	Stock	196.58	196.84	196.05	196.725	4481986.0
2023-12-19 11:00:00	AAPL	Stock	196.725	196.95	196.21	196.285	3291780.0
2023-12-19 12:00:00	AAPL	Stock	196.285	196.35	195.97	196.25	2292811.0
2023-12-19 13:00:00	AAPL	Stock	196.245	196.31	195.97	196.085	1901894.0
2023-12-19 14:00:00	AAPL	Stock	196.09	196.1701	195.99	196.095	1915175.0
2023-12-19 15:00:00	AAPL	Stock	196.1	196.95	195.98	196.92	4744053.0
2023-12-19 16:00:00	AAPL	Stock	196.92	197.0	196.78	196.83	8927922.0
2023-12-19 17:00:00	AAPL	Stock	196.82	196.84	196.76	196.84	37327.0
2023-12-19 18:00:00	AAPL	Stock	196.82	196.8406	196.76	196.8	12433.0
2023-12-19 19:00:00	AAPL	Stock	196.76	196.88	196.76	196.88	32288.0
2023-12-19 04:00:00	MSFT	Stock	372.51	372.77	372.33	372.77	1570.0
2023-12-19 05:00:00	MSFT	Stock	372.94	372.94	372.94	372.94	100.0
2023-12-19 06:00:00	MSFT	Stock	372.87	373.29	372.85	373.0	2148.0
2023-12-19 07:00:00	MSFT	Stock	373.18	373.86	373.08	373.85	10650.0
2023-12-19 08:00:00	MSFT	Stock	373.01	374.1979	372.15	373.2484	52605.0
2023-12-19 09:00:00	MSFT	Stock	373.25	373.25	370.65	370.935	2545642.0
2023-12-19 10:00:00	MSFT	Stock	370.915	372.33	369.84	371.66	2040057.0
2023-12-19 11:00:00	MSFT	Stock	371.66	372.72	371.36	371.93	1081846.0
2023-12-19 12:00:00	MSFT	Stock	371.96	372.3495	371.2904	372.03	706485.0
2023-12-19 13:00:00	MSFT	Stock	372.0209	372.6313	371.47	371.9537	960390.0
2023-12-19 14:00:00	MSFT	Stock	371.96	372.4	371.74	372.001	941685.0
2023-12-19 15:00:00	MSFT	Stock	372.01	373.26	371.55	373.21	2182945.0
2023-12-19 16:00:00	MSFT	Stock	373.26	373.51	373.0	373.19	3561312.0
2023-12-19 17:00:00	MSFT	Stock	373.09	373.2	373.0	373.1001	5868.0
2023-12-19 18:00:00	MSFT	Stock	373.1	373.26	373.0	373.0147	20996.0
2023-12-19 19:00:00	MSFT	Stock	373.01	373.25	373.01	373.25	7941.0
2023-12-19 04:00:00	NVDA	Stock	50.127	50.286	50.09	50.228	65330.0
2023-12-19 05:00:00	NVDA	Stock	50.25	50.25	50.187	50.2	49170.0
2023-12-19 06:00:00	NVDA	Stock	50.228	50.228	49.285	49.311	676650.0
2023-12-19 07:00:00	NVDA	Stock	49.313	49.651	49.31	49.538	2168970.0
2023-12-19 08:00:00	NVDA	Stock	49.49	50.113	49.21	49.325	5282940.0
2023-12-19 09:00:00	NVDA	Stock	49.306	49.7	48.895	49.262	81076010.0
2023-12-19 10:00:00	NVDA	Stock	49.256	49.605	48.928	49.278	69746870.0
2023-12-19 11:00:00	NVDA	Stock	49.28	49.381	49.0	49.144	45384580.0
2023-12-19 12:00:00	NVDA	Stock	49.1495	49.393	49.06	49.2901	28206900.0
2023-12-19 13:00:00	NVDA	Stock	49.293	49.365	49.075	49.199	23952770.0
2023-12-19 14:00:00	NVDA	Stock	49.199	49.555	49.1665	49.5245	33417660.0
2023-12-19 15:00:00	NVDA	Stock	49.525	49.617	49.424	49.6129	38418760.0
2023-12-19 16:00:00	NVDA	Stock	49.6075	49.615	49.501	49.543	14652340.0
2023-12-19 17:00:00	NVDA	Stock	49.549	49.56	49.52	49.539	186520.0
2023-12-19 18:00:00	NVDA	Stock	49.536	49.56	49.535	49.549	166690.0
2023-12-19 19:00:00	NVDA	Stock	49.542	49.57	49.519	49.546	303490.0
2023-12-19 04:00:00	AMZN	Stock	153.91	154.01	153.79	153.99	4466.0
2023-12-19 05:00:00	AMZN	Stock	154.0	154.1	153.9	153.9	17931.0

> showing 50 of 60,983 rows — these rows as CSV

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