PREVIEW / stock_30min / 2013-07-09

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-09.parquet
  size:    1.5 MB
  rows:    79,759
  symbols: 3,519

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-07-09 04:00:00	AAPL	Stock	14.8564	14.8564	14.8432	14.85	20356.0
2013-07-09 05:00:00	AAPL	Stock	14.8482	14.8482	14.8482	14.8482	2800.0
2013-07-09 06:30:00	AAPL	Stock	14.8257	14.8286	14.8146	14.8146	45276.0
2013-07-09 07:00:00	AAPL	Stock	14.8164	14.8282	14.8054	14.8071	56448.0
2013-07-09 07:30:00	AAPL	Stock	14.8071	14.8082	14.7793	14.7964	116424.0
2013-07-09 08:00:00	AAPL	Stock	14.7975	14.8571	14.7818	14.8107	492772.0
2013-07-09 08:30:00	AAPL	Stock	14.8204	14.8479	14.8125	14.8389	287448.0
2013-07-09 09:00:00	AAPL	Stock	14.8414	14.8446	14.7639	14.77	641424.0
2013-07-09 09:30:00	AAPL	Stock	14.7714	14.8679	14.6564	14.8089	65872128.0
2013-07-09 10:00:00	AAPL	Stock	14.8096	14.885	14.79	14.8289	39823700.0
2013-07-09 10:30:00	AAPL	Stock	14.8286	14.8893	14.8137	14.8654	19786676.0
2013-07-09 11:00:00	AAPL	Stock	14.8675	14.9857	14.8457	14.9789	28905716.0
2013-07-09 11:30:00	AAPL	Stock	14.9793	15.0125	14.9504	14.9682	24494624.0
2013-07-09 12:00:00	AAPL	Stock	14.9668	14.9896	14.9543	14.979	10126368.0
2013-07-09 12:30:00	AAPL	Stock	14.9779	15.0112	14.9515	14.9643	10760260.0
2013-07-09 13:00:00	AAPL	Stock	14.9711	14.995	14.9589	14.9761	8175776.0
2013-07-09 13:30:00	AAPL	Stock	14.9786	14.9849	14.9311	14.9761	11219320.0
2013-07-09 14:00:00	AAPL	Stock	14.9768	15.0782	14.9715	15.0546	26365220.0
2013-07-09 14:30:00	AAPL	Stock	15.0571	15.1143	15.0571	15.0796	24872204.0
2013-07-09 15:00:00	AAPL	Stock	15.0796	15.125	15.0596	15.1071	17303636.0
2013-07-09 15:30:00	AAPL	Stock	15.1071	15.1179	15.0464	15.0757	31346728.0
2013-07-09 16:00:00	AAPL	Stock	15.0757	15.0841	14.8359	15.0721	25318692.0
2013-07-09 16:30:00	AAPL	Stock	15.0757	15.0839	14.8931	15.0793	367892.0
2013-07-09 17:00:00	AAPL	Stock	15.0793	15.085	15.0789	15.0789	63896.0
2013-07-09 17:30:00	AAPL	Stock	15.0771	15.0811	15.0757	15.0804	17640.0
2013-07-09 18:00:00	AAPL	Stock	15.08	15.0814	15.0757	15.0814	16324.0
2013-07-09 18:30:00	AAPL	Stock	15.0768	15.0768	15.075	15.075	14000.0
2013-07-09 19:00:00	AAPL	Stock	15.0786	15.0821	15.0786	15.0821	27440.0
2013-07-09 19:30:00	AAPL	Stock	15.0857	15.0893	15.0807	15.0807	63084.0
2013-07-09 07:30:00	MSFT	Stock	34.45	34.45	34.45	34.45	640.0
2013-07-09 08:00:00	MSFT	Stock	34.21	34.47	34.21	34.36	3415.0
2013-07-09 08:30:00	MSFT	Stock	34.42	34.47	34.4	34.47	5200.0
2013-07-09 09:00:00	MSFT	Stock	34.47	34.57	34.33	34.57	72435.0
2013-07-09 09:30:00	MSFT	Stock	34.57	34.6	34.21	34.25	3271727.0
2013-07-09 10:00:00	MSFT	Stock	34.24	34.3	34.14	34.28	2403700.0
2013-07-09 10:30:00	MSFT	Stock	34.28	34.41	34.26	34.365	2211204.0
2013-07-09 11:00:00	MSFT	Stock	34.365	34.37	34.285	34.36	1869808.0
2013-07-09 11:30:00	MSFT	Stock	34.355	34.46	34.35	34.39	1493757.0
2013-07-09 12:00:00	MSFT	Stock	34.385	34.43	34.37	34.405	634566.0
2013-07-09 12:30:00	MSFT	Stock	34.405	34.46	34.4	34.45	840481.0
2013-07-09 13:00:00	MSFT	Stock	34.455	34.46	34.36	34.36	679785.0
2013-07-09 13:30:00	MSFT	Stock	34.36	34.36	34.31	34.349	779020.0
2013-07-09 14:00:00	MSFT	Stock	34.345	34.37	34.32	34.35	876661.0
2013-07-09 14:30:00	MSFT	Stock	34.35	34.41	34.34	34.395	1219285.0
2013-07-09 15:00:00	MSFT	Stock	34.395	34.54	34.39	34.475	2032872.0
2013-07-09 15:30:00	MSFT	Stock	34.475	34.49	34.3	34.37	3666539.0
2013-07-09 16:00:00	MSFT	Stock	34.35	34.447	34.248	34.357	2130547.0
2013-07-09 16:30:00	MSFT	Stock	34.35	34.35	34.29	34.35	38379.0
2013-07-09 17:00:00	MSFT	Stock	34.439	34.439	34.248	34.35	310397.0
2013-07-09 18:30:00	MSFT	Stock	34.35	34.35	34.35	34.35	490.0

> showing 50 of 79,759 rows — these rows as CSV

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