PREVIEW / stock_1hour / 2006-10-30

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-30.parquet
  size:    633 KB
  rows:    30,402
  symbols: 2,427

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-30 04:00:00	AAPL	Stock	2.8643	2.8643	2.8643	2.8643	2800.0
2006-10-30 07:00:00	AAPL	Stock	2.8643	2.8643	2.8643	2.8643	2800.0
2006-10-30 08:00:00	AAPL	Stock	2.8643	2.8696	2.8607	2.8643	847588.0
2006-10-30 09:00:00	AAPL	Stock	2.8657	2.8707	2.8393	2.8561	102354280.0
2006-10-30 10:00:00	AAPL	Stock	2.8561	2.8661	2.8482	2.8643	90255200.0
2006-10-30 11:00:00	AAPL	Stock	2.8643	2.8854	2.8607	2.8675	85032920.0
2006-10-30 12:00:00	AAPL	Stock	2.8679	2.8711	2.8586	2.8689	33704692.0
2006-10-30 13:00:00	AAPL	Stock	2.8689	2.8893	2.8668	2.8864	47602632.0
2006-10-30 14:00:00	AAPL	Stock	2.8864	2.8875	2.8771	2.8818	33299924.0
2006-10-30 15:00:00	AAPL	Stock	2.8814	2.8854	2.8646	2.8714	55776056.0
2006-10-30 16:00:00	AAPL	Stock	2.8721	2.8743	2.8718	2.8739	18697952.0
2006-10-30 17:00:00	AAPL	Stock	2.8739	2.8771	2.8725	2.8764	151844.0
2006-10-30 18:00:00	AAPL	Stock	2.8732	2.8768	2.8721	2.8725	34356.0
2006-10-30 19:00:00	AAPL	Stock	2.8725	2.8779	2.8725	2.8779	8400.0
2006-10-30 07:00:00	MSFT	Stock	28.3	28.3	28.3	28.3	100.0
2006-10-30 08:00:00	MSFT	Stock	28.4	28.4	28.25	28.25	11531.0
2006-10-30 09:00:00	MSFT	Stock	28.26	28.49	28.24	28.39	4835810.0
2006-10-30 10:00:00	MSFT	Stock	28.39	28.55	28.39	28.539	5196628.0
2006-10-30 11:00:00	MSFT	Stock	28.53	28.69	28.52	28.68	8767306.0
2006-10-30 12:00:00	MSFT	Stock	28.68	28.69	28.62	28.66	3969007.0
2006-10-30 13:00:00	MSFT	Stock	28.66	28.79	28.64	28.77	6922926.0
2006-10-30 14:00:00	MSFT	Stock	28.78	28.84	28.69	28.7	7778085.0
2006-10-30 15:00:00	MSFT	Stock	28.7	28.74	28.5	28.57	7527225.0
2006-10-30 16:00:00	MSFT	Stock	28.58	28.58	28.52	28.53	366620.0
2006-10-30 17:00:00	MSFT	Stock	28.57	28.6	28.57	28.58	11252.0
2006-10-30 18:00:00	MSFT	Stock	28.53	28.6	28.53	28.6	4266.0
2006-10-30 19:00:00	MSFT	Stock	28.6	28.6	28.6	28.6	1000.0
2006-10-30 08:00:00	NVDA	Stock	0.54	0.54	0.54	0.54	6000.0
2006-10-30 09:00:00	NVDA	Stock	0.5383	0.5497	0.5375	0.5403	55095000.0
2006-10-30 10:00:00	NVDA	Stock	0.5402	0.5473	0.5393	0.5457	65730360.0
2006-10-30 11:00:00	NVDA	Stock	0.5457	0.5525	0.5452	0.5482	60920100.0
2006-10-30 12:00:00	NVDA	Stock	0.5482	0.5482	0.542	0.5438	37173540.0
2006-10-30 13:00:00	NVDA	Stock	0.5438	0.5515	0.5432	0.5508	44019660.0
2006-10-30 14:00:00	NVDA	Stock	0.5508	0.5558	0.5497	0.5512	67642500.0
2006-10-30 15:00:00	NVDA	Stock	0.5508	0.5525	0.5443	0.5455	69027600.0
2006-10-30 16:00:00	NVDA	Stock	0.5462	0.5463	0.5455	0.5455	1099200.0
2006-10-30 17:00:00	NVDA	Stock	0.5465	0.5467	0.5465	0.5467	84000.0
2006-10-30 18:00:00	NVDA	Stock	0.5467	0.5482	0.5467	0.5482	36000.0
2006-10-30 08:00:00	AMZN	Stock	1.9125	1.9125	1.899	1.9045	288660.0
2006-10-30 09:00:00	AMZN	Stock	1.902	1.91	1.887	1.888	21254060.0
2006-10-30 10:00:00	AMZN	Stock	1.8875	1.91	1.884	1.9046	23992860.0
2006-10-30 11:00:00	AMZN	Stock	1.9049	1.917	1.9005	1.904	18842980.0
2006-10-30 12:00:00	AMZN	Stock	1.9035	1.915	1.8916	1.8945	16239240.0
2006-10-30 13:00:00	AMZN	Stock	1.8945	1.916	1.894	1.916	11499020.0
2006-10-30 14:00:00	AMZN	Stock	1.9165	1.9165	1.9055	1.9091	13879540.0
2006-10-30 15:00:00	AMZN	Stock	1.909	1.9145	1.9	1.906	28707640.0
2006-10-30 16:00:00	AMZN	Stock	1.906	1.9085	1.906	1.9075	672220.0
2006-10-30 18:00:00	AMZN	Stock	1.905	1.905	1.905	1.905	6940.0
2006-10-30 09:00:00	CL	Stock	31.61	31.835	31.585	31.675	345000.0
2006-10-30 10:00:00	CL	Stock	31.68	31.715	31.615	31.71	513200.0

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

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