PREVIEW / stock_1hour / 2012-09-05

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-09-05.parquet
  size:    926 KB
  rows:    43,661
  symbols: 3,470

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-09-05 04:00:00	AAPL	Stock	24.1061	24.1061	24.0368	24.0368	117012.0
2012-09-05 05:00:00	AAPL	Stock	24.05	24.1029	24.0464	24.1029	111300.0
2012-09-05 06:00:00	AAPL	Stock	24.0982	24.1496	24.0982	24.1429	27608.0
2012-09-05 07:00:00	AAPL	Stock	24.1339	24.1554	24.1071	24.125	609056.0
2012-09-05 08:00:00	AAPL	Stock	24.1243	24.1657	24.0357	24.1075	3238536.0
2012-09-05 09:00:00	AAPL	Stock	24.1079	24.1554	23.9739	24.1046	72968644.0
2012-09-05 10:00:00	AAPL	Stock	24.1068	24.1221	23.9821	23.985	56148232.0
2012-09-05 11:00:00	AAPL	Stock	23.987	24.0686	23.9554	24.0357	33614364.0
2012-09-05 12:00:00	AAPL	Stock	24.0362	24.1382	24.0268	24.1061	25187428.0
2012-09-05 13:00:00	AAPL	Stock	24.1032	24.1179	23.9971	24.0411	32315472.0
2012-09-05 14:00:00	AAPL	Stock	24.0357	24.0412	23.9775	23.9993	28279972.0
2012-09-05 15:00:00	AAPL	Stock	24.0	24.0112	23.9143	23.9339	54386808.0
2012-09-05 16:00:00	AAPL	Stock	23.9297	24.0743	23.9297	23.9536	18244996.0
2012-09-05 17:00:00	AAPL	Stock	23.9568	24.0645	23.9489	23.9586	235424.0
2012-09-05 18:00:00	AAPL	Stock	23.9586	23.9586	23.9329	23.9382	188636.0
2012-09-05 19:00:00	AAPL	Stock	23.9425	23.9464	23.9314	23.9464	263508.0
2012-09-05 08:00:00	MSFT	Stock	30.36	30.42	30.36	30.42	16000.0
2012-09-05 09:00:00	MSFT	Stock	30.44	30.468	30.21	30.35	4128868.0
2012-09-05 10:00:00	MSFT	Stock	30.35	30.53	30.3	30.35	6383721.0
2012-09-05 11:00:00	MSFT	Stock	30.345	30.4	30.29	30.34	4429510.0
2012-09-05 12:00:00	MSFT	Stock	30.34	30.43	30.3	30.41	2270429.0
2012-09-05 13:00:00	MSFT	Stock	30.41	30.42	30.27	30.28	3571658.0
2012-09-05 14:00:00	MSFT	Stock	30.29	30.39	30.25	30.355	3345034.0
2012-09-05 15:00:00	MSFT	Stock	30.355	30.39	30.25	30.38	7676482.0
2012-09-05 16:00:00	MSFT	Stock	30.39	30.428	30.305	30.36	1120435.0
2012-09-05 17:00:00	MSFT	Stock	30.37	30.37	30.36	30.37	897.0
2012-09-05 18:00:00	MSFT	Stock	30.39	30.4	30.39	30.4	563.0
2012-09-05 19:00:00	MSFT	Stock	30.38	30.38	30.38	30.38	400.0
2012-09-05 06:00:00	NVDA	Stock	0.325	0.3375	0.325	0.3375	12000.0
2012-09-05 08:00:00	NVDA	Stock	0.3335	0.3348	0.3325	0.3348	45400.0
2012-09-05 09:00:00	NVDA	Stock	0.3325	0.3335	0.3295	0.332	67931800.0
2012-09-05 10:00:00	NVDA	Stock	0.332	0.338	0.332	0.334	121523920.0
2012-09-05 11:00:00	NVDA	Stock	0.334	0.3358	0.3335	0.3338	51227960.0
2012-09-05 12:00:00	NVDA	Stock	0.3338	0.335	0.3335	0.334	32011760.0
2012-09-05 13:00:00	NVDA	Stock	0.334	0.3345	0.3325	0.3333	42447840.0
2012-09-05 14:00:00	NVDA	Stock	0.3335	0.3345	0.332	0.3338	43819240.0
2012-09-05 15:00:00	NVDA	Stock	0.3336	0.3338	0.332	0.333	92406640.0
2012-09-05 16:00:00	NVDA	Stock	0.333	0.3348	0.3319	0.333	11232200.0
2012-09-05 18:00:00	NVDA	Stock	0.3338	0.334	0.3338	0.334	48000.0
2012-09-05 04:00:00	AMZN	Stock	12.329	12.329	12.329	12.329	3960.0
2012-09-05 08:00:00	AMZN	Stock	12.394	12.42	12.356	12.3785	128200.0
2012-09-05 09:00:00	AMZN	Stock	12.3825	12.423	12.301	12.4075	8244820.0
2012-09-05 10:00:00	AMZN	Stock	12.4025	12.4305	12.285	12.2885	11311240.0
2012-09-05 11:00:00	AMZN	Stock	12.2945	12.377	12.266	12.3645	6083900.0
2012-09-05 12:00:00	AMZN	Stock	12.3645	12.3965	12.353	12.3548	4610080.0
2012-09-05 13:00:00	AMZN	Stock	12.354	12.3568	12.266	12.2956	6960020.0
2012-09-05 14:00:00	AMZN	Stock	12.297	12.323	12.2695	12.306	5951080.0
2012-09-05 15:00:00	AMZN	Stock	12.309	12.3205	12.265	12.311	8024260.0
2012-09-05 16:00:00	AMZN	Stock	12.311	12.3489	12.2978	12.3195	1446820.0
2012-09-05 17:00:00	AMZN	Stock	12.3135	12.3135	12.3135	12.3135	2000.0

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

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