PREVIEW / stock_1hour / 2014-05-16

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-16.parquet
  size:    1.0 MB
  rows:    47,352
  symbols: 3,534

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-16 05:00:00	AAPL	Stock	21.0375	21.04	21.0314	21.0318	16800.0
2014-05-16 06:00:00	AAPL	Stock	21.0264	21.0264	21.0264	21.0264	2800.0
2014-05-16 07:00:00	AAPL	Stock	21.0225	21.0229	21.0	21.0114	53480.0
2014-05-16 08:00:00	AAPL	Stock	21.0161	21.0607	20.9839	21.0564	385784.0
2014-05-16 09:00:00	AAPL	Stock	21.0536	21.0886	20.9364	20.9721	41618136.0
2014-05-16 10:00:00	AAPL	Stock	20.9768	20.9839	20.9071	20.9532	27007932.0
2014-05-16 11:00:00	AAPL	Stock	20.955	20.9918	20.9396	20.9801	14162876.0
2014-05-16 12:00:00	AAPL	Stock	20.9818	21.0725	20.9814	21.0461	18310908.0
2014-05-16 13:00:00	AAPL	Stock	21.0475	21.1179	21.0182	21.1036	17317552.0
2014-05-16 14:00:00	AAPL	Stock	21.1054	21.2329	21.0832	21.2314	26039328.0
2014-05-16 15:00:00	AAPL	Stock	21.2296	21.3404	21.2296	21.338	62984236.0
2014-05-16 16:00:00	AAPL	Stock	21.3396	21.3571	20.9555	21.3414	11645256.0
2014-05-16 17:00:00	AAPL	Stock	21.3411	21.3432	21.3375	21.34	464576.0
2014-05-16 18:00:00	AAPL	Stock	21.3396	21.3493	21.3396	21.3493	248080.0
2014-05-16 19:00:00	AAPL	Stock	21.3496	21.3529	21.3432	21.3457	60312.0
2014-05-16 08:00:00	MSFT	Stock	39.78	39.78	39.63	39.65	7225.0
2014-05-16 09:00:00	MSFT	Stock	39.65	39.74	39.44	39.64	6998733.0
2014-05-16 10:00:00	MSFT	Stock	39.63	39.69	39.33	39.512	4974449.0
2014-05-16 11:00:00	MSFT	Stock	39.51	39.59	39.42	39.45	1859992.0
2014-05-16 12:00:00	MSFT	Stock	39.45	39.555	39.38	39.385	1976266.0
2014-05-16 13:00:00	MSFT	Stock	39.385	39.48	39.27	39.4	1902854.0
2014-05-16 14:00:00	MSFT	Stock	39.4	39.627	39.355	39.62	2548115.0
2014-05-16 15:00:00	MSFT	Stock	39.61	39.84	39.585	39.82	5193560.0
2014-05-16 16:00:00	MSFT	Stock	39.83	39.84	39.569	39.83	3055405.0
2014-05-16 17:00:00	MSFT	Stock	39.85	39.85	39.81	39.81	1100.0
2014-05-16 18:00:00	MSFT	Stock	39.81	39.81	39.81	39.81	100.0
2014-05-16 19:00:00	MSFT	Stock	39.81	39.81	39.81	39.81	1018.0
2014-05-16 09:00:00	NVDA	Stock	0.4465	0.4518	0.4465	0.451	38580200.0
2014-05-16 10:00:00	NVDA	Stock	0.451	0.4522	0.4475	0.4518	35429440.0
2014-05-16 11:00:00	NVDA	Stock	0.4518	0.4522	0.449	0.4499	14488960.0
2014-05-16 12:00:00	NVDA	Stock	0.4498	0.4502	0.4472	0.4478	32404880.0
2014-05-16 13:00:00	NVDA	Stock	0.4479	0.4482	0.4472	0.4478	31247560.0
2014-05-16 14:00:00	NVDA	Stock	0.448	0.4494	0.4471	0.4485	49253240.0
2014-05-16 15:00:00	NVDA	Stock	0.4486	0.4505	0.4482	0.4495	63720600.0
2014-05-16 16:00:00	NVDA	Stock	0.4495	0.4496	0.4495	0.4495	1069560.0
2014-05-16 06:00:00	AMZN	Stock	14.7445	14.7445	14.7445	14.7445	2000.0
2014-05-16 07:00:00	AMZN	Stock	14.78	14.78	14.78	14.78	4160.0
2014-05-16 08:00:00	AMZN	Stock	14.7025	14.7025	14.6325	14.6775	182160.0
2014-05-16 09:00:00	AMZN	Stock	14.67	14.723	14.5775	14.688	16903880.0
2014-05-16 10:00:00	AMZN	Stock	14.693	14.767	14.611	14.7301	10536480.0
2014-05-16 11:00:00	AMZN	Stock	14.732	14.819	14.706	14.7925	6451240.0
2014-05-16 12:00:00	AMZN	Stock	14.7915	14.88	14.78	14.8005	6406480.0
2014-05-16 13:00:00	AMZN	Stock	14.7995	14.835	14.7525	14.8138	4670100.0
2014-05-16 14:00:00	AMZN	Stock	14.805	14.8738	14.7565	14.8738	5174920.0
2014-05-16 15:00:00	AMZN	Stock	14.875	14.944	14.8595	14.885	14301220.0
2014-05-16 16:00:00	AMZN	Stock	14.885	14.9075	14.7624	14.885	3083500.0
2014-05-16 18:00:00	AMZN	Stock	14.885	14.885	14.885	14.885	30780.0
2014-05-16 19:00:00	AMZN	Stock	14.905	14.9065	14.9	14.9065	12000.0
2014-05-16 07:00:00	GOOGL	Stock	26.4435	26.4435	26.4435	26.4435	12000.0
2014-05-16 08:00:00	GOOGL	Stock	26.4435	26.448	26.442	26.448	29500.0

> showing 50 of 47,352 rows — these rows as CSV

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