PREVIEW / stock_1hour / 2023-09-08

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-09-08.parquet
  size:    1.3 MB
  rows:    57,352
  symbols: 1,445

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-09-08 04:00:00	AAPL	Stock	179.0	179.0	177.51	177.75	48561.0
2023-09-08 05:00:00	AAPL	Stock	177.73	177.77	177.18	177.53	67945.0
2023-09-08 06:00:00	AAPL	Stock	177.52	177.82	177.16	177.8	39666.0
2023-09-08 07:00:00	AAPL	Stock	177.78	177.89	177.24	177.48	132443.0
2023-09-08 08:00:00	AAPL	Stock	177.7913	179.75	177.06	178.1901	491916.0
2023-09-08 09:00:00	AAPL	Stock	178.19	180.239	178.15	179.075	10016787.0
2023-09-08 10:00:00	AAPL	Stock	179.0784	180.0252	178.93	178.9442	8590448.0
2023-09-08 11:00:00	AAPL	Stock	178.94	180.2	178.7	179.545	7416081.0
2023-09-08 12:00:00	AAPL	Stock	179.55	179.99	179.21	179.6181	4722335.0
2023-09-08 13:00:00	AAPL	Stock	179.61	179.91	179.26	179.7	3561905.0
2023-09-08 14:00:00	AAPL	Stock	179.7037	179.89	178.02	178.205	6867173.0
2023-09-08 15:00:00	AAPL	Stock	178.2	178.41	177.79	178.19	8743816.0
2023-09-08 16:00:00	AAPL	Stock	178.18	178.76	178.17	178.59	4741439.0
2023-09-08 17:00:00	AAPL	Stock	178.62	178.76	178.18	178.65	89897.0
2023-09-08 18:00:00	AAPL	Stock	178.68	178.86	178.68	178.76	20586.0
2023-09-08 19:00:00	AAPL	Stock	178.7585	178.78	178.66	178.71	21776.0
2023-09-08 04:00:00	MSFT	Stock	331.9	331.9	330.1	330.4	2063.0
2023-09-08 05:00:00	MSFT	Stock	330.2	330.2	329.5	329.5	1491.0
2023-09-08 06:00:00	MSFT	Stock	329.5	330.1	329.5	330.1	300.0
2023-09-08 07:00:00	MSFT	Stock	330.04	330.05	329.08	329.48	1839.0
2023-09-08 08:00:00	MSFT	Stock	330.1	331.37	329.13	329.8	12196.0
2023-09-08 09:00:00	MSFT	Stock	329.84	334.55	329.46	333.5	1667864.0
2023-09-08 10:00:00	MSFT	Stock	333.55	335.95	333.299	334.01	2357218.0
2023-09-08 11:00:00	MSFT	Stock	333.98	336.16	333.6803	335.28	1902984.0
2023-09-08 12:00:00	MSFT	Stock	335.27	335.5	333.92	334.8	1007870.0
2023-09-08 13:00:00	MSFT	Stock	334.76	335.42	334.3	335.2554	706880.0
2023-09-08 14:00:00	MSFT	Stock	335.25	336.05	333.72	333.73	1419689.0
2023-09-08 15:00:00	MSFT	Stock	333.72	334.5	333.17	334.3	1925511.0
2023-09-08 16:00:00	MSFT	Stock	334.29	335.13	334.27	334.82	2894902.0
2023-09-08 17:00:00	MSFT	Stock	334.78	334.78	334.5354	334.7	6343.0
2023-09-08 18:00:00	MSFT	Stock	334.7	334.85	334.5042	334.85	15539.0
2023-09-08 19:00:00	MSFT	Stock	334.8	334.81	334.5	334.5	1859.0
2023-09-08 04:00:00	NVDA	Stock	46.41	46.429	46.081	46.082	143070.0
2023-09-08 05:00:00	NVDA	Stock	46.055	46.055	45.822	45.949	79480.0
2023-09-08 06:00:00	NVDA	Stock	45.962	46.06	45.909	46.048	62170.0
2023-09-08 07:00:00	NVDA	Stock	46.05	46.159	45.845	45.916	574930.0
2023-09-08 08:00:00	NVDA	Stock	46.092	46.581	45.85	46.098	1378780.0
2023-09-08 09:00:00	NVDA	Stock	46.086	46.606	45.83	46.2095	48458870.0
2023-09-08 10:00:00	NVDA	Stock	46.215	46.365	45.311	45.3148	58882290.0
2023-09-08 11:00:00	NVDA	Stock	45.311	45.891	45.271	45.821	49597690.0
2023-09-08 12:00:00	NVDA	Stock	45.822	46.048	45.671	45.766	39459630.0
2023-09-08 13:00:00	NVDA	Stock	45.7629	45.797	45.467	45.523	32364210.0
2023-09-08 14:00:00	NVDA	Stock	45.5238	45.688	45.33	45.418	40794910.0
2023-09-08 15:00:00	NVDA	Stock	45.411	45.6039	45.382	45.572	52520890.0
2023-09-08 16:00:00	NVDA	Stock	45.572	45.58	45.516	45.54	14169610.0
2023-09-08 17:00:00	NVDA	Stock	45.541	45.63	45.53	45.62	331110.0
2023-09-08 18:00:00	NVDA	Stock	45.595	45.649	45.578	45.586	259210.0
2023-09-08 19:00:00	NVDA	Stock	45.577	45.59	45.52	45.52	345300.0
2023-09-08 04:00:00	AMZN	Stock	138.19	138.19	137.4	137.4	13301.0
2023-09-08 05:00:00	AMZN	Stock	137.42	137.5	137.18	137.31	5036.0

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

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