PREVIEW / stock_1hour / 2023-11-08

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-08.parquet
  size:    1.3 MB
  rows:    58,229
  symbols: 1,330

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-11-08 04:00:00	AAPL	Stock	181.86	181.96	181.66	181.92	12414.0
2023-11-08 05:00:00	AAPL	Stock	181.88	181.98	181.82	181.9	13239.0
2023-11-08 06:00:00	AAPL	Stock	181.9	181.9	181.81	181.84	15836.0
2023-11-08 07:00:00	AAPL	Stock	181.82	181.85	181.61	181.85	29340.0
2023-11-08 08:00:00	AAPL	Stock	181.7	182.06	181.39	181.53	86743.0
2023-11-08 09:00:00	AAPL	Stock	181.56	183.45	181.51	182.96	7145727.0
2023-11-08 10:00:00	AAPL	Stock	182.98	183.33	182.2851	182.58	7276619.0
2023-11-08 11:00:00	AAPL	Stock	182.585	182.85	182.0	182.01	4685368.0
2023-11-08 12:00:00	AAPL	Stock	182.02	182.29	181.59	182.1501	3683195.0
2023-11-08 13:00:00	AAPL	Stock	182.16	182.7475	182.0	182.5933	2985648.0
2023-11-08 14:00:00	AAPL	Stock	182.59	182.89	182.37	182.43	2992938.0
2023-11-08 15:00:00	AAPL	Stock	182.43	183.01	182.41	182.89	6628909.0
2023-11-08 16:00:00	AAPL	Stock	182.905	182.94	182.72	182.77	6055755.0
2023-11-08 17:00:00	AAPL	Stock	182.76	182.89	182.76	182.79	27429.0
2023-11-08 18:00:00	AAPL	Stock	182.79	182.79	182.33	182.6	40087.0
2023-11-08 19:00:00	AAPL	Stock	182.6	182.72	182.43	182.43	27400.0
2023-11-08 04:00:00	MSFT	Stock	360.19	360.29	360.0	360.29	1842.0
2023-11-08 05:00:00	MSFT	Stock	360.3	360.48	360.3	360.48	2668.0
2023-11-08 06:00:00	MSFT	Stock	360.41	360.98	360.36	360.92	3562.0
2023-11-08 07:00:00	MSFT	Stock	360.85	360.99	360.51	360.9	9019.0
2023-11-08 08:00:00	MSFT	Stock	360.82	361.25	359.62	360.6501	49098.0
2023-11-08 09:00:00	MSFT	Stock	360.7002	363.87	360.7002	362.51	2362931.0
2023-11-08 10:00:00	MSFT	Stock	362.54	362.63	360.55	361.635	2514582.0
2023-11-08 11:00:00	MSFT	Stock	361.66	362.95	361.54	362.3375	1506697.0
2023-11-08 12:00:00	MSFT	Stock	362.34	362.62	361.29	362.26	1156592.0
2023-11-08 13:00:00	MSFT	Stock	362.2666	363.23	362.091	362.81	1098347.0
2023-11-08 14:00:00	MSFT	Stock	362.82	363.31	361.9	361.97	1134830.0
2023-11-08 15:00:00	MSFT	Stock	361.98	363.34	361.39	363.23	2634024.0
2023-11-08 16:00:00	MSFT	Stock	363.2	363.49	362.76	363.14	3213958.0
2023-11-08 17:00:00	MSFT	Stock	363.14	363.2435	362.76	363.01	5423.0
2023-11-08 18:00:00	MSFT	Stock	362.85	363.19	362.61	362.9693	16596.0
2023-11-08 19:00:00	MSFT	Stock	362.88	362.97	362.7	362.9	5772.0
2023-11-08 04:00:00	NVDA	Stock	45.95	46.0	45.85	46.0	79290.0
2023-11-08 05:00:00	NVDA	Stock	45.988	46.136	45.988	46.122	67850.0
2023-11-08 06:00:00	NVDA	Stock	46.119	46.131	46.074	46.11	62170.0
2023-11-08 07:00:00	NVDA	Stock	46.104	46.115	46.035	46.093	397050.0
2023-11-08 08:00:00	NVDA	Stock	46.119	46.15	45.8	46.1202	1026970.0
2023-11-08 09:00:00	NVDA	Stock	46.11	46.607	45.968	46.456	47002850.0
2023-11-08 10:00:00	NVDA	Stock	46.462	46.51	46.08	46.27	47864930.0
2023-11-08 11:00:00	NVDA	Stock	46.2642	46.565	46.25	46.439	34835150.0
2023-11-08 12:00:00	NVDA	Stock	46.439	46.465	46.153	46.405	27082620.0
2023-11-08 13:00:00	NVDA	Stock	46.402	46.744	46.356	46.7094	35594330.0
2023-11-08 14:00:00	NVDA	Stock	46.709	46.867	46.547	46.5562	30406650.0
2023-11-08 15:00:00	NVDA	Stock	46.567	46.6545	46.443	46.583	32129870.0
2023-11-08 16:00:00	NVDA	Stock	46.578	46.633	46.54	46.561	14032080.0
2023-11-08 17:00:00	NVDA	Stock	46.555	46.59	46.545	46.575	187380.0
2023-11-08 18:00:00	NVDA	Stock	46.57	46.57	46.438	46.5	384630.0
2023-11-08 19:00:00	NVDA	Stock	46.506	46.535	46.415	46.42	325390.0
2023-11-08 04:00:00	AMZN	Stock	142.63	142.71	142.5	142.66	6379.0
2023-11-08 05:00:00	AMZN	Stock	142.6	142.6	142.45	142.45	4158.0

> showing 50 of 58,229 rows — these rows as CSV

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