PREVIEW / stock_1hour / 2014-05-09

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-09.parquet
  size:    1.0 MB
  rows:    47,265
  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-09 04:00:00	AAPL	Stock	20.9964	20.9964	20.8929	20.8929	11200.0
2014-05-09 05:00:00	AAPL	Stock	20.9479	20.9554	20.9457	20.9554	8400.0
2014-05-09 06:00:00	AAPL	Stock	20.9518	20.9518	20.8839	20.9082	33600.0
2014-05-09 07:00:00	AAPL	Stock	20.9107	20.9696	20.8636	20.905	244692.0
2014-05-09 08:00:00	AAPL	Stock	20.9107	20.9214	20.8482	20.8939	1108632.0
2014-05-09 09:00:00	AAPL	Stock	20.8907	20.9375	20.7707	20.8146	43428924.0
2014-05-09 10:00:00	AAPL	Stock	20.8154	20.875	20.7796	20.7814	31530380.0
2014-05-09 11:00:00	AAPL	Stock	20.7829	20.81	20.7261	20.7896	28818328.0
2014-05-09 12:00:00	AAPL	Stock	20.7904	20.8036	20.7429	20.7857	18662980.0
2014-05-09 13:00:00	AAPL	Stock	20.7879	20.7996	20.735	20.7486	14255528.0
2014-05-09 14:00:00	AAPL	Stock	20.7479	20.8343	20.7389	20.8339	18880792.0
2014-05-09 15:00:00	AAPL	Stock	20.8343	20.9179	20.833	20.9121	41902028.0
2014-05-09 16:00:00	AAPL	Stock	20.9125	20.9286	20.8104	20.9129	7502768.0
2014-05-09 17:00:00	AAPL	Stock	20.9125	20.9161	20.9079	20.9125	248080.0
2014-05-09 18:00:00	AAPL	Stock	20.9107	20.9214	20.9093	20.9107	170604.0
2014-05-09 19:00:00	AAPL	Stock	20.9179	20.9193	20.9107	20.9193	80948.0
2014-05-09 07:00:00	MSFT	Stock	39.63	39.63	39.63	39.63	300.0
2014-05-09 08:00:00	MSFT	Stock	39.51	39.55	39.5	39.55	5118.0
2014-05-09 09:00:00	MSFT	Stock	39.55	39.66	39.45	39.61	4276713.0
2014-05-09 10:00:00	MSFT	Stock	39.6	39.85	39.56	39.565	4964206.0
2014-05-09 11:00:00	MSFT	Stock	39.56	39.61	39.46	39.466	5100867.0
2014-05-09 12:00:00	MSFT	Stock	39.46	39.69	39.45	39.67	3161163.0
2014-05-09 13:00:00	MSFT	Stock	39.67	39.68	39.5	39.52	1670115.0
2014-05-09 14:00:00	MSFT	Stock	39.51	39.59	39.37	39.535	3537635.0
2014-05-09 15:00:00	MSFT	Stock	39.54	39.59	39.52	39.55	3874354.0
2014-05-09 16:00:00	MSFT	Stock	39.54	39.567	39.53	39.54	1809460.0
2014-05-09 17:00:00	MSFT	Stock	39.54	39.572	39.52	39.572	950.0
2014-05-09 19:00:00	MSFT	Stock	39.55	39.55	39.54	39.54	565.0
2014-05-09 08:00:00	NVDA	Stock	0.45	0.45	0.4498	0.4498	60000.0
2014-05-09 09:00:00	NVDA	Stock	0.4498	0.45	0.4428	0.4475	122246760.0
2014-05-09 10:00:00	NVDA	Stock	0.4474	0.4512	0.4445	0.4478	129415480.0
2014-05-09 11:00:00	NVDA	Stock	0.4475	0.449	0.4455	0.446	49358720.0
2014-05-09 12:00:00	NVDA	Stock	0.4462	0.4515	0.4462	0.45	40371240.0
2014-05-09 13:00:00	NVDA	Stock	0.45	0.451	0.4485	0.45	52161040.0
2014-05-09 14:00:00	NVDA	Stock	0.45	0.4528	0.45	0.4515	35445000.0
2014-05-09 15:00:00	NVDA	Stock	0.4515	0.4522	0.45	0.451	96661520.0
2014-05-09 16:00:00	NVDA	Stock	0.4512	0.4633	0.4498	0.4512	8494720.0
2014-05-09 17:00:00	NVDA	Stock	0.4508	0.4508	0.4505	0.4505	28000.0
2014-05-09 04:00:00	AMZN	Stock	14.41	14.41	14.41	14.41	2000.0
2014-05-09 05:00:00	AMZN	Stock	14.4125	14.42	14.4125	14.42	4000.0
2014-05-09 06:00:00	AMZN	Stock	14.404	14.404	14.3905	14.3905	4000.0
2014-05-09 07:00:00	AMZN	Stock	14.4115	14.425	14.4115	14.4205	16820.0
2014-05-09 08:00:00	AMZN	Stock	14.415	14.477	14.3925	14.4445	207580.0
2014-05-09 09:00:00	AMZN	Stock	14.4575	14.542	14.219	14.434	19588960.0
2014-05-09 10:00:00	AMZN	Stock	14.4338	14.51	14.3075	14.314	13639800.0
2014-05-09 11:00:00	AMZN	Stock	14.31	14.448	14.26	14.4105	7500340.0
2014-05-09 12:00:00	AMZN	Stock	14.4145	14.562	14.3855	14.5394	6978300.0
2014-05-09 13:00:00	AMZN	Stock	14.5435	14.5585	14.4882	14.5028	4621200.0
2014-05-09 14:00:00	AMZN	Stock	14.5038	14.571	14.459	14.5385	5905880.0
2014-05-09 15:00:00	AMZN	Stock	14.543	14.684	14.5423	14.608	14382140.0

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

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