PREVIEW / stock_1hour / 2014-07-28

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-28.parquet
  size:    1.0 MB
  rows:    49,691
  symbols: 3,562

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-07-28 04:00:00	AAPL	Stock	24.4	24.4	24.4	24.4	800.0
2014-07-28 05:00:00	AAPL	Stock	24.4525	24.4625	24.4425	24.4425	13196.0
2014-07-28 06:00:00	AAPL	Stock	24.4375	24.4375	24.4025	24.4025	34352.0
2014-07-28 07:00:00	AAPL	Stock	24.4375	24.45	24.42	24.425	111124.0
2014-07-28 08:00:00	AAPL	Stock	24.425	24.4775	24.35	24.47	625244.0
2014-07-28 09:00:00	AAPL	Stock	24.4675	24.6	24.3875	24.53	36436056.0
2014-07-28 10:00:00	AAPL	Stock	24.5275	24.5425	24.3925	24.4785	27609696.0
2014-07-28 11:00:00	AAPL	Stock	24.482	24.6	24.4675	24.5675	21964228.0
2014-07-28 12:00:00	AAPL	Stock	24.5675	24.63	24.505	24.5948	18523680.0
2014-07-28 13:00:00	AAPL	Stock	24.5925	24.7175	24.58	24.6953	20577712.0
2014-07-28 14:00:00	AAPL	Stock	24.695	24.7625	24.6775	24.7575	21825856.0
2014-07-28 15:00:00	AAPL	Stock	24.7575	24.81	24.7225	24.75	34761112.0
2014-07-28 16:00:00	AAPL	Stock	24.755	24.77	24.4225	24.7575	17984856.0
2014-07-28 17:00:00	AAPL	Stock	24.755	24.775	24.75	24.76	1074148.0
2014-07-28 18:00:00	AAPL	Stock	24.76	24.7625	24.745	24.7575	224616.0
2014-07-28 19:00:00	AAPL	Stock	24.755	24.7575	24.7375	24.7575	263884.0
2014-07-28 05:00:00	MSFT	Stock	44.49	44.49	44.33	44.33	400.0
2014-07-28 07:00:00	MSFT	Stock	44.34	44.36	44.34	44.36	800.0
2014-07-28 08:00:00	MSFT	Stock	44.4	44.45	44.34	44.43	2325.0
2014-07-28 09:00:00	MSFT	Stock	44.43	44.51	44.28	44.32	2394152.0
2014-07-28 10:00:00	MSFT	Stock	44.31	44.312	44.02	44.05	4160271.0
2014-07-28 11:00:00	MSFT	Stock	44.05	44.42	44.03	44.225	3605037.0
2014-07-28 12:00:00	MSFT	Stock	44.23	44.25	44.115	44.22	2105760.0
2014-07-28 13:00:00	MSFT	Stock	44.215	44.41	44.19	44.275	3370900.0
2014-07-28 14:00:00	MSFT	Stock	44.28	44.31	44.16	44.185	2899945.0
2014-07-28 15:00:00	MSFT	Stock	44.18	44.19	43.93	43.96	8722916.0
2014-07-28 16:00:00	MSFT	Stock	43.97	44.172	43.94	43.97	1391561.0
2014-07-28 17:00:00	MSFT	Stock	43.92	43.97	43.9	43.91	54000.0
2014-07-28 18:00:00	MSFT	Stock	43.94	43.97	43.91	43.94	32481.0
2014-07-28 19:00:00	MSFT	Stock	43.93	43.95	43.93	43.93	2200.0
2014-07-28 09:00:00	NVDA	Stock	0.4468	0.4468	0.4358	0.4385	64898960.0
2014-07-28 10:00:00	NVDA	Stock	0.4388	0.4388	0.4354	0.4368	71318760.0
2014-07-28 11:00:00	NVDA	Stock	0.4365	0.4412	0.436	0.4395	43625560.0
2014-07-28 12:00:00	NVDA	Stock	0.4395	0.4418	0.4395	0.4402	23624520.0
2014-07-28 13:00:00	NVDA	Stock	0.4402	0.4424	0.44	0.4422	25126880.0
2014-07-28 14:00:00	NVDA	Stock	0.4421	0.4432	0.441	0.4425	21113440.0
2014-07-28 15:00:00	NVDA	Stock	0.4425	0.4432	0.4415	0.4429	62933080.0
2014-07-28 16:00:00	NVDA	Stock	0.443	0.443	0.4399	0.442	8643920.0
2014-07-28 17:00:00	NVDA	Stock	0.4425	0.443	0.4425	0.443	557440.0
2014-07-28 04:00:00	AMZN	Stock	16.2235	16.2235	16.2	16.2	22000.0
2014-07-28 05:00:00	AMZN	Stock	16.1875	16.1875	16.1875	16.1875	2200.0
2014-07-28 06:00:00	AMZN	Stock	16.175	16.175	16.125	16.125	69100.0
2014-07-28 07:00:00	AMZN	Stock	16.1545	16.1545	16.104	16.1185	51040.0
2014-07-28 08:00:00	AMZN	Stock	16.105	16.195	16.105	16.1875	420500.0
2014-07-28 09:00:00	AMZN	Stock	16.193	16.241	15.91	15.9345	20235220.0
2014-07-28 10:00:00	AMZN	Stock	15.9365	15.956	15.825	15.8995	24992120.0
2014-07-28 11:00:00	AMZN	Stock	15.897	15.9565	15.875	15.8845	12968580.0
2014-07-28 12:00:00	AMZN	Stock	15.885	15.926	15.86	15.9165	7566640.0
2014-07-28 13:00:00	AMZN	Stock	15.914	16.042	15.896	16.0128	13597380.0
2014-07-28 14:00:00	AMZN	Stock	16.015	16.059	15.95	16.058	9433020.0

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

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