PREVIEW / stock_30min / 2015-05-28

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-05-28.parquet
  size:    1.6 MB
  rows:    81,440
  symbols: 3,507

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
2015-05-28 04:00:00	AAPL	Stock	33.25	33.25	32.925	32.925	2800.0
2015-05-28 04:30:00	AAPL	Stock	32.975	32.975	32.975	32.975	800.0
2015-05-28 05:00:00	AAPL	Stock	32.9725	32.9725	32.9375	32.9375	2384.0
2015-05-28 06:00:00	AAPL	Stock	32.985	32.985	32.985	32.985	1600.0
2015-05-28 06:30:00	AAPL	Stock	32.95	32.9875	32.95	32.955	14584.0
2015-05-28 07:00:00	AAPL	Stock	32.99	33.0025	32.935	32.9375	59788.0
2015-05-28 07:30:00	AAPL	Stock	32.9325	32.9375	32.875	32.905	83120.0
2015-05-28 08:00:00	AAPL	Stock	32.925	32.9875	32.77	32.8325	739884.0
2015-05-28 08:30:00	AAPL	Stock	32.8425	32.8775	32.815	32.8775	363124.0
2015-05-28 09:00:00	AAPL	Stock	32.8675	32.965	32.8475	32.965	520876.0
2015-05-28 09:30:00	AAPL	Stock	32.965	32.9725	32.775	32.8098	24682744.0
2015-05-28 10:00:00	AAPL	Stock	32.81	32.92	32.8025	32.9075	10245764.0
2015-05-28 10:30:00	AAPL	Stock	32.9075	32.9075	32.8275	32.8452	8008332.0
2015-05-28 11:00:00	AAPL	Stock	32.8475	32.95	32.8325	32.9095	8699104.0
2015-05-28 11:30:00	AAPL	Stock	32.91	32.9275	32.8375	32.86	6770576.0
2015-05-28 12:00:00	AAPL	Stock	32.8625	32.915	32.84	32.9125	5284436.0
2015-05-28 12:30:00	AAPL	Stock	32.9125	32.915	32.855	32.8662	4491080.0
2015-05-28 13:00:00	AAPL	Stock	32.8662	32.9	32.8475	32.8675	3933188.0
2015-05-28 13:30:00	AAPL	Stock	32.869	32.8875	32.85	32.8698	4089656.0
2015-05-28 14:00:00	AAPL	Stock	32.87	32.9225	32.8525	32.9212	4434224.0
2015-05-28 14:30:00	AAPL	Stock	32.9212	32.946	32.905	32.935	4900612.0
2015-05-28 15:00:00	AAPL	Stock	32.935	32.9875	32.91	32.92	7164028.0
2015-05-28 15:30:00	AAPL	Stock	32.92	32.9725	32.9175	32.9425	9137704.0
2015-05-28 16:00:00	AAPL	Stock	32.945	32.9675	32.8702	32.965	10207700.0
2015-05-28 16:30:00	AAPL	Stock	32.9625	32.975	32.9578	32.975	69612.0
2015-05-28 17:00:00	AAPL	Stock	32.98	32.9875	32.9575	32.9575	52120.0
2015-05-28 17:30:00	AAPL	Stock	32.9502	32.9625	32.945	32.96	63792.0
2015-05-28 18:00:00	AAPL	Stock	32.9525	32.9625	32.9525	32.9625	13924.0
2015-05-28 18:30:00	AAPL	Stock	32.9625	32.965	32.9525	32.9525	10712.0
2015-05-28 19:00:00	AAPL	Stock	32.9625	32.9625	32.955	32.9575	9132.0
2015-05-28 19:30:00	AAPL	Stock	32.965	32.97	32.96	32.97	30232.0
2015-05-28 04:00:00	MSFT	Stock	47.49	47.5	47.49	47.49	892.0
2015-05-28 07:00:00	MSFT	Stock	47.33	47.33	47.33	47.33	2100.0
2015-05-28 07:30:00	MSFT	Stock	47.45	47.45	47.45	47.45	100.0
2015-05-28 08:00:00	MSFT	Stock	47.25	47.49	47.25	47.49	2000.0
2015-05-28 08:30:00	MSFT	Stock	47.52	47.54	47.45	47.53	12810.0
2015-05-28 09:00:00	MSFT	Stock	47.55	47.64	47.49	47.5	13524.0
2015-05-28 09:30:00	MSFT	Stock	47.49	48.02	47.43	47.855	3491927.0
2015-05-28 10:00:00	MSFT	Stock	47.84	47.86	47.68	47.75	1487046.0
2015-05-28 10:30:00	MSFT	Stock	47.75	47.755	47.435	47.49	1441256.0
2015-05-28 11:00:00	MSFT	Stock	47.5	47.72	47.47	47.625	1503087.0
2015-05-28 11:30:00	MSFT	Stock	47.625	47.68	47.44	47.505	953056.0
2015-05-28 12:00:00	MSFT	Stock	47.505	47.57	47.43	47.56	859874.0
2015-05-28 12:30:00	MSFT	Stock	47.57	47.57	47.39	47.4	835138.0
2015-05-28 13:00:00	MSFT	Stock	47.4	47.54	47.39	47.42	707147.0
2015-05-28 13:30:00	MSFT	Stock	47.41	47.57	47.4	47.5	931961.0
2015-05-28 14:00:00	MSFT	Stock	47.495	47.63	47.47	47.614	708453.0
2015-05-28 14:30:00	MSFT	Stock	47.62	47.64	47.55	47.565	453658.0
2015-05-28 15:00:00	MSFT	Stock	47.565	47.575	47.45	47.48	827487.0
2015-05-28 15:30:00	MSFT	Stock	47.475	47.53	47.43	47.45	2330532.0

> showing 50 of 81,440 rows — these rows as CSV

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