PREVIEW / stock_1hour / 2011-09-28

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-28.parquet
  size:    917 KB
  rows:    44,061
  symbols: 3,483

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
2011-09-28 04:00:00	AAPL	Stock	14.2664	14.3929	14.2664	14.3214	44492.0
2011-09-28 05:00:00	AAPL	Stock	14.3357	14.3971	14.3336	14.3971	25200.0
2011-09-28 06:00:00	AAPL	Stock	14.3782	14.4157	14.3782	14.4104	91336.0
2011-09-28 07:00:00	AAPL	Stock	14.4107	14.4107	14.2786	14.2964	919968.0
2011-09-28 08:00:00	AAPL	Stock	14.2904	14.325	14.2282	14.2729	4013380.0
2011-09-28 09:00:00	AAPL	Stock	14.2689	14.4193	14.2028	14.3864	89919088.0
2011-09-28 10:00:00	AAPL	Stock	14.3857	14.3968	14.3214	14.362	86847292.0
2011-09-28 11:00:00	AAPL	Stock	14.3571	14.3821	14.2929	14.3693	46728108.0
2011-09-28 12:00:00	AAPL	Stock	14.3689	14.3796	14.2786	14.3514	37653980.0
2011-09-28 13:00:00	AAPL	Stock	14.3468	14.3493	14.2354	14.2611	35186592.0
2011-09-28 14:00:00	AAPL	Stock	14.2586	14.2896	14.2232	14.2582	38447640.0
2011-09-28 15:00:00	AAPL	Stock	14.2582	14.3393	14.1611	14.1757	77268884.0
2011-09-28 16:00:00	AAPL	Stock	14.1761	14.3082	14.1686	14.1789	9122876.0
2011-09-28 17:00:00	AAPL	Stock	14.1786	14.1786	14.1618	14.17	574252.0
2011-09-28 18:00:00	AAPL	Stock	14.1675	14.1789	14.1586	14.1779	238700.0
2011-09-28 19:00:00	AAPL	Stock	14.1661	14.1682	14.1429	14.1621	181944.0
2011-09-28 07:00:00	MSFT	Stock	25.76	25.76	25.76	25.76	200.0
2011-09-28 08:00:00	MSFT	Stock	25.76	25.86	25.73	25.8	18586.0
2011-09-28 09:00:00	MSFT	Stock	25.78	26.37	25.78	26.18	9030005.0
2011-09-28 10:00:00	MSFT	Stock	26.18	26.185	25.84	25.985	11540243.0
2011-09-28 11:00:00	MSFT	Stock	25.985	26.15	25.93	26.108	6146743.0
2011-09-28 12:00:00	MSFT	Stock	26.108	26.13	25.93	26.011	4478461.0
2011-09-28 13:00:00	MSFT	Stock	26.01	26.03	25.73	25.785	6510621.0
2011-09-28 14:00:00	MSFT	Stock	25.785	25.915	25.77	25.895	5704703.0
2011-09-28 15:00:00	MSFT	Stock	25.89	25.97	25.51	25.55	13228025.0
2011-09-28 16:00:00	MSFT	Stock	25.54	25.928	25.53	25.56	2780620.0
2011-09-28 17:00:00	MSFT	Stock	25.58	25.58	25.56	25.56	350.0
2011-09-28 18:00:00	MSFT	Stock	25.57	25.63	25.41	25.63	9586.0
2011-09-28 19:00:00	MSFT	Stock	25.63	25.67	25.63	25.67	5175.0
2011-09-28 07:00:00	NVDA	Stock	0.35	0.35	0.35	0.35	4000.0
2011-09-28 08:00:00	NVDA	Stock	0.3502	0.3542	0.3495	0.35	1570000.0
2011-09-28 09:00:00	NVDA	Stock	0.35	0.3555	0.346	0.3518	120636680.0
2011-09-28 10:00:00	NVDA	Stock	0.3518	0.3525	0.345	0.3455	177605800.0
2011-09-28 11:00:00	NVDA	Stock	0.3455	0.3465	0.3388	0.343	186649680.0
2011-09-28 12:00:00	NVDA	Stock	0.343	0.3433	0.3378	0.3385	118767880.0
2011-09-28 13:00:00	NVDA	Stock	0.3385	0.3388	0.3303	0.3305	162828080.0
2011-09-28 14:00:00	NVDA	Stock	0.3305	0.3358	0.33	0.335	123204320.0
2011-09-28 15:00:00	NVDA	Stock	0.335	0.3393	0.3335	0.3355	326999720.0
2011-09-28 16:00:00	NVDA	Stock	0.3356	0.3402	0.335	0.3355	9155480.0
2011-09-28 17:00:00	NVDA	Stock	0.3348	0.3348	0.3328	0.3328	142000.0
2011-09-28 18:00:00	NVDA	Stock	0.3333	0.3355	0.3325	0.3325	713400.0
2011-09-28 19:00:00	NVDA	Stock	0.3335	0.3342	0.333	0.3342	232000.0
2011-09-28 04:00:00	AMZN	Stock	11.2355	11.258	11.2355	11.258	6000.0
2011-09-28 05:00:00	AMZN	Stock	11.2935	11.2935	11.2935	11.2935	2000.0
2011-09-28 06:00:00	AMZN	Stock	11.31	11.342	11.31	11.342	8000.0
2011-09-28 07:00:00	AMZN	Stock	11.342	11.375	11.315	11.325	89780.0
2011-09-28 08:00:00	AMZN	Stock	11.353	11.358	11.275	11.3005	777840.0
2011-09-28 09:00:00	AMZN	Stock	11.3	11.715	11.28	11.561	60100420.0
2011-09-28 10:00:00	AMZN	Stock	11.565	11.625	11.397	11.5695	51044700.0
2011-09-28 11:00:00	AMZN	Stock	11.5695	11.745	11.466	11.74	45921280.0

> showing 50 of 44,061 rows — these rows as CSV

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