PREVIEW / stock_1hour / 2023-08-16

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-16.parquet
  size:    1.3 MB
  rows:    59,361
  symbols: 1,479

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-08-16 04:00:00	AAPL	Stock	178.03	178.07	177.96	178.01	8042.0
2023-08-16 05:00:00	AAPL	Stock	178.06	178.13	177.65	177.86	21106.0
2023-08-16 06:00:00	AAPL	Stock	177.89	177.98	177.45	177.86	13326.0
2023-08-16 07:00:00	AAPL	Stock	177.83	177.84	177.38	177.72	19990.0
2023-08-16 08:00:00	AAPL	Stock	177.39	178.35	177.03	177.07	153825.0
2023-08-16 09:00:00	AAPL	Stock	177.07	178.19	176.84	177.9771	4452184.0
2023-08-16 10:00:00	AAPL	Stock	177.975	178.54	177.625	178.215	4721300.0
2023-08-16 11:00:00	AAPL	Stock	178.22	178.335	177.5	177.66	3359718.0
2023-08-16 12:00:00	AAPL	Stock	177.66	177.84	177.305	177.5973	3084618.0
2023-08-16 13:00:00	AAPL	Stock	177.59	178.3771	177.38	178.08	2910728.0
2023-08-16 14:00:00	AAPL	Stock	178.1	178.31	177.31	177.7586	3888483.0
2023-08-16 15:00:00	AAPL	Stock	177.76	177.76	176.5	176.5586	7270792.0
2023-08-16 16:00:00	AAPL	Stock	176.55	176.61	176.08	176.36	4085665.0
2023-08-16 17:00:00	AAPL	Stock	176.35	176.57	176.31	176.4	81251.0
2023-08-16 18:00:00	AAPL	Stock	176.42	176.47	176.35	176.36	23951.0
2023-08-16 19:00:00	AAPL	Stock	176.35	176.35	176.07	176.09	49337.0
2023-08-16 04:00:00	MSFT	Stock	321.81	323.0	321.81	322.85	7086.0
2023-08-16 05:00:00	MSFT	Stock	322.59	322.6	321.42	321.69	1957.0
2023-08-16 06:00:00	MSFT	Stock	321.69	321.69	321.51	321.51	400.0
2023-08-16 07:00:00	MSFT	Stock	321.47	321.56	320.84	321.3	6345.0
2023-08-16 08:00:00	MSFT	Stock	321.5	321.53	320.5002	320.5002	18359.0
2023-08-16 09:00:00	MSFT	Stock	320.71	322.61	319.8035	321.69	1370967.0
2023-08-16 10:00:00	MSFT	Stock	321.69	323.79	321.13	323.39	1863838.0
2023-08-16 11:00:00	MSFT	Stock	323.4	324.42	322.0	322.26	1346074.0
2023-08-16 12:00:00	MSFT	Stock	322.23	322.31	321.25	321.33	881182.0
2023-08-16 13:00:00	MSFT	Stock	321.317	322.91	320.7	322.62	1005916.0
2023-08-16 14:00:00	MSFT	Stock	322.59	323.65	321.13	322.0328	1272635.0
2023-08-16 15:00:00	MSFT	Stock	322.025	322.025	320.25	320.3526	2152790.0
2023-08-16 16:00:00	MSFT	Stock	320.36	320.47	319.52	319.85	3438003.0
2023-08-16 17:00:00	MSFT	Stock	319.82	320.17	319.75	319.933	7451.0
2023-08-16 18:00:00	MSFT	Stock	319.85	319.9836	319.6	319.62	10125.0
2023-08-16 19:00:00	MSFT	Stock	319.62	319.7	319.3	319.3	9545.0
2023-08-16 04:00:00	NVDA	Stock	44.06	44.55	44.06	44.471	349380.0
2023-08-16 05:00:00	NVDA	Stock	44.498	44.498	44.175	44.28	117110.0
2023-08-16 06:00:00	NVDA	Stock	44.3	44.377	44.28	44.346	26690.0
2023-08-16 07:00:00	NVDA	Stock	44.386	44.386	44.035	44.245	1158570.0
2023-08-16 08:00:00	NVDA	Stock	44.12	44.355	44.008	44.28	2728860.0
2023-08-16 09:00:00	NVDA	Stock	44.2958	44.675	44.009	44.118	65958180.0
2023-08-16 10:00:00	NVDA	Stock	44.1175	44.4123	43.799	44.1765	66469090.0
2023-08-16 11:00:00	NVDA	Stock	44.173	44.323	43.767	43.8192	43598790.0
2023-08-16 12:00:00	NVDA	Stock	43.814	43.963	43.406	43.683	50394070.0
2023-08-16 13:00:00	NVDA	Stock	43.68	44.08	43.56	43.8825	35746260.0
2023-08-16 14:00:00	NVDA	Stock	43.89	44.176	43.625	43.913	51286070.0
2023-08-16 15:00:00	NVDA	Stock	43.906	43.915	43.453	43.48	58474410.0
2023-08-16 16:00:00	NVDA	Stock	43.481	43.639	43.45	43.562	25980910.0
2023-08-16 17:00:00	NVDA	Stock	43.55	43.58	43.52	43.575	257930.0
2023-08-16 18:00:00	NVDA	Stock	43.5913	43.639	43.555	43.555	352440.0
2023-08-16 19:00:00	NVDA	Stock	43.555	43.581	43.51	43.57	686000.0
2023-08-16 04:00:00	AMZN	Stock	138.22	138.39	138.15	138.26	9743.0
2023-08-16 05:00:00	AMZN	Stock	138.25	138.25	137.81	137.84	4727.0

> showing 50 of 59,361 rows — these rows as CSV

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