PREVIEW / stock_1hour / 2023-03-08

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-08.parquet
  size:    1.3 MB
  rows:    59,634
  symbols: 1,840

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-03-08 04:00:00	AAPL	Stock	151.5	151.94	151.5	151.6	6771.0
2023-03-08 05:00:00	AAPL	Stock	151.7	151.89	151.62	151.79	4545.0
2023-03-08 06:00:00	AAPL	Stock	151.87	152.2	151.84	152.0	36921.0
2023-03-08 07:00:00	AAPL	Stock	151.92	152.1	151.63	151.94	39972.0
2023-03-08 08:00:00	AAPL	Stock	152.0212	152.34	151.06	152.25	220017.0
2023-03-08 09:00:00	AAPL	Stock	152.19	153.1	152.08	152.65	6030796.0
2023-03-08 10:00:00	AAPL	Stock	152.66	153.21	151.83	152.61	7698841.0
2023-03-08 11:00:00	AAPL	Stock	152.6	153.47	152.35	153.34	4936481.0
2023-03-08 12:00:00	AAPL	Stock	153.35	153.41	152.35	152.83	4209468.0
2023-03-08 13:00:00	AAPL	Stock	152.84	152.9401	152.05	152.29	3667421.0
2023-03-08 14:00:00	AAPL	Stock	152.28	152.9896	152.23	152.5	3522600.0
2023-03-08 15:00:00	AAPL	Stock	152.51	153.26	152.07	152.89	7237302.0
2023-03-08 16:00:00	AAPL	Stock	152.9	152.98	152.79	152.93	4051003.0
2023-03-08 17:00:00	AAPL	Stock	152.9499	153.04	152.87	153.02	47363.0
2023-03-08 18:00:00	AAPL	Stock	153.0	153.0599	152.87	153.0	38831.0
2023-03-08 19:00:00	AAPL	Stock	152.95	152.99	152.25	152.65	36563.0
2023-03-08 04:00:00	MSFT	Stock	254.5	254.5	254.15	254.41	1812.0
2023-03-08 05:00:00	MSFT	Stock	254.6	255.01	254.6	254.95	1974.0
2023-03-08 06:00:00	MSFT	Stock	255.16	255.49	254.82	255.09	2124.0
2023-03-08 07:00:00	MSFT	Stock	254.81	255.1	253.49	253.66	7914.0
2023-03-08 08:00:00	MSFT	Stock	254.9972	255.3	252.81	253.31	34558.0
2023-03-08 09:00:00	MSFT	Stock	253.456	254.5417	252.2	252.28	1869540.0
2023-03-08 10:00:00	MSFT	Stock	252.25	253.03	250.81	252.35	2350582.0
2023-03-08 11:00:00	MSFT	Stock	252.36	253.84	251.56	253.72	1520791.0
2023-03-08 12:00:00	MSFT	Stock	253.73	253.8999	251.79	252.6	1105045.0
2023-03-08 13:00:00	MSFT	Stock	252.6	252.81	251.45	251.83	937213.0
2023-03-08 14:00:00	MSFT	Stock	251.815	253.34	251.67	252.575	1028160.0
2023-03-08 15:00:00	MSFT	Stock	252.58	253.96	252.01	253.75	2063990.0
2023-03-08 16:00:00	MSFT	Stock	253.75	253.93	253.53	253.93	2075880.0
2023-03-08 17:00:00	MSFT	Stock	253.85	253.85	253.7	253.71	25192.0
2023-03-08 18:00:00	MSFT	Stock	253.7	253.7	253.41	253.64	6593.0
2023-03-08 19:00:00	MSFT	Stock	253.41	253.41	252.42	252.51	10786.0
2023-03-08 04:00:00	NVDA	Stock	23.35	23.368	23.3	23.336	51810.0
2023-03-08 05:00:00	NVDA	Stock	23.338	23.382	23.33	23.37	68880.0
2023-03-08 06:00:00	NVDA	Stock	23.381	23.425	23.375	23.392	176710.0
2023-03-08 07:00:00	NVDA	Stock	23.392	23.425	23.285	23.322	295300.0
2023-03-08 08:00:00	NVDA	Stock	23.3411	23.45	23.196	23.378	1021410.0
2023-03-08 09:00:00	NVDA	Stock	23.37	23.82	23.37	23.7486	60162900.0
2023-03-08 10:00:00	NVDA	Stock	23.744	24.014	23.55	23.8295	93222650.0
2023-03-08 11:00:00	NVDA	Stock	23.834	23.999	23.686	23.9954	58776420.0
2023-03-08 12:00:00	NVDA	Stock	23.996	24.035	23.7864	23.904	48818460.0
2023-03-08 13:00:00	NVDA	Stock	23.907	23.928	23.7751	23.822	39400620.0
2023-03-08 14:00:00	NVDA	Stock	23.8197	24.023	23.81	23.9732	37470960.0
2023-03-08 15:00:00	NVDA	Stock	23.976	24.2	23.872	24.185	66198180.0
2023-03-08 16:00:00	NVDA	Stock	24.181	24.268	24.171	24.259	20474470.0
2023-03-08 17:00:00	NVDA	Stock	24.26	24.288	24.181	24.261	780040.0
2023-03-08 18:00:00	NVDA	Stock	24.26	24.26	24.214	24.245	507550.0
2023-03-08 19:00:00	NVDA	Stock	24.241	24.244	24.19	24.235	638710.0
2023-03-08 04:00:00	AMZN	Stock	93.55	93.69	93.36	93.44	4884.0
2023-03-08 05:00:00	AMZN	Stock	93.59	93.84	93.5	93.84	7738.0

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

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