PREVIEW / stock_30min / 2017-05-23

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-23.parquet
  size:    1.6 MB
  rows:    80,588
  symbols: 3,044

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
2017-05-23 04:00:00	AAPL	Stock	38.5075	38.575	38.5075	38.575	4128.0
2017-05-23 04:30:00	AAPL	Stock	38.5625	38.5625	38.5	38.5	4560.0
2017-05-23 05:30:00	AAPL	Stock	38.595	38.6	38.595	38.6	2800.0
2017-05-23 06:00:00	AAPL	Stock	38.5375	38.555	38.5375	38.555	12884.0
2017-05-23 06:30:00	AAPL	Stock	38.5375	38.575	38.5375	38.575	3744.0
2017-05-23 07:00:00	AAPL	Stock	38.5825	38.6475	38.5825	38.6475	41192.0
2017-05-23 07:30:00	AAPL	Stock	38.6625	38.7	38.65	38.65	32212.0
2017-05-23 08:00:00	AAPL	Stock	38.65	38.7075	38.625	38.6925	171456.0
2017-05-23 08:30:00	AAPL	Stock	38.7	38.725	38.6625	38.6975	100952.0
2017-05-23 09:00:00	AAPL	Stock	38.6975	38.7475	38.6975	38.725	212896.0
2017-05-23 09:30:00	AAPL	Stock	38.7225	38.725	38.445	38.465	13669124.0
2017-05-23 10:00:00	AAPL	Stock	38.465	38.5775	38.4325	38.5162	6776988.0
2017-05-23 10:30:00	AAPL	Stock	38.515	38.5375	38.4625	38.4975	5345936.0
2017-05-23 11:00:00	AAPL	Stock	38.495	38.545	38.475	38.5225	3573804.0
2017-05-23 11:30:00	AAPL	Stock	38.5212	38.5225	38.4625	38.4812	3385880.0
2017-05-23 12:00:00	AAPL	Stock	38.4825	38.4912	38.38	38.3925	4742008.0
2017-05-23 12:30:00	AAPL	Stock	38.3912	38.435	38.3275	38.3862	5161688.0
2017-05-23 13:00:00	AAPL	Stock	38.385	38.4425	38.3775	38.4	4415532.0
2017-05-23 13:30:00	AAPL	Stock	38.401	38.415	38.3425	38.3778	3699992.0
2017-05-23 14:00:00	AAPL	Stock	38.379	38.4225	38.345	38.395	2885884.0
2017-05-23 14:30:00	AAPL	Stock	38.395	38.4288	38.3575	38.3715	3364748.0
2017-05-23 15:00:00	AAPL	Stock	38.37	38.4012	38.3625	38.3838	2573268.0
2017-05-23 15:30:00	AAPL	Stock	38.3825	38.45	38.365	38.45	6568752.0
2017-05-23 16:00:00	AAPL	Stock	38.445	38.4675	38.3825	38.4425	5448228.0
2017-05-23 16:30:00	AAPL	Stock	38.4375	38.45	38.43	38.43	19040.0
2017-05-23 17:00:00	AAPL	Stock	38.4325	38.455	38.43	38.455	11744.0
2017-05-23 17:30:00	AAPL	Stock	38.43	38.43	38.43	38.43	3264.0
2017-05-23 18:00:00	AAPL	Stock	38.43	38.43	38.43	38.43	400.0
2017-05-23 18:30:00	AAPL	Stock	38.4425	38.4425	38.425	38.425	13524.0
2017-05-23 19:00:00	AAPL	Stock	38.425	38.425	38.4175	38.425	4608.0
2017-05-23 19:30:00	AAPL	Stock	38.4425	38.4425	38.4225	38.4225	15688.0
2017-05-23 05:30:00	MSFT	Stock	68.51	68.51	68.51	68.51	151.0
2017-05-23 06:00:00	MSFT	Stock	68.5	68.5	68.5	68.5	249.0
2017-05-23 07:30:00	MSFT	Stock	68.59	68.59	68.59	68.59	150.0
2017-05-23 08:00:00	MSFT	Stock	68.5	68.58	68.5	68.53	3309.0
2017-05-23 08:30:00	MSFT	Stock	68.53	68.55	68.53	68.55	1745.0
2017-05-23 09:00:00	MSFT	Stock	68.59	68.9	68.59	68.65	5002.0
2017-05-23 09:30:00	MSFT	Stock	68.72	68.75	68.43	68.495	1794447.0
2017-05-23 10:00:00	MSFT	Stock	68.495	68.605	68.38	68.555	1224992.0
2017-05-23 10:30:00	MSFT	Stock	68.555	68.62	68.47	68.525	653245.0
2017-05-23 11:00:00	MSFT	Stock	68.53	68.575	68.45	68.54	922879.0
2017-05-23 11:30:00	MSFT	Stock	68.53	68.65	68.48	68.645	858498.0
2017-05-23 12:00:00	MSFT	Stock	68.65	68.666	68.48	68.5	1192307.0
2017-05-23 12:30:00	MSFT	Stock	68.49	68.55	68.385	68.435	1037074.0
2017-05-23 13:00:00	MSFT	Stock	68.44	68.6	68.431	68.59	681001.0
2017-05-23 13:30:00	MSFT	Stock	68.59	68.6	68.51	68.56	616655.0
2017-05-23 14:00:00	MSFT	Stock	68.555	68.57	68.506	68.547	405930.0
2017-05-23 14:30:00	MSFT	Stock	68.545	68.66	68.54	68.624	661324.0
2017-05-23 15:00:00	MSFT	Stock	68.625	68.69	68.6	68.64	683189.0
2017-05-23 15:30:00	MSFT	Stock	68.64	68.71	68.58	68.69	1666898.0

> showing 50 of 80,588 rows — these rows as CSV

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