PREVIEW / stock_1hour / 2009-07-09

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-07-09.parquet
  size:    817 KB
  rows:    40,101
  symbols: 3,328

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
2009-07-09 07:00:00	AAPL	Stock	4.9286	4.9318	4.9286	4.9286	15400.0
2009-07-09 08:00:00	AAPL	Stock	4.9089	4.9464	4.9089	4.9404	1722840.0
2009-07-09 09:00:00	AAPL	Stock	4.9446	4.9446	4.8679	4.8979	78878212.0
2009-07-09 10:00:00	AAPL	Stock	4.8968	4.9071	4.8625	4.8804	65476656.0
2009-07-09 11:00:00	AAPL	Stock	4.8804	4.905	4.8679	4.8939	38489612.0
2009-07-09 12:00:00	AAPL	Stock	4.8939	4.9036	4.8775	4.8982	28518616.0
2009-07-09 13:00:00	AAPL	Stock	4.8982	4.9096	4.8825	4.8949	34482700.0
2009-07-09 14:00:00	AAPL	Stock	4.8954	4.9046	4.8871	4.8957	30818228.0
2009-07-09 15:00:00	AAPL	Stock	4.8946	4.8954	4.8546	4.8686	54737732.0
2009-07-09 16:00:00	AAPL	Stock	4.8679	4.8893	4.8546	4.8682	8368388.0
2009-07-09 17:00:00	AAPL	Stock	4.87	4.87	4.8679	4.8696	35000.0
2009-07-09 18:00:00	AAPL	Stock	4.8679	4.8707	4.8679	4.87	221620.0
2009-07-09 19:00:00	AAPL	Stock	4.8707	4.8707	4.8682	4.8707	62552.0
2009-07-09 08:00:00	MSFT	Stock	22.52	22.75	22.43	22.75	82111.0
2009-07-09 09:00:00	MSFT	Stock	22.74	22.81	22.535	22.55	7125197.0
2009-07-09 10:00:00	MSFT	Stock	22.54	22.605	22.45	22.577	7175835.0
2009-07-09 11:00:00	MSFT	Stock	22.58	22.66	22.45	22.541	6220826.0
2009-07-09 12:00:00	MSFT	Stock	22.54	22.57	22.43	22.48	3481279.0
2009-07-09 13:00:00	MSFT	Stock	22.47	22.58	22.41	22.438	4197720.0
2009-07-09 14:00:00	MSFT	Stock	22.43	22.59	22.41	22.54	6971115.0
2009-07-09 15:00:00	MSFT	Stock	22.545	22.55	22.37	22.44	8645407.0
2009-07-09 16:00:00	MSFT	Stock	22.44	22.556	22.39	22.4	2144685.0
2009-07-09 17:00:00	MSFT	Stock	22.39	22.39	22.3	22.34	34636.0
2009-07-09 18:00:00	MSFT	Stock	22.36	22.44	22.33	22.34	11463.0
2009-07-09 19:00:00	MSFT	Stock	22.35	22.36	22.34	22.34	4829.0
2009-07-09 08:00:00	NVDA	Stock	0.255	0.2588	0.255	0.2585	318000.0
2009-07-09 09:00:00	NVDA	Stock	0.2572	0.2615	0.2563	0.2598	137841920.0
2009-07-09 10:00:00	NVDA	Stock	0.2598	0.2616	0.2578	0.2583	142969920.0
2009-07-09 11:00:00	NVDA	Stock	0.2585	0.261	0.2563	0.26	122026680.0
2009-07-09 12:00:00	NVDA	Stock	0.2601	0.2618	0.26	0.2612	55834320.0
2009-07-09 13:00:00	NVDA	Stock	0.2612	0.2625	0.26	0.2612	65389480.0
2009-07-09 14:00:00	NVDA	Stock	0.2612	0.2612	0.2595	0.2603	47977880.0
2009-07-09 15:00:00	NVDA	Stock	0.2601	0.2608	0.2578	0.2578	130093600.0
2009-07-09 16:00:00	NVDA	Stock	0.2583	0.2594	0.2575	0.2583	9805360.0
2009-07-09 19:00:00	NVDA	Stock	0.2575	0.2575	0.2575	0.2575	9000.0
2009-07-09 08:00:00	AMZN	Stock	3.895	3.945	3.895	3.925	186500.0
2009-07-09 09:00:00	AMZN	Stock	3.9175	3.932	3.841	3.8705	17939120.0
2009-07-09 10:00:00	AMZN	Stock	3.8708	3.9075	3.86	3.8905	19829300.0
2009-07-09 11:00:00	AMZN	Stock	3.891	3.927	3.878	3.906	17085940.0
2009-07-09 12:00:00	AMZN	Stock	3.9055	3.913	3.894	3.907	11151000.0
2009-07-09 13:00:00	AMZN	Stock	3.9075	3.916	3.873	3.875	12416380.0
2009-07-09 14:00:00	AMZN	Stock	3.874	3.9265	3.873	3.916	17469340.0
2009-07-09 15:00:00	AMZN	Stock	3.916	3.9265	3.8962	3.905	27265580.0
2009-07-09 16:00:00	AMZN	Stock	3.905	3.905	3.899	3.905	1309720.0
2009-07-09 19:00:00	AMZN	Stock	3.914	3.914	3.914	3.914	2000.0
2009-07-09 07:00:00	TLT	Stock	95.7	95.7	95.64	95.64	25500.0
2009-07-09 08:00:00	TLT	Stock	95.67	95.95	95.31	95.4	355311.0
2009-07-09 09:00:00	TLT	Stock	95.42	95.65	95.18	95.39	619584.0
2009-07-09 10:00:00	TLT	Stock	95.39	95.73	95.25	95.4	709868.0
2009-07-09 11:00:00	TLT	Stock	95.41	95.55	95.289	95.35	744290.0

> showing 50 of 40,101 rows — these rows as CSV

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