PREVIEW / stock_1hour / 2023-11-16

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-16.parquet
  size:    1.3 MB
  rows:    58,283
  symbols: 1,294

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-16 04:00:00	AAPL	Stock	188.2	188.6	188.2	188.36	6441.0
2023-11-16 05:00:00	AAPL	Stock	188.22	188.4	188.21	188.3	8198.0
2023-11-16 06:00:00	AAPL	Stock	188.26	188.3	187.9	188.05	17156.0
2023-11-16 07:00:00	AAPL	Stock	188.21	188.3	187.7	188.2	48087.0
2023-11-16 08:00:00	AAPL	Stock	188.15	189.18	187.81	189.12	238600.0
2023-11-16 09:00:00	AAPL	Stock	189.13	190.96	188.92	190.69	11900266.0
2023-11-16 10:00:00	AAPL	Stock	190.685	190.85	189.01	189.455	6832920.0
2023-11-16 11:00:00	AAPL	Stock	189.46	189.57	188.72	189.29	4753920.0
2023-11-16 12:00:00	AAPL	Stock	189.29	189.98	189.19	189.755	3551831.0
2023-11-16 13:00:00	AAPL	Stock	189.76	189.78	188.65	189.28	3271296.0
2023-11-16 14:00:00	AAPL	Stock	189.285	189.735	189.215	189.575	3298255.0
2023-11-16 15:00:00	AAPL	Stock	189.57	189.87	189.3303	189.77	6636902.0
2023-11-16 16:00:00	AAPL	Stock	189.76	190.16	189.67	190.1	5112704.0
2023-11-16 17:00:00	AAPL	Stock	190.14	190.16	189.95	189.96	38402.0
2023-11-16 18:00:00	AAPL	Stock	190.03	190.04	189.73	190.04	28721.0
2023-11-16 19:00:00	AAPL	Stock	190.05	190.52	190.05	190.51	49761.0
2023-11-16 04:00:00	MSFT	Stock	371.21	372.2	371.12	371.98	14853.0
2023-11-16 05:00:00	MSFT	Stock	371.99	372.45	371.99	372.4	3719.0
2023-11-16 06:00:00	MSFT	Stock	372.38	372.63	372.27	372.63	3189.0
2023-11-16 07:00:00	MSFT	Stock	372.45	372.62	371.6	371.8	74129.0
2023-11-16 08:00:00	MSFT	Stock	371.85	372.7267	370.0	371.9	105656.0
2023-11-16 09:00:00	MSFT	Stock	371.86	376.07	370.18	375.395	3722910.0
2023-11-16 10:00:00	MSFT	Stock	375.4085	376.01	373.26	373.62	3062750.0
2023-11-16 11:00:00	MSFT	Stock	373.65	374.1899	372.41	373.97	1751139.0
2023-11-16 12:00:00	MSFT	Stock	374.03	375.58	373.92	375.17	1598011.0
2023-11-16 13:00:00	MSFT	Stock	375.185	376.3	374.825	375.49	1565594.0
2023-11-16 14:00:00	MSFT	Stock	375.47	376.2	375.045	375.83	1347773.0
2023-11-16 15:00:00	MSFT	Stock	375.82	376.35	375.2101	376.2	2848493.0
2023-11-16 16:00:00	MSFT	Stock	376.17	376.74	375.95	376.3	3040388.0
2023-11-16 17:00:00	MSFT	Stock	376.25	376.35	375.5	375.59	22742.0
2023-11-16 18:00:00	MSFT	Stock	375.9899	376.1	375.45	376.1	16401.0
2023-11-16 19:00:00	MSFT	Stock	376.11	376.35	376.09	376.21	4706.0
2023-11-16 04:00:00	NVDA	Stock	48.795	48.795	48.4	48.487	100120.0
2023-11-16 05:00:00	NVDA	Stock	48.475	48.533	48.435	48.526	70950.0
2023-11-16 06:00:00	NVDA	Stock	48.499	48.53	48.41	48.5	65020.0
2023-11-16 07:00:00	NVDA	Stock	48.49	48.59	48.28	48.451	736480.0
2023-11-16 08:00:00	NVDA	Stock	48.425	48.774	48.276	48.63	2354030.0
2023-11-16 09:00:00	NVDA	Stock	48.61	48.887	48.33	48.5545	41557560.0
2023-11-16 10:00:00	NVDA	Stock	48.559	49.1	48.514	48.6833	59210890.0
2023-11-16 11:00:00	NVDA	Stock	48.691	48.975	48.6255	48.913	27970270.0
2023-11-16 12:00:00	NVDA	Stock	48.925	49.296	48.8711	49.1379	32709500.0
2023-11-16 13:00:00	NVDA	Stock	49.1406	49.22	48.931	48.975	21334550.0
2023-11-16 14:00:00	NVDA	Stock	48.975	49.249	48.903	49.17	19645050.0
2023-11-16 15:00:00	NVDA	Stock	49.175	49.5247	49.1256	49.488	37402030.0
2023-11-16 16:00:00	NVDA	Stock	49.488	49.65	49.425	49.61	15246640.0
2023-11-16 17:00:00	NVDA	Stock	49.61	49.638	49.56	49.595	592310.0
2023-11-16 18:00:00	NVDA	Stock	49.58	49.602	49.525	49.594	388090.0
2023-11-16 19:00:00	NVDA	Stock	49.6	49.606	49.565	49.585	424910.0
2023-11-16 04:00:00	AMZN	Stock	143.34	143.57	143.3	143.35	3840.0
2023-11-16 05:00:00	AMZN	Stock	143.4	143.5	143.22	143.4	8088.0

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

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