PREVIEW / stock_1hour / 2012-10-17

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-10-17.parquet
  size:    923 KB
  rows:    43,330
  symbols: 3,458

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-10-17 04:00:00	AAPL	Stock	23.2143	23.2321	23.1964	23.1964	96600.0
2012-10-17 05:00:00	AAPL	Stock	23.1964	23.2446	23.1911	23.2446	228928.0
2012-10-17 06:00:00	AAPL	Stock	23.2446	23.2857	23.2446	23.25	117600.0
2012-10-17 07:00:00	AAPL	Stock	23.2393	23.2539	23.1571	23.1571	852320.0
2012-10-17 08:00:00	AAPL	Stock	23.1607	23.2004	23.1143	23.1675	1289624.0
2012-10-17 09:00:00	AAPL	Stock	23.16	23.3139	23.0982	23.2011	90241900.0
2012-10-17 10:00:00	AAPL	Stock	23.2011	23.2354	23.075	23.1457	65701692.0
2012-10-17 11:00:00	AAPL	Stock	23.1461	23.2321	23.0821	23.182	36002876.0
2012-10-17 12:00:00	AAPL	Stock	23.1784	23.2104	23.1189	23.1591	23272480.0
2012-10-17 13:00:00	AAPL	Stock	23.1554	23.16	23.0	23.0536	38614828.0
2012-10-17 14:00:00	AAPL	Stock	23.0535	23.1111	23.0143	23.0479	28437248.0
2012-10-17 15:00:00	AAPL	Stock	23.0504	23.205	23.0129	23.0189	76106296.0
2012-10-17 16:00:00	AAPL	Stock	23.0193	23.1401	23.0186	23.0411	14843920.0
2012-10-17 17:00:00	AAPL	Stock	23.0411	23.0514	23.0325	23.0507	262696.0
2012-10-17 18:00:00	AAPL	Stock	23.0511	23.0518	23.0357	23.0429	104972.0
2012-10-17 19:00:00	AAPL	Stock	23.0368	23.0621	23.0346	23.0621	243292.0
2012-10-17 06:00:00	MSFT	Stock	29.58	29.58	29.51	29.51	300.0
2012-10-17 07:00:00	MSFT	Stock	29.4	29.41	29.4	29.4	4100.0
2012-10-17 08:00:00	MSFT	Stock	29.39	29.4	29.3	29.33	48477.0
2012-10-17 09:00:00	MSFT	Stock	29.33	29.49	29.09	29.47	7045075.0
2012-10-17 10:00:00	MSFT	Stock	29.46	29.51	29.37	29.42	6406211.0
2012-10-17 11:00:00	MSFT	Stock	29.42	29.64	29.37	29.55	5764981.0
2012-10-17 12:00:00	MSFT	Stock	29.55	29.6	29.52	29.575	3793929.0
2012-10-17 13:00:00	MSFT	Stock	29.57	29.61	29.53	29.54	4360466.0
2012-10-17 14:00:00	MSFT	Stock	29.54	29.57	29.51	29.555	3303118.0
2012-10-17 15:00:00	MSFT	Stock	29.555	29.63	29.55	29.585	7775776.0
2012-10-17 16:00:00	MSFT	Stock	29.58	29.608	29.415	29.59	4218125.0
2012-10-17 17:00:00	MSFT	Stock	29.58	29.58	29.57	29.57	250.0
2012-10-17 18:00:00	MSFT	Stock	29.58	29.58	29.57	29.57	2800.0
2012-10-17 19:00:00	MSFT	Stock	29.57	29.59	29.56	29.56	5692.0
2012-10-17 08:00:00	NVDA	Stock	0.3288	0.3288	0.3285	0.3285	96000.0
2012-10-17 09:00:00	NVDA	Stock	0.3263	0.3283	0.3218	0.3235	92457880.0
2012-10-17 10:00:00	NVDA	Stock	0.3235	0.328	0.3228	0.3243	80121560.0
2012-10-17 11:00:00	NVDA	Stock	0.3243	0.3273	0.3228	0.3265	40883720.0
2012-10-17 12:00:00	NVDA	Stock	0.3265	0.3273	0.3263	0.327	17569200.0
2012-10-17 13:00:00	NVDA	Stock	0.327	0.327	0.3249	0.3255	29771680.0
2012-10-17 14:00:00	NVDA	Stock	0.3258	0.326	0.3245	0.3253	39563800.0
2012-10-17 15:00:00	NVDA	Stock	0.3253	0.3275	0.325	0.3265	70995200.0
2012-10-17 16:00:00	NVDA	Stock	0.3268	0.3283	0.3233	0.3256	14403280.0
2012-10-17 08:00:00	AMZN	Stock	12.197	12.197	12.185	12.185	105000.0
2012-10-17 09:00:00	AMZN	Stock	12.175	12.3465	12.151	12.3355	9871780.0
2012-10-17 10:00:00	AMZN	Stock	12.335	12.44	12.2915	12.2955	14298960.0
2012-10-17 11:00:00	AMZN	Stock	12.2977	12.3935	12.2875	12.3845	7362240.0
2012-10-17 12:00:00	AMZN	Stock	12.384	12.415	12.3802	12.4025	4811460.0
2012-10-17 13:00:00	AMZN	Stock	12.403	12.4145	12.2925	12.2998	5730920.0
2012-10-17 14:00:00	AMZN	Stock	12.2965	12.337	12.2665	12.3295	5372280.0
2012-10-17 15:00:00	AMZN	Stock	12.329	12.379	12.3175	12.3705	9395860.0
2012-10-17 16:00:00	AMZN	Stock	12.3745	12.377	12.2124	12.3745	7875440.0
2012-10-17 17:00:00	AMZN	Stock	12.3745	12.3745	12.3745	12.3745	2000.0
2012-10-17 18:00:00	AMZN	Stock	12.3835	12.3835	12.3835	12.3835	4000.0

> showing 50 of 43,330 rows — these rows as CSV

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