PREVIEW / stock_1hour / 2023-10-10

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-10-10.parquet
  size:    1.3 MB
  rows:    57,937
  symbols: 1,387

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-10-10 04:00:00	AAPL	Stock	179.0	179.35	178.85	179.35	19730.0
2023-10-10 05:00:00	AAPL	Stock	179.3	179.3	179.1	179.12	8907.0
2023-10-10 06:00:00	AAPL	Stock	179.14	179.18	178.82	178.82	14494.0
2023-10-10 07:00:00	AAPL	Stock	178.89	178.89	177.7	177.7	74890.0
2023-10-10 08:00:00	AAPL	Stock	178.25	179.11	177.7	178.15	160996.0
2023-10-10 09:00:00	AAPL	Stock	178.03	179.16	177.85	178.63	4263516.0
2023-10-10 10:00:00	AAPL	Stock	178.63	179.43	178.35	179.32	5489278.0
2023-10-10 11:00:00	AAPL	Stock	179.33	179.68	179.13	179.565	3511043.0
2023-10-10 12:00:00	AAPL	Stock	179.56	179.72	179.35	179.51	2272353.0
2023-10-10 13:00:00	AAPL	Stock	179.5	179.5	178.04	178.275	4933463.0
2023-10-10 14:00:00	AAPL	Stock	178.27	178.63	177.95	178.175	3675857.0
2023-10-10 15:00:00	AAPL	Stock	178.175	178.9099	178.07	178.41	7017438.0
2023-10-10 16:00:00	AAPL	Stock	178.42	178.58	178.3	178.37	5499244.0
2023-10-10 17:00:00	AAPL	Stock	178.35	178.49	178.31	178.31	31221.0
2023-10-10 18:00:00	AAPL	Stock	178.34	178.45	178.33	178.45	25072.0
2023-10-10 19:00:00	AAPL	Stock	178.45	178.54	178.41	178.54	7773.0
2023-10-10 04:00:00	MSFT	Stock	330.33	331.27	330.33	331.27	2292.0
2023-10-10 05:00:00	MSFT	Stock	331.1	331.3	331.0	331.18	3029.0
2023-10-10 06:00:00	MSFT	Stock	331.3	331.3	331.09	331.2	3078.0
2023-10-10 07:00:00	MSFT	Stock	331.1	331.6	330.36	330.42	17151.0
2023-10-10 08:00:00	MSFT	Stock	331.01	331.7557	329.33	331.35	41183.0
2023-10-10 09:00:00	MSFT	Stock	331.2	331.3	327.9925	329.14	1905664.0
2023-10-10 10:00:00	MSFT	Stock	329.18	330.31	328.55	329.59	2619726.0
2023-10-10 11:00:00	MSFT	Stock	329.65	330.98	329.25	330.54	2216866.0
2023-10-10 12:00:00	MSFT	Stock	330.54	330.68	329.83	330.0601	1042305.0
2023-10-10 13:00:00	MSFT	Stock	330.04	330.04	327.67	328.48	1626716.0
2023-10-10 14:00:00	MSFT	Stock	328.47	329.01	328.03	328.72	1024297.0
2023-10-10 15:00:00	MSFT	Stock	328.735	329.59	328.25	328.39	2285322.0
2023-10-10 16:00:00	MSFT	Stock	328.39	328.86	328.33	328.63	2636723.0
2023-10-10 17:00:00	MSFT	Stock	328.58	328.6	328.51	328.6	1894.0
2023-10-10 18:00:00	MSFT	Stock	328.6	328.75	328.55	328.622	3310.0
2023-10-10 19:00:00	MSFT	Stock	328.73	330.0	328.73	329.23	12097.0
2023-10-10 04:00:00	NVDA	Stock	45.351	45.45	45.275	45.393	55970.0
2023-10-10 05:00:00	NVDA	Stock	45.359	45.41	45.345	45.4	29970.0
2023-10-10 06:00:00	NVDA	Stock	45.4	45.491	45.4	45.406	75660.0
2023-10-10 07:00:00	NVDA	Stock	45.416	45.47	45.27	45.28	542170.0
2023-10-10 08:00:00	NVDA	Stock	45.437	45.474	45.096	45.298	1355660.0
2023-10-10 09:00:00	NVDA	Stock	45.281	45.574	45.088	45.5675	43698970.0
2023-10-10 10:00:00	NVDA	Stock	45.573	45.843	45.326	45.822	54705060.0
2023-10-10 11:00:00	NVDA	Stock	45.83	46.239	45.807	46.169	46456420.0
2023-10-10 12:00:00	NVDA	Stock	46.168	46.259	46.012	46.197	27747150.0
2023-10-10 13:00:00	NVDA	Stock	46.194	46.199	45.75	45.934	34497810.0
2023-10-10 14:00:00	NVDA	Stock	45.934	46.047	45.808	45.9825	24624340.0
2023-10-10 15:00:00	NVDA	Stock	45.9765	46.045	45.7683	45.794	32044670.0
2023-10-10 16:00:00	NVDA	Stock	45.794	45.825	45.721	45.76	11666540.0
2023-10-10 17:00:00	NVDA	Stock	45.751	45.774	45.735	45.765	190670.0
2023-10-10 18:00:00	NVDA	Stock	45.756	45.798	45.756	45.789	175340.0
2023-10-10 19:00:00	NVDA	Stock	45.79	45.858	45.78	45.84	407790.0
2023-10-10 04:00:00	AMZN	Stock	128.2	128.75	128.2	128.74	15477.0
2023-10-10 05:00:00	AMZN	Stock	128.65	128.79	128.52	128.75	8428.0

> showing 50 of 57,937 rows — these rows as CSV

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