PREVIEW / stock_30min / 2013-10-16

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-16.parquet
  size:    1.6 MB
  rows:    82,209
  symbols: 3,558

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-16 04:00:00	AAPL	Stock	17.7514	17.8611	17.7211	17.7232	224868.0
2013-10-16 04:30:00	AAPL	Stock	17.7318	17.7404	17.7232	17.7404	90580.0
2013-10-16 05:00:00	AAPL	Stock	17.75	17.7782	17.7429	17.7564	204708.0
2013-10-16 05:30:00	AAPL	Stock	17.7746	17.7843	17.7325	17.7325	140224.0
2013-10-16 06:00:00	AAPL	Stock	17.75	17.7761	17.7321	17.75	155764.0
2013-10-16 06:30:00	AAPL	Stock	17.75	17.7979	17.7236	17.7979	277172.0
2013-10-16 07:00:00	AAPL	Stock	17.7989	17.9286	17.7914	17.8929	1084832.0
2013-10-16 07:30:00	AAPL	Stock	17.9029	17.9107	17.8807	17.8868	1066492.0
2013-10-16 08:00:00	AAPL	Stock	17.8829	17.9318	17.75	17.9129	1702512.0
2013-10-16 08:30:00	AAPL	Stock	17.9129	17.9204	17.8929	17.9011	1367016.0
2013-10-16 09:00:00	AAPL	Stock	17.905	17.9107	17.8807	17.8836	2263128.0
2013-10-16 09:30:00	AAPL	Stock	17.8836	17.9475	17.8296	17.8371	59400236.0
2013-10-16 10:00:00	AAPL	Stock	17.8371	17.9068	17.8346	17.8893	29196608.0
2013-10-16 10:30:00	AAPL	Stock	17.8893	17.8893	17.8336	17.8689	16629228.0
2013-10-16 11:00:00	AAPL	Stock	17.8728	17.8879	17.8486	17.8796	12470836.0
2013-10-16 11:30:00	AAPL	Stock	17.8754	17.8929	17.8696	17.8839	10369408.0
2013-10-16 12:00:00	AAPL	Stock	17.885	17.9286	17.8786	17.9086	14883792.0
2013-10-16 12:30:00	AAPL	Stock	17.9111	17.9229	17.8714	17.9146	12870032.0
2013-10-16 13:00:00	AAPL	Stock	17.9139	17.9286	17.8882	17.9068	11047428.0
2013-10-16 13:30:00	AAPL	Stock	17.9068	17.9232	17.8782	17.8782	11020212.0
2013-10-16 14:00:00	AAPL	Stock	17.8782	17.8989	17.8754	17.8859	10113404.0
2013-10-16 14:30:00	AAPL	Stock	17.8864	17.9125	17.8804	17.8984	10909808.0
2013-10-16 15:00:00	AAPL	Stock	17.8979	17.915	17.8868	17.8946	8648696.0
2013-10-16 15:30:00	AAPL	Stock	17.8939	17.9143	17.8775	17.8957	21417452.0
2013-10-16 16:00:00	AAPL	Stock	17.8971	17.9066	17.7854	17.8589	8752156.0
2013-10-16 16:30:00	AAPL	Stock	17.8568	17.8971	17.8568	17.8571	359212.0
2013-10-16 17:00:00	AAPL	Stock	17.8561	17.86	17.8518	17.8571	136920.0
2013-10-16 17:30:00	AAPL	Stock	17.8571	17.8969	17.8571	17.8969	521248.0
2013-10-16 18:00:00	AAPL	Stock	17.8661	17.8971	17.8625	17.8679	140000.0
2013-10-16 18:30:00	AAPL	Stock	17.875	17.8782	17.8679	17.8782	33600.0
2013-10-16 19:00:00	AAPL	Stock	17.8779	17.8839	17.875	17.8839	104160.0
2013-10-16 19:30:00	AAPL	Stock	17.8821	17.895	17.8796	17.8911	499884.0
2013-10-16 05:00:00	MSFT	Stock	34.34	34.34	34.33	34.33	649.0
2013-10-16 06:00:00	MSFT	Stock	34.47	34.47	34.36	34.36	320.0
2013-10-16 07:00:00	MSFT	Stock	34.46	34.5	34.46	34.5	2249.0
2013-10-16 07:30:00	MSFT	Stock	34.49	34.5	34.47	34.5	1000.0
2013-10-16 08:00:00	MSFT	Stock	34.55	34.6	34.55	34.6	2400.0
2013-10-16 08:30:00	MSFT	Stock	34.6	34.67	34.49	34.67	4945.0
2013-10-16 09:00:00	MSFT	Stock	34.62	34.68	34.56	34.6	6700.0
2013-10-16 09:30:00	MSFT	Stock	34.6	34.86	34.56	34.757	6170164.0
2013-10-16 10:00:00	MSFT	Stock	34.755	34.81	34.57	34.73	4719021.0
2013-10-16 10:30:00	MSFT	Stock	34.73	34.81	34.69	34.79	2937328.0
2013-10-16 11:00:00	MSFT	Stock	34.78	34.895	34.76	34.84	2566124.0
2013-10-16 11:30:00	MSFT	Stock	34.835	34.855	34.775	34.823	1651745.0
2013-10-16 12:00:00	MSFT	Stock	34.825	34.875	34.755	34.81	1776054.0
2013-10-16 12:30:00	MSFT	Stock	34.81	34.865	34.78	34.803	1476741.0
2013-10-16 13:00:00	MSFT	Stock	34.805	34.82	34.68	34.729	1759449.0
2013-10-16 13:30:00	MSFT	Stock	34.724	34.75	34.68	34.69	936235.0
2013-10-16 14:00:00	MSFT	Stock	34.69	34.73	34.655	34.67	1127094.0
2013-10-16 14:30:00	MSFT	Stock	34.675	34.73	34.66	34.68	1325893.0

> showing 50 of 82,209 rows — these rows as CSV

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