PREVIEW / stock_1hour / 2014-05-08

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-08.parquet
  size:    1.0 MB
  rows:    48,042
  symbols: 3,537

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
2014-05-08 04:00:00	AAPL	Stock	21.0714	21.1107	21.0714	21.1107	19600.0
2014-05-08 05:00:00	AAPL	Stock	21.0893	21.0893	21.0718	21.0718	14000.0
2014-05-08 06:00:00	AAPL	Stock	21.0714	21.0714	21.0429	21.0429	82628.0
2014-05-08 07:00:00	AAPL	Stock	21.0711	21.0879	21.0193	21.0446	477624.0
2014-05-08 08:00:00	AAPL	Stock	21.0536	21.0557	20.9954	21.0282	1476832.0
2014-05-08 09:00:00	AAPL	Stock	21.0304	21.1386	21.0089	21.1375	27559252.0
2014-05-08 10:00:00	AAPL	Stock	21.1375	21.1989	21.1084	21.1457	29351672.0
2014-05-08 11:00:00	AAPL	Stock	21.1429	21.2289	21.1311	21.1668	19399268.0
2014-05-08 12:00:00	AAPL	Stock	21.1664	21.1789	21.1129	21.12	13987400.0
2014-05-08 13:00:00	AAPL	Stock	21.12	21.1429	21.0718	21.0811	12733308.0
2014-05-08 14:00:00	AAPL	Stock	21.0814	21.0868	20.9511	20.9863	22727740.0
2014-05-08 15:00:00	AAPL	Stock	20.9796	21.0081	20.9429	21.0043	29561252.0
2014-05-08 16:00:00	AAPL	Stock	21.0043	21.1542	20.9875	20.9982	6277068.0
2014-05-08 17:00:00	AAPL	Stock	21.0032	21.0057	20.9286	20.9286	160608.0
2014-05-08 18:00:00	AAPL	Stock	20.9293	21.0043	20.825	20.9286	688016.0
2014-05-08 19:00:00	AAPL	Stock	20.9279	20.945	20.9196	20.9425	230552.0
2014-05-08 07:00:00	MSFT	Stock	39.4	39.4	39.4	39.4	2000.0
2014-05-08 08:00:00	MSFT	Stock	39.35	39.35	39.2	39.28	8154.0
2014-05-08 09:00:00	MSFT	Stock	39.29	39.59	38.97	39.58	3151233.0
2014-05-08 10:00:00	MSFT	Stock	39.58	39.69	39.55	39.64	4578498.0
2014-05-08 11:00:00	MSFT	Stock	39.64	39.87	39.58	39.7	3109308.0
2014-05-08 12:00:00	MSFT	Stock	39.706	39.89	39.7	39.82	2880758.0
2014-05-08 13:00:00	MSFT	Stock	39.825	39.9	39.61	39.63	1988069.0
2014-05-08 14:00:00	MSFT	Stock	39.625	39.631	39.45	39.52	4249416.0
2014-05-08 15:00:00	MSFT	Stock	39.52	39.64	39.48	39.64	5957259.0
2014-05-08 16:00:00	MSFT	Stock	39.64	39.768	39.57	39.64	1093116.0
2014-05-08 17:00:00	MSFT	Stock	39.63	39.64	39.4	39.55	19636.0
2014-05-08 18:00:00	MSFT	Stock	39.51	39.64	39.46	39.46	12496.0
2014-05-08 19:00:00	MSFT	Stock	39.46	39.5	39.46	39.5	1135.0
2014-05-08 09:00:00	NVDA	Stock	0.4555	0.46	0.4528	0.46	23646640.0
2014-05-08 10:00:00	NVDA	Stock	0.4598	0.4675	0.4598	0.467	54082720.0
2014-05-08 11:00:00	NVDA	Stock	0.467	0.4688	0.4648	0.467	36126760.0
2014-05-08 12:00:00	NVDA	Stock	0.467	0.468	0.4658	0.4678	46650960.0
2014-05-08 13:00:00	NVDA	Stock	0.4678	0.4698	0.4673	0.4688	57492000.0
2014-05-08 14:00:00	NVDA	Stock	0.4688	0.4688	0.4603	0.4618	61417960.0
2014-05-08 15:00:00	NVDA	Stock	0.4619	0.4628	0.4593	0.4624	88838800.0
2014-05-08 16:00:00	NVDA	Stock	0.4622	0.463	0.438	0.4472	50498240.0
2014-05-08 17:00:00	NVDA	Stock	0.4475	0.4475	0.4452	0.4475	266000.0
2014-05-08 18:00:00	NVDA	Stock	0.4475	0.4475	0.4475	0.4475	55200.0
2014-05-08 19:00:00	NVDA	Stock	0.455	0.455	0.455	0.455	12000.0
2014-05-08 06:00:00	AMZN	Stock	14.7295	14.7295	14.6255	14.6255	16000.0
2014-05-08 07:00:00	AMZN	Stock	14.6235	14.6235	14.55	14.55	4000.0
2014-05-08 08:00:00	AMZN	Stock	14.5495	14.5515	14.469	14.4985	291420.0
2014-05-08 09:00:00	AMZN	Stock	14.4895	14.7	14.4585	14.6245	10720680.0
2014-05-08 10:00:00	AMZN	Stock	14.623	14.7939	14.612	14.6605	16662860.0
2014-05-08 11:00:00	AMZN	Stock	14.665	14.77	14.641	14.713	6943080.0
2014-05-08 12:00:00	AMZN	Stock	14.715	14.721	14.55	14.573	5974500.0
2014-05-08 13:00:00	AMZN	Stock	14.576	14.6405	14.511	14.511	6609120.0
2014-05-08 14:00:00	AMZN	Stock	14.511	14.525	14.3978	14.412	8379280.0
2014-05-08 15:00:00	AMZN	Stock	14.4125	14.457	14.3615	14.4185	12868220.0

> showing 50 of 48,042 rows — these rows as CSV

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