PREVIEW / stock_1hour / 2022-07-14

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-07-14.parquet
  size:    1.3 MB
  rows:    60,908
  symbols: 2,300

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-07-14 04:00:00	AAPL	Stock	144.49	144.97	143.68	144.17	43483.0
2022-07-14 05:00:00	AAPL	Stock	144.13	144.37	143.9	144.34	11862.0
2022-07-14 06:00:00	AAPL	Stock	144.25	144.43	143.91	144.39	13687.0
2022-07-14 07:00:00	AAPL	Stock	144.36	144.37	143.89	144.12	85424.0
2022-07-14 08:00:00	AAPL	Stock	144.2	145.68	143.84	144.33	454483.0
2022-07-14 09:00:00	AAPL	Stock	144.29	144.7699	143.25	144.08	7836120.0
2022-07-14 10:00:00	AAPL	Stock	144.0836	145.08	143.6101	144.822	9402171.0
2022-07-14 11:00:00	AAPL	Stock	144.82	147.17	144.79	147.1509	10971641.0
2022-07-14 12:00:00	AAPL	Stock	147.155	147.32	146.1001	146.6273	6514807.0
2022-07-14 13:00:00	AAPL	Stock	146.6301	147.66	146.32	147.545	7046694.0
2022-07-14 14:00:00	AAPL	Stock	147.55	148.8416	147.48	148.6794	8684245.0
2022-07-14 15:00:00	AAPL	Stock	148.68	148.95	148.03	148.48	10574530.0
2022-07-14 16:00:00	AAPL	Stock	148.47	148.67	148.31	148.57	6000895.0
2022-07-14 17:00:00	AAPL	Stock	148.58	148.7393	148.55	148.71	21517.0
2022-07-14 18:00:00	AAPL	Stock	148.7	149.19	148.66	149.06	68280.0
2022-07-14 19:00:00	AAPL	Stock	149.0	149.4	149.0	149.37	45559.0
2022-07-14 04:00:00	MSFT	Stock	251.09	251.57	249.5	250.05	3557.0
2022-07-14 05:00:00	MSFT	Stock	250.0	250.55	249.99	250.55	3300.0
2022-07-14 06:00:00	MSFT	Stock	250.94	251.05	250.08	250.97	5184.0
2022-07-14 07:00:00	MSFT	Stock	250.78	250.89	250.0	250.4	12791.0
2022-07-14 08:00:00	MSFT	Stock	250.5545	251.2	249.6991	250.28	42741.0
2022-07-14 09:00:00	MSFT	Stock	250.278	251.4	247.8	247.8101	1876915.0
2022-07-14 10:00:00	MSFT	Stock	247.81	249.55	245.94	248.6	3281542.0
2022-07-14 11:00:00	MSFT	Stock	248.61	252.07	248.41	251.49	2293713.0
2022-07-14 12:00:00	MSFT	Stock	251.55	251.91	249.87	250.46	1391034.0
2022-07-14 13:00:00	MSFT	Stock	250.46	253.12	250.195	252.84	1573810.0
2022-07-14 14:00:00	MSFT	Stock	252.82	255.05	252.71	254.41	1918532.0
2022-07-14 15:00:00	MSFT	Stock	254.41	255.1374	253.61	254.08	2717918.0
2022-07-14 16:00:00	MSFT	Stock	254.08	255.0	253.6	254.14	3487637.0
2022-07-14 17:00:00	MSFT	Stock	254.2001	254.5	254.13	254.1842	12696.0
2022-07-14 18:00:00	MSFT	Stock	254.4	255.09	254.4	254.91	8518.0
2022-07-14 19:00:00	MSFT	Stock	254.87	255.55	254.87	255.43	10263.0
2022-07-14 04:00:00	NVDA	Stock	15.094	15.15	15.0	15.034	147860.0
2022-07-14 05:00:00	NVDA	Stock	15.079	15.12	15.046	15.119	46050.0
2022-07-14 06:00:00	NVDA	Stock	15.139	15.15	15.061	15.135	63870.0
2022-07-14 07:00:00	NVDA	Stock	15.109	15.15	15.07	15.08	526610.0
2022-07-14 08:00:00	NVDA	Stock	15.12	15.2278	15.022	15.2	2003370.0
2022-07-14 09:00:00	NVDA	Stock	15.19	15.21	14.851	14.9536	52927350.0
2022-07-14 10:00:00	NVDA	Stock	14.9535	14.966	14.728	14.848	65286900.0
2022-07-14 11:00:00	NVDA	Stock	14.847	15.098	14.847	15.081	45722810.0
2022-07-14 12:00:00	NVDA	Stock	15.084	15.1108	14.9524	15.0054	28697890.0
2022-07-14 13:00:00	NVDA	Stock	15.0094	15.3466	14.981	15.3007	47246020.0
2022-07-14 14:00:00	NVDA	Stock	15.302	15.473	15.243	15.39	50119320.0
2022-07-14 15:00:00	NVDA	Stock	15.389	15.432	15.295	15.372	58366110.0
2022-07-14 16:00:00	NVDA	Stock	15.372	15.387	15.357	15.383	16543850.0
2022-07-14 17:00:00	NVDA	Stock	15.377	15.419	15.374	15.417	186640.0
2022-07-14 18:00:00	NVDA	Stock	15.418	15.501	15.401	15.48	533490.0
2022-07-14 19:00:00	NVDA	Stock	15.48	15.545	15.47	15.525	619100.0
2022-07-14 04:00:00	AMZN	Stock	109.88	109.89	108.82	109.25	14015.0
2022-07-14 05:00:00	AMZN	Stock	109.28	109.48	109.11	109.48	15317.0

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

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