PREVIEW / stock_30min / 2014-07-28

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-28.parquet
  size:    1.6 MB
  rows:    83,390
  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-28 04:00:00	AAPL	Stock	24.4	24.4	24.4	24.4	800.0
2014-07-28 05:00:00	AAPL	Stock	24.4525	24.4625	24.4525	24.4625	3760.0
2014-07-28 05:30:00	AAPL	Stock	24.4425	24.4425	24.4425	24.4425	9436.0
2014-07-28 06:00:00	AAPL	Stock	24.4375	24.4375	24.405	24.405	33952.0
2014-07-28 06:30:00	AAPL	Stock	24.4025	24.4025	24.4025	24.4025	400.0
2014-07-28 07:00:00	AAPL	Stock	24.4375	24.45	24.42	24.4375	74496.0
2014-07-28 07:30:00	AAPL	Stock	24.4425	24.45	24.42	24.425	36628.0
2014-07-28 08:00:00	AAPL	Stock	24.425	24.45	24.35	24.4475	255976.0
2014-07-28 08:30:00	AAPL	Stock	24.4425	24.4775	24.4375	24.47	369268.0
2014-07-28 09:00:00	AAPL	Stock	24.4675	24.495	24.45	24.455	437728.0
2014-07-28 09:30:00	AAPL	Stock	24.455	24.6	24.3875	24.53	35998328.0
2014-07-28 10:00:00	AAPL	Stock	24.5275	24.5425	24.3925	24.4773	16167440.0
2014-07-28 10:30:00	AAPL	Stock	24.4775	24.52	24.4	24.4785	11442256.0
2014-07-28 11:00:00	AAPL	Stock	24.482	24.5925	24.4675	24.5925	11807744.0
2014-07-28 11:30:00	AAPL	Stock	24.59	24.6	24.5425	24.5675	10156484.0
2014-07-28 12:00:00	AAPL	Stock	24.5675	24.615	24.505	24.523	8702816.0
2014-07-28 12:30:00	AAPL	Stock	24.525	24.63	24.5225	24.5948	9820864.0
2014-07-28 13:00:00	AAPL	Stock	24.5925	24.6425	24.58	24.6275	6700224.0
2014-07-28 13:30:00	AAPL	Stock	24.63	24.7175	24.63	24.6953	13877488.0
2014-07-28 14:00:00	AAPL	Stock	24.695	24.7288	24.6775	24.7135	8477780.0
2014-07-28 14:30:00	AAPL	Stock	24.7125	24.7625	24.6875	24.7575	13348076.0
2014-07-28 15:00:00	AAPL	Stock	24.7575	24.81	24.7275	24.74	16771688.0
2014-07-28 15:30:00	AAPL	Stock	24.74	24.77	24.7225	24.75	17989424.0
2014-07-28 16:00:00	AAPL	Stock	24.755	24.77	24.4225	24.7625	17762468.0
2014-07-28 16:30:00	AAPL	Stock	24.7625	24.7675	24.489	24.7575	222388.0
2014-07-28 17:00:00	AAPL	Stock	24.755	24.76	24.755	24.755	195612.0
2014-07-28 17:30:00	AAPL	Stock	24.7575	24.775	24.75	24.76	878536.0
2014-07-28 18:00:00	AAPL	Stock	24.76	24.7625	24.745	24.7575	179768.0
2014-07-28 18:30:00	AAPL	Stock	24.755	24.7575	24.7475	24.7575	44848.0
2014-07-28 19:00:00	AAPL	Stock	24.755	24.755	24.75	24.75	66116.0
2014-07-28 19:30:00	AAPL	Stock	24.755	24.7575	24.7375	24.7575	197768.0
2014-07-28 05:30:00	MSFT	Stock	44.49	44.49	44.33	44.33	400.0
2014-07-28 07:00:00	MSFT	Stock	44.34	44.34	44.34	44.34	500.0
2014-07-28 07:30:00	MSFT	Stock	44.35	44.36	44.35	44.36	300.0
2014-07-28 08:00:00	MSFT	Stock	44.4	44.45	44.34	44.45	2125.0
2014-07-28 08:30:00	MSFT	Stock	44.4	44.43	44.4	44.43	200.0
2014-07-28 09:00:00	MSFT	Stock	44.43	44.45	44.37	44.4	20925.0
2014-07-28 09:30:00	MSFT	Stock	44.36	44.51	44.28	44.32	2373227.0
2014-07-28 10:00:00	MSFT	Stock	44.31	44.312	44.02	44.065	2434333.0
2014-07-28 10:30:00	MSFT	Stock	44.061	44.22	44.03	44.05	1725938.0
2014-07-28 11:00:00	MSFT	Stock	44.05	44.33	44.03	44.32	1612834.0
2014-07-28 11:30:00	MSFT	Stock	44.32	44.42	44.225	44.225	1992203.0
2014-07-28 12:00:00	MSFT	Stock	44.23	44.25	44.16	44.16	868510.0
2014-07-28 12:30:00	MSFT	Stock	44.16	44.23	44.115	44.22	1237250.0
2014-07-28 13:00:00	MSFT	Stock	44.215	44.29	44.19	44.275	1172938.0
2014-07-28 13:30:00	MSFT	Stock	44.28	44.41	44.27	44.275	2197962.0
2014-07-28 14:00:00	MSFT	Stock	44.28	44.31	44.2	44.215	1662041.0
2014-07-28 14:30:00	MSFT	Stock	44.21	44.22	44.16	44.185	1237904.0
2014-07-28 15:00:00	MSFT	Stock	44.18	44.19	44.13	44.135	1537719.0
2014-07-28 15:30:00	MSFT	Stock	44.135	44.14	43.93	43.96	7185197.0

> showing 50 of 83,390 rows — these rows as CSV

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