PREVIEW / stock_1hour / 2011-07-27

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-07-27.parquet
  size:    973 KB
  rows:    46,486
  symbols: 3,544

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-07-27 05:00:00	AAPL	Stock	14.4214	14.4214	14.4214	14.4214	2800.0
2011-07-27 06:00:00	AAPL	Stock	14.4018	14.4018	14.4018	14.4018	14000.0
2011-07-27 07:00:00	AAPL	Stock	14.4011	14.4229	14.3714	14.3714	287924.0
2011-07-27 08:00:00	AAPL	Stock	14.3714	14.375	14.2857	14.3029	3908408.0
2011-07-27 09:00:00	AAPL	Stock	14.2982	14.38	14.2071	14.2336	106030512.0
2011-07-27 10:00:00	AAPL	Stock	14.2375	14.2629	14.0268	14.2025	194077604.0
2011-07-27 11:00:00	AAPL	Stock	14.2018	14.2107	14.1272	14.1411	66252368.0
2011-07-27 12:00:00	AAPL	Stock	14.1411	14.1575	14.1	14.1077	53000864.0
2011-07-27 13:00:00	AAPL	Stock	14.1075	14.1496	14.0825	14.1319	36212008.0
2011-07-27 14:00:00	AAPL	Stock	14.1314	14.1357	14.0468	14.0875	56875560.0
2011-07-27 15:00:00	AAPL	Stock	14.0857	14.1071	14.0054	14.0207	114367792.0
2011-07-27 16:00:00	AAPL	Stock	14.0204	14.1954	14.0018	14.0079	22073072.0
2011-07-27 17:00:00	AAPL	Stock	14.0089	14.0204	13.975	13.975	1286936.0
2011-07-27 18:00:00	AAPL	Stock	13.9786	14.0211	13.9643	13.9911	817348.0
2011-07-27 19:00:00	AAPL	Stock	13.9821	13.9982	13.9686	13.975	653912.0
2011-07-27 07:00:00	MSFT	Stock	27.96	27.99	27.92	27.99	1500.0
2011-07-27 08:00:00	MSFT	Stock	27.95	27.98	27.82	27.88	32154.0
2011-07-27 09:00:00	MSFT	Stock	27.85	27.985	27.51	27.9	7532721.0
2011-07-27 10:00:00	MSFT	Stock	27.9	27.905	27.57	27.64	14270701.0
2011-07-27 11:00:00	MSFT	Stock	27.645	27.85	27.61	27.66	7870617.0
2011-07-27 12:00:00	MSFT	Stock	27.665	27.705	27.58	27.605	5938897.0
2011-07-27 13:00:00	MSFT	Stock	27.61	27.71	27.56	27.66	5040801.0
2011-07-27 14:00:00	MSFT	Stock	27.665	27.67	27.39	27.43	10093292.0
2011-07-27 15:00:00	MSFT	Stock	27.425	27.45	27.2	27.34	15863180.0
2011-07-27 16:00:00	MSFT	Stock	27.33	28.07	27.28	27.35	3342932.0
2011-07-27 17:00:00	MSFT	Stock	27.33	27.35	27.29	27.3	142052.0
2011-07-27 18:00:00	MSFT	Stock	27.28	27.36	27.28	27.36	53914.0
2011-07-27 19:00:00	MSFT	Stock	27.36	27.37	27.25	27.25	3475.0
2011-07-27 08:00:00	NVDA	Stock	0.3562	0.36	0.3562	0.3588	100160.0
2011-07-27 09:00:00	NVDA	Stock	0.3585	0.3585	0.3502	0.3515	63246440.0
2011-07-27 10:00:00	NVDA	Stock	0.3515	0.3525	0.3455	0.3521	151241200.0
2011-07-27 11:00:00	NVDA	Stock	0.3522	0.353	0.3498	0.3508	75588480.0
2011-07-27 12:00:00	NVDA	Stock	0.3505	0.3528	0.3505	0.3513	56486200.0
2011-07-27 13:00:00	NVDA	Stock	0.3513	0.3518	0.3494	0.3494	38681800.0
2011-07-27 14:00:00	NVDA	Stock	0.3495	0.3498	0.3458	0.3482	72677440.0
2011-07-27 15:00:00	NVDA	Stock	0.3482	0.3488	0.3455	0.3465	169810440.0
2011-07-27 16:00:00	NVDA	Stock	0.3475	0.3548	0.3453	0.3458	9380440.0
2011-07-27 17:00:00	NVDA	Stock	0.3465	0.3465	0.345	0.345	386480.0
2011-07-27 18:00:00	NVDA	Stock	0.345	0.345	0.345	0.345	24000.0
2011-07-27 19:00:00	NVDA	Stock	0.346	0.3462	0.3445	0.345	247000.0
2011-07-27 04:00:00	AMZN	Stock	11.335	11.335	11.2945	11.3055	31000.0
2011-07-27 05:00:00	AMZN	Stock	11.315	11.3515	11.315	11.328	46100.0
2011-07-27 06:00:00	AMZN	Stock	11.333	11.333	11.325	11.325	15780.0
2011-07-27 07:00:00	AMZN	Stock	11.35	11.4625	11.35	11.3665	634960.0
2011-07-27 08:00:00	AMZN	Stock	11.367	11.375	11.2575	11.2725	2142520.0
2011-07-27 09:00:00	AMZN	Stock	11.272	11.36	11.113	11.3145	69464580.0
2011-07-27 10:00:00	AMZN	Stock	11.3158	11.319	11.172	11.239	49231600.0
2011-07-27 11:00:00	AMZN	Stock	11.2398	11.245	11.19	11.2365	16208600.0
2011-07-27 12:00:00	AMZN	Stock	11.2335	11.3275	11.2155	11.2837	23428380.0
2011-07-27 13:00:00	AMZN	Stock	11.2853	11.2925	11.1185	11.154	20295320.0

> showing 50 of 46,486 rows — these rows as CSV

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