PREVIEW / stock_1hour / 2012-07-05

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-05.parquet
  size:    919 KB
  rows:    43,611
  symbols: 3,507

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-07-05 04:00:00	AAPL	Stock	21.3929	21.3929	21.3571	21.3571	28000.0
2012-07-05 05:00:00	AAPL	Stock	21.3582	21.3582	21.3582	21.3582	2800.0
2012-07-05 06:00:00	AAPL	Stock	21.3839	21.3839	21.3839	21.3839	14000.0
2012-07-05 07:00:00	AAPL	Stock	21.3929	21.535	21.3929	21.4489	898576.0
2012-07-05 08:00:00	AAPL	Stock	21.4611	21.5268	21.4214	21.495	4769884.0
2012-07-05 09:00:00	AAPL	Stock	21.4957	21.6714	21.4161	21.6146	97076028.0
2012-07-05 10:00:00	AAPL	Stock	21.6143	21.7987	21.5668	21.7875	90954892.0
2012-07-05 11:00:00	AAPL	Stock	21.7921	21.9357	21.7789	21.8402	92332436.0
2012-07-05 12:00:00	AAPL	Stock	21.8379	21.8896	21.8268	21.8629	33979848.0
2012-07-05 13:00:00	AAPL	Stock	21.8646	21.9407	21.8472	21.9286	43915172.0
2012-07-05 14:00:00	AAPL	Stock	21.9314	21.9321	21.8093	21.825	36421392.0
2012-07-05 15:00:00	AAPL	Stock	21.8268	21.8779	21.7768	21.7837	64496516.0
2012-07-05 16:00:00	AAPL	Stock	21.7779	21.8527	21.4075	21.7832	8709148.0
2012-07-05 17:00:00	AAPL	Stock	21.7839	21.7929	21.7696	21.7929	522844.0
2012-07-05 18:00:00	AAPL	Stock	21.7911	21.7932	21.7861	21.7932	107744.0
2012-07-05 19:00:00	AAPL	Stock	21.7929	21.7946	21.7839	21.7889	280616.0
2012-07-05 05:00:00	MSFT	Stock	30.65	30.65	30.65	30.65	200.0
2012-07-05 07:00:00	MSFT	Stock	30.71	30.94	30.7	30.7	4270.0
2012-07-05 08:00:00	MSFT	Stock	30.7	30.8	30.41	30.62	101998.0
2012-07-05 09:00:00	MSFT	Stock	30.64	30.76	30.5	30.6	3956873.0
2012-07-05 10:00:00	MSFT	Stock	30.61	30.64	30.375	30.615	4736470.0
2012-07-05 11:00:00	MSFT	Stock	30.62	30.67	30.59	30.67	2838349.0
2012-07-05 12:00:00	MSFT	Stock	30.67	30.72	30.61	30.655	2389504.0
2012-07-05 13:00:00	MSFT	Stock	30.659	30.74	30.64	30.738	2670680.0
2012-07-05 14:00:00	MSFT	Stock	30.74	30.775	30.71	30.74	3110306.0
2012-07-05 15:00:00	MSFT	Stock	30.75	30.78	30.69	30.69	6472150.0
2012-07-05 16:00:00	MSFT	Stock	30.7	30.76	30.64	30.7	2177326.0
2012-07-05 17:00:00	MSFT	Stock	30.64	30.64	30.64	30.64	300.0
2012-07-05 18:00:00	MSFT	Stock	30.64	30.65	30.63	30.64	2200.0
2012-07-05 19:00:00	MSFT	Stock	30.64	30.64	30.64	30.64	500.0
2012-07-05 08:00:00	NVDA	Stock	0.346	0.347	0.3435	0.344	313400.0
2012-07-05 09:00:00	NVDA	Stock	0.345	0.3453	0.3375	0.338	38387880.0
2012-07-05 10:00:00	NVDA	Stock	0.3381	0.3425	0.3362	0.342	55468680.0
2012-07-05 11:00:00	NVDA	Stock	0.3422	0.3433	0.3408	0.341	28246120.0
2012-07-05 12:00:00	NVDA	Stock	0.341	0.3433	0.34	0.3422	33779680.0
2012-07-05 13:00:00	NVDA	Stock	0.3422	0.3438	0.342	0.3435	21371280.0
2012-07-05 14:00:00	NVDA	Stock	0.3435	0.3442	0.3425	0.3428	22266600.0
2012-07-05 15:00:00	NVDA	Stock	0.3428	0.343	0.3408	0.3411	64368120.0
2012-07-05 16:00:00	NVDA	Stock	0.3413	0.3453	0.3408	0.3415	1370080.0
2012-07-05 17:00:00	NVDA	Stock	0.3402	0.3402	0.3395	0.3395	108000.0
2012-07-05 18:00:00	NVDA	Stock	0.3418	0.3418	0.339	0.339	44000.0
2012-07-05 08:00:00	AMZN	Stock	11.45	11.473	11.371	11.4175	99180.0
2012-07-05 09:00:00	AMZN	Stock	11.424	11.4485	11.3585	11.3645	5430560.0
2012-07-05 10:00:00	AMZN	Stock	11.364	11.4965	11.3265	11.476	11076460.0
2012-07-05 11:00:00	AMZN	Stock	11.4805	11.525	11.415	11.4164	8856920.0
2012-07-05 12:00:00	AMZN	Stock	11.416	11.432	11.382	11.3881	5048620.0
2012-07-05 13:00:00	AMZN	Stock	11.389	11.46	11.38	11.4475	3579740.0
2012-07-05 14:00:00	AMZN	Stock	11.446	11.4465	11.38	11.3834	4437920.0
2012-07-05 15:00:00	AMZN	Stock	11.382	11.405	11.35	11.3525	9267900.0
2012-07-05 16:00:00	AMZN	Stock	11.353	11.4765	11.3305	11.347	2668820.0

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

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