PREVIEW / stock_1hour / 2006-05-15

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-15.parquet
  size:    641 KB
  rows:    30,043
  symbols: 2,276

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-05-15 07:00:00	AAPL	Stock	2.3875	2.4018	2.3875	2.4018	109200.0
2006-05-15 08:00:00	AAPL	Stock	2.4061	2.4107	2.3711	2.4086	1032108.0
2006-05-15 09:00:00	AAPL	Stock	2.4096	2.4421	2.3957	2.4243	83924652.0
2006-05-15 10:00:00	AAPL	Stock	2.4243	2.4411	2.4093	2.4189	105793856.0
2006-05-15 11:00:00	AAPL	Stock	2.42	2.4354	2.4179	2.4307	49161224.0
2006-05-15 12:00:00	AAPL	Stock	2.4304	2.4379	2.4186	2.4368	49642152.0
2006-05-15 13:00:00	AAPL	Stock	2.4368	2.4393	2.4075	2.4118	60130560.0
2006-05-15 14:00:00	AAPL	Stock	2.4118	2.4321	2.4114	2.42	78702960.0
2006-05-15 15:00:00	AAPL	Stock	2.4193	2.4296	2.4161	2.4221	90539344.0
2006-05-15 16:00:00	AAPL	Stock	2.4221	2.4239	2.4125	2.4143	2895452.0
2006-05-15 17:00:00	AAPL	Stock	2.4125	2.4157	2.4125	2.4143	344400.0
2006-05-15 18:00:00	AAPL	Stock	2.4129	2.4189	2.4125	2.4125	108696.0
2006-05-15 08:00:00	MSFT	Stock	23.11	23.16	23.11	23.15	70711.0
2006-05-15 09:00:00	MSFT	Stock	23.15	23.23	23.05	23.18	7401854.0
2006-05-15 10:00:00	MSFT	Stock	23.18	23.21	23.08	23.14	10254600.0
2006-05-15 11:00:00	MSFT	Stock	23.14	23.17	23.08	23.13	6080511.0
2006-05-15 12:00:00	MSFT	Stock	23.13	23.16	23.12	23.147	3073687.0
2006-05-15 13:00:00	MSFT	Stock	23.15	23.17	23.06	23.109	7204783.0
2006-05-15 14:00:00	MSFT	Stock	23.102	23.2	23.09	23.1	9640911.0
2006-05-15 15:00:00	MSFT	Stock	23.11	23.15	23.03	23.13	15042872.0
2006-05-15 16:00:00	MSFT	Stock	23.11	23.15	23.084	23.14	4920347.0
2006-05-15 17:00:00	MSFT	Stock	23.14	23.15	23.13	23.14	2623.0
2006-05-15 18:00:00	MSFT	Stock	23.14	23.16	23.13	23.14	2792848.0
2006-05-15 04:00:00	NVDA	Stock	0.4333	0.4342	0.4333	0.4342	260580.0
2006-05-15 06:00:00	NVDA	Stock	0.4335	0.4335	0.4335	0.4335	12000.0
2006-05-15 08:00:00	NVDA	Stock	0.435	0.4383	0.435	0.4375	322080.0
2006-05-15 09:00:00	NVDA	Stock	0.4352	0.449	0.4342	0.4474	86672280.0
2006-05-15 10:00:00	NVDA	Stock	0.4475	0.4475	0.4342	0.4445	92657220.0
2006-05-15 11:00:00	NVDA	Stock	0.4447	0.4483	0.4445	0.4475	54469560.0
2006-05-15 12:00:00	NVDA	Stock	0.4475	0.448	0.4448	0.4462	43069380.0
2006-05-15 13:00:00	NVDA	Stock	0.4465	0.4467	0.4392	0.4397	55758840.0
2006-05-15 14:00:00	NVDA	Stock	0.4397	0.4415	0.4375	0.4375	57341400.0
2006-05-15 15:00:00	NVDA	Stock	0.4375	0.4472	0.4358	0.4452	129751860.0
2006-05-15 16:00:00	NVDA	Stock	0.445	0.4458	0.4409	0.4452	551160.0
2006-05-15 18:00:00	NVDA	Stock	0.4452	0.446	0.4452	0.446	145260.0
2006-05-15 08:00:00	AMZN	Stock	1.625	1.625	1.625	1.625	4000.0
2006-05-15 09:00:00	AMZN	Stock	1.613	1.641	1.613	1.6185	10232480.0
2006-05-15 10:00:00	AMZN	Stock	1.618	1.6315	1.611	1.6215	12894820.0
2006-05-15 11:00:00	AMZN	Stock	1.621	1.6265	1.6195	1.625	9688680.0
2006-05-15 12:00:00	AMZN	Stock	1.6245	1.6255	1.6187	1.6235	5649760.0
2006-05-15 13:00:00	AMZN	Stock	1.6235	1.6245	1.6105	1.611	9789160.0
2006-05-15 14:00:00	AMZN	Stock	1.6115	1.622	1.611	1.616	13136720.0
2006-05-15 15:00:00	AMZN	Stock	1.616	1.6425	1.615	1.6375	21939280.0
2006-05-15 16:00:00	AMZN	Stock	1.6375	1.639	1.629	1.639	314560.0
2006-05-15 17:00:00	AMZN	Stock	1.633	1.6375	1.614	1.6375	58000.0
2006-05-15 18:00:00	AMZN	Stock	1.6388	1.6388	1.6388	1.6388	114440.0
2006-05-15 08:00:00	CL	Stock	30.0	30.0	29.6	29.6	400.0
2006-05-15 09:00:00	CL	Stock	29.55	29.635	29.425	29.455	363200.0
2006-05-15 10:00:00	CL	Stock	29.46	29.58	29.405	29.5	701400.0
2006-05-15 11:00:00	CL	Stock	29.5	29.6	29.485	29.565	523800.0

> showing 50 of 30,043 rows — these rows as CSV

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