PREVIEW / stock_1hour / 2023-12-04

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-12-04.parquet
  size:    1.4 MB
  rows:    61,421
  symbols: 1,290

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-12-04 04:00:00	AAPL	Stock	190.7	190.82	190.19	190.31	19687.0
2023-12-04 05:00:00	AAPL	Stock	190.3	190.36	190.16	190.18	10897.0
2023-12-04 06:00:00	AAPL	Stock	190.2	190.33	190.0	190.0	14151.0
2023-12-04 07:00:00	AAPL	Stock	190.09	190.25	189.78	190.22	36940.0
2023-12-04 08:00:00	AAPL	Stock	190.11	191.24	189.76	189.9051	108839.0
2023-12-04 09:00:00	AAPL	Stock	189.86	190.05	188.93	189.3972	5424159.0
2023-12-04 10:00:00	AAPL	Stock	189.4	189.64	187.75	188.03	6176611.0
2023-12-04 11:00:00	AAPL	Stock	188.02	188.42	187.4511	188.3601	4078868.0
2023-12-04 12:00:00	AAPL	Stock	188.365	188.77	188.19	188.67	2643618.0
2023-12-04 13:00:00	AAPL	Stock	188.67	188.81	188.49	188.665	2230413.0
2023-12-04 14:00:00	AAPL	Stock	188.665	189.13	188.495	189.0117	2523643.0
2023-12-04 15:00:00	AAPL	Stock	189.01	189.66	188.72	189.45	6280090.0
2023-12-04 16:00:00	AAPL	Stock	189.43	189.43	189.07	189.18	6371855.0
2023-12-04 17:00:00	AAPL	Stock	189.17	189.43	189.16	189.25	115578.0
2023-12-04 18:00:00	AAPL	Stock	189.2	189.2	189.05	189.05	5544.0
2023-12-04 19:00:00	AAPL	Stock	189.09	189.29	189.03	189.21	9448.0
2023-12-04 04:00:00	MSFT	Stock	373.0	373.0	372.15	372.15	2227.0
2023-12-04 05:00:00	MSFT	Stock	372.42	372.55	372.32	372.4	775.0
2023-12-04 06:00:00	MSFT	Stock	372.54	372.58	372.0	372.0	5449.0
2023-12-04 07:00:00	MSFT	Stock	372.0	372.3	371.7	372.27	7800.0
2023-12-04 08:00:00	MSFT	Stock	372.08	374.51	370.75	370.8898	60075.0
2023-12-04 09:00:00	MSFT	Stock	370.6955	370.73	363.68	365.02	5593453.0
2023-12-04 10:00:00	MSFT	Stock	365.02	366.3999	362.9	364.44	4259831.0
2023-12-04 11:00:00	MSFT	Stock	364.44	367.99	363.95	367.7699	2405183.0
2023-12-04 12:00:00	MSFT	Stock	367.77	369.265	367.18	369.17	2116316.0
2023-12-04 13:00:00	MSFT	Stock	369.18	369.4599	368.26	368.32	1465506.0
2023-12-04 14:00:00	MSFT	Stock	368.34	368.71	367.32	367.91	1390132.0
2023-12-04 15:00:00	MSFT	Stock	367.91	369.52	367.5239	369.27	3119010.0
2023-12-04 16:00:00	MSFT	Stock	369.14	370.55	368.97	370.0128	3989997.0
2023-12-04 17:00:00	MSFT	Stock	370.02	370.7	370.02	370.39	10124.0
2023-12-04 18:00:00	MSFT	Stock	370.37	370.44	370.25	370.3	10033.0
2023-12-04 19:00:00	MSFT	Stock	370.3	370.3	370.0	370.1	9117.0
2023-12-04 04:00:00	NVDA	Stock	46.6	46.626	46.3	46.576	113010.0
2023-12-04 05:00:00	NVDA	Stock	46.555	46.57	46.47	46.5	45210.0
2023-12-04 06:00:00	NVDA	Stock	46.495	46.495	46.25	46.328	183930.0
2023-12-04 07:00:00	NVDA	Stock	46.352	46.434	46.279	46.389	386650.0
2023-12-04 08:00:00	NVDA	Stock	46.476	46.765	46.149	46.151	1547100.0
2023-12-04 09:00:00	NVDA	Stock	46.15	46.17	45.267	45.621	67247340.0
2023-12-04 10:00:00	NVDA	Stock	45.631	45.925	45.01	45.108	70101010.0
2023-12-04 11:00:00	NVDA	Stock	45.1113	45.492	45.074	45.4635	42347250.0
2023-12-04 12:00:00	NVDA	Stock	45.467	45.71	45.41	45.6045	31552940.0
2023-12-04 13:00:00	NVDA	Stock	45.609	45.6462	45.261	45.261	27191430.0
2023-12-04 14:00:00	NVDA	Stock	45.26	45.332	45.123	45.24	27097290.0
2023-12-04 15:00:00	NVDA	Stock	45.241	45.608	45.132	45.512	43737990.0
2023-12-04 16:00:00	NVDA	Stock	45.506	45.511	45.3324	45.375	18641340.0
2023-12-04 17:00:00	NVDA	Stock	45.364	45.51	45.364	45.415	760550.0
2023-12-04 18:00:00	NVDA	Stock	45.425	45.43	45.359	45.36	183470.0
2023-12-04 19:00:00	NVDA	Stock	45.359	45.391	45.301	45.313	346670.0
2023-12-04 04:00:00	AMZN	Stock	146.67	146.67	146.41	146.51	1640.0
2023-12-04 05:00:00	AMZN	Stock	146.36	146.42	146.18	146.27	1331.0

> showing 50 of 61,421 rows — these rows as CSV

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