PREVIEW / stock_1hour / 2023-07-19

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-07-19.parquet
  size:    1.4 MB
  rows:    61,163
  symbols: 1,553

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-07-19 04:00:00	AAPL	Stock	193.64	193.66	193.45	193.6	7089.0
2023-07-19 05:00:00	AAPL	Stock	193.55	193.66	193.39	193.59	3565.0
2023-07-19 06:00:00	AAPL	Stock	193.53	193.54	193.11	193.12	12316.0
2023-07-19 07:00:00	AAPL	Stock	193.38	193.66	193.25	193.4	46060.0
2023-07-19 08:00:00	AAPL	Stock	193.41	193.96	193.2607	193.67	127186.0
2023-07-19 09:00:00	AAPL	Stock	193.67	193.71	192.69	192.81	5161142.0
2023-07-19 10:00:00	AAPL	Stock	192.82	193.35	192.65	192.9472	5320107.0
2023-07-19 11:00:00	AAPL	Stock	192.95	193.6	192.79	193.38	3315860.0
2023-07-19 12:00:00	AAPL	Stock	193.37	198.23	193.36	195.07	25605702.0
2023-07-19 13:00:00	AAPL	Stock	195.1	195.1899	194.0652	194.8	5470655.0
2023-07-19 14:00:00	AAPL	Stock	194.81	195.56	194.275	195.55	4606011.0
2023-07-19 15:00:00	AAPL	Stock	195.55	195.72	194.93	195.08	6274921.0
2023-07-19 16:00:00	AAPL	Stock	195.0	195.23	194.73	194.89	8352149.0
2023-07-19 17:00:00	AAPL	Stock	194.88	194.93	194.4201	194.6	57940.0
2023-07-19 18:00:00	AAPL	Stock	194.6433	194.7	194.0101	194.02	85359.0
2023-07-19 19:00:00	AAPL	Stock	194.03	194.1	193.39	193.73	100253.0
2023-07-19 04:00:00	MSFT	Stock	360.79	362.9	360.0	361.83	44437.0
2023-07-19 05:00:00	MSFT	Stock	362.01	362.53	361.6	362.28	4014.0
2023-07-19 06:00:00	MSFT	Stock	362.2	362.4	361.7	361.86	16664.0
2023-07-19 07:00:00	MSFT	Stock	361.9	362.19	361.21	361.7	37816.0
2023-07-19 08:00:00	MSFT	Stock	362.0	363.0	360.0	360.85	163034.0
2023-07-19 09:00:00	MSFT	Stock	360.85	362.46	357.8	359.37	4710651.0
2023-07-19 10:00:00	MSFT	Stock	359.395	361.56	357.25	359.49	4021745.0
2023-07-19 11:00:00	MSFT	Stock	359.51	360.72	358.83	359.235	2224380.0
2023-07-19 12:00:00	MSFT	Stock	359.21	359.65	354.36	354.69	4524535.0
2023-07-19 13:00:00	MSFT	Stock	354.69	354.85	353.02	353.0901	2576163.0
2023-07-19 14:00:00	MSFT	Stock	353.105	354.45	352.435	354.33	2541844.0
2023-07-19 15:00:00	MSFT	Stock	354.33	356.31	354.262	355.01	3419709.0
2023-07-19 16:00:00	MSFT	Stock	355.05	355.08	354.2	354.52	4809390.0
2023-07-19 17:00:00	MSFT	Stock	354.45	354.64	354.04	354.43	9480.0
2023-07-19 18:00:00	MSFT	Stock	354.6	354.7	352.97	353.8	29582.0
2023-07-19 19:00:00	MSFT	Stock	353.8	354.38	353.24	353.36	28050.0
2023-07-19 04:00:00	NVDA	Stock	47.48	47.564	47.299	47.502	105660.0
2023-07-19 05:00:00	NVDA	Stock	47.5	47.69	47.495	47.64	120100.0
2023-07-19 06:00:00	NVDA	Stock	47.658	47.665	47.541	47.64	101400.0
2023-07-19 07:00:00	NVDA	Stock	47.659	47.659	47.369	47.53	580480.0
2023-07-19 08:00:00	NVDA	Stock	47.542	47.7	47.3	47.55	2358760.0
2023-07-19 09:00:00	NVDA	Stock	47.53	47.565	46.914	47.1299	50969560.0
2023-07-19 10:00:00	NVDA	Stock	47.128	47.526	46.901	47.2887	58437740.0
2023-07-19 11:00:00	NVDA	Stock	47.2845	47.64	47.2245	47.3315	37644430.0
2023-07-19 12:00:00	NVDA	Stock	47.3246	47.818	46.92	47.088	55097630.0
2023-07-19 13:00:00	NVDA	Stock	47.089	47.13	46.812	47.001	32803300.0
2023-07-19 14:00:00	NVDA	Stock	47.0	47.042	46.742	46.83	29408230.0
2023-07-19 15:00:00	NVDA	Stock	46.834	47.141	46.826	47.08	41531570.0
2023-07-19 16:00:00	NVDA	Stock	47.08	47.13	46.93	47.12	14502000.0
2023-07-19 17:00:00	NVDA	Stock	47.11	47.11	46.91	46.94	478170.0
2023-07-19 18:00:00	NVDA	Stock	46.93	46.956	46.4	46.565	2006090.0
2023-07-19 19:00:00	NVDA	Stock	46.54	46.6	46.451	46.585	625030.0
2023-07-19 04:00:00	AMZN	Stock	133.18	133.8	133.16	133.55	17398.0
2023-07-19 05:00:00	AMZN	Stock	133.41	133.71	133.33	133.69	5044.0

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

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