PREVIEW / stock_5min / 2016-04-05

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-04-05.parquet
  size:    5.3 MB
  rows:    351,786
  symbols: 3,325

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-04-05 04:00:00	AAPL	Stock	27.625	27.625	27.56	27.56	1548.0
2016-04-05 04:05:00	AAPL	Stock	27.5575	27.5875	27.5575	27.5875	1556.0
2016-04-05 04:25:00	AAPL	Stock	27.6	27.6	27.5875	27.5875	2016.0
2016-04-05 04:30:00	AAPL	Stock	27.5575	27.5575	27.54	27.54	1448.0
2016-04-05 04:35:00	AAPL	Stock	27.4975	27.4975	27.4975	27.4975	400.0
2016-04-05 04:40:00	AAPL	Stock	27.5	27.5	27.5	27.5	8000.0
2016-04-05 05:00:00	AAPL	Stock	27.5	27.5	27.5	27.5	1600.0
2016-04-05 05:40:00	AAPL	Stock	27.565	27.565	27.565	27.565	400.0
2016-04-05 06:10:00	AAPL	Stock	27.5325	27.5325	27.5	27.5	1412.0
2016-04-05 06:20:00	AAPL	Stock	27.575	27.575	27.575	27.575	2400.0
2016-04-05 06:30:00	AAPL	Stock	27.5175	27.5175	27.5175	27.5175	400.0
2016-04-05 06:45:00	AAPL	Stock	27.53	27.53	27.53	27.53	800.0
2016-04-05 06:50:00	AAPL	Stock	27.5125	27.545	27.5125	27.545	2800.0
2016-04-05 06:55:00	AAPL	Stock	27.53	27.5325	27.53	27.53	2000.0
2016-04-05 07:00:00	AAPL	Stock	27.5475	27.5625	27.5475	27.5525	3000.0
2016-04-05 07:05:00	AAPL	Stock	27.57	27.57	27.57	27.57	3840.0
2016-04-05 07:10:00	AAPL	Stock	27.5725	27.575	27.5725	27.575	3608.0
2016-04-05 07:15:00	AAPL	Stock	27.5825	27.5825	27.46	27.475	150988.0
2016-04-05 07:20:00	AAPL	Stock	27.475	27.5	27.415	27.4525	21248.0
2016-04-05 07:25:00	AAPL	Stock	27.43	27.4325	27.36	27.365	78492.0
2016-04-05 07:30:00	AAPL	Stock	27.37	27.4075	27.3375	27.395	65032.0
2016-04-05 07:35:00	AAPL	Stock	27.3975	27.41	27.3125	27.3125	34144.0
2016-04-05 07:40:00	AAPL	Stock	27.3	27.35	27.2875	27.325	27160.0
2016-04-05 07:45:00	AAPL	Stock	27.31	27.3475	27.3025	27.31	32412.0
2016-04-05 07:50:00	AAPL	Stock	27.31	27.325	27.2825	27.3175	55576.0
2016-04-05 07:55:00	AAPL	Stock	27.3175	27.4	27.2875	27.37	90572.0
2016-04-05 08:00:00	AAPL	Stock	27.3725	27.61	27.2975	27.4125	156476.0
2016-04-05 08:05:00	AAPL	Stock	27.395	27.4325	27.3875	27.425	71740.0
2016-04-05 08:10:00	AAPL	Stock	27.425	27.425	27.3925	27.4125	50884.0
2016-04-05 08:15:00	AAPL	Stock	27.4125	27.4125	27.3875	27.3875	56700.0
2016-04-05 08:20:00	AAPL	Stock	27.3875	27.3925	27.3725	27.3925	62840.0
2016-04-05 08:25:00	AAPL	Stock	27.3875	27.425	27.3825	27.425	66372.0
2016-04-05 08:30:00	AAPL	Stock	27.425	27.4325	27.41	27.4175	53904.0
2016-04-05 08:35:00	AAPL	Stock	27.4175	27.425	27.4125	27.4125	70896.0
2016-04-05 08:40:00	AAPL	Stock	27.425	27.425	27.4075	27.4075	7332.0
2016-04-05 08:45:00	AAPL	Stock	27.4075	27.4225	27.4025	27.4075	10112.0
2016-04-05 08:50:00	AAPL	Stock	27.4125	27.4125	27.4025	27.4025	8740.0
2016-04-05 08:55:00	AAPL	Stock	27.41	27.4375	27.41	27.4375	8724.0
2016-04-05 09:00:00	AAPL	Stock	27.4375	27.4375	27.42	27.4375	13204.0
2016-04-05 09:05:00	AAPL	Stock	27.4375	27.4375	27.4225	27.4225	15920.0
2016-04-05 09:10:00	AAPL	Stock	27.405	27.4125	27.3875	27.4125	69320.0
2016-04-05 09:15:00	AAPL	Stock	27.405	27.405	27.3925	27.3925	24592.0
2016-04-05 09:20:00	AAPL	Stock	27.4025	27.4225	27.4	27.4225	24600.0
2016-04-05 09:25:00	AAPL	Stock	27.42	27.4325	27.375	27.38	134620.0
2016-04-05 09:30:00	AAPL	Stock	27.4125	27.5825	27.355	27.5575	5316572.0
2016-04-05 09:35:00	AAPL	Stock	27.56	27.6075	27.51	27.52	2679556.0
2016-04-05 09:40:00	AAPL	Stock	27.52	27.54	27.4585	27.472	2415448.0
2016-04-05 09:45:00	AAPL	Stock	27.4675	27.4775	27.4	27.429	2397972.0
2016-04-05 09:50:00	AAPL	Stock	27.4275	27.4675	27.41	27.4175	1692164.0
2016-04-05 09:55:00	AAPL	Stock	27.4175	27.445	27.375	27.44	2141160.0

> showing 50 of 351,786 rows — these rows as CSV

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