PREVIEW / stock_1hour / 2023-12-05

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-12-05.parquet
  size:    1.3 MB
  rows:    59,772
  symbols: 1,292

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-12-05 04:00:00	AAPL	Stock	188.7	189.38	188.6	188.72	17689.0
2023-12-05 05:00:00	AAPL	Stock	188.6	188.77	188.0	188.67	56089.0
2023-12-05 06:00:00	AAPL	Stock	188.76	188.86	188.56	188.57	27903.0
2023-12-05 07:00:00	AAPL	Stock	188.64	190.5	188.61	190.26	109370.0
2023-12-05 08:00:00	AAPL	Stock	188.605	190.49	188.15	190.05	146354.0
2023-12-05 09:00:00	AAPL	Stock	190.06	193.35	189.84	192.69	11480055.0
2023-12-05 10:00:00	AAPL	Stock	192.66	194.36	192.61	194.26	10978267.0
2023-12-05 11:00:00	AAPL	Stock	194.265	194.4	192.62	193.2141	5861653.0
2023-12-05 12:00:00	AAPL	Stock	193.22	193.83	192.95	193.62	4195527.0
2023-12-05 13:00:00	AAPL	Stock	193.63	193.66	192.85	192.91	3331936.0
2023-12-05 14:00:00	AAPL	Stock	192.91	193.31	192.75	193.22	3531389.0
2023-12-05 15:00:00	AAPL	Stock	193.2201	193.54	192.87	193.5	7532705.0
2023-12-05 16:00:00	AAPL	Stock	193.5	193.5	193.31	193.4	7058642.0
2023-12-05 17:00:00	AAPL	Stock	193.41	193.41	193.2	193.23	36591.0
2023-12-05 18:00:00	AAPL	Stock	193.22	193.42	192.895	193.33	199556.0
2023-12-05 19:00:00	AAPL	Stock	193.33	193.9	193.33	193.79	47614.0
2023-12-05 04:00:00	MSFT	Stock	368.66	368.66	367.81	368.06	3290.0
2023-12-05 05:00:00	MSFT	Stock	368.11	368.12	367.3	367.45	3073.0
2023-12-05 06:00:00	MSFT	Stock	367.7	368.08	367.6	367.62	5551.0
2023-12-05 07:00:00	MSFT	Stock	367.53	368.0	366.8	366.8	11994.0
2023-12-05 08:00:00	MSFT	Stock	367.58	369.2	366.72	368.02	31798.0
2023-12-05 09:00:00	MSFT	Stock	368.02	370.06	365.621	369.76	2495780.0
2023-12-05 10:00:00	MSFT	Stock	369.7	373.075	369.21	371.79	2943216.0
2023-12-05 11:00:00	MSFT	Stock	371.785	373.075	369.36	370.66	2101503.0
2023-12-05 12:00:00	MSFT	Stock	370.68	372.07	370.5003	371.7694	1104746.0
2023-12-05 13:00:00	MSFT	Stock	371.78	372.98	371.07	371.735	1746258.0
2023-12-05 14:00:00	MSFT	Stock	371.725	372.26	370.8308	372.2242	954127.0
2023-12-05 15:00:00	MSFT	Stock	372.23	372.63	371.83	372.58	2716489.0
2023-12-05 16:00:00	MSFT	Stock	372.52	372.78	372.478	372.55	2977745.0
2023-12-05 17:00:00	MSFT	Stock	372.5003	372.6997	372.48	372.6997	3635.0
2023-12-05 18:00:00	MSFT	Stock	372.33	373.0	372.2256	373.0	100051.0
2023-12-05 19:00:00	MSFT	Stock	372.73	374.42	372.73	374.42	10469.0
2023-12-05 04:00:00	NVDA	Stock	45.135	45.2	45.12	45.165	46910.0
2023-12-05 05:00:00	NVDA	Stock	45.162	45.17	45.069	45.07	58900.0
2023-12-05 06:00:00	NVDA	Stock	45.068	45.088	45.019	45.072	98480.0
2023-12-05 07:00:00	NVDA	Stock	45.066	45.16	45.0	45.09	584120.0
2023-12-05 08:00:00	NVDA	Stock	45.06	45.312	45.002	45.2	2122840.0
2023-12-05 09:00:00	NVDA	Stock	45.222	46.12	45.211	46.0895	55848110.0
2023-12-05 10:00:00	NVDA	Stock	46.086	46.585	46.067	46.4635	61784740.0
2023-12-05 11:00:00	NVDA	Stock	46.463	46.5	45.75	45.893	40671400.0
2023-12-05 12:00:00	NVDA	Stock	45.898	46.184	45.898	46.11	28202440.0
2023-12-05 13:00:00	NVDA	Stock	46.1017	46.274	46.016	46.2465	20770100.0
2023-12-05 14:00:00	NVDA	Stock	46.2455	46.425	46.139	46.3995	22451040.0
2023-12-05 15:00:00	NVDA	Stock	46.406	46.6	46.314	46.568	37038100.0
2023-12-05 16:00:00	NVDA	Stock	46.577	46.6619	46.3433	46.6257	13339300.0
2023-12-05 17:00:00	NVDA	Stock	46.627	46.64	46.606	46.606	210980.0
2023-12-05 18:00:00	NVDA	Stock	46.602	46.688	46.566	46.688	954250.0
2023-12-05 19:00:00	NVDA	Stock	46.69	46.885	46.676	46.85	827000.0
2023-12-05 04:00:00	AMZN	Stock	143.93	144.13	143.83	143.89	6473.0
2023-12-05 05:00:00	AMZN	Stock	143.91	143.91	143.38	143.41	6223.0

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

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