PREVIEW / stock_5min / 2017-11-03

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-11-03.parquet
  size:    5.5 MB
  rows:    352,187
  symbols: 2,948

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-11-03 04:00:00	AAPL	Stock	43.3875	43.4525	43.375	43.4	32052.0
2017-11-03 04:05:00	AAPL	Stock	43.425	43.46	43.425	43.45	18328.0
2017-11-03 04:10:00	AAPL	Stock	43.465	43.4675	43.465	43.4675	2000.0
2017-11-03 04:15:00	AAPL	Stock	43.4775	43.4875	43.4475	43.4875	8488.0
2017-11-03 04:20:00	AAPL	Stock	43.4875	43.4925	43.4875	43.4925	5648.0
2017-11-03 04:25:00	AAPL	Stock	43.4875	43.4875	43.4175	43.4175	9080.0
2017-11-03 04:30:00	AAPL	Stock	43.4125	43.4125	43.3625	43.3775	7808.0
2017-11-03 04:35:00	AAPL	Stock	43.3925	43.3925	43.35	43.35	6400.0
2017-11-03 04:40:00	AAPL	Stock	43.39	43.3925	43.39	43.3925	1400.0
2017-11-03 04:45:00	AAPL	Stock	43.4075	43.4325	43.4	43.4325	4688.0
2017-11-03 04:50:00	AAPL	Stock	43.4375	43.4375	43.4375	43.4375	8304.0
2017-11-03 04:55:00	AAPL	Stock	43.4375	43.4475	43.4375	43.4475	4000.0
2017-11-03 05:00:00	AAPL	Stock	43.4375	43.4375	43.375	43.4025	4016.0
2017-11-03 05:05:00	AAPL	Stock	43.435	43.435	43.435	43.435	520.0
2017-11-03 05:10:00	AAPL	Stock	43.45	43.45	43.4175	43.4175	3148.0
2017-11-03 05:15:00	AAPL	Stock	43.45	43.4525	43.45	43.45	2488.0
2017-11-03 05:25:00	AAPL	Stock	43.45	43.45	43.375	43.375	32836.0
2017-11-03 05:30:00	AAPL	Stock	43.3975	43.4075	43.3475	43.375	11452.0
2017-11-03 05:35:00	AAPL	Stock	43.375	43.4	43.3725	43.4	24052.0
2017-11-03 05:40:00	AAPL	Stock	43.3975	43.3975	43.3425	43.3425	14148.0
2017-11-03 05:45:00	AAPL	Stock	43.3375	43.3375	43.2	43.2	22684.0
2017-11-03 05:50:00	AAPL	Stock	43.2525	43.2525	43.2525	43.2525	524.0
2017-11-03 05:55:00	AAPL	Stock	43.2525	43.28	43.245	43.245	26440.0
2017-11-03 06:00:00	AAPL	Stock	43.255	43.27	43.25	43.2575	16916.0
2017-11-03 06:05:00	AAPL	Stock	43.2575	43.2575	43.215	43.225	10708.0
2017-11-03 06:10:00	AAPL	Stock	43.2225	43.25	43.2225	43.25	16764.0
2017-11-03 06:15:00	AAPL	Stock	43.25	43.29	43.25	43.285	20316.0
2017-11-03 06:20:00	AAPL	Stock	43.295	43.295	43.285	43.285	2228.0
2017-11-03 06:25:00	AAPL	Stock	43.2825	43.3	43.275	43.3	3896.0
2017-11-03 06:30:00	AAPL	Stock	43.2975	43.325	43.275	43.325	9840.0
2017-11-03 06:35:00	AAPL	Stock	43.345	43.345	43.25	43.325	15680.0
2017-11-03 06:40:00	AAPL	Stock	43.3275	43.3275	43.3275	43.3275	800.0
2017-11-03 06:45:00	AAPL	Stock	43.3575	43.375	43.3125	43.34	39088.0
2017-11-03 06:50:00	AAPL	Stock	43.3575	43.375	43.3575	43.375	24264.0
2017-11-03 06:55:00	AAPL	Stock	43.375	43.52	43.375	43.5125	85936.0
2017-11-03 07:00:00	AAPL	Stock	43.5125	43.6225	43.4525	43.5975	207436.0
2017-11-03 07:05:00	AAPL	Stock	43.6	43.7075	43.575	43.7	208216.0
2017-11-03 07:10:00	AAPL	Stock	43.6875	43.7275	43.675	43.6925	205100.0
2017-11-03 07:15:00	AAPL	Stock	43.7	43.725	43.61	43.725	174280.0
2017-11-03 07:20:00	AAPL	Stock	43.7225	43.725	43.6125	43.7125	153392.0
2017-11-03 07:25:00	AAPL	Stock	43.69	43.7	43.6125	43.6725	117948.0
2017-11-03 07:30:00	AAPL	Stock	43.65	43.675	43.4625	43.55	297016.0
2017-11-03 07:35:00	AAPL	Stock	43.57	43.5725	43.4625	43.55	117012.0
2017-11-03 07:40:00	AAPL	Stock	43.5325	43.725	43.525	43.5625	205140.0
2017-11-03 07:45:00	AAPL	Stock	43.5825	43.6425	43.5825	43.5975	58040.0
2017-11-03 07:50:00	AAPL	Stock	43.5825	43.625	43.55	43.6175	78312.0
2017-11-03 07:55:00	AAPL	Stock	43.5975	43.6875	43.58	43.65	136720.0
2017-11-03 08:00:00	AAPL	Stock	43.65	43.725	43.25	43.4925	774252.0
2017-11-03 08:05:00	AAPL	Stock	43.4925	43.5625	43.4375	43.545	491992.0
2017-11-03 08:10:00	AAPL	Stock	43.505	43.67	43.505	43.6575	711148.0

> showing 50 of 352,187 rows — these rows as CSV

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