PREVIEW / stock_30min / 2013-03-15

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-03-15.parquet
  size:    1.5 MB
  rows:    78,982
  symbols: 3,466

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
2013-03-15 04:30:00	AAPL	Stock	15.4393	15.4393	15.4393	15.4393	6720.0
2013-03-15 05:00:00	AAPL	Stock	15.4554	15.4636	15.4554	15.4636	17080.0
2013-03-15 05:30:00	AAPL	Stock	15.4546	15.4629	15.4546	15.4629	43064.0
2013-03-15 06:00:00	AAPL	Stock	15.4643	15.5714	15.4643	15.5714	31052.0
2013-03-15 06:30:00	AAPL	Stock	15.5636	15.5707	15.5504	15.5707	38976.0
2013-03-15 07:00:00	AAPL	Stock	15.5771	15.6714	15.5771	15.6429	867944.0
2013-03-15 07:30:00	AAPL	Stock	15.6514	15.6639	15.6243	15.6304	795788.0
2013-03-15 08:00:00	AAPL	Stock	15.6257	15.6607	15.5804	15.6464	2434432.0
2013-03-15 08:30:00	AAPL	Stock	15.6496	15.705	15.6339	15.705	3258612.0
2013-03-15 09:00:00	AAPL	Stock	15.7068	15.7257	15.6254	15.6432	8750812.0
2013-03-15 09:30:00	AAPL	Stock	15.6404	15.8036	15.6161	15.7411	185576888.0
2013-03-15 10:00:00	AAPL	Stock	15.7389	15.7729	15.67	15.7325	63904792.0
2013-03-15 10:30:00	AAPL	Stock	15.7321	15.7636	15.6629	15.7179	42042868.0
2013-03-15 11:00:00	AAPL	Stock	15.715	15.745	15.7069	15.7246	22597456.0
2013-03-15 11:30:00	AAPL	Stock	15.7279	15.7554	15.7179	15.7464	18263784.0
2013-03-15 12:00:00	AAPL	Stock	15.7512	15.8214	15.7389	15.8164	29290240.0
2013-03-15 12:30:00	AAPL	Stock	15.8139	15.8482	15.7975	15.8176	31007844.0
2013-03-15 13:00:00	AAPL	Stock	15.8171	15.8654	15.805	15.852	22095304.0
2013-03-15 13:30:00	AAPL	Stock	15.85	15.858	15.825	15.8425	15762012.0
2013-03-15 14:00:00	AAPL	Stock	15.8396	15.8454	15.7475	15.7579	28004760.0
2013-03-15 14:30:00	AAPL	Stock	15.7564	15.7914	15.7321	15.7547	24034388.0
2013-03-15 15:00:00	AAPL	Stock	15.7557	15.7718	15.7182	15.7718	28067760.0
2013-03-15 15:30:00	AAPL	Stock	15.7721	15.8536	15.7525	15.8518	61870536.0
2013-03-15 16:00:00	AAPL	Stock	15.8518	15.875	15.7474	15.87	32267368.0
2013-03-15 16:30:00	AAPL	Stock	15.8679	15.8846	15.7392	15.8764	8345484.0
2013-03-15 17:00:00	AAPL	Stock	15.8793	15.8893	15.845	15.8786	827820.0
2013-03-15 17:30:00	AAPL	Stock	15.8786	15.9107	15.8757	15.9007	473256.0
2013-03-15 18:00:00	AAPL	Stock	15.9089	15.9089	15.8857	15.8868	278628.0
2013-03-15 18:30:00	AAPL	Stock	15.8857	15.8896	15.8839	15.8882	59192.0
2013-03-15 19:00:00	AAPL	Stock	15.8857	15.8929	15.8843	15.8929	358596.0
2013-03-15 19:30:00	AAPL	Stock	15.8893	15.9014	15.8893	15.8964	420308.0
2013-03-15 07:30:00	MSFT	Stock	28.24	28.24	28.24	28.24	100.0
2013-03-15 08:00:00	MSFT	Stock	28.27	28.27	28.06	28.06	8225.0
2013-03-15 08:30:00	MSFT	Stock	28.1	28.15	28.1	28.15	2500.0
2013-03-15 09:00:00	MSFT	Stock	28.15	28.15	28.01	28.08	130336.0
2013-03-15 09:30:00	MSFT	Stock	28.06	28.12	27.98	28.04	26573808.0
2013-03-15 10:00:00	MSFT	Stock	28.04	28.16	28.02	28.09	6570363.0
2013-03-15 10:30:00	MSFT	Stock	28.09	28.12	28.035	28.055	4691382.0
2013-03-15 11:00:00	MSFT	Stock	28.05	28.07	28.02	28.06	4611120.0
2013-03-15 11:30:00	MSFT	Stock	28.05	28.06	28.035	28.048	2003235.0
2013-03-15 12:00:00	MSFT	Stock	28.04	28.07	28.03	28.04	3229770.0
2013-03-15 12:30:00	MSFT	Stock	28.045	28.07	28.04	28.045	1600383.0
2013-03-15 13:00:00	MSFT	Stock	28.05	28.105	28.04	28.07	3683497.0
2013-03-15 13:30:00	MSFT	Stock	28.07	28.095	28.04	28.04	1226932.0
2013-03-15 14:00:00	MSFT	Stock	28.04	28.06	28.04	28.04	3937592.0
2013-03-15 14:30:00	MSFT	Stock	28.04	28.05	28.03	28.04	3426048.0
2013-03-15 15:00:00	MSFT	Stock	28.05	28.07	28.04	28.04	4871917.0
2013-03-15 15:30:00	MSFT	Stock	28.05	28.07	28.03	28.06	9800883.0
2013-03-15 16:00:00	MSFT	Stock	28.04	28.15	28.02	28.084	12612727.0
2013-03-15 16:30:00	MSFT	Stock	28.072	28.076	28.0	28.07	910717.0

> showing 50 of 78,982 rows — these rows as CSV

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