PREVIEW / stock_30min / 2014-07-10

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-10.parquet
  size:    1.6 MB
  rows:    83,724
  symbols: 3,577

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-10 04:00:00	AAPL	Stock	23.845	23.845	23.795	23.795	2000.0
2014-07-10 04:30:00	AAPL	Stock	23.7925	23.7925	23.7	23.7	13392.0
2014-07-10 05:00:00	AAPL	Stock	23.715	23.7225	23.68	23.68	8256.0
2014-07-10 05:30:00	AAPL	Stock	23.69	23.695	23.6075	23.6175	59608.0
2014-07-10 06:00:00	AAPL	Stock	23.5825	23.6	23.4375	23.5025	83580.0
2014-07-10 06:30:00	AAPL	Stock	23.515	23.5375	23.4625	23.4925	86632.0
2014-07-10 07:00:00	AAPL	Stock	23.4925	23.5125	23.45	23.5025	255352.0
2014-07-10 07:30:00	AAPL	Stock	23.5	23.5225	23.475	23.4875	187920.0
2014-07-10 08:00:00	AAPL	Stock	23.49	23.5225	23.4375	23.4975	997640.0
2014-07-10 08:30:00	AAPL	Stock	23.4975	23.5175	23.4425	23.45	792456.0
2014-07-10 09:00:00	AAPL	Stock	23.45	23.48	23.4025	23.425	1188132.0
2014-07-10 09:30:00	AAPL	Stock	23.44	23.5975	23.38	23.55	32627140.0
2014-07-10 10:00:00	AAPL	Stock	23.5475	23.685	23.515	23.64	16325300.0
2014-07-10 10:30:00	AAPL	Stock	23.64	23.6525	23.5825	23.63	8895648.0
2014-07-10 11:00:00	AAPL	Stock	23.63	23.6675	23.5975	23.64	7280280.0
2014-07-10 11:30:00	AAPL	Stock	23.64	23.6625	23.6	23.6475	5330996.0
2014-07-10 12:00:00	AAPL	Stock	23.645	23.735	23.625	23.7325	6591864.0
2014-07-10 12:30:00	AAPL	Stock	23.7325	23.735	23.6725	23.72	4709648.0
2014-07-10 13:00:00	AAPL	Stock	23.72	23.855	23.7125	23.8415	8494948.0
2014-07-10 13:30:00	AAPL	Stock	23.8425	23.8725	23.7825	23.815	7535064.0
2014-07-10 14:00:00	AAPL	Stock	23.8155	23.8875	23.8075	23.8758	7017232.0
2014-07-10 14:30:00	AAPL	Stock	23.8775	23.88	23.775	23.7762	7228796.0
2014-07-10 15:00:00	AAPL	Stock	23.775	23.7925	23.7425	23.7812	7427652.0
2014-07-10 15:30:00	AAPL	Stock	23.7775	23.795	23.735	23.7575	12291192.0
2014-07-10 16:00:00	AAPL	Stock	23.7575	23.7722	23.6375	23.725	5002236.0
2014-07-10 16:30:00	AAPL	Stock	23.754	23.7998	23.7175	23.7375	187876.0
2014-07-10 17:00:00	AAPL	Stock	23.73	23.76	23.715	23.73	91504.0
2014-07-10 17:30:00	AAPL	Stock	23.73	23.73	23.72	23.72	7792.0
2014-07-10 18:00:00	AAPL	Stock	23.72	23.7275	23.7125	23.7225	48812.0
2014-07-10 18:30:00	AAPL	Stock	23.725	23.725	23.7075	23.7225	53116.0
2014-07-10 19:00:00	AAPL	Stock	23.7225	23.7425	23.7125	23.725	16240.0
2014-07-10 19:30:00	AAPL	Stock	23.725	23.735	23.715	23.72	42440.0
2014-07-10 05:00:00	MSFT	Stock	41.49	41.5	41.49	41.5	700.0
2014-07-10 06:30:00	MSFT	Stock	41.45	41.45	41.45	41.45	100.0
2014-07-10 07:30:00	MSFT	Stock	41.3	41.31	41.28	41.28	500.0
2014-07-10 08:00:00	MSFT	Stock	41.3	41.45	41.27	41.41	3633.0
2014-07-10 08:30:00	MSFT	Stock	41.41	41.42	41.36	41.36	26364.0
2014-07-10 09:00:00	MSFT	Stock	41.35	41.47	41.3	41.44	13745.0
2014-07-10 09:30:00	MSFT	Stock	41.37	41.61	41.05	41.34	4250350.0
2014-07-10 10:00:00	MSFT	Stock	41.35	41.65	41.34	41.63	1318038.0
2014-07-10 10:30:00	MSFT	Stock	41.63	41.76	41.565	41.75	1541139.0
2014-07-10 11:00:00	MSFT	Stock	41.755	41.855	41.65	41.662	1268308.0
2014-07-10 11:30:00	MSFT	Stock	41.665	41.77	41.65	41.735	1208227.0
2014-07-10 12:00:00	MSFT	Stock	41.735	41.87	41.71	41.86	744878.0
2014-07-10 12:30:00	MSFT	Stock	41.87	41.89	41.77	41.81	730039.0
2014-07-10 13:00:00	MSFT	Stock	41.81	41.98	41.8	41.97	797689.0
2014-07-10 13:30:00	MSFT	Stock	41.97	42.0	41.89	41.91	1057441.0
2014-07-10 14:00:00	MSFT	Stock	41.9	41.95	41.89	41.94	699486.0
2014-07-10 14:30:00	MSFT	Stock	41.95	41.97	41.796	41.796	1307190.0
2014-07-10 15:00:00	MSFT	Stock	41.79	41.815	41.71	41.795	1447489.0

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

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