PREVIEW / stock_1hour / 2012-11-26

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-26.parquet
  size:    932 KB
  rows:    44,225
  symbols: 3,497

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-11-26 04:00:00	AAPL	Stock	20.4643	20.535	20.4579	20.4821	148428.0
2012-11-26 05:00:00	AAPL	Stock	20.4768	20.5143	20.4554	20.5143	54152.0
2012-11-26 06:00:00	AAPL	Stock	20.4979	20.5143	20.4607	20.4643	100772.0
2012-11-26 07:00:00	AAPL	Stock	20.4643	20.4786	20.3779	20.4286	1529472.0
2012-11-26 08:00:00	AAPL	Stock	20.4521	20.4811	20.4196	20.4607	3699808.0
2012-11-26 09:00:00	AAPL	Stock	20.4596	20.705	20.4596	20.685	107255204.0
2012-11-26 10:00:00	AAPL	Stock	20.6893	20.7143	20.5896	20.6593	80337264.0
2012-11-26 11:00:00	AAPL	Stock	20.6626	20.8064	20.6161	20.7679	65889096.0
2012-11-26 12:00:00	AAPL	Stock	20.7671	21.0307	20.7607	21.004	95020436.0
2012-11-26 13:00:00	AAPL	Stock	21.0029	21.0357	20.9371	20.9853	62444536.0
2012-11-26 14:00:00	AAPL	Stock	20.9877	21.0671	20.9196	21.0493	56257096.0
2012-11-26 15:00:00	AAPL	Stock	21.0471	21.0675	20.9436	21.0454	95302172.0
2012-11-26 16:00:00	AAPL	Stock	21.0454	21.1372	20.5875	21.0464	45596796.0
2012-11-26 17:00:00	AAPL	Stock	21.0496	21.0607	21.0411	21.0411	588644.0
2012-11-26 18:00:00	AAPL	Stock	21.0393	21.0582	21.0375	21.0571	204708.0
2012-11-26 19:00:00	AAPL	Stock	21.0579	21.0786	21.0536	21.0779	1113420.0
2012-11-26 04:00:00	MSFT	Stock	27.7	27.7	27.58	27.58	800.0
2012-11-26 05:00:00	MSFT	Stock	27.55	27.55	27.55	27.55	150.0
2012-11-26 07:00:00	MSFT	Stock	27.6	27.6	27.45	27.48	5800.0
2012-11-26 08:00:00	MSFT	Stock	27.55	27.7	27.46	27.56	16575.0
2012-11-26 09:00:00	MSFT	Stock	27.55	27.58	27.32	27.36	6550312.0
2012-11-26 10:00:00	MSFT	Stock	27.362	27.38	27.25	27.27	10747122.0
2012-11-26 11:00:00	MSFT	Stock	27.28	27.32	27.17	27.25	8531884.0
2012-11-26 12:00:00	MSFT	Stock	27.245	27.32	27.23	27.23	5928527.0
2012-11-26 13:00:00	MSFT	Stock	27.235	27.28	27.21	27.25	6490099.0
2012-11-26 14:00:00	MSFT	Stock	27.255	27.31	27.23	27.276	5097841.0
2012-11-26 15:00:00	MSFT	Stock	27.275	27.4	27.25	27.4	9022687.0
2012-11-26 16:00:00	MSFT	Stock	27.375	27.41	27.221	27.4	7239151.0
2012-11-26 17:00:00	MSFT	Stock	27.4	27.42	27.37	27.4	13243.0
2012-11-26 18:00:00	MSFT	Stock	27.4	27.4	27.37	27.38	7700.0
2012-11-26 19:00:00	MSFT	Stock	27.38	27.42	27.38	27.42	17862.0
2012-11-26 04:00:00	NVDA	Stock	0.2978	0.2978	0.2978	0.2978	4000.0
2012-11-26 06:00:00	NVDA	Stock	0.3012	0.3012	0.3012	0.3012	4000.0
2012-11-26 08:00:00	NVDA	Stock	0.2985	0.299	0.2965	0.2965	80000.0
2012-11-26 09:00:00	NVDA	Stock	0.298	0.3035	0.2975	0.3015	51742720.0
2012-11-26 10:00:00	NVDA	Stock	0.3015	0.3032	0.3002	0.3022	70453000.0
2012-11-26 11:00:00	NVDA	Stock	0.3022	0.303	0.3005	0.3025	32692480.0
2012-11-26 12:00:00	NVDA	Stock	0.3026	0.303	0.3012	0.3015	25989040.0
2012-11-26 13:00:00	NVDA	Stock	0.3016	0.302	0.3002	0.3008	27287600.0
2012-11-26 14:00:00	NVDA	Stock	0.3008	0.3022	0.3	0.302	30049120.0
2012-11-26 15:00:00	NVDA	Stock	0.302	0.303	0.3018	0.3029	61016840.0
2012-11-26 16:00:00	NVDA	Stock	0.303	0.3032	0.3015	0.3019	63700440.0
2012-11-26 19:00:00	NVDA	Stock	0.3025	0.3028	0.3025	0.3028	14000.0
2012-11-26 04:00:00	AMZN	Stock	11.975	11.975	11.975	11.975	2000.0
2012-11-26 05:00:00	AMZN	Stock	11.975	11.975	11.95	11.95	8000.0
2012-11-26 06:00:00	AMZN	Stock	11.9625	11.9625	11.9625	11.9625	2000.0
2012-11-26 07:00:00	AMZN	Stock	11.975	11.99	11.9495	11.95	130200.0
2012-11-26 08:00:00	AMZN	Stock	11.9515	12.0125	11.9375	12.0125	379640.0
2012-11-26 09:00:00	AMZN	Stock	12.0065	12.0995	11.9	12.0775	17575280.0
2012-11-26 10:00:00	AMZN	Stock	12.077	12.1365	12.0375	12.0868	13987780.0

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

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