PREVIEW / stock_30min / 2014-07-17

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-17.parquet
  size:    1.6 MB
  rows:    82,661
  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-17 04:00:00	AAPL	Stock	23.7875	23.7875	23.6975	23.7225	21200.0
2014-07-17 04:30:00	AAPL	Stock	23.7225	23.7225	23.7225	23.7225	1600.0
2014-07-17 05:00:00	AAPL	Stock	23.72	23.72	23.72	23.72	1600.0
2014-07-17 05:30:00	AAPL	Stock	23.72	23.72	23.7075	23.7075	6400.0
2014-07-17 06:00:00	AAPL	Stock	23.725	23.725	23.665	23.6925	39272.0
2014-07-17 06:30:00	AAPL	Stock	23.69	23.69	23.625	23.635	17860.0
2014-07-17 07:00:00	AAPL	Stock	23.6375	23.74	23.61	23.625	74144.0
2014-07-17 07:30:00	AAPL	Stock	23.625	23.65	23.62	23.6275	61744.0
2014-07-17 08:00:00	AAPL	Stock	23.6475	23.6925	23.6	23.6925	232228.0
2014-07-17 08:30:00	AAPL	Stock	23.6925	23.78	23.6925	23.75	369844.0
2014-07-17 09:00:00	AAPL	Stock	23.7475	23.775	23.7025	23.755	443716.0
2014-07-17 09:30:00	AAPL	Stock	23.7575	23.8198	23.64	23.68	24069388.0
2014-07-17 10:00:00	AAPL	Stock	23.68	23.7225	23.515	23.6075	20178752.0
2014-07-17 10:30:00	AAPL	Stock	23.6097	23.6975	23.5475	23.6625	10616652.0
2014-07-17 11:00:00	AAPL	Stock	23.6625	23.6625	23.4925	23.5	11652744.0
2014-07-17 11:30:00	AAPL	Stock	23.5	23.6025	23.3875	23.41	14862056.0
2014-07-17 12:00:00	AAPL	Stock	23.4125	23.475	23.2675	23.4338	20641548.0
2014-07-17 12:30:00	AAPL	Stock	23.435	23.4435	23.365	23.3888	8538684.0
2014-07-17 13:00:00	AAPL	Stock	23.39	23.495	23.3775	23.4325	8897064.0
2014-07-17 13:30:00	AAPL	Stock	23.4375	23.455	23.3625	23.3843	8035488.0
2014-07-17 14:00:00	AAPL	Stock	23.385	23.3922	23.3	23.3105	9772612.0
2014-07-17 14:30:00	AAPL	Stock	23.3112	23.435	23.3112	23.3475	10351728.0
2014-07-17 15:00:00	AAPL	Stock	23.3475	23.3475	23.24	23.2805	16367472.0
2014-07-17 15:30:00	AAPL	Stock	23.2812	23.3375	23.1425	23.27	33900508.0
2014-07-17 16:00:00	AAPL	Stock	23.27	23.4152	23.2675	23.3125	6706096.0
2014-07-17 16:30:00	AAPL	Stock	23.315	23.315	23.2675	23.2875	637560.0
2014-07-17 17:00:00	AAPL	Stock	23.29	23.3	23.2625	23.275	674588.0
2014-07-17 17:30:00	AAPL	Stock	23.2725	23.4375	23.255	23.2875	59808.0
2014-07-17 18:00:00	AAPL	Stock	23.295	23.3125	23.255	23.255	129632.0
2014-07-17 18:30:00	AAPL	Stock	23.2525	23.27	23.2	23.215	270876.0
2014-07-17 19:00:00	AAPL	Stock	23.235	23.24	23.2025	23.2325	66492.0
2014-07-17 19:30:00	AAPL	Stock	23.225	23.24	23.2	23.225	171604.0
2014-07-17 07:00:00	MSFT	Stock	43.85	43.89	43.85	43.88	3370.0
2014-07-17 08:00:00	MSFT	Stock	43.85	45.05	43.8	44.91	1417569.0
2014-07-17 08:30:00	MSFT	Stock	44.93	45.56	44.85	45.34	2851283.0
2014-07-17 09:00:00	MSFT	Stock	45.34	45.8	45.29	45.47	2785170.0
2014-07-17 09:30:00	MSFT	Stock	45.45	45.71	45.22	45.27	17473028.0
2014-07-17 10:00:00	MSFT	Stock	45.28	45.44	45.02	45.105	9854423.0
2014-07-17 10:30:00	MSFT	Stock	45.1	45.13	44.61	44.611	8560677.0
2014-07-17 11:00:00	MSFT	Stock	44.61	44.65	44.29	44.375	5844302.0
2014-07-17 11:30:00	MSFT	Stock	44.37	44.54	44.31	44.38	4309603.0
2014-07-17 12:00:00	MSFT	Stock	44.385	44.46	44.25	44.45	2665895.0
2014-07-17 12:30:00	MSFT	Stock	44.44	44.82	44.39	44.765	3282992.0
2014-07-17 13:00:00	MSFT	Stock	44.77	44.97	44.7	44.84	2853900.0
2014-07-17 13:30:00	MSFT	Stock	44.85	44.95	44.8	44.86	2312195.0
2014-07-17 14:00:00	MSFT	Stock	44.855	44.86	44.66	44.72	2212999.0
2014-07-17 14:30:00	MSFT	Stock	44.722	44.76	44.6	44.68	2055542.0
2014-07-17 15:00:00	MSFT	Stock	44.685	44.785	44.54	44.57	3377904.0
2014-07-17 15:30:00	MSFT	Stock	44.575	44.6	44.3	44.54	6430689.0
2014-07-17 16:00:00	MSFT	Stock	44.53	44.906	44.511	44.59	1884521.0

> showing 50 of 82,661 rows — these rows as CSV

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