PREVIEW / stock_1hour / 2022-10-21

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-21.parquet
  size:    1.3 MB
  rows:    60,584
  symbols: 2,157

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-21 04:00:00	AAPL	Stock	142.79	142.79	142.03	142.15	36207.0
2022-10-21 05:00:00	AAPL	Stock	142.2	142.29	141.85	142.17	31289.0
2022-10-21 06:00:00	AAPL	Stock	142.03	142.18	142.0	142.03	11732.0
2022-10-21 07:00:00	AAPL	Stock	142.24	142.5	141.86	141.88	72511.0
2022-10-21 08:00:00	AAPL	Stock	142.7	143.39	141.57	142.29	247404.0
2022-10-21 09:00:00	AAPL	Stock	142.27	144.9	142.27	144.8898	13664762.0
2022-10-21 10:00:00	AAPL	Stock	144.8892	145.34	144.0101	144.1	10367201.0
2022-10-21 11:00:00	AAPL	Stock	144.1	145.6	143.55	145.59	8655541.0
2022-10-21 12:00:00	AAPL	Stock	145.6	146.1	145.02	145.775	7506049.0
2022-10-21 13:00:00	AAPL	Stock	145.78	146.285	145.63	146.24	5605960.0
2022-10-21 14:00:00	AAPL	Stock	146.25	146.65	145.94	146.65	6037821.0
2022-10-21 15:00:00	AAPL	Stock	146.65	147.8479	146.6	147.27	15159165.0
2022-10-21 16:00:00	AAPL	Stock	147.335	147.6399	147.265	147.54	7540989.0
2022-10-21 17:00:00	AAPL	Stock	147.52	147.67	147.27	147.59	454903.0
2022-10-21 18:00:00	AAPL	Stock	147.63	147.65	147.56	147.57	36245.0
2022-10-21 19:00:00	AAPL	Stock	147.63	147.75	147.58	147.58	36569.0
2022-10-21 04:00:00	MSFT	Stock	234.67	234.67	234.04	234.04	1821.0
2022-10-21 05:00:00	MSFT	Stock	234.0	234.23	233.83	234.0	709.0
2022-10-21 06:00:00	MSFT	Stock	234.18	234.18	233.99	233.99	690.0
2022-10-21 07:00:00	MSFT	Stock	234.26	234.91	234.13	234.46	5853.0
2022-10-21 08:00:00	MSFT	Stock	234.37	236.15	233.18	234.54	45036.0
2022-10-21 09:00:00	MSFT	Stock	234.68	238.0	234.05	237.99	4186244.0
2022-10-21 10:00:00	MSFT	Stock	238.01	238.75	235.9	235.965	2019722.0
2022-10-21 11:00:00	MSFT	Stock	235.9699	238.99	235.11	238.99	1587490.0
2022-10-21 12:00:00	MSFT	Stock	238.98	239.82	237.91	239.18	1387677.0
2022-10-21 13:00:00	MSFT	Stock	239.21	241.18	239.11	241.04	1512052.0
2022-10-21 14:00:00	MSFT	Stock	241.05	241.98	240.53	241.14	1550809.0
2022-10-21 15:00:00	MSFT	Stock	241.15	243.0	241.0201	242.03	3350989.0
2022-10-21 16:00:00	MSFT	Stock	242.04	242.85	241.92	242.61	4564675.0
2022-10-21 17:00:00	MSFT	Stock	242.61	242.61	242.2335	242.5	15632.0
2022-10-21 18:00:00	MSFT	Stock	242.38	242.5	242.12	242.48	3574.0
2022-10-21 19:00:00	MSFT	Stock	242.36	242.47	242.22	242.3	8402.0
2022-10-21 04:00:00	NVDA	Stock	12.054	12.09	12.011	12.02	97950.0
2022-10-21 05:00:00	NVDA	Stock	12.027	12.075	12.008	12.075	35640.0
2022-10-21 06:00:00	NVDA	Stock	12.072	12.072	12.007	12.047	56590.0
2022-10-21 07:00:00	NVDA	Stock	12.06	12.08	12.018	12.03	213320.0
2022-10-21 08:00:00	NVDA	Stock	12.03	12.194	11.899	11.937	2650970.0
2022-10-21 09:00:00	NVDA	Stock	11.935	12.246	11.887	12.2255	82124820.0
2022-10-21 10:00:00	NVDA	Stock	12.2255	12.444	12.064	12.082	99390140.0
2022-10-21 11:00:00	NVDA	Stock	12.084	12.2836	11.984	12.2705	71210770.0
2022-10-21 12:00:00	NVDA	Stock	12.2695	12.392	12.249	12.282	70206420.0
2022-10-21 13:00:00	NVDA	Stock	12.282	12.448	12.273	12.4477	48889040.0
2022-10-21 14:00:00	NVDA	Stock	12.4469	12.489	12.364	12.409	53944620.0
2022-10-21 15:00:00	NVDA	Stock	12.409	12.498	12.387	12.46	75591750.0
2022-10-21 16:00:00	NVDA	Stock	12.4605	12.529	12.45	12.503	23172940.0
2022-10-21 17:00:00	NVDA	Stock	12.504	12.505	12.466	12.498	736260.0
2022-10-21 18:00:00	NVDA	Stock	12.495	12.509	12.495	12.505	143590.0
2022-10-21 19:00:00	NVDA	Stock	12.508	12.545	12.508	12.545	351430.0
2022-10-21 04:00:00	AMZN	Stock	114.5	114.5	113.81	113.94	8107.0
2022-10-21 05:00:00	AMZN	Stock	114.12	114.2	113.81	114.2	6004.0

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

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