PREVIEW / stock_1hour / 2014-11-20

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-11-20.parquet
  size:    1.1 MB
  rows:    49,885
  symbols: 3,563

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-11-20 04:00:00	AAPL	Stock	27.5	28.595	27.5	28.5875	12800.0
2014-11-20 05:00:00	AAPL	Stock	28.5675	28.6025	28.5675	28.57	9552.0
2014-11-20 06:00:00	AAPL	Stock	28.585	28.59	28.5625	28.5875	9964.0
2014-11-20 07:00:00	AAPL	Stock	28.605	28.6475	28.58	28.625	100260.0
2014-11-20 08:00:00	AAPL	Stock	28.63	28.7725	28.58	28.7275	6654336.0
2014-11-20 09:00:00	AAPL	Stock	28.725	28.9625	28.7125	28.9	28540792.0
2014-11-20 10:00:00	AAPL	Stock	28.9	29.1075	28.9	29.0875	32625756.0
2014-11-20 11:00:00	AAPL	Stock	29.09	29.215	29.0875	29.1375	25254624.0
2014-11-20 12:00:00	AAPL	Stock	29.135	29.1575	29.0675	29.1225	15769632.0
2014-11-20 13:00:00	AAPL	Stock	29.1225	29.1725	29.105	29.1082	10153296.0
2014-11-20 14:00:00	AAPL	Stock	29.1075	29.165	29.1	29.1125	10963508.0
2014-11-20 15:00:00	AAPL	Stock	29.1125	29.135	29.055	29.075	22847124.0
2014-11-20 16:00:00	AAPL	Stock	29.0775	29.1155	28.9025	29.0925	9315668.0
2014-11-20 17:00:00	AAPL	Stock	29.0875	29.1	29.0775	29.0975	1101348.0
2014-11-20 18:00:00	AAPL	Stock	29.0975	29.1025	29.0825	29.085	75112.0
2014-11-20 19:00:00	AAPL	Stock	29.085	29.11	29.08	29.1075	153476.0
2014-11-20 04:00:00	MSFT	Stock	48.18	48.18	48.18	48.18	100.0
2014-11-20 06:00:00	MSFT	Stock	48.06	48.06	48.06	48.06	200.0
2014-11-20 07:00:00	MSFT	Stock	48.06	48.06	48.06	48.06	200.0
2014-11-20 08:00:00	MSFT	Stock	48.03	48.05	48.0	48.0	4579.0
2014-11-20 09:00:00	MSFT	Stock	48.02	48.1	47.87	48.04	2864751.0
2014-11-20 10:00:00	MSFT	Stock	48.05	48.35	48.04	48.33	3185365.0
2014-11-20 11:00:00	MSFT	Stock	48.33	48.4	48.29	48.36	1405015.0
2014-11-20 12:00:00	MSFT	Stock	48.36	48.49	48.25	48.43	1565909.0
2014-11-20 13:00:00	MSFT	Stock	48.43	48.48	48.37	48.41	2031485.0
2014-11-20 14:00:00	MSFT	Stock	48.405	48.59	48.4	48.55	2597583.0
2014-11-20 15:00:00	MSFT	Stock	48.54	48.7	48.51	48.69	4193655.0
2014-11-20 16:00:00	MSFT	Stock	48.7	48.7	47.96	48.5	2523408.0
2014-11-20 17:00:00	MSFT	Stock	48.47	48.7	48.46	48.46	19927.0
2014-11-20 18:00:00	MSFT	Stock	48.377	48.377	48.377	48.377	5248.0
2014-11-20 19:00:00	MSFT	Stock	48.48	48.48	48.44	48.44	4600.0
2014-11-20 08:00:00	NVDA	Stock	0.4803	0.4803	0.4803	0.4803	40000.0
2014-11-20 09:00:00	NVDA	Stock	0.4948	0.5018	0.4948	0.5008	22084480.0
2014-11-20 10:00:00	NVDA	Stock	0.5008	0.506	0.5003	0.5043	51735560.0
2014-11-20 11:00:00	NVDA	Stock	0.5043	0.5062	0.5032	0.506	25924600.0
2014-11-20 12:00:00	NVDA	Stock	0.5059	0.509	0.5055	0.508	30403680.0
2014-11-20 13:00:00	NVDA	Stock	0.508	0.5088	0.5055	0.5081	16955800.0
2014-11-20 14:00:00	NVDA	Stock	0.508	0.5085	0.5066	0.507	12200400.0
2014-11-20 15:00:00	NVDA	Stock	0.507	0.5088	0.5066	0.5088	45200360.0
2014-11-20 16:00:00	NVDA	Stock	0.5085	0.5085	0.5055	0.5085	1567960.0
2014-11-20 17:00:00	NVDA	Stock	0.5085	0.5085	0.5085	0.5085	29560.0
2014-11-20 05:00:00	AMZN	Stock	16.207	16.207	16.207	16.207	2200.0
2014-11-20 07:00:00	AMZN	Stock	16.225	16.225	16.2185	16.2185	4000.0
2014-11-20 08:00:00	AMZN	Stock	16.24	16.248	16.2	16.2	112420.0
2014-11-20 09:00:00	AMZN	Stock	16.195	16.449	16.1665	16.4345	7688960.0
2014-11-20 10:00:00	AMZN	Stock	16.4395	16.585	16.4025	16.575	18640060.0
2014-11-20 11:00:00	AMZN	Stock	16.577	16.6335	16.5525	16.5855	11128680.0
2014-11-20 12:00:00	AMZN	Stock	16.5845	16.609	16.502	16.541	7060800.0
2014-11-20 13:00:00	AMZN	Stock	16.538	16.5385	16.463	16.4955	4377520.0
2014-11-20 14:00:00	AMZN	Stock	16.4951	16.5489	16.481	16.4845	4074740.0

> showing 50 of 49,885 rows — these rows as CSV

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