PREVIEW / stock_1hour / 2013-11-21

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-11-21.parquet
  size:    1.0 MB
  rows:    47,364
  symbols: 3,525

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
2013-11-21 04:00:00	AAPL	Stock	18.3889	18.3946	18.3768	18.3918	53816.0
2013-11-21 05:00:00	AAPL	Stock	18.3929	18.4161	18.3929	18.4161	36400.0
2013-11-21 06:00:00	AAPL	Stock	18.4232	18.4286	18.415	18.4286	66472.0
2013-11-21 07:00:00	AAPL	Stock	18.4129	18.4864	18.4118	18.4821	336700.0
2013-11-21 08:00:00	AAPL	Stock	18.4786	18.5254	18.3893	18.5089	2132312.0
2013-11-21 09:00:00	AAPL	Stock	18.5089	18.5518	18.4396	18.492	42457660.0
2013-11-21 10:00:00	AAPL	Stock	18.4964	18.4996	18.4089	18.4371	41382684.0
2013-11-21 11:00:00	AAPL	Stock	18.4361	18.455	18.395	18.4243	29142904.0
2013-11-21 12:00:00	AAPL	Stock	18.4254	18.4304	18.3454	18.3904	27999104.0
2013-11-21 13:00:00	AAPL	Stock	18.3911	18.4479	18.3857	18.4439	15229256.0
2013-11-21 14:00:00	AAPL	Stock	18.4436	18.5668	18.4357	18.5554	33975368.0
2013-11-21 15:00:00	AAPL	Stock	18.5568	18.6146	18.5254	18.6079	51457532.0
2013-11-21 16:00:00	AAPL	Stock	18.6075	18.6229	18.3854	18.6157	13256712.0
2013-11-21 17:00:00	AAPL	Stock	18.6229	18.6471	18.6075	18.6396	666820.0
2013-11-21 18:00:00	AAPL	Stock	18.6411	18.6421	18.6286	18.6286	133924.0
2013-11-21 19:00:00	AAPL	Stock	18.6293	18.6471	18.6293	18.6429	115612.0
2013-11-21 06:00:00	MSFT	Stock	37.16	37.16	37.16	37.16	500.0
2013-11-21 07:00:00	MSFT	Stock	37.17	37.23	37.17	37.21	900.0
2013-11-21 08:00:00	MSFT	Stock	37.2	37.23	37.07	37.21	110412.0
2013-11-21 09:00:00	MSFT	Stock	37.23	37.499	37.21	37.46	3114390.0
2013-11-21 10:00:00	MSFT	Stock	37.46	37.53	37.35	37.412	3704303.0
2013-11-21 11:00:00	MSFT	Stock	37.42	37.43	37.27	37.29	2307405.0
2013-11-21 12:00:00	MSFT	Stock	37.29	37.44	37.29	37.336	1830790.0
2013-11-21 13:00:00	MSFT	Stock	37.33	37.51	37.29	37.45	2410539.0
2013-11-21 14:00:00	MSFT	Stock	37.453	37.49	37.35	37.375	2258763.0
2013-11-21 15:00:00	MSFT	Stock	37.38	37.44	37.36	37.4	5161941.0
2013-11-21 16:00:00	MSFT	Stock	37.39	37.46	37.37	37.39	1964236.0
2013-11-21 17:00:00	MSFT	Stock	37.43	37.43	37.39	37.43	39842.0
2013-11-21 18:00:00	MSFT	Stock	37.43	37.48	37.42	37.48	13900.0
2013-11-21 19:00:00	MSFT	Stock	37.49	37.49	37.48	37.49	10600.0
2013-11-21 09:00:00	NVDA	Stock	0.3808	0.3815	0.3793	0.3805	20546320.0
2013-11-21 10:00:00	NVDA	Stock	0.3805	0.3813	0.3793	0.38	31841480.0
2013-11-21 11:00:00	NVDA	Stock	0.38	0.3805	0.379	0.3795	24277520.0
2013-11-21 12:00:00	NVDA	Stock	0.3798	0.3808	0.3793	0.38	23253360.0
2013-11-21 13:00:00	NVDA	Stock	0.38	0.3822	0.38	0.3819	20182720.0
2013-11-21 14:00:00	NVDA	Stock	0.382	0.3835	0.3818	0.3825	30672320.0
2013-11-21 15:00:00	NVDA	Stock	0.3825	0.384	0.3824	0.3835	51635840.0
2013-11-21 16:00:00	NVDA	Stock	0.3835	0.3836	0.3812	0.3835	2498480.0
2013-11-21 17:00:00	NVDA	Stock	0.3835	0.3835	0.3835	0.3835	115840.0
2013-11-21 07:00:00	AMZN	Stock	18.1615	18.1615	18.1615	18.1615	2000.0
2013-11-21 08:00:00	AMZN	Stock	18.1765	18.235	18.1285	18.201	146500.0
2013-11-21 09:00:00	AMZN	Stock	18.198	18.375	18.165	18.355	7350980.0
2013-11-21 10:00:00	AMZN	Stock	18.355	18.435	18.313	18.4125	6542940.0
2013-11-21 11:00:00	AMZN	Stock	18.4265	18.4335	18.325	18.347	3623180.0
2013-11-21 12:00:00	AMZN	Stock	18.345	18.35	18.248	18.2615	3020360.0
2013-11-21 13:00:00	AMZN	Stock	18.261	18.4305	18.25	18.4155	4269400.0
2013-11-21 14:00:00	AMZN	Stock	18.415	18.4425	18.385	18.426	3650540.0
2013-11-21 15:00:00	AMZN	Stock	18.4285	18.4625	18.42	18.4505	7172380.0
2013-11-21 16:00:00	AMZN	Stock	18.446	18.4745	18.3665	18.4485	3324380.0
2013-11-21 17:00:00	AMZN	Stock	18.449	18.475	18.446	18.475	75040.0

> showing 50 of 47,364 rows — these rows as CSV

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