PREVIEW / stock_30min / 2013-08-22

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-22.parquet
  size:    1.3 MB
  rows:    69,825
  symbols: 3,505

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-08-22 04:00:00	AAPL	Stock	17.9771	18.0475	17.9771	18.0475	27160.0
2013-08-22 04:30:00	AAPL	Stock	18.0	18.0	18.0	18.0	2800.0
2013-08-22 05:00:00	AAPL	Stock	18.0225	18.0225	18.0225	18.0225	2800.0
2013-08-22 05:30:00	AAPL	Stock	18.0321	18.0321	18.0268	18.0268	23800.0
2013-08-22 06:30:00	AAPL	Stock	18.0311	18.0321	18.0311	18.0321	18872.0
2013-08-22 07:00:00	AAPL	Stock	18.0075	18.0268	17.9946	18.0214	196504.0
2013-08-22 07:30:00	AAPL	Stock	18.0264	18.0671	18.0264	18.0604	176792.0
2013-08-22 08:00:00	AAPL	Stock	18.0571	18.0571	17.9846	18.0014	815024.0
2013-08-22 08:30:00	AAPL	Stock	18.0036	18.0493	17.9986	18.0493	594328.0
2013-08-22 09:00:00	AAPL	Stock	18.0482	18.0493	18.0179	18.0354	1197084.0
2013-08-22 09:30:00	AAPL	Stock	18.03	18.0568	17.8982	17.9296	54922336.0
2013-08-22 10:00:00	AAPL	Stock	17.9296	17.9739	17.8889	17.9307	30475032.0
2013-08-22 10:30:00	AAPL	Stock	17.9343	17.9911	17.9304	17.9523	15449616.0
2013-08-22 11:00:00	AAPL	Stock	17.955	17.9711	17.915	17.9293	15435952.0
2013-08-22 11:30:00	AAPL	Stock	17.9318	17.9464	17.8168	17.8454	28162204.0
2013-08-22 12:00:00	AAPL	Stock	17.8454	17.8518	17.7929	17.8214	14065744.0
2013-08-22 12:30:00	AAPL	Stock	17.8218	17.8218	17.8218	17.8218	17500.0
2013-08-22 13:00:00	AAPL	Stock	17.8214	17.8214	17.8214	17.8214	2800.0
2013-08-22 15:00:00	AAPL	Stock	17.8929	17.9482	17.8225	17.8825	11990384.0
2013-08-22 15:30:00	AAPL	Stock	17.8807	18.0036	17.8225	17.9629	55915860.0
2013-08-22 16:00:00	AAPL	Stock	17.9629	17.9821	17.9134	17.9679	12161492.0
2013-08-22 16:30:00	AAPL	Stock	17.9664	17.975	17.9625	17.9714	328748.0
2013-08-22 17:00:00	AAPL	Stock	17.9746	17.9807	17.9629	17.9786	168952.0
2013-08-22 17:30:00	AAPL	Stock	17.9821	17.9821	17.975	17.9779	70000.0
2013-08-22 18:00:00	AAPL	Stock	17.9754	17.9832	17.9696	17.9821	209524.0
2013-08-22 18:30:00	AAPL	Stock	17.9821	17.9875	17.9707	17.9707	241696.0
2013-08-22 19:00:00	AAPL	Stock	17.9811	17.9821	17.975	17.9821	120316.0
2013-08-22 19:30:00	AAPL	Stock	17.9821	17.9875	17.9761	17.9875	140560.0
2013-08-22 06:00:00	MSFT	Stock	32.0	32.0	31.99	32.0	9843.0
2013-08-22 06:30:00	MSFT	Stock	31.9	32.04	31.9	32.04	17700.0
2013-08-22 07:00:00	MSFT	Stock	32.0	32.08	32.0	32.08	34001.0
2013-08-22 07:30:00	MSFT	Stock	32.02	32.14	32.01	32.1	17800.0
2013-08-22 08:00:00	MSFT	Stock	32.1	32.1	32.01	32.03	22719.0
2013-08-22 08:30:00	MSFT	Stock	32.03	32.22	32.03	32.19	39558.0
2013-08-22 09:00:00	MSFT	Stock	32.19	32.2	32.1	32.2	66856.0
2013-08-22 09:30:00	MSFT	Stock	32.19	32.3	32.1	32.255	6024936.0
2013-08-22 10:00:00	MSFT	Stock	32.26	32.34	32.2	32.34	3332605.0
2013-08-22 10:30:00	MSFT	Stock	32.33	32.49	32.33	32.383	3512316.0
2013-08-22 11:00:00	MSFT	Stock	32.38	32.4	32.302	32.35	2671723.0
2013-08-22 11:30:00	MSFT	Stock	32.34	32.36	32.27	32.36	2123568.0
2013-08-22 12:00:00	MSFT	Stock	32.328	32.37	32.27	32.299	1388693.0
2013-08-22 15:00:00	MSFT	Stock	32.25	32.36	32.13	32.3	886497.0
2013-08-22 15:30:00	MSFT	Stock	32.31	32.46	32.29	32.39	6975061.0
2013-08-22 16:00:00	MSFT	Stock	32.39	32.397	32.313	32.343	3686264.0
2013-08-22 16:30:00	MSFT	Stock	32.39	32.39	32.29	32.3	53643.0
2013-08-22 17:00:00	MSFT	Stock	32.35	32.4	32.29	32.4	28450.0
2013-08-22 18:00:00	MSFT	Stock	32.39	32.39	32.39	32.39	300.0
2013-08-22 18:30:00	MSFT	Stock	32.36	32.39	32.36	32.39	1975.0
2013-08-22 19:00:00	MSFT	Stock	32.39	32.4	32.39	32.4	1600.0
2013-08-22 19:30:00	MSFT	Stock	32.39	32.39	32.39	32.39	505.0

> showing 50 of 69,825 rows — these rows as CSV

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