PREVIEW / stock_1hour / 2022-10-14

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-14.parquet
  size:    1.3 MB
  rows:    60,124
  symbols: 2,123

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
2022-10-14 04:00:00	AAPL	Stock	143.0	143.3	141.8	141.81	57012.0
2022-10-14 05:00:00	AAPL	Stock	141.81	142.43	141.68	142.37	43707.0
2022-10-14 06:00:00	AAPL	Stock	142.39	143.25	142.37	143.2	45718.0
2022-10-14 07:00:00	AAPL	Stock	143.2	143.38	142.1	142.11	105495.0
2022-10-14 08:00:00	AAPL	Stock	143.01	144.66	141.7715	144.1	533488.0
2022-10-14 09:00:00	AAPL	Stock	144.12	144.52	141.39	142.135	12217366.0
2022-10-14 10:00:00	AAPL	Stock	142.12	142.13	139.51	140.3158	14081275.0
2022-10-14 11:00:00	AAPL	Stock	140.34	140.94	139.24	139.64	8498752.0
2022-10-14 12:00:00	AAPL	Stock	139.64	140.21	138.98	139.13	5703398.0
2022-10-14 13:00:00	AAPL	Stock	139.14	139.64	138.95	139.5	5135633.0
2022-10-14 14:00:00	AAPL	Stock	139.5	139.51	138.39	138.805	6795601.0
2022-10-14 15:00:00	AAPL	Stock	138.81	139.18	138.19	138.38	15268221.0
2022-10-14 16:00:00	AAPL	Stock	138.38	138.55	138.2	138.41	11217835.0
2022-10-14 17:00:00	AAPL	Stock	138.42	138.48	138.25	138.36	58678.0
2022-10-14 18:00:00	AAPL	Stock	138.36	138.36	138.04	138.07	44266.0
2022-10-14 19:00:00	AAPL	Stock	138.07	138.1	138.0	138.08	39626.0
2022-10-14 04:00:00	MSFT	Stock	233.72	233.72	232.46	232.47	713.0
2022-10-14 05:00:00	MSFT	Stock	232.38	233.0	232.1	233.0	2790.0
2022-10-14 06:00:00	MSFT	Stock	233.18	234.8	233.18	234.14	4147.0
2022-10-14 07:00:00	MSFT	Stock	234.41	234.89	232.51	232.51	16655.0
2022-10-14 08:00:00	MSFT	Stock	234.0202	236.938	232.51	236.02	88358.0
2022-10-14 09:00:00	MSFT	Stock	236.28	237.24	233.765	234.18	3218111.0
2022-10-14 10:00:00	MSFT	Stock	234.11	234.16	230.31	231.5	3470939.0
2022-10-14 11:00:00	MSFT	Stock	231.51	232.985	229.91	230.254	2259235.0
2022-10-14 12:00:00	MSFT	Stock	230.19	230.99	229.02	229.79	1818176.0
2022-10-14 13:00:00	MSFT	Stock	229.79	230.7	229.51	230.67	1332156.0
2022-10-14 14:00:00	MSFT	Stock	230.67	230.68	229.0	229.9101	1600850.0
2022-10-14 15:00:00	MSFT	Stock	229.9	230.6	228.34	228.58	4980657.0
2022-10-14 16:00:00	MSFT	Stock	228.56	228.93	228.52	228.6679	5576780.0
2022-10-14 17:00:00	MSFT	Stock	228.52	228.52	228.01	228.3399	5770.0
2022-10-14 18:00:00	MSFT	Stock	228.55	228.55	228.1	228.1	5166.0
2022-10-14 19:00:00	MSFT	Stock	228.02	228.1	227.83	227.95	3547.0
2022-10-14 04:00:00	NVDA	Stock	12.004	12.004	11.835	11.835	75180.0
2022-10-14 05:00:00	NVDA	Stock	11.84	11.893	11.819	11.893	288680.0
2022-10-14 06:00:00	NVDA	Stock	11.856	11.972	11.856	11.964	276530.0
2022-10-14 07:00:00	NVDA	Stock	11.951	12.0	11.87	11.87	368780.0
2022-10-14 08:00:00	NVDA	Stock	11.9505	12.19	11.869	12.12	2291000.0
2022-10-14 09:00:00	NVDA	Stock	12.135	12.161	11.553	11.578	102104140.0
2022-10-14 10:00:00	NVDA	Stock	11.576	11.618	11.299	11.434	131328260.0
2022-10-14 11:00:00	NVDA	Stock	11.439	11.575	11.314	11.335	88246920.0
2022-10-14 12:00:00	NVDA	Stock	11.334	11.419	11.244	11.311	61551010.0
2022-10-14 13:00:00	NVDA	Stock	11.314	11.4071	11.296	11.3911	51421010.0
2022-10-14 14:00:00	NVDA	Stock	11.3915	11.403	11.285	11.4009	57611600.0
2022-10-14 15:00:00	NVDA	Stock	11.401	11.444	11.204	11.231	93784230.0
2022-10-14 16:00:00	NVDA	Stock	11.227	11.232	11.19	11.196	32979960.0
2022-10-14 17:00:00	NVDA	Stock	11.2	11.204	11.181	11.187	488770.0
2022-10-14 18:00:00	NVDA	Stock	11.187	11.187	11.177	11.177	468230.0
2022-10-14 19:00:00	NVDA	Stock	11.179	11.18	11.119	11.119	296430.0
2022-10-14 04:00:00	AMZN	Stock	112.95	112.95	111.65	111.79	16967.0
2022-10-14 05:00:00	AMZN	Stock	111.79	112.15	111.21	112.1	14293.0

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

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