PREVIEW / stock_1hour / 2012-06-07

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-07.parquet
  size:    940 KB
  rows:    44,563
  symbols: 3,523

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
2012-06-07 04:00:00	AAPL	Stock	20.445	20.445	20.4286	20.4286	8400.0
2012-06-07 05:00:00	AAPL	Stock	20.4857	20.5157	20.4643	20.5157	25200.0
2012-06-07 06:00:00	AAPL	Stock	20.475	20.4786	20.4643	20.4786	18200.0
2012-06-07 07:00:00	AAPL	Stock	20.4821	20.6143	20.4736	20.5982	877436.0
2012-06-07 08:00:00	AAPL	Stock	20.5964	20.6107	20.5575	20.5775	2376836.0
2012-06-07 09:00:00	AAPL	Stock	20.5732	20.625	20.5014	20.5821	56823088.0
2012-06-07 10:00:00	AAPL	Stock	20.5798	20.5886	20.375	20.4382	88037516.0
2012-06-07 11:00:00	AAPL	Stock	20.4379	20.5307	20.4286	20.4857	44845668.0
2012-06-07 12:00:00	AAPL	Stock	20.4825	20.5286	20.45	20.5161	28807940.0
2012-06-07 13:00:00	AAPL	Stock	20.5175	20.5893	20.4946	20.5043	44082864.0
2012-06-07 14:00:00	AAPL	Stock	20.5029	20.5493	20.4946	20.5411	24519516.0
2012-06-07 15:00:00	AAPL	Stock	20.5407	20.5446	20.3754	20.4193	71774108.0
2012-06-07 16:00:00	AAPL	Stock	20.4182	20.4999	20.4145	20.4667	9316468.0
2012-06-07 17:00:00	AAPL	Stock	20.4667	20.4667	20.4375	20.4393	323680.0
2012-06-07 18:00:00	AAPL	Stock	20.4407	20.4461	20.4343	20.4364	130116.0
2012-06-07 19:00:00	AAPL	Stock	20.435	20.4418	20.4343	20.4393	82068.0
2012-06-07 07:00:00	MSFT	Stock	29.43	29.53	29.26	29.51	6825.0
2012-06-07 08:00:00	MSFT	Stock	29.46	29.54	29.43	29.45	15065.0
2012-06-07 09:00:00	MSFT	Stock	29.45	29.7	29.36	29.39	5440498.0
2012-06-07 10:00:00	MSFT	Stock	29.38	29.455	29.22	29.301	6857963.0
2012-06-07 11:00:00	MSFT	Stock	29.31	29.45	29.29	29.39	3456744.0
2012-06-07 12:00:00	MSFT	Stock	29.385	29.46	29.335	29.403	3001924.0
2012-06-07 13:00:00	MSFT	Stock	29.401	29.47	29.3	29.315	3938011.0
2012-06-07 14:00:00	MSFT	Stock	29.31	29.35	29.3	29.324	3323758.0
2012-06-07 15:00:00	MSFT	Stock	29.325	29.36	29.17	29.23	7714446.0
2012-06-07 16:00:00	MSFT	Stock	29.22	29.35	29.2	29.28	2919816.0
2012-06-07 17:00:00	MSFT	Stock	29.28	29.31	29.21	29.3	11065.0
2012-06-07 18:00:00	MSFT	Stock	29.27	29.28	29.27	29.28	600.0
2012-06-07 19:00:00	MSFT	Stock	29.3	29.3	29.26	29.26	1700.0
2012-06-07 08:00:00	NVDA	Stock	0.3125	0.315	0.3125	0.315	112000.0
2012-06-07 09:00:00	NVDA	Stock	0.3145	0.316	0.3105	0.311	52440920.0
2012-06-07 10:00:00	NVDA	Stock	0.3108	0.3113	0.3025	0.3039	101391800.0
2012-06-07 11:00:00	NVDA	Stock	0.3038	0.307	0.3035	0.3052	37590440.0
2012-06-07 12:00:00	NVDA	Stock	0.3051	0.3068	0.3045	0.3054	60825480.0
2012-06-07 13:00:00	NVDA	Stock	0.3054	0.3059	0.3028	0.303	37724920.0
2012-06-07 14:00:00	NVDA	Stock	0.3032	0.3041	0.3022	0.3022	43726680.0
2012-06-07 15:00:00	NVDA	Stock	0.3022	0.3025	0.297	0.2975	151932040.0
2012-06-07 16:00:00	NVDA	Stock	0.298	0.301	0.2972	0.2972	16521760.0
2012-06-07 17:00:00	NVDA	Stock	0.2995	0.2995	0.298	0.298	120000.0
2012-06-07 18:00:00	NVDA	Stock	0.2982	0.2995	0.2982	0.2995	36680.0
2012-06-07 19:00:00	NVDA	Stock	0.2995	0.2995	0.2988	0.2988	68400.0
2012-06-07 06:00:00	AMZN	Stock	10.9445	10.9445	10.9445	10.9445	2000.0
2012-06-07 07:00:00	AMZN	Stock	10.924	10.9845	10.924	10.94	184000.0
2012-06-07 08:00:00	AMZN	Stock	10.96	10.96	10.9	10.9275	472220.0
2012-06-07 09:00:00	AMZN	Stock	10.911	11.0745	10.905	11.045	15775040.0
2012-06-07 10:00:00	AMZN	Stock	11.0445	11.0508	10.9211	10.9645	16753020.0
2012-06-07 11:00:00	AMZN	Stock	10.968	11.01	10.9055	10.999	7317600.0
2012-06-07 12:00:00	AMZN	Stock	10.9935	11.03	10.975	11.001	7004340.0
2012-06-07 13:00:00	AMZN	Stock	11.0027	11.0405	10.9825	10.9825	3917400.0
2012-06-07 14:00:00	AMZN	Stock	10.9835	11.0175	10.954	11.0	4071280.0

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

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