PREVIEW / stock_1hour / 2012-08-03

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-03.parquet
  size:    920 KB
  rows:    43,800
  symbols: 3,496

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-08-03 04:00:00	AAPL	Stock	21.7929	21.8321	21.7929	21.8321	35000.0
2012-08-03 05:00:00	AAPL	Stock	21.8393	21.8393	21.8357	21.8357	61600.0
2012-08-03 06:00:00	AAPL	Stock	21.8464	21.8643	21.8464	21.8571	15400.0
2012-08-03 07:00:00	AAPL	Stock	21.8507	21.8714	21.7946	21.7946	718732.0
2012-08-03 08:00:00	AAPL	Stock	21.7932	21.8893	21.7143	21.8707	4800572.0
2012-08-03 09:00:00	AAPL	Stock	21.8679	22.005	21.8414	21.9811	71468712.0
2012-08-03 10:00:00	AAPL	Stock	21.9821	22.0489	21.9175	22.035	60773104.0
2012-08-03 11:00:00	AAPL	Stock	22.0354	22.0707	21.9846	22.0175	49210924.0
2012-08-03 12:00:00	AAPL	Stock	22.0144	22.0339	21.9475	21.9564	27831776.0
2012-08-03 13:00:00	AAPL	Stock	21.9568	22.0332	21.9532	22.0157	25432456.0
2012-08-03 14:00:00	AAPL	Stock	22.0127	22.0446	22.005	22.0071	28498680.0
2012-08-03 15:00:00	AAPL	Stock	22.0089	22.0364	21.9614	21.9875	62281604.0
2012-08-03 16:00:00	AAPL	Stock	21.9875	22.0339	21.9575	21.9857	9612148.0
2012-08-03 17:00:00	AAPL	Stock	21.9857	21.9907	21.9857	21.9893	263228.0
2012-08-03 18:00:00	AAPL	Stock	21.9882	21.9907	21.9861	21.9861	173880.0
2012-08-03 19:00:00	AAPL	Stock	21.9896	22.0018	21.9857	22.0	305956.0
2012-08-03 07:00:00	MSFT	Stock	29.33	29.33	29.33	29.33	100.0
2012-08-03 08:00:00	MSFT	Stock	29.28	29.43	29.28	29.39	53589.0
2012-08-03 09:00:00	MSFT	Stock	29.39	29.76	29.37	29.74	4350404.0
2012-08-03 10:00:00	MSFT	Stock	29.735	29.89	29.71	29.81	6069675.0
2012-08-03 11:00:00	MSFT	Stock	29.805	29.89	29.785	29.88	3660474.0
2012-08-03 12:00:00	MSFT	Stock	29.885	29.92	29.83	29.83	2928562.0
2012-08-03 13:00:00	MSFT	Stock	29.835	29.87	29.76	29.868	2941744.0
2012-08-03 14:00:00	MSFT	Stock	29.865	29.9	29.83	29.89	2877049.0
2012-08-03 15:00:00	MSFT	Stock	29.89	29.94	29.73	29.75	10117321.0
2012-08-03 16:00:00	MSFT	Stock	29.74	29.822	29.74	29.77	1985406.0
2012-08-03 17:00:00	MSFT	Stock	29.78	29.85	29.75	29.81	77475.0
2012-08-03 18:00:00	MSFT	Stock	29.81	29.81	29.81	29.81	2500.0
2012-08-03 19:00:00	MSFT	Stock	29.82	29.82	29.8	29.82	570.0
2012-08-03 08:00:00	NVDA	Stock	0.3378	0.338	0.337	0.3375	45440.0
2012-08-03 09:00:00	NVDA	Stock	0.3413	0.3435	0.3333	0.3375	51382200.0
2012-08-03 10:00:00	NVDA	Stock	0.3378	0.342	0.337	0.341	60173720.0
2012-08-03 11:00:00	NVDA	Stock	0.341	0.343	0.341	0.3428	39824960.0
2012-08-03 12:00:00	NVDA	Stock	0.3428	0.3438	0.3422	0.3436	23241160.0
2012-08-03 13:00:00	NVDA	Stock	0.3436	0.3458	0.3435	0.3454	36210880.0
2012-08-03 14:00:00	NVDA	Stock	0.3453	0.3465	0.3438	0.3442	30416160.0
2012-08-03 15:00:00	NVDA	Stock	0.3444	0.3453	0.342	0.3428	71620720.0
2012-08-03 16:00:00	NVDA	Stock	0.3425	0.3433	0.336	0.343	10848080.0
2012-08-03 17:00:00	NVDA	Stock	0.3425	0.3425	0.3425	0.3425	9960.0
2012-08-03 08:00:00	AMZN	Stock	11.6335	11.692	11.5875	11.67	213920.0
2012-08-03 09:00:00	AMZN	Stock	11.675	11.7775	11.5405	11.7535	9354500.0
2012-08-03 10:00:00	AMZN	Stock	11.753	11.8145	11.733	11.794	12193120.0
2012-08-03 11:00:00	AMZN	Stock	11.794	11.814	11.777	11.789	4946460.0
2012-08-03 12:00:00	AMZN	Stock	11.7875	11.8245	11.75	11.8165	5998860.0
2012-08-03 13:00:00	AMZN	Stock	11.8175	11.8205	11.776	11.7805	3208220.0
2012-08-03 14:00:00	AMZN	Stock	11.781	11.7975	11.7695	11.7855	4643620.0
2012-08-03 15:00:00	AMZN	Stock	11.7835	11.7975	11.741	11.7485	13374460.0
2012-08-03 16:00:00	AMZN	Stock	11.7475	11.7887	11.5405	11.7485	717500.0
2012-08-03 17:00:00	AMZN	Stock	11.745	11.745	11.745	11.745	4000.0
2012-08-03 18:00:00	AMZN	Stock	11.745	11.745	11.745	11.745	5000.0

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

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