PREVIEW / stock_30min / 2013-10-31

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-31.parquet
  size:    1.6 MB
  rows:    80,466
  symbols: 3,543

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-10-31 04:30:00	AAPL	Stock	18.6907	18.6907	18.6907	18.6907	2800.0
2013-10-31 05:30:00	AAPL	Stock	18.6939	18.6939	18.6939	18.6939	2800.0
2013-10-31 06:00:00	AAPL	Stock	18.7446	18.7464	18.7446	18.7464	25200.0
2013-10-31 07:00:00	AAPL	Stock	18.7239	18.7893	18.7239	18.7536	231812.0
2013-10-31 07:30:00	AAPL	Stock	18.7536	18.7629	18.75	18.7629	70000.0
2013-10-31 08:00:00	AAPL	Stock	18.7589	18.7857	18.7232	18.7836	402864.0
2013-10-31 08:30:00	AAPL	Stock	18.7679	18.7821	18.7429	18.7668	762916.0
2013-10-31 09:00:00	AAPL	Stock	18.7554	18.7679	18.7454	18.7504	1087772.0
2013-10-31 09:30:00	AAPL	Stock	18.75	18.7693	18.6168	18.6229	42689584.0
2013-10-31 10:00:00	AAPL	Stock	18.6211	18.7046	18.6207	18.6382	23055620.0
2013-10-31 10:30:00	AAPL	Stock	18.6368	18.7461	18.6321	18.7261	20329260.0
2013-10-31 11:00:00	AAPL	Stock	18.7225	18.8389	18.72	18.8164	24000872.0
2013-10-31 11:30:00	AAPL	Stock	18.8175	18.8279	18.7701	18.7701	11827732.0
2013-10-31 12:00:00	AAPL	Stock	18.77	18.8036	18.7375	18.7718	10980676.0
2013-10-31 12:30:00	AAPL	Stock	18.7732	18.8154	18.75	18.7529	9397500.0
2013-10-31 13:00:00	AAPL	Stock	18.7543	18.7714	18.6946	18.7407	13365688.0
2013-10-31 13:30:00	AAPL	Stock	18.7414	18.7446	18.6925	18.7124	7744968.0
2013-10-31 14:00:00	AAPL	Stock	18.7143	18.7721	18.7143	18.7536	9018716.0
2013-10-31 14:30:00	AAPL	Stock	18.755	18.7614	18.7065	18.7164	10010588.0
2013-10-31 15:00:00	AAPL	Stock	18.7114	18.7279	18.6943	18.6954	10673068.0
2013-10-31 15:30:00	AAPL	Stock	18.6968	18.7404	18.6543	18.6561	31084760.0
2013-10-31 16:00:00	AAPL	Stock	18.6561	18.7201	18.6479	18.6554	18943596.0
2013-10-31 16:30:00	AAPL	Stock	18.6568	18.7246	18.6521	18.6607	676620.0
2013-10-31 17:00:00	AAPL	Stock	18.6607	18.6639	18.6554	18.6607	383768.0
2013-10-31 17:30:00	AAPL	Stock	18.6607	18.6639	18.6607	18.6636	59836.0
2013-10-31 18:00:00	AAPL	Stock	18.6636	18.6693	18.6554	18.6554	98112.0
2013-10-31 18:30:00	AAPL	Stock	18.6693	18.6729	18.6646	18.6729	53200.0
2013-10-31 19:00:00	AAPL	Stock	18.6729	18.6764	18.67	18.6714	181272.0
2013-10-31 19:30:00	AAPL	Stock	18.6761	18.6786	18.6679	18.6786	176596.0
2013-10-31 08:00:00	MSFT	Stock	35.5	35.56	35.48	35.56	1800.0
2013-10-31 08:30:00	MSFT	Stock	35.56	35.56	35.56	35.56	1486.0
2013-10-31 09:00:00	MSFT	Stock	35.56	35.64	35.56	35.64	12863.0
2013-10-31 09:30:00	MSFT	Stock	35.64	35.68	35.34	35.45	4430358.0
2013-10-31 10:00:00	MSFT	Stock	35.45	35.62	35.41	35.6	2770470.0
2013-10-31 10:30:00	MSFT	Stock	35.6	35.69	35.52	35.64	3037680.0
2013-10-31 11:00:00	MSFT	Stock	35.64	35.67	35.55	35.58	1831595.0
2013-10-31 11:30:00	MSFT	Stock	35.58	35.65	35.58	35.585	1095995.0
2013-10-31 12:00:00	MSFT	Stock	35.585	35.64	35.55	35.585	1128830.0
2013-10-31 12:30:00	MSFT	Stock	35.585	35.63	35.5	35.53	1917182.0
2013-10-31 13:00:00	MSFT	Stock	35.525	35.55	35.51	35.53	1712789.0
2013-10-31 13:30:00	MSFT	Stock	35.52	35.55	35.51	35.525	864103.0
2013-10-31 14:00:00	MSFT	Stock	35.53	35.61	35.51	35.591	1518456.0
2013-10-31 14:30:00	MSFT	Stock	35.595	35.61	35.51	35.53	1774263.0
2013-10-31 15:00:00	MSFT	Stock	35.52	35.57	35.5	35.51	2574857.0
2013-10-31 15:30:00	MSFT	Stock	35.505	35.55	35.35	35.36	8249518.0
2013-10-31 16:00:00	MSFT	Stock	35.36	35.536	35.338	35.514	5287802.0
2013-10-31 16:30:00	MSFT	Stock	35.538	35.54	35.35	35.54	46387.0
2013-10-31 17:00:00	MSFT	Stock	35.35	35.42	35.35	35.42	67813.0
2013-10-31 18:00:00	MSFT	Stock	35.42	35.42	35.37	35.37	5280.0
2013-10-31 18:30:00	MSFT	Stock	35.39	35.39	35.39	35.39	1100.0

> showing 50 of 80,466 rows — these rows as CSV

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