PREVIEW / stock_1hour / 2014-06-09

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-09.parquet
  size:    1.0 MB
  rows:    48,389
  symbols: 3,551

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-06-09 04:00:00	AAPL	Stock	23.0575	23.1725	23.0575	23.16	49072.0
2014-06-09 05:00:00	AAPL	Stock	23.1575	23.16	23.1	23.1	66628.0
2014-06-09 06:00:00	AAPL	Stock	23.09	23.1	23.0375	23.05	120052.0
2014-06-09 07:00:00	AAPL	Stock	23.0575	23.0575	22.9325	23.0125	531436.0
2014-06-09 08:00:00	AAPL	Stock	23.0125	23.4175	22.95	23.0125	2966144.0
2014-06-09 09:00:00	AAPL	Stock	23.0125	23.27	23.0125	23.0775	52232596.0
2014-06-09 10:00:00	AAPL	Stock	23.08	23.1875	22.9375	23.155	43139820.0
2014-06-09 11:00:00	AAPL	Stock	23.155	23.29	23.115	23.2525	33766428.0
2014-06-09 12:00:00	AAPL	Stock	23.2525	23.4325	23.25	23.4237	38252932.0
2014-06-09 13:00:00	AAPL	Stock	23.4248	23.455	23.3525	23.44	30230556.0
2014-06-09 14:00:00	AAPL	Stock	23.4412	23.46	23.3275	23.4225	27097656.0
2014-06-09 15:00:00	AAPL	Stock	23.4225	23.47	23.3712	23.425	36248008.0
2014-06-09 16:00:00	AAPL	Stock	23.425	23.4425	23.4	23.4	7361492.0
2014-06-09 17:00:00	AAPL	Stock	23.405	23.435	23.4	23.4225	281112.0
2014-06-09 18:00:00	AAPL	Stock	23.42	23.44	23.4125	23.44	167984.0
2014-06-09 19:00:00	AAPL	Stock	23.4375	23.445	23.425	23.4425	129796.0
2014-06-09 07:00:00	MSFT	Stock	41.58	41.58	41.58	41.58	1000.0
2014-06-09 08:00:00	MSFT	Stock	41.5	41.7	41.48	41.54	4400.0
2014-06-09 09:00:00	MSFT	Stock	41.58	41.58	41.13	41.25	2376491.0
2014-06-09 10:00:00	MSFT	Stock	41.25	41.34	41.14	41.32	1657974.0
2014-06-09 11:00:00	MSFT	Stock	41.32	41.37	41.26	41.33	1207076.0
2014-06-09 12:00:00	MSFT	Stock	41.32	41.33	41.25	41.27	1225474.0
2014-06-09 13:00:00	MSFT	Stock	41.27	41.28	41.13	41.14	1396798.0
2014-06-09 14:00:00	MSFT	Stock	41.13	41.18	41.02	41.16	1719336.0
2014-06-09 15:00:00	MSFT	Stock	41.16	41.27	41.13	41.27	3533024.0
2014-06-09 16:00:00	MSFT	Stock	41.26	41.48	41.22	41.22	1396578.0
2014-06-09 17:00:00	MSFT	Stock	41.3	41.3	41.22	41.22	200.0
2014-06-09 19:00:00	MSFT	Stock	41.25	41.25	41.25	41.25	148.0
2014-06-09 09:00:00	NVDA	Stock	0.4763	0.4763	0.472	0.4758	25893480.0
2014-06-09 10:00:00	NVDA	Stock	0.4758	0.4778	0.4746	0.4775	31482240.0
2014-06-09 11:00:00	NVDA	Stock	0.4778	0.4793	0.4768	0.4784	23653000.0
2014-06-09 12:00:00	NVDA	Stock	0.4784	0.4798	0.4782	0.4794	24468760.0
2014-06-09 13:00:00	NVDA	Stock	0.4795	0.4808	0.4782	0.4793	44611480.0
2014-06-09 14:00:00	NVDA	Stock	0.4794	0.4795	0.4772	0.4775	21875960.0
2014-06-09 15:00:00	NVDA	Stock	0.4776	0.4785	0.4759	0.4763	66540200.0
2014-06-09 16:00:00	NVDA	Stock	0.4763	0.477	0.476	0.4763	6135240.0
2014-06-09 06:00:00	AMZN	Stock	16.51	16.51	16.51	16.51	2000.0
2014-06-09 07:00:00	AMZN	Stock	16.55	16.563	16.525	16.525	46320.0
2014-06-09 08:00:00	AMZN	Stock	16.5475	16.5875	16.45	16.57	387720.0
2014-06-09 09:00:00	AMZN	Stock	16.57	16.65	16.4101	16.5985	13697000.0
2014-06-09 10:00:00	AMZN	Stock	16.599	16.601	16.2825	16.3985	17631220.0
2014-06-09 11:00:00	AMZN	Stock	16.3985	16.5375	16.3835	16.5	6553260.0
2014-06-09 12:00:00	AMZN	Stock	16.5	16.5054	16.3956	16.4215	3475860.0
2014-06-09 13:00:00	AMZN	Stock	16.4259	16.4335	16.3505	16.367	3724660.0
2014-06-09 14:00:00	AMZN	Stock	16.36	16.3975	16.2945	16.391	5703800.0
2014-06-09 15:00:00	AMZN	Stock	16.391	16.4045	16.3485	16.375	5468120.0
2014-06-09 16:00:00	AMZN	Stock	16.375	16.4375	16.3505	16.375	1124120.0
2014-06-09 17:00:00	AMZN	Stock	16.362	16.373	16.3575	16.3575	24300.0
2014-06-09 18:00:00	AMZN	Stock	16.368	16.375	16.3575	16.3575	57480.0
2014-06-09 19:00:00	AMZN	Stock	16.3575	16.3725	16.3575	16.3725	7000.0

> showing 50 of 48,389 rows — these rows as CSV

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