PREVIEW / stock_30min / 2016-11-07

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-11-07.parquet
  size:    1.6 MB
  rows:    81,533
  symbols: 3,165

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
2016-11-07 04:00:00	AAPL	Stock	27.6625	27.7025	27.5875	27.7025	9820.0
2016-11-07 04:30:00	AAPL	Stock	27.6975	27.6975	27.66	27.6675	4884.0
2016-11-07 05:00:00	AAPL	Stock	27.665	27.665	27.625	27.625	6712.0
2016-11-07 05:30:00	AAPL	Stock	27.6275	27.6375	27.615	27.615	11880.0
2016-11-07 06:00:00	AAPL	Stock	27.635	27.6375	27.6025	27.6025	18720.0
2016-11-07 06:30:00	AAPL	Stock	27.605	27.6075	27.54	27.5925	21916.0
2016-11-07 07:00:00	AAPL	Stock	27.5875	27.5875	27.545	27.55	66004.0
2016-11-07 07:30:00	AAPL	Stock	27.55	27.5675	27.5375	27.5625	41724.0
2016-11-07 08:00:00	AAPL	Stock	27.57	27.6075	27.53	27.53	216088.0
2016-11-07 08:30:00	AAPL	Stock	27.535	27.5375	27.47	27.4775	237132.0
2016-11-07 09:00:00	AAPL	Stock	27.49	27.55	27.475	27.505	398108.0
2016-11-07 09:30:00	AAPL	Stock	27.525	27.625	27.365	27.435	21867928.0
2016-11-07 10:00:00	AAPL	Stock	27.4325	27.5075	27.3875	27.5	10475740.0
2016-11-07 10:30:00	AAPL	Stock	27.4998	27.505	27.4175	27.475	8100144.0
2016-11-07 11:00:00	AAPL	Stock	27.475	27.5075	27.465	27.4948	7962100.0
2016-11-07 11:30:00	AAPL	Stock	27.4938	27.5172	27.48	27.5125	7752080.0
2016-11-07 12:00:00	AAPL	Stock	27.5125	27.5175	27.485	27.5162	6402484.0
2016-11-07 12:30:00	AAPL	Stock	27.5175	27.5238	27.49	27.52	3660068.0
2016-11-07 13:00:00	AAPL	Stock	27.52	27.545	27.5025	27.54	6348112.0
2016-11-07 13:30:00	AAPL	Stock	27.5388	27.6125	27.5325	27.6112	4498336.0
2016-11-07 14:00:00	AAPL	Stock	27.612	27.6225	27.5575	27.5582	5308144.0
2016-11-07 14:30:00	AAPL	Stock	27.56	27.5675	27.4325	27.4825	6550936.0
2016-11-07 15:00:00	AAPL	Stock	27.4812	27.52	27.46	27.4878	4773328.0
2016-11-07 15:30:00	AAPL	Stock	27.49	27.6275	27.46	27.6025	12785780.0
2016-11-07 16:00:00	AAPL	Stock	27.59	27.615	27.4915	27.6	12222096.0
2016-11-07 16:30:00	AAPL	Stock	27.605	27.6125	27.5875	27.6025	53212.0
2016-11-07 17:00:00	AAPL	Stock	27.605	27.61	27.5925	27.5925	22172.0
2016-11-07 17:30:00	AAPL	Stock	27.605	27.605	27.5825	27.585	16552.0
2016-11-07 18:00:00	AAPL	Stock	27.5975	27.6125	27.5975	27.6125	19880.0
2016-11-07 18:30:00	AAPL	Stock	27.6125	27.6125	27.6	27.6	7868.0
2016-11-07 19:00:00	AAPL	Stock	27.5875	27.6	27.5825	27.5825	17736.0
2016-11-07 19:30:00	AAPL	Stock	27.6	27.6	27.585	27.585	22240.0
2016-11-07 04:30:00	MSFT	Stock	59.74	59.74	59.74	59.74	520.0
2016-11-07 06:30:00	MSFT	Stock	59.64	59.64	59.64	59.64	1000.0
2016-11-07 07:00:00	MSFT	Stock	59.64	59.69	59.55	59.55	9070.0
2016-11-07 07:30:00	MSFT	Stock	59.55	59.55	59.43	59.52	800.0
2016-11-07 08:00:00	MSFT	Stock	59.58	59.6	59.39	59.5	28282.0
2016-11-07 08:30:00	MSFT	Stock	59.49	59.6	59.49	59.56	5880.0
2016-11-07 09:00:00	MSFT	Stock	59.6	59.84	59.55	59.78	57822.0
2016-11-07 09:30:00	MSFT	Stock	59.795	60.3	59.78	60.13	4776392.0
2016-11-07 10:00:00	MSFT	Stock	60.14	60.25	60.1	60.172	1798478.0
2016-11-07 10:30:00	MSFT	Stock	60.175	60.4	60.17	60.39	1903999.0
2016-11-07 11:00:00	MSFT	Stock	60.39	60.45	60.34	60.39	2156554.0
2016-11-07 11:30:00	MSFT	Stock	60.39	60.486	60.37	60.47	1331292.0
2016-11-07 12:00:00	MSFT	Stock	60.475	60.52	60.41	60.46	1245055.0
2016-11-07 12:30:00	MSFT	Stock	60.465	60.5	60.41	60.46	936026.0
2016-11-07 13:00:00	MSFT	Stock	60.47	60.5	60.43	60.47	884981.0
2016-11-07 13:30:00	MSFT	Stock	60.475	60.49	60.41	60.475	840951.0
2016-11-07 14:00:00	MSFT	Stock	60.475	60.49	60.39	60.393	1140431.0
2016-11-07 14:30:00	MSFT	Stock	60.397	60.4	60.285	60.341	1371991.0

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

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