PREVIEW / stock_1hour / 2014-11-13

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-11-13.parquet
  size:    1.0 MB
  rows:    48,700
  symbols: 3,538

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-13 04:00:00	AAPL	Stock	27.875	27.925	27.875	27.925	23272.0
2014-11-13 05:00:00	AAPL	Stock	27.9525	27.9525	27.9125	27.925	18792.0
2014-11-13 06:00:00	AAPL	Stock	27.95	27.9825	27.9075	27.9075	63368.0
2014-11-13 07:00:00	AAPL	Stock	27.925	27.9425	27.9075	27.9125	216520.0
2014-11-13 08:00:00	AAPL	Stock	27.9075	27.9375	27.62	27.9025	731880.0
2014-11-13 09:00:00	AAPL	Stock	27.905	28.175	27.8775	28.16	36522212.0
2014-11-13 10:00:00	AAPL	Stock	28.16	28.3625	28.1025	28.315	42817056.0
2014-11-13 11:00:00	AAPL	Stock	28.3125	28.32	28.1525	28.27	37320996.0
2014-11-13 12:00:00	AAPL	Stock	28.27	28.285	28.2175	28.27	17051048.0
2014-11-13 13:00:00	AAPL	Stock	28.27	28.275	28.045	28.1325	29865500.0
2014-11-13 14:00:00	AAPL	Stock	28.1325	28.2175	28.0575	28.175	16872308.0
2014-11-13 15:00:00	AAPL	Stock	28.1758	28.3075	28.1575	28.205	34552876.0
2014-11-13 16:00:00	AAPL	Stock	28.205	28.2448	28.0825	28.2	6158020.0
2014-11-13 17:00:00	AAPL	Stock	28.2025	28.21	28.1875	28.2	333512.0
2014-11-13 18:00:00	AAPL	Stock	28.1925	28.2125	28.185	28.2125	115220.0
2014-11-13 19:00:00	AAPL	Stock	28.2125	28.245	28.2125	28.245	153608.0
2014-11-13 05:00:00	MSFT	Stock	48.95	48.97	48.95	48.97	540.0
2014-11-13 06:00:00	MSFT	Stock	48.97	48.97	48.97	48.97	2100.0
2014-11-13 07:00:00	MSFT	Stock	48.93	48.93	48.93	48.93	100.0
2014-11-13 08:00:00	MSFT	Stock	48.95	48.95	48.8	48.82	2200.0
2014-11-13 09:00:00	MSFT	Stock	48.86	49.15	48.705	49.135	2966534.0
2014-11-13 10:00:00	MSFT	Stock	49.135	49.456	49.08	49.345	4456041.0
2014-11-13 11:00:00	MSFT	Stock	49.34	49.46	49.16	49.34	3234672.0
2014-11-13 12:00:00	MSFT	Stock	49.34	49.58	49.31	49.5	2129463.0
2014-11-13 13:00:00	MSFT	Stock	49.505	49.52	49.27	49.38	2516277.0
2014-11-13 14:00:00	MSFT	Stock	49.38	49.55	49.32	49.504	2370458.0
2014-11-13 15:00:00	MSFT	Stock	49.5	49.645	49.48	49.6	5964323.0
2014-11-13 16:00:00	MSFT	Stock	49.61	49.62	49.358	49.61	1635270.0
2014-11-13 17:00:00	MSFT	Stock	49.51	49.57	49.51	49.51	450.0
2014-11-13 18:00:00	MSFT	Stock	49.6	49.6	49.55	49.55	700.0
2014-11-13 19:00:00	MSFT	Stock	49.6	49.6	49.55	49.55	1340.0
2014-11-13 09:00:00	NVDA	Stock	0.492	0.4937	0.4894	0.4918	28596720.0
2014-11-13 10:00:00	NVDA	Stock	0.4918	0.4923	0.4885	0.4888	21367760.0
2014-11-13 11:00:00	NVDA	Stock	0.4888	0.4888	0.4848	0.487	21354560.0
2014-11-13 12:00:00	NVDA	Stock	0.487	0.489	0.4865	0.4884	20230640.0
2014-11-13 13:00:00	NVDA	Stock	0.4884	0.4889	0.4852	0.488	22250000.0
2014-11-13 14:00:00	NVDA	Stock	0.4879	0.489	0.4875	0.488	24914560.0
2014-11-13 15:00:00	NVDA	Stock	0.4881	0.4898	0.4879	0.489	44100840.0
2014-11-13 16:00:00	NVDA	Stock	0.4888	0.4888	0.4884	0.4884	39032720.0
2014-11-13 19:00:00	NVDA	Stock	0.4872	0.4872	0.487	0.4872	32000.0
2014-11-13 07:00:00	AMZN	Stock	15.685	15.6925	15.685	15.6925	5600.0
2014-11-13 08:00:00	AMZN	Stock	15.6275	15.6275	15.5755	15.5955	41880.0
2014-11-13 09:00:00	AMZN	Stock	15.5935	15.845	15.5755	15.7998	10685100.0
2014-11-13 10:00:00	AMZN	Stock	15.793	15.843	15.759	15.7605	10195760.0
2014-11-13 11:00:00	AMZN	Stock	15.76	15.7985	15.705	15.753	9386060.0
2014-11-13 12:00:00	AMZN	Stock	15.758	15.8945	15.733	15.8065	7592220.0
2014-11-13 13:00:00	AMZN	Stock	15.8065	15.8165	15.7145	15.771	7078080.0
2014-11-13 14:00:00	AMZN	Stock	15.771	15.8212	15.7395	15.769	6927040.0
2014-11-13 15:00:00	AMZN	Stock	15.771	15.8275	15.754	15.824	14769800.0
2014-11-13 16:00:00	AMZN	Stock	15.824	15.8272	15.771	15.771	381160.0

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

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