PREVIEW / stock_1hour / 2008-10-01

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-01.parquet
  size:    829 KB
  rows:    41,271
  symbols: 3,346

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
2008-10-01 05:00:00	AAPL	Stock	4.0714	4.0714	4.0714	4.0714	5600.0
2008-10-01 06:00:00	AAPL	Stock	4.0714	4.0714	4.0714	4.0714	2800.0
2008-10-01 07:00:00	AAPL	Stock	4.0539	4.0704	4.0354	4.0357	667100.0
2008-10-01 08:00:00	AAPL	Stock	4.0482	4.0496	3.9857	4.0032	3844540.0
2008-10-01 09:00:00	AAPL	Stock	4.0054	4.0157	3.9286	3.98	147470232.0
2008-10-01 10:00:00	AAPL	Stock	3.9811	3.9821	3.8414	3.8593	233246664.0
2008-10-01 11:00:00	AAPL	Stock	3.8589	3.9107	3.8354	3.8882	133282940.0
2008-10-01 12:00:00	AAPL	Stock	3.888	4.0129	3.8689	3.9868	174731536.0
2008-10-01 13:00:00	AAPL	Stock	3.9871	3.9961	3.8793	3.9629	206098564.0
2008-10-01 14:00:00	AAPL	Stock	3.9636	4.0004	3.9286	3.9404	158084696.0
2008-10-01 15:00:00	AAPL	Stock	3.9411	3.9454	3.8911	3.8971	187504240.0
2008-10-01 16:00:00	AAPL	Stock	3.9036	3.9429	3.8864	3.9125	29900136.0
2008-10-01 17:00:00	AAPL	Stock	3.9107	3.9325	3.9079	3.9107	646044.0
2008-10-01 18:00:00	AAPL	Stock	3.9179	3.9607	3.9179	3.9589	621880.0
2008-10-01 19:00:00	AAPL	Stock	3.9589	3.9589	3.9286	3.9464	385784.0
2008-10-01 06:00:00	MSFT	Stock	26.13	26.13	26.13	26.13	100.0
2008-10-01 08:00:00	MSFT	Stock	26.5	26.69	26.35	26.36	116562.0
2008-10-01 09:00:00	MSFT	Stock	26.37	26.87	26.25	26.73	8446037.0
2008-10-01 10:00:00	MSFT	Stock	26.73	26.85	26.28	26.71	13854721.0
2008-10-01 11:00:00	MSFT	Stock	26.72	26.74	26.54	26.72	7941904.0
2008-10-01 12:00:00	MSFT	Stock	26.71	26.99	26.64	26.91	9206569.0
2008-10-01 13:00:00	MSFT	Stock	26.9	26.92	26.49	26.57	12404579.0
2008-10-01 14:00:00	MSFT	Stock	26.57	26.87	26.5	26.65	9940649.0
2008-10-01 15:00:00	MSFT	Stock	26.655	26.69	26.41	26.47	14001052.0
2008-10-01 16:00:00	MSFT	Stock	26.48	26.744	26.47	26.48	11123599.0
2008-10-01 17:00:00	MSFT	Stock	26.55	26.651	26.228	26.55	25802.0
2008-10-01 18:00:00	MSFT	Stock	26.48	26.55	26.48	26.5	38824.0
2008-10-01 19:00:00	MSFT	Stock	26.49	26.68	26.49	26.55	23091.0
2008-10-01 08:00:00	NVDA	Stock	0.2685	0.2685	0.2625	0.267	84000.0
2008-10-01 09:00:00	NVDA	Stock	0.2638	0.2685	0.2625	0.2678	53718360.0
2008-10-01 10:00:00	NVDA	Stock	0.2675	0.2676	0.2558	0.2565	132833880.0
2008-10-01 11:00:00	NVDA	Stock	0.2568	0.2585	0.2555	0.2578	51683720.0
2008-10-01 12:00:00	NVDA	Stock	0.2578	0.2628	0.257	0.262	67776560.0
2008-10-01 13:00:00	NVDA	Stock	0.262	0.264	0.2592	0.2604	83745360.0
2008-10-01 14:00:00	NVDA	Stock	0.2605	0.2635	0.2588	0.2612	64610840.0
2008-10-01 15:00:00	NVDA	Stock	0.2612	0.2615	0.2588	0.2605	87368760.0
2008-10-01 16:00:00	NVDA	Stock	0.2603	0.2615	0.2598	0.2603	13536560.0
2008-10-01 18:00:00	NVDA	Stock	0.26	0.2603	0.26	0.2603	32000.0
2008-10-01 19:00:00	NVDA	Stock	0.2612	0.2625	0.2612	0.2625	51880.0
2008-10-01 07:00:00	AMZN	Stock	3.575	3.6125	3.575	3.59	54000.0
2008-10-01 08:00:00	AMZN	Stock	3.6	3.6075	3.575	3.5955	249080.0
2008-10-01 09:00:00	AMZN	Stock	3.5975	3.6075	3.502	3.5295	23168700.0
2008-10-01 10:00:00	AMZN	Stock	3.5295	3.577	3.4265	3.4595	39895680.0
2008-10-01 11:00:00	AMZN	Stock	3.4595	3.477	3.425	3.4485	22644260.0
2008-10-01 12:00:00	AMZN	Stock	3.4485	3.5235	3.4205	3.498	22455780.0
2008-10-01 13:00:00	AMZN	Stock	3.495	3.5105	3.4335	3.458	33413080.0
2008-10-01 14:00:00	AMZN	Stock	3.4585	3.501	3.44	3.469	19764800.0
2008-10-01 15:00:00	AMZN	Stock	3.4685	3.4945	3.4355	3.4725	23610300.0
2008-10-01 16:00:00	AMZN	Stock	3.479	3.4905	3.4732	3.4905	5092260.0
2008-10-01 17:00:00	AMZN	Stock	3.4753	3.491	3.4753	3.4905	277940.0

> showing 50 of 41,271 rows — these rows as CSV

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