PREVIEW / stock_1hour / 2006-08-18

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-18.parquet
  size:    589 KB
  rows:    28,308
  symbols: 2,325

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
2006-08-18 08:00:00	AAPL	Stock	2.4136	2.4136	2.4036	2.4089	737016.0
2006-08-18 09:00:00	AAPL	Stock	2.4089	2.4211	2.4021	2.4136	93469040.0
2006-08-18 10:00:00	AAPL	Stock	2.4143	2.4368	2.4093	2.4346	121304792.0
2006-08-18 11:00:00	AAPL	Stock	2.4347	2.4429	2.425	2.4311	74256224.0
2006-08-18 12:00:00	AAPL	Stock	2.4307	2.4354	2.4175	2.4321	63483924.0
2006-08-18 13:00:00	AAPL	Stock	2.4325	2.4418	2.4282	2.4286	48122312.0
2006-08-18 14:00:00	AAPL	Stock	2.4286	2.4354	2.4218	2.4232	52197992.0
2006-08-18 15:00:00	AAPL	Stock	2.4232	2.4293	2.4225	2.4264	71439844.0
2006-08-18 16:00:00	AAPL	Stock	2.4264	2.4286	2.4243	2.4243	1906940.0
2006-08-18 17:00:00	AAPL	Stock	2.4286	2.4286	2.4239	2.4239	91000.0
2006-08-18 08:00:00	MSFT	Stock	24.63	24.71	24.63	24.68	5200.0
2006-08-18 09:00:00	MSFT	Stock	24.69	25.2	24.68	25.02	22720791.0
2006-08-18 10:00:00	MSFT	Stock	25.03	25.1	25.0	25.09	9638705.0
2006-08-18 11:00:00	MSFT	Stock	25.1	25.43	25.05	25.41	24271316.0
2006-08-18 12:00:00	MSFT	Stock	25.42	25.54	25.4	25.44	13785778.0
2006-08-18 13:00:00	MSFT	Stock	25.44	25.49	25.4	25.42	7084342.0
2006-08-18 14:00:00	MSFT	Stock	25.43	25.53	25.42	25.48	11756861.0
2006-08-18 15:00:00	MSFT	Stock	25.49	25.8	25.47	25.78	32034625.0
2006-08-18 16:00:00	MSFT	Stock	25.79	25.85	25.74	25.78	1116009.0
2006-08-18 17:00:00	MSFT	Stock	25.79	25.8	25.7	25.8	2367173.0
2006-08-18 18:00:00	MSFT	Stock	25.79	25.79	25.77	25.78	9800.0
2006-08-18 06:00:00	NVDA	Stock	0.4625	0.4625	0.4625	0.4625	6000.0
2006-08-18 07:00:00	NVDA	Stock	0.4535	0.4583	0.4535	0.455	432060.0
2006-08-18 08:00:00	NVDA	Stock	0.455	0.4567	0.4458	0.449	13513020.0
2006-08-18 09:00:00	NVDA	Stock	0.448	0.45	0.4338	0.4347	149710680.0
2006-08-18 10:00:00	NVDA	Stock	0.4347	0.4478	0.4335	0.4453	126029520.0
2006-08-18 11:00:00	NVDA	Stock	0.4453	0.4482	0.44	0.4432	65759040.0
2006-08-18 12:00:00	NVDA	Stock	0.4432	0.4492	0.4425	0.4478	63561420.0
2006-08-18 13:00:00	NVDA	Stock	0.4478	0.4513	0.447	0.4505	61204500.0
2006-08-18 14:00:00	NVDA	Stock	0.4503	0.4555	0.449	0.453	66450780.0
2006-08-18 15:00:00	NVDA	Stock	0.453	0.4583	0.4527	0.4562	105270540.0
2006-08-18 16:00:00	NVDA	Stock	0.4565	0.4583	0.455	0.4583	2902860.0
2006-08-18 17:00:00	NVDA	Stock	0.4567	0.4567	0.4567	0.4567	63600.0
2006-08-18 08:00:00	AMZN	Stock	1.4545	1.4545	1.4495	1.45	130000.0
2006-08-18 09:00:00	AMZN	Stock	1.45	1.455	1.411	1.416	20802680.0
2006-08-18 10:00:00	AMZN	Stock	1.4155	1.437	1.4135	1.435	20257100.0
2006-08-18 11:00:00	AMZN	Stock	1.435	1.4485	1.4335	1.438	10920680.0
2006-08-18 12:00:00	AMZN	Stock	1.438	1.4439	1.4335	1.4395	5652440.0
2006-08-18 13:00:00	AMZN	Stock	1.4395	1.449	1.4385	1.439	9943700.0
2006-08-18 14:00:00	AMZN	Stock	1.4385	1.4545	1.435	1.438	16860660.0
2006-08-18 15:00:00	AMZN	Stock	1.4385	1.4615	1.4315	1.4555	27141800.0
2006-08-18 16:00:00	AMZN	Stock	1.4555	1.456	1.455	1.456	207660.0
2006-08-18 09:00:00	CL	Stock	29.54	29.65	29.435	29.51	436000.0
2006-08-18 10:00:00	CL	Stock	29.51	29.59	29.5	29.575	258200.0
2006-08-18 11:00:00	CL	Stock	29.575	29.575	29.44	29.47	211600.0
2006-08-18 12:00:00	CL	Stock	29.475	29.505	29.42	29.485	204200.0
2006-08-18 13:00:00	CL	Stock	29.486	29.565	29.485	29.55	205600.0
2006-08-18 14:00:00	CL	Stock	29.54	29.58	29.5	29.555	235800.0
2006-08-18 15:00:00	CL	Stock	29.555	29.56	29.48	29.505	662800.0
2006-08-18 17:00:00	CL	Stock	29.625	29.625	29.625	29.625	1000.0

> showing 50 of 28,308 rows — these rows as CSV

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