PREVIEW / stock_1hour / 2006-10-18

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-18.parquet
  size:    618 KB
  rows:    29,480
  symbols: 2,406

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-10-18 07:00:00	AAPL	Stock	2.6539	2.6539	2.6361	2.6457	89320.0
2006-10-18 08:00:00	AAPL	Stock	2.6475	2.675	2.6443	2.6714	4315164.0
2006-10-18 09:00:00	AAPL	Stock	2.6714	2.6875	2.655	2.6736	119547092.0
2006-10-18 10:00:00	AAPL	Stock	2.6736	2.6761	2.6504	2.6568	107682624.0
2006-10-18 11:00:00	AAPL	Stock	2.6568	2.6614	2.6396	2.6561	104731116.0
2006-10-18 12:00:00	AAPL	Stock	2.6564	2.6789	2.65	2.6736	97826512.0
2006-10-18 13:00:00	AAPL	Stock	2.6739	2.6918	2.6668	2.68	100518236.0
2006-10-18 14:00:00	AAPL	Stock	2.6804	2.6893	2.6725	2.6771	105248304.0
2006-10-18 15:00:00	AAPL	Stock	2.6786	2.6825	2.6607	2.6636	147323848.0
2006-10-18 16:00:00	AAPL	Stock	2.6632	2.8536	2.6536	2.8246	253127252.0
2006-10-18 17:00:00	AAPL	Stock	2.825	2.8286	2.7536	2.7643	82733560.0
2006-10-18 18:00:00	AAPL	Stock	2.7643	2.7875	2.7639	2.7807	11444076.0
2006-10-18 19:00:00	AAPL	Stock	2.7811	2.7854	2.7768	2.7814	1205988.0
2006-10-18 08:00:00	MSFT	Stock	28.5	28.59	28.45	28.56	29181.0
2006-10-18 09:00:00	MSFT	Stock	28.6	28.7	28.48	28.6	6930291.0
2006-10-18 10:00:00	MSFT	Stock	28.6	28.65	28.4	28.43	6841735.0
2006-10-18 11:00:00	MSFT	Stock	28.44	28.6	28.35	28.478	5648653.0
2006-10-18 12:00:00	MSFT	Stock	28.48	28.5	28.36	28.37	2798879.0
2006-10-18 13:00:00	MSFT	Stock	28.37	28.39	28.26	28.36	4370955.0
2006-10-18 14:00:00	MSFT	Stock	28.36	28.493	28.35	28.47	4789463.0
2006-10-18 15:00:00	MSFT	Stock	28.47	28.52	28.37	28.52	6804390.0
2006-10-18 16:00:00	MSFT	Stock	28.5	28.54	28.48	28.54	169209.0
2006-10-18 17:00:00	MSFT	Stock	28.51	28.54	28.5	28.51	13421.0
2006-10-18 18:00:00	MSFT	Stock	28.51	28.52	28.49	28.49	33706.0
2006-10-18 19:00:00	MSFT	Stock	28.49	28.49	28.48	28.48	866.0
2006-10-18 08:00:00	NVDA	Stock	0.5448	0.5458	0.5448	0.5458	163500.0
2006-10-18 09:00:00	NVDA	Stock	0.5438	0.5542	0.5438	0.5465	104995380.0
2006-10-18 10:00:00	NVDA	Stock	0.5465	0.5493	0.5275	0.5342	243858780.0
2006-10-18 11:00:00	NVDA	Stock	0.5342	0.5448	0.5333	0.5375	103513680.0
2006-10-18 12:00:00	NVDA	Stock	0.5375	0.5387	0.5342	0.5343	61380840.0
2006-10-18 13:00:00	NVDA	Stock	0.5343	0.5343	0.5275	0.5297	74697840.0
2006-10-18 14:00:00	NVDA	Stock	0.5298	0.5302	0.5253	0.5293	100131960.0
2006-10-18 15:00:00	NVDA	Stock	0.5292	0.53	0.5222	0.5268	102275280.0
2006-10-18 16:00:00	NVDA	Stock	0.5268	0.5292	0.525	0.525	2599380.0
2006-10-18 17:00:00	NVDA	Stock	0.5247	0.5247	0.5245	0.5247	219000.0
2006-10-18 18:00:00	NVDA	Stock	0.527	0.5275	0.527	0.5275	105000.0
2006-10-18 19:00:00	NVDA	Stock	0.5292	0.5292	0.5292	0.5292	41700.0
2006-10-18 08:00:00	AMZN	Stock	1.62	1.62	1.61	1.61	12000.0
2006-10-18 09:00:00	AMZN	Stock	1.6255	1.639	1.619	1.63	11640220.0
2006-10-18 10:00:00	AMZN	Stock	1.6295	1.63	1.616	1.627	15579100.0
2006-10-18 11:00:00	AMZN	Stock	1.627	1.632	1.62	1.631	10872180.0
2006-10-18 12:00:00	AMZN	Stock	1.6312	1.6345	1.6195	1.622	9662540.0
2006-10-18 13:00:00	AMZN	Stock	1.6225	1.6235	1.6	1.6145	22323280.0
2006-10-18 14:00:00	AMZN	Stock	1.615	1.622	1.6075	1.6145	13203900.0
2006-10-18 15:00:00	AMZN	Stock	1.614	1.6155	1.6055	1.6155	21339140.0
2006-10-18 16:00:00	AMZN	Stock	1.6145	1.633	1.604	1.625	453080.0
2006-10-18 17:00:00	AMZN	Stock	1.6225	1.625	1.6125	1.6125	81000.0
2006-10-18 08:00:00	CL	Stock	29.895	29.895	29.895	29.895	32800.0
2006-10-18 09:00:00	CL	Stock	30.0	30.17	29.97	30.145	566000.0
2006-10-18 10:00:00	CL	Stock	30.15	30.305	30.145	30.265	1246400.0

> showing 50 of 29,480 rows — these rows as CSV

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