PREVIEW / stock_1hour / 2023-09-15

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-09-15.parquet
  size:    1.3 MB
  rows:    60,069
  symbols: 1,426

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-15 04:00:00	AAPL	Stock	176.0	176.3	175.92	175.96	31002.0
2023-09-15 05:00:00	AAPL	Stock	176.0	176.18	175.94	176.17	11937.0
2023-09-15 06:00:00	AAPL	Stock	176.18	176.49	176.18	176.39	31756.0
2023-09-15 07:00:00	AAPL	Stock	176.31	176.47	175.81	176.05	65848.0
2023-09-15 08:00:00	AAPL	Stock	176.4	177.4895	175.52	177.1	563402.0
2023-09-15 09:00:00	AAPL	Stock	177.19	177.43	174.69	174.985	19751010.0
2023-09-15 10:00:00	AAPL	Stock	175.0	175.38	174.55	174.57	9271002.0
2023-09-15 11:00:00	AAPL	Stock	174.57	175.16	174.525	174.952	5603418.0
2023-09-15 12:00:00	AAPL	Stock	174.96	175.15	174.675	174.99	3723619.0
2023-09-15 13:00:00	AAPL	Stock	174.99	175.04	173.82	174.26	5241805.0
2023-09-15 14:00:00	AAPL	Stock	174.26	174.63	174.155	174.3701	5176414.0
2023-09-15 15:00:00	AAPL	Stock	174.3799	175.12	174.1387	174.96	9998584.0
2023-09-15 16:00:00	AAPL	Stock	175.01	175.2	174.93	175.01	30179060.0
2023-09-15 17:00:00	AAPL	Stock	175.01	175.02	174.92	174.92	127847.0
2023-09-15 18:00:00	AAPL	Stock	174.9399	174.98	174.91	174.93	16960.0
2023-09-15 19:00:00	AAPL	Stock	174.92	174.92	174.7	174.83	22394.0
2023-09-15 04:00:00	MSFT	Stock	339.67	339.67	339.07	339.15	3665.0
2023-09-15 05:00:00	MSFT	Stock	339.03	339.09	338.49	338.71	1399.0
2023-09-15 06:00:00	MSFT	Stock	338.71	338.71	338.64	338.64	466.0
2023-09-15 07:00:00	MSFT	Stock	338.99	339.0	338.72	338.8	2981.0
2023-09-15 08:00:00	MSFT	Stock	338.88	339.99	337.7836	338.0	31590.0
2023-09-15 09:00:00	MSFT	Stock	337.9	338.64	332.35	333.2	7730731.0
2023-09-15 10:00:00	MSFT	Stock	333.24	333.98	332.03	332.62	1987996.0
2023-09-15 11:00:00	MSFT	Stock	332.61	332.91	331.58	332.2368	1577203.0
2023-09-15 12:00:00	MSFT	Stock	332.28	333.42	332.11	333.15	986180.0
2023-09-15 13:00:00	MSFT	Stock	333.1885	333.2	330.77	331.15	1091775.0
2023-09-15 14:00:00	MSFT	Stock	331.15	331.31	329.65	330.34	1143257.0
2023-09-15 15:00:00	MSFT	Stock	330.31	331.44	330.05	330.25	2252768.0
2023-09-15 16:00:00	MSFT	Stock	330.27	330.36	329.89	329.98	9308969.0
2023-09-15 17:00:00	MSFT	Stock	330.04	330.22	330.04	330.16	257919.0
2023-09-15 18:00:00	MSFT	Stock	330.11	330.22	330.11	330.12	2817.0
2023-09-15 19:00:00	MSFT	Stock	330.2	330.2	329.95	329.95	4345.0
2023-09-15 04:00:00	NVDA	Stock	45.6	45.6	45.35	45.397	150440.0
2023-09-15 05:00:00	NVDA	Stock	45.39	45.46	45.365	45.45	58970.0
2023-09-15 06:00:00	NVDA	Stock	45.43	45.501	45.43	45.501	47950.0
2023-09-15 07:00:00	NVDA	Stock	45.5	45.575	45.5	45.52	235480.0
2023-09-15 08:00:00	NVDA	Stock	45.485	45.797	45.355	45.36	890190.0
2023-09-15 09:00:00	NVDA	Stock	45.362	45.599	44.805	44.934	57326960.0
2023-09-15 10:00:00	NVDA	Stock	44.934	45.02	44.256	44.2571	57482540.0
2023-09-15 11:00:00	NVDA	Stock	44.262	44.439	44.065	44.18	47439050.0
2023-09-15 12:00:00	NVDA	Stock	44.18	44.485	44.165	44.443	31827240.0
2023-09-15 13:00:00	NVDA	Stock	44.4439	44.451	43.902	44.032	39710100.0
2023-09-15 14:00:00	NVDA	Stock	44.036	44.067	43.808	43.911	34058350.0
2023-09-15 15:00:00	NVDA	Stock	43.91	44.159	43.818	43.897	53909790.0
2023-09-15 16:00:00	NVDA	Stock	43.9	43.91	43.811	43.8233	52306840.0
2023-09-15 17:00:00	NVDA	Stock	43.828	43.9	43.76	43.825	726290.0
2023-09-15 18:00:00	NVDA	Stock	43.825	43.835	43.8	43.81	172390.0
2023-09-15 19:00:00	NVDA	Stock	43.802	43.802	43.71	43.72	507120.0
2023-09-15 04:00:00	AMZN	Stock	145.09	146.22	144.2	144.3	17020.0
2023-09-15 05:00:00	AMZN	Stock	144.16	144.2	143.95	144.0	7827.0

> showing 50 of 60,069 rows — these rows as CSV

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