PREVIEW / stock_1hour / 2014-11-17

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-11-17.parquet
  size:    1.1 MB
  rows:    50,520
  symbols: 3,567

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-17 04:00:00	AAPL	Stock	28.475	28.545	28.4625	28.49	48296.0
2014-11-17 05:00:00	AAPL	Stock	28.49	28.5	28.43	28.4625	107784.0
2014-11-17 06:00:00	AAPL	Stock	28.465	28.5	28.4625	28.5	55856.0
2014-11-17 07:00:00	AAPL	Stock	28.5	28.57	28.4625	28.5375	245732.0
2014-11-17 08:00:00	AAPL	Stock	28.55	28.67	28.405	28.655	973824.0
2014-11-17 09:00:00	AAPL	Stock	28.6675	28.7375	28.5	28.6775	31114852.0
2014-11-17 10:00:00	AAPL	Stock	28.68	28.7725	28.5625	28.6072	40486804.0
2014-11-17 11:00:00	AAPL	Stock	28.6095	28.6162	28.325	28.4362	33947324.0
2014-11-17 12:00:00	AAPL	Stock	28.435	28.6075	28.3825	28.4825	18226240.0
2014-11-17 13:00:00	AAPL	Stock	28.4825	28.5525	28.45	28.475	14135368.0
2014-11-17 14:00:00	AAPL	Stock	28.475	28.545	28.465	28.524	10728548.0
2014-11-17 15:00:00	AAPL	Stock	28.525	28.55	28.47	28.5	19255032.0
2014-11-17 16:00:00	AAPL	Stock	28.4975	28.569	28.4525	28.4675	6437408.0
2014-11-17 17:00:00	AAPL	Stock	28.4625	28.5155	28.46	28.4975	87088.0
2014-11-17 18:00:00	AAPL	Stock	28.47	28.4975	28.4525	28.4575	77912.0
2014-11-17 19:00:00	AAPL	Stock	28.45	28.46	28.4325	28.4325	94988.0
2014-11-17 05:00:00	MSFT	Stock	49.49	49.49	49.49	49.49	100.0
2014-11-17 06:00:00	MSFT	Stock	49.31	49.44	49.31	49.44	1700.0
2014-11-17 07:00:00	MSFT	Stock	49.38	49.38	49.38	49.38	650.0
2014-11-17 08:00:00	MSFT	Stock	49.49	49.58	49.38	49.58	13870.0
2014-11-17 09:00:00	MSFT	Stock	49.53	49.53	49.14	49.205	2700253.0
2014-11-17 10:00:00	MSFT	Stock	49.2	49.45	49.16	49.315	3945010.0
2014-11-17 11:00:00	MSFT	Stock	49.315	49.355	49.24	49.33	2882577.0
2014-11-17 12:00:00	MSFT	Stock	49.33	49.705	49.305	49.58	4578289.0
2014-11-17 13:00:00	MSFT	Stock	49.58	49.63	49.511	49.57	2136036.0
2014-11-17 14:00:00	MSFT	Stock	49.575	49.58	49.48	49.495	3132929.0
2014-11-17 15:00:00	MSFT	Stock	49.495	49.51	49.38	49.47	5843820.0
2014-11-17 16:00:00	MSFT	Stock	49.47	49.5	49.39	49.5	3466606.0
2014-11-17 17:00:00	MSFT	Stock	49.5	49.521	49.43	49.46	6464.0
2014-11-17 18:00:00	MSFT	Stock	49.48	49.48	49.48	49.48	1350.0
2014-11-17 19:00:00	MSFT	Stock	49.49	49.49	49.48	49.48	1701.0
2014-11-17 04:00:00	NVDA	Stock	0.4945	0.4945	0.4945	0.4945	8000.0
2014-11-17 08:00:00	NVDA	Stock	0.4942	0.4942	0.4942	0.4942	4000.0
2014-11-17 09:00:00	NVDA	Stock	0.4925	0.4978	0.4918	0.496	23373080.0
2014-11-17 10:00:00	NVDA	Stock	0.496	0.4963	0.491	0.4915	21933840.0
2014-11-17 11:00:00	NVDA	Stock	0.4916	0.4935	0.4892	0.4932	27833400.0
2014-11-17 12:00:00	NVDA	Stock	0.4932	0.4945	0.4926	0.4938	10362680.0
2014-11-17 13:00:00	NVDA	Stock	0.4939	0.4952	0.4938	0.4946	8182200.0
2014-11-17 14:00:00	NVDA	Stock	0.4945	0.4959	0.4942	0.4958	15057880.0
2014-11-17 15:00:00	NVDA	Stock	0.4958	0.4963	0.492	0.4925	40425800.0
2014-11-17 16:00:00	NVDA	Stock	0.4924	0.4946	0.4923	0.4936	2326360.0
2014-11-17 04:00:00	AMZN	Stock	16.325	16.325	16.325	16.325	6000.0
2014-11-17 07:00:00	AMZN	Stock	16.3125	16.3125	16.261	16.3015	19160.0
2014-11-17 08:00:00	AMZN	Stock	16.31	16.344	16.256	16.344	229060.0
2014-11-17 09:00:00	AMZN	Stock	16.3315	16.4	16.1825	16.213	14157880.0
2014-11-17 10:00:00	AMZN	Stock	16.2095	16.2325	16.0025	16.033	19977120.0
2014-11-17 11:00:00	AMZN	Stock	16.0342	16.043	15.9015	15.9825	16745660.0
2014-11-17 12:00:00	AMZN	Stock	15.979	16.1075	15.9285	16.0455	10086280.0
2014-11-17 13:00:00	AMZN	Stock	16.0433	16.114	16.0345	16.0618	5099500.0
2014-11-17 14:00:00	AMZN	Stock	16.06	16.1365	16.054	16.1255	6583220.0

> showing 50 of 50,520 rows — these rows as CSV

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