PREVIEW / stock_1hour / 2007-02-07

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-02-07.parquet
  size:    650 KB
  rows:    31,015
  symbols: 2,517

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
2007-02-07 07:00:00	AAPL	Stock	3.0143	3.0143	3.0107	3.0107	8400.0
2007-02-07 08:00:00	AAPL	Stock	3.0129	3.0179	3.0046	3.0061	2474640.0
2007-02-07 09:00:00	AAPL	Stock	3.0071	3.0214	2.9839	2.9943	92193052.0
2007-02-07 10:00:00	AAPL	Stock	2.9936	3.0286	2.9864	3.0193	164353056.0
2007-02-07 11:00:00	AAPL	Stock	3.0193	3.0339	3.0146	3.0329	110317984.0
2007-02-07 12:00:00	AAPL	Stock	3.0325	3.0825	3.0318	3.0811	222295528.0
2007-02-07 13:00:00	AAPL	Stock	3.0814	3.085	3.0604	3.0643	131471564.0
2007-02-07 14:00:00	AAPL	Stock	3.0661	3.075	3.05	3.0582	159367236.0
2007-02-07 15:00:00	AAPL	Stock	3.0586	3.0771	3.0582	3.0768	144730012.0
2007-02-07 16:00:00	AAPL	Stock	3.0764	3.0804	3.0214	3.0804	24676316.0
2007-02-07 17:00:00	AAPL	Stock	3.0796	3.0904	3.0768	3.0893	5195820.0
2007-02-07 18:00:00	AAPL	Stock	3.0907	3.0982	3.0765	3.0946	1423324.0
2007-02-07 19:00:00	AAPL	Stock	3.0946	3.1018	3.0929	3.1	562884.0
2007-02-07 08:00:00	MSFT	Stock	29.55	29.65	29.5	29.63	26560.0
2007-02-07 09:00:00	MSFT	Stock	29.64	29.68	29.25	29.41	11166358.0
2007-02-07 10:00:00	MSFT	Stock	29.4	29.7	29.35	29.59	13322980.0
2007-02-07 11:00:00	MSFT	Stock	29.59	29.6	29.42	29.45	5445010.0
2007-02-07 12:00:00	MSFT	Stock	29.457	29.64	29.41	29.44	3845773.0
2007-02-07 13:00:00	MSFT	Stock	29.432	29.46	29.4	29.42	6795621.0
2007-02-07 14:00:00	MSFT	Stock	29.42	29.45	29.34	29.4	11175304.0
2007-02-07 15:00:00	MSFT	Stock	29.34	29.46	29.34	29.372	11383379.0
2007-02-07 16:00:00	MSFT	Stock	29.38	29.4	29.35	29.39	493199.0
2007-02-07 17:00:00	MSFT	Stock	29.39	29.4	29.39	29.39	9439.0
2007-02-07 18:00:00	MSFT	Stock	29.4	29.4	29.38	29.38	4610.0
2007-02-07 19:00:00	MSFT	Stock	29.39	29.43	29.39	29.43	1519.0
2007-02-07 07:00:00	NVDA	Stock	0.5625	0.5625	0.5625	0.5625	12000.0
2007-02-07 08:00:00	NVDA	Stock	0.5655	0.5667	0.5633	0.5648	786000.0
2007-02-07 09:00:00	NVDA	Stock	0.5648	0.5697	0.5598	0.568	109447200.0
2007-02-07 10:00:00	NVDA	Stock	0.568	0.5767	0.5658	0.5725	145299000.0
2007-02-07 11:00:00	NVDA	Stock	0.5725	0.5747	0.572	0.5733	70522920.0
2007-02-07 12:00:00	NVDA	Stock	0.5732	0.578	0.5695	0.5777	90117300.0
2007-02-07 13:00:00	NVDA	Stock	0.5777	0.5795	0.576	0.5767	81767640.0
2007-02-07 14:00:00	NVDA	Stock	0.5767	0.5773	0.5708	0.572	113359080.0
2007-02-07 15:00:00	NVDA	Stock	0.572	0.5818	0.572	0.5805	129195600.0
2007-02-07 16:00:00	NVDA	Stock	0.5803	0.5813	0.5785	0.5785	1049220.0
2007-02-07 17:00:00	NVDA	Stock	0.5785	0.5785	0.5773	0.5783	219000.0
2007-02-07 18:00:00	NVDA	Stock	0.5805	0.5805	0.5805	0.5805	15240.0
2007-02-07 19:00:00	NVDA	Stock	0.5783	0.58	0.5783	0.58	36000.0
2007-02-07 08:00:00	AMZN	Stock	1.932	1.9325	1.921	1.9325	45000.0
2007-02-07 09:00:00	AMZN	Stock	1.9325	1.9325	1.9185	1.9245	18988840.0
2007-02-07 10:00:00	AMZN	Stock	1.924	1.959	1.924	1.959	32561360.0
2007-02-07 11:00:00	AMZN	Stock	1.9585	1.976	1.9575	1.971	39165280.0
2007-02-07 12:00:00	AMZN	Stock	1.971	1.972	1.95	1.953	27151480.0
2007-02-07 13:00:00	AMZN	Stock	1.9525	1.96	1.9465	1.9465	19395720.0
2007-02-07 14:00:00	AMZN	Stock	1.9465	1.9675	1.938	1.945	31196180.0
2007-02-07 15:00:00	AMZN	Stock	1.9455	1.951	1.9395	1.949	36086260.0
2007-02-07 16:00:00	AMZN	Stock	1.9485	1.9525	1.9485	1.9525	952400.0
2007-02-07 17:00:00	AMZN	Stock	1.955	1.955	1.9515	1.9515	14000.0
2007-02-07 18:00:00	AMZN	Stock	1.9545	1.9575	1.949	1.9525	51980.0
2007-02-07 19:00:00	AMZN	Stock	1.9555	1.9555	1.9555	1.9555	10000.0

> showing 50 of 31,015 rows — these rows as CSV

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