PREVIEW / stock_1hour / 2009-05-29

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-05-29.parquet
  size:    874 KB
  rows:    42,475
  symbols: 3,375

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-05-29 06:00:00	AAPL	Stock	4.8782	4.8782	4.8782	4.8782	2800.0
2009-05-29 07:00:00	AAPL	Stock	4.8743	4.875	4.8729	4.875	52640.0
2009-05-29 08:00:00	AAPL	Stock	4.8525	4.8679	4.8414	4.8414	1302420.0
2009-05-29 09:00:00	AAPL	Stock	4.8446	4.8582	4.7832	4.8125	83028288.0
2009-05-29 10:00:00	AAPL	Stock	4.8125	4.8411	4.8	4.8296	76878172.0
2009-05-29 11:00:00	AAPL	Stock	4.8296	4.8343	4.7804	4.7982	57122212.0
2009-05-29 12:00:00	AAPL	Stock	4.7982	4.825	4.7975	4.8039	34098848.0
2009-05-29 13:00:00	AAPL	Stock	4.8043	4.8225	4.8036	4.8186	24223444.0
2009-05-29 14:00:00	AAPL	Stock	4.8189	4.8207	4.7857	4.7968	31698492.0
2009-05-29 15:00:00	AAPL	Stock	4.7975	4.8536	4.7911	4.8507	89400080.0
2009-05-29 16:00:00	AAPL	Stock	4.8511	4.8925	4.8144	4.8507	40461092.0
2009-05-29 17:00:00	AAPL	Stock	4.8507	4.8532	4.8457	4.8532	683620.0
2009-05-29 18:00:00	AAPL	Stock	4.8518	4.8543	4.8457	4.8507	623196.0
2009-05-29 19:00:00	AAPL	Stock	4.85	4.8532	4.8396	4.8464	91980.0
2009-05-29 05:00:00	MSFT	Stock	20.6	20.6	20.6	20.6	100.0
2009-05-29 06:00:00	MSFT	Stock	20.73	20.73	20.62	20.62	2000.0
2009-05-29 07:00:00	MSFT	Stock	20.62	20.65	20.62	20.65	600.0
2009-05-29 08:00:00	MSFT	Stock	20.62	20.69	20.58	20.65	40140.0
2009-05-29 09:00:00	MSFT	Stock	20.65	20.67	20.3	20.38	5658206.0
2009-05-29 10:00:00	MSFT	Stock	20.388	20.6	20.34	20.518	4653178.0
2009-05-29 11:00:00	MSFT	Stock	20.51	20.55	20.37	20.388	3708253.0
2009-05-29 12:00:00	MSFT	Stock	20.38	20.45	20.305	20.355	2254299.0
2009-05-29 13:00:00	MSFT	Stock	20.36	20.47	20.35	20.41	2472004.0
2009-05-29 14:00:00	MSFT	Stock	20.41	20.48	20.36	20.42	3331839.0
2009-05-29 15:00:00	MSFT	Stock	20.43	20.94	20.39	20.84	14833587.0
2009-05-29 16:00:00	MSFT	Stock	20.9	20.98	20.408	20.898	7151541.0
2009-05-29 17:00:00	MSFT	Stock	20.83	20.9	20.406	20.85	272023.0
2009-05-29 18:00:00	MSFT	Stock	20.79	20.89	20.76	20.79	36125.0
2009-05-29 19:00:00	MSFT	Stock	20.8	20.85	20.8	20.85	4201.0
2009-05-29 08:00:00	NVDA	Stock	0.2748	0.2748	0.26	0.26	148000.0
2009-05-29 09:00:00	NVDA	Stock	0.263	0.2635	0.2578	0.262	127179080.0
2009-05-29 10:00:00	NVDA	Stock	0.2623	0.2628	0.2585	0.2592	113154480.0
2009-05-29 11:00:00	NVDA	Stock	0.2592	0.2598	0.2523	0.2523	138992880.0
2009-05-29 12:00:00	NVDA	Stock	0.2524	0.2565	0.2518	0.2548	93568840.0
2009-05-29 13:00:00	NVDA	Stock	0.255	0.2585	0.2547	0.2583	143637760.0
2009-05-29 14:00:00	NVDA	Stock	0.2583	0.2588	0.2558	0.2565	44205840.0
2009-05-29 15:00:00	NVDA	Stock	0.2565	0.2608	0.2565	0.2605	119523880.0
2009-05-29 16:00:00	NVDA	Stock	0.2603	0.2612	0.2588	0.2606	43715640.0
2009-05-29 17:00:00	NVDA	Stock	0.2608	0.2608	0.2606	0.2608	1305280.0
2009-05-29 19:00:00	NVDA	Stock	0.2592	0.2592	0.259	0.2592	176000.0
2009-05-29 07:00:00	AMZN	Stock	3.9125	3.9125	3.9125	3.9125	10000.0
2009-05-29 09:00:00	AMZN	Stock	3.8855	3.891	3.82	3.867	15120180.0
2009-05-29 10:00:00	AMZN	Stock	3.866	3.8995	3.8555	3.866	10428060.0
2009-05-29 11:00:00	AMZN	Stock	3.8655	3.87	3.8205	3.8266	16471980.0
2009-05-29 12:00:00	AMZN	Stock	3.826	3.859	3.826	3.8475	8875880.0
2009-05-29 13:00:00	AMZN	Stock	3.849	3.8705	3.8435	3.857	6002580.0
2009-05-29 14:00:00	AMZN	Stock	3.857	3.8745	3.83	3.845	13914760.0
2009-05-29 15:00:00	AMZN	Stock	3.845	3.9	3.8385	3.893	20984580.0
2009-05-29 16:00:00	AMZN	Stock	3.897	3.91	3.8393	3.901	2697980.0
2009-05-29 17:00:00	AMZN	Stock	3.8995	3.9014	3.893	3.8995	180800.0

> showing 50 of 42,475 rows — these rows as CSV

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