PREVIEW / stock_30min / 2016-08-31

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-31.parquet
  size:    1.6 MB
  rows:    81,396
  symbols: 3,269

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-08-31 04:00:00	AAPL	Stock	26.48	26.48	26.48	26.48	800.0
2016-08-31 04:30:00	AAPL	Stock	26.455	26.455	26.455	26.455	20488.0
2016-08-31 05:00:00	AAPL	Stock	26.4825	26.4975	26.4825	26.4975	2016.0
2016-08-31 05:30:00	AAPL	Stock	26.4825	26.5525	26.4825	26.525	22548.0
2016-08-31 06:00:00	AAPL	Stock	26.4875	26.4875	26.4875	26.4875	432.0
2016-08-31 06:30:00	AAPL	Stock	26.4825	26.5125	26.4825	26.5125	7200.0
2016-08-31 07:00:00	AAPL	Stock	26.505	26.525	26.505	26.525	8060.0
2016-08-31 07:30:00	AAPL	Stock	26.525	26.54	26.525	26.54	9924.0
2016-08-31 08:00:00	AAPL	Stock	26.5375	26.5525	26.5025	26.5225	75580.0
2016-08-31 08:30:00	AAPL	Stock	26.51	26.532	26.475	26.475	104576.0
2016-08-31 09:00:00	AAPL	Stock	26.475	26.5075	26.415	26.42	188560.0
2016-08-31 09:30:00	AAPL	Stock	26.4175	26.6	26.41	26.5875	13461956.0
2016-08-31 10:00:00	AAPL	Stock	26.59	26.6162	26.5325	26.5425	7179896.0
2016-08-31 10:30:00	AAPL	Stock	26.54	26.61	26.5125	26.5835	6773896.0
2016-08-31 11:00:00	AAPL	Stock	26.5825	26.6425	26.565	26.635	6483380.0
2016-08-31 11:30:00	AAPL	Stock	26.6375	26.64	26.5825	26.5925	4380296.0
2016-08-31 12:00:00	AAPL	Stock	26.59	26.6075	26.5025	26.585	8109508.0
2016-08-31 12:30:00	AAPL	Stock	26.585	26.625	26.5588	26.5825	4062624.0
2016-08-31 13:00:00	AAPL	Stock	26.5838	26.6225	26.55	26.62	3773984.0
2016-08-31 13:30:00	AAPL	Stock	26.6225	26.625	26.5775	26.585	2751628.0
2016-08-31 14:00:00	AAPL	Stock	26.5875	26.615	26.5675	26.5975	3098456.0
2016-08-31 14:30:00	AAPL	Stock	26.595	26.5975	26.5125	26.515	5201504.0
2016-08-31 15:00:00	AAPL	Stock	26.5125	26.5625	26.5062	26.546	7069780.0
2016-08-31 15:30:00	AAPL	Stock	26.5475	26.57	26.525	26.5275	12337960.0
2016-08-31 16:00:00	AAPL	Stock	26.525	26.56	26.5175	26.525	19098388.0
2016-08-31 16:30:00	AAPL	Stock	26.535	26.535	26.525	26.525	26900.0
2016-08-31 17:00:00	AAPL	Stock	26.5225	26.5275	26.505	26.505	4572.0
2016-08-31 17:30:00	AAPL	Stock	26.51	26.5375	26.5	26.525	32000.0
2016-08-31 18:30:00	AAPL	Stock	26.52	26.52	26.5125	26.5125	3120.0
2016-08-31 19:00:00	AAPL	Stock	26.51	26.51	26.5075	26.5075	2796.0
2016-08-31 19:30:00	AAPL	Stock	26.5075	26.5125	26.5	26.5	14228.0
2016-08-31 07:00:00	MSFT	Stock	58.06	58.08	58.06	58.08	400.0
2016-08-31 08:30:00	MSFT	Stock	57.89	57.89	57.89	57.89	175.0
2016-08-31 09:00:00	MSFT	Stock	57.83	57.83	57.67	57.67	4210.0
2016-08-31 09:30:00	MSFT	Stock	57.67	57.8	57.61	57.69	1984624.0
2016-08-31 10:00:00	MSFT	Stock	57.695	57.75	57.57	57.625	987375.0
2016-08-31 10:30:00	MSFT	Stock	57.62	57.67	57.535	57.64	982469.0
2016-08-31 11:00:00	MSFT	Stock	57.635	57.7	57.5	57.54	928971.0
2016-08-31 11:30:00	MSFT	Stock	57.55	57.64	57.54	57.556	490554.0
2016-08-31 12:00:00	MSFT	Stock	57.55	57.55	57.3	57.345	1094463.0
2016-08-31 12:30:00	MSFT	Stock	57.34	57.4	57.32	57.375	748341.0
2016-08-31 13:00:00	MSFT	Stock	57.375	57.47	57.374	57.409	595491.0
2016-08-31 13:30:00	MSFT	Stock	57.41	57.46	57.32	57.34	890201.0
2016-08-31 14:00:00	MSFT	Stock	57.34	57.49	57.34	57.47	905996.0
2016-08-31 14:30:00	MSFT	Stock	57.47	57.479	57.36	57.39	946961.0
2016-08-31 15:00:00	MSFT	Stock	57.39	57.59	57.375	57.534	1258625.0
2016-08-31 15:30:00	MSFT	Stock	57.53	57.56	57.44	57.47	3252727.0
2016-08-31 16:00:00	MSFT	Stock	57.47	57.47	57.27	57.27	3857724.0
2016-08-31 16:30:00	MSFT	Stock	57.26	57.3	57.06	57.14	13578.0
2016-08-31 17:00:00	MSFT	Stock	57.14	57.46	57.14	57.46	263150.0

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

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