PREVIEW / stock_1hour / 2022-12-06

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-12-06.parquet
  size:    1.4 MB
  rows:    60,736
  symbols: 2,056

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-12-06 04:00:00	AAPL	Stock	147.05	147.42	146.91	147.15	53825.0
2022-12-06 05:00:00	AAPL	Stock	147.07	147.29	146.77	147.25	23732.0
2022-12-06 06:00:00	AAPL	Stock	147.2	147.45	147.06	147.36	13692.0
2022-12-06 07:00:00	AAPL	Stock	147.32	147.61	147.16	147.22	55663.0
2022-12-06 08:00:00	AAPL	Stock	147.4	147.6	146.264	147.21	125761.0
2022-12-06 09:00:00	AAPL	Stock	147.21	147.47	145.11	145.1308	6013507.0
2022-12-06 10:00:00	AAPL	Stock	145.135	145.36	143.56	144.125	8455975.0
2022-12-06 11:00:00	AAPL	Stock	144.12	145.015	143.85	144.56	6193134.0
2022-12-06 12:00:00	AAPL	Stock	144.55	144.89	143.86	143.97	4336651.0
2022-12-06 13:00:00	AAPL	Stock	143.98	144.19	143.11	143.57	6259111.0
2022-12-06 14:00:00	AAPL	Stock	143.5722	143.6	141.92	142.4599	6830723.0
2022-12-06 15:00:00	AAPL	Stock	142.47	143.01	141.98	142.92	10712349.0
2022-12-06 16:00:00	AAPL	Stock	142.92	143.05	142.71	143.01	8405163.0
2022-12-06 17:00:00	AAPL	Stock	143.0	143.02	142.9	142.9615	66832.0
2022-12-06 18:00:00	AAPL	Stock	142.95	143.15	142.95	143.11	17330.0
2022-12-06 19:00:00	AAPL	Stock	143.11	143.33	143.07	143.07	26114.0
2022-12-06 04:00:00	MSFT	Stock	250.83	250.83	250.0	250.0	2725.0
2022-12-06 05:00:00	MSFT	Stock	250.17	250.38	249.99	249.99	2186.0
2022-12-06 06:00:00	MSFT	Stock	250.11	250.65	250.11	250.65	841.0
2022-12-06 07:00:00	MSFT	Stock	250.69	250.73	250.21	250.21	7021.0
2022-12-06 08:00:00	MSFT	Stock	250.1525	250.89	249.575	250.89	19096.0
2022-12-06 09:00:00	MSFT	Stock	250.94	251.86	248.23	248.23	2011510.0
2022-12-06 10:00:00	MSFT	Stock	248.25	248.3028	246.41	247.09	1923364.0
2022-12-06 11:00:00	MSFT	Stock	247.115	247.28	246.21	246.49	1369613.0
2022-12-06 12:00:00	MSFT	Stock	246.5	246.76	245.21	245.37	1727412.0
2022-12-06 13:00:00	MSFT	Stock	245.37	245.67	244.4101	245.3	1353158.0
2022-12-06 14:00:00	MSFT	Stock	245.29	245.35	243.97	244.45	1257753.0
2022-12-06 15:00:00	MSFT	Stock	244.45	245.98	243.78	245.07	3155688.0
2022-12-06 16:00:00	MSFT	Stock	245.12	245.3	244.63	245.1	4726502.0
2022-12-06 17:00:00	MSFT	Stock	245.12	245.2	245.02	245.122	3472.0
2022-12-06 18:00:00	MSFT	Stock	245.2	245.3	245.2	245.26	1945.0
2022-12-06 19:00:00	MSFT	Stock	245.25	245.47	245.13	245.15	4101.0
2022-12-06 04:00:00	NVDA	Stock	16.65	16.67	16.627	16.627	44640.0
2022-12-06 05:00:00	NVDA	Stock	16.621	16.631	16.583	16.62	49190.0
2022-12-06 06:00:00	NVDA	Stock	16.61	16.622	16.599	16.622	13240.0
2022-12-06 07:00:00	NVDA	Stock	16.646	16.694	16.646	16.66	60640.0
2022-12-06 08:00:00	NVDA	Stock	16.665	16.699	16.474	16.642	283140.0
2022-12-06 09:00:00	NVDA	Stock	16.638	16.6415	16.196	16.199	31492970.0
2022-12-06 10:00:00	NVDA	Stock	16.201	16.253	15.944	16.022	58393610.0
2022-12-06 11:00:00	NVDA	Stock	16.023	16.151	15.985	16.057	36019010.0
2022-12-06 12:00:00	NVDA	Stock	16.057	16.13	15.977	16.062	34733770.0
2022-12-06 13:00:00	NVDA	Stock	16.063	16.106	15.991	16.084	24348380.0
2022-12-06 14:00:00	NVDA	Stock	16.083	16.0907	15.845	15.909	34784400.0
2022-12-06 15:00:00	NVDA	Stock	15.911	16.009	15.819	15.987	48177790.0
2022-12-06 16:00:00	NVDA	Stock	15.987	16.011	15.971	15.9863	20646480.0
2022-12-06 17:00:00	NVDA	Stock	15.987	15.998	15.98	15.982	108410.0
2022-12-06 18:00:00	NVDA	Stock	15.982	16.002	15.982	15.992	80360.0
2022-12-06 19:00:00	NVDA	Stock	15.999	16.0	15.951	15.96	242070.0
2022-12-06 04:00:00	AMZN	Stock	91.74	91.74	91.06	91.33	33459.0
2022-12-06 05:00:00	AMZN	Stock	91.33	91.45	91.1	91.42	13743.0

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

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