PREVIEW / stock_1hour / 2014-11-14

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-11-14.parquet
  size:    1.0 MB
  rows:    48,831
  symbols: 3,565

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-14 04:00:00	AAPL	Stock	28.215	28.2625	28.215	28.2625	18100.0
2014-11-14 05:00:00	AAPL	Stock	28.2475	28.2625	28.2475	28.2625	2800.0
2014-11-14 06:00:00	AAPL	Stock	28.2625	28.2625	28.215	28.26	54516.0
2014-11-14 07:00:00	AAPL	Stock	28.245	28.27	28.215	28.2475	147364.0
2014-11-14 08:00:00	AAPL	Stock	28.235	28.275	28.0625	28.2475	558452.0
2014-11-14 09:00:00	AAPL	Stock	28.2475	28.4075	28.2175	28.345	29372396.0
2014-11-14 10:00:00	AAPL	Stock	28.3425	28.5025	28.335	28.5	39616124.0
2014-11-14 11:00:00	AAPL	Stock	28.4975	28.5	28.43	28.45	16328720.0
2014-11-14 12:00:00	AAPL	Stock	28.45	28.52	28.4475	28.48	14621996.0
2014-11-14 13:00:00	AAPL	Stock	28.4775	28.5	28.44	28.4475	9935360.0
2014-11-14 14:00:00	AAPL	Stock	28.445	28.475	28.3975	28.4725	11803008.0
2014-11-14 15:00:00	AAPL	Stock	28.4725	28.5475	28.4675	28.5475	29080992.0
2014-11-14 16:00:00	AAPL	Stock	28.545	28.575	28.205	28.57	8984092.0
2014-11-14 17:00:00	AAPL	Stock	28.565	28.5825	28.545	28.5825	1727912.0
2014-11-14 18:00:00	AAPL	Stock	28.575	28.5825	28.545	28.5825	137408.0
2014-11-14 19:00:00	AAPL	Stock	28.575	28.6	28.575	28.6	121116.0
2014-11-14 07:00:00	MSFT	Stock	49.61	49.61	49.55	49.55	1742.0
2014-11-14 08:00:00	MSFT	Stock	49.53	49.6	49.51	49.6	6500.0
2014-11-14 09:00:00	MSFT	Stock	49.6	50.045	49.55	49.7	6026885.0
2014-11-14 10:00:00	MSFT	Stock	49.7	49.94	49.625	49.81	3345334.0
2014-11-14 11:00:00	MSFT	Stock	49.82	49.9	49.74	49.79	2999836.0
2014-11-14 12:00:00	MSFT	Stock	49.795	49.82	49.66	49.68	2153226.0
2014-11-14 13:00:00	MSFT	Stock	49.685	49.685	49.52	49.54	2263306.0
2014-11-14 14:00:00	MSFT	Stock	49.54	49.545	49.39	49.46	3272122.0
2014-11-14 15:00:00	MSFT	Stock	49.47	49.63	49.435	49.58	4889627.0
2014-11-14 16:00:00	MSFT	Stock	49.58	49.663	49.4	49.58	2850278.0
2014-11-14 17:00:00	MSFT	Stock	49.51	49.58	49.45	49.58	290996.0
2014-11-14 18:00:00	MSFT	Stock	49.57	49.58	49.57	49.58	6663.0
2014-11-14 08:00:00	NVDA	Stock	0.4838	0.4838	0.4838	0.4838	7000.0
2014-11-14 09:00:00	NVDA	Stock	0.4875	0.4892	0.4844	0.486	14510360.0
2014-11-14 10:00:00	NVDA	Stock	0.4858	0.4912	0.4856	0.4903	25188960.0
2014-11-14 11:00:00	NVDA	Stock	0.4905	0.4912	0.49	0.4905	10684040.0
2014-11-14 12:00:00	NVDA	Stock	0.4908	0.4915	0.4905	0.4912	9091000.0
2014-11-14 13:00:00	NVDA	Stock	0.4912	0.4925	0.4912	0.4915	10524400.0
2014-11-14 14:00:00	NVDA	Stock	0.4914	0.494	0.491	0.4935	14032280.0
2014-11-14 15:00:00	NVDA	Stock	0.4935	0.4948	0.4923	0.4946	54106520.0
2014-11-14 16:00:00	NVDA	Stock	0.4946	0.495	0.4912	0.4946	11880000.0
2014-11-14 17:00:00	NVDA	Stock	0.4946	0.4946	0.4945	0.4945	726160.0
2014-11-14 19:00:00	NVDA	Stock	0.4945	0.4945	0.4945	0.4945	6080.0
2014-11-14 08:00:00	AMZN	Stock	15.824	15.869	15.824	15.85	28280.0
2014-11-14 09:00:00	AMZN	Stock	15.85	16.1625	15.8201	16.1165	22050520.0
2014-11-14 10:00:00	AMZN	Stock	16.117	16.47	16.1164	16.4305	36869320.0
2014-11-14 11:00:00	AMZN	Stock	16.4365	16.4925	16.369	16.464	25651540.0
2014-11-14 12:00:00	AMZN	Stock	16.4625	16.644	16.4575	16.5275	22843940.0
2014-11-14 13:00:00	AMZN	Stock	16.5225	16.549	16.4	16.4035	13019140.0
2014-11-14 14:00:00	AMZN	Stock	16.4035	16.4785	16.354	16.4185	15167160.0
2014-11-14 15:00:00	AMZN	Stock	16.4181	16.4355	16.2435	16.3915	25709580.0
2014-11-14 16:00:00	AMZN	Stock	16.391	16.4044	16.3056	16.3755	4740720.0
2014-11-14 17:00:00	AMZN	Stock	16.3765	16.391	16.36	16.36	383380.0
2014-11-14 18:00:00	AMZN	Stock	16.375	16.375	16.3595	16.3595	19620.0

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

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