PREVIEW / stock_30min / 2014-09-09

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-09-09.parquet
  size:    1.6 MB
  rows:    82,869
  symbols: 3,565

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-09-09 04:00:00	AAPL	Stock	24.75	24.765	24.65	24.75	51816.0
2014-09-09 04:30:00	AAPL	Stock	24.735	24.735	24.705	24.7175	23640.0
2014-09-09 05:00:00	AAPL	Stock	24.7425	24.7425	24.7025	24.715	34432.0
2014-09-09 05:30:00	AAPL	Stock	24.725	24.7425	24.7125	24.7125	48408.0
2014-09-09 06:00:00	AAPL	Stock	24.735	24.8225	24.705	24.76	87872.0
2014-09-09 06:30:00	AAPL	Stock	24.7825	24.7825	24.745	24.77	76064.0
2014-09-09 07:00:00	AAPL	Stock	24.7725	24.7925	24.765	24.7875	368008.0
2014-09-09 07:30:00	AAPL	Stock	24.7925	24.8175	24.7725	24.7875	477308.0
2014-09-09 08:00:00	AAPL	Stock	24.7875	24.8175	24.71	24.75	1293480.0
2014-09-09 08:30:00	AAPL	Stock	24.75	24.7875	24.73	24.76	788940.0
2014-09-09 09:00:00	AAPL	Stock	24.76	24.7825	24.725	24.77	1219672.0
2014-09-09 09:30:00	AAPL	Stock	24.77	24.9	24.7158	24.845	38104160.0
2014-09-09 10:00:00	AAPL	Stock	24.845	24.92	24.78	24.8225	24133100.0
2014-09-09 10:30:00	AAPL	Stock	24.8225	24.846	24.7055	24.7888	20928748.0
2014-09-09 11:00:00	AAPL	Stock	24.79	24.88	24.7775	24.8585	12510004.0
2014-09-09 11:30:00	AAPL	Stock	24.859	24.8925	24.8425	24.8762	11529272.0
2014-09-09 12:00:00	AAPL	Stock	24.874	25.08	24.8625	25.0562	29664836.0
2014-09-09 12:30:00	AAPL	Stock	25.055	25.075	24.9525	25.0625	28396088.0
2014-09-09 13:00:00	AAPL	Stock	25.0625	25.17	24.525	24.9112	75035256.0
2014-09-09 13:30:00	AAPL	Stock	24.91	25.77	24.9025	25.685	118179400.0
2014-09-09 14:00:00	AAPL	Stock	25.68	25.75	24.875	24.8825	101664620.0
2014-09-09 14:30:00	AAPL	Stock	24.8862	25.2075	24.6	24.8175	82723736.0
2014-09-09 15:00:00	AAPL	Stock	24.8162	24.83	24.035	24.6775	97765636.0
2014-09-09 15:30:00	AAPL	Stock	24.68	24.725	24.4675	24.5	55639464.0
2014-09-09 16:00:00	AAPL	Stock	24.5	25.055	24.4475	24.515	11707308.0
2014-09-09 16:30:00	AAPL	Stock	24.515	25.375	19.4375	24.5125	687632.0
2014-09-09 17:00:00	AAPL	Stock	24.5125	24.515	24.4925	24.4975	613052.0
2014-09-09 17:30:00	AAPL	Stock	24.495	24.495	24.465	24.47	401120.0
2014-09-09 18:00:00	AAPL	Stock	24.48	24.6352	24.4425	24.4425	257992.0
2014-09-09 18:30:00	AAPL	Stock	24.4525	24.4975	24.4425	24.465	360204.0
2014-09-09 19:00:00	AAPL	Stock	24.465	24.47	24.45	24.46	255296.0
2014-09-09 19:30:00	AAPL	Stock	24.4625	24.465	24.43	24.43	331828.0
2014-09-09 07:00:00	MSFT	Stock	46.5	46.5	46.5	46.5	1760.0
2014-09-09 08:00:00	MSFT	Stock	46.51	46.52	46.45	46.48	1303.0
2014-09-09 08:30:00	MSFT	Stock	46.48	46.48	46.45	46.45	1080.0
2014-09-09 09:00:00	MSFT	Stock	46.35	46.46	46.3	46.46	13136.0
2014-09-09 09:30:00	MSFT	Stock	46.45	46.72	46.42	46.54	3817947.0
2014-09-09 10:00:00	MSFT	Stock	46.53	46.66	46.52	46.61	2501122.0
2014-09-09 10:30:00	MSFT	Stock	46.605	46.735	46.6	46.69	2896630.0
2014-09-09 11:00:00	MSFT	Stock	46.69	46.885	46.67	46.875	2397572.0
2014-09-09 11:30:00	MSFT	Stock	46.87	46.885	46.84	46.86	2091538.0
2014-09-09 12:00:00	MSFT	Stock	46.85	46.856	46.75	46.84	1495771.0
2014-09-09 12:30:00	MSFT	Stock	46.835	46.86	46.8	46.83	1267741.0
2014-09-09 13:00:00	MSFT	Stock	46.83	46.86	46.77	46.83	1684943.0
2014-09-09 13:30:00	MSFT	Stock	46.835	46.97	46.82	46.906	2236688.0
2014-09-09 14:00:00	MSFT	Stock	46.9	46.95	46.72	46.75	1907180.0
2014-09-09 14:30:00	MSFT	Stock	46.75	46.76	46.62	46.67	3584587.0
2014-09-09 15:00:00	MSFT	Stock	46.67	46.75	46.62	46.7	5013080.0
2014-09-09 15:30:00	MSFT	Stock	46.705	46.79	46.68	46.76	5000636.0
2014-09-09 16:00:00	MSFT	Stock	46.76	46.79	46.71	46.77	1464545.0

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

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