PREVIEW / stock_5min / 2017-10-02

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-10-02.parquet
  size:    5.5 MB
  rows:    357,835
  symbols: 2,955

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-10-02 04:00:00	AAPL	Stock	38.53	38.53	38.53	38.53	400.0
2017-10-02 04:40:00	AAPL	Stock	38.535	38.535	38.535	38.535	400.0
2017-10-02 05:25:00	AAPL	Stock	38.5375	38.5375	38.53	38.53	42000.0
2017-10-02 06:25:00	AAPL	Stock	38.5475	38.5475	38.5475	38.5475	1200.0
2017-10-02 06:35:00	AAPL	Stock	38.5	38.5575	38.5	38.5575	5928.0
2017-10-02 06:40:00	AAPL	Stock	38.5375	38.5375	38.5375	38.5375	6120.0
2017-10-02 06:50:00	AAPL	Stock	38.545	38.545	38.545	38.545	400.0
2017-10-02 06:55:00	AAPL	Stock	38.5375	38.5625	38.525	38.56	25220.0
2017-10-02 07:00:00	AAPL	Stock	38.5525	38.575	38.5525	38.575	2320.0
2017-10-02 07:05:00	AAPL	Stock	38.575	38.6175	38.575	38.6175	23568.0
2017-10-02 07:10:00	AAPL	Stock	38.6	38.6	38.5825	38.5825	7112.0
2017-10-02 07:15:00	AAPL	Stock	38.5825	38.6	38.5825	38.5825	6800.0
2017-10-02 07:20:00	AAPL	Stock	38.6	38.6125	38.6	38.6	6088.0
2017-10-02 07:25:00	AAPL	Stock	38.6125	38.6225	38.585	38.585	10988.0
2017-10-02 07:30:00	AAPL	Stock	38.585	38.585	38.5825	38.5825	11712.0
2017-10-02 07:35:00	AAPL	Stock	38.5825	38.6225	38.58	38.6225	16792.0
2017-10-02 07:40:00	AAPL	Stock	38.6	38.6	38.575	38.575	12004.0
2017-10-02 07:45:00	AAPL	Stock	38.5775	38.6175	38.5775	38.6175	28228.0
2017-10-02 07:50:00	AAPL	Stock	38.6225	38.625	38.6125	38.6125	31544.0
2017-10-02 07:55:00	AAPL	Stock	38.6125	38.6125	38.6	38.6	22420.0
2017-10-02 08:00:00	AAPL	Stock	38.6125	38.62	38.585	38.6125	20544.0
2017-10-02 08:05:00	AAPL	Stock	38.605	38.6125	38.6025	38.6025	10800.0
2017-10-02 08:10:00	AAPL	Stock	38.6025	38.62	38.6025	38.6025	86600.0
2017-10-02 08:15:00	AAPL	Stock	38.6025	38.6125	38.5925	38.6	34348.0
2017-10-02 08:20:00	AAPL	Stock	38.62	38.62	38.5925	38.6	34800.0
2017-10-02 08:25:00	AAPL	Stock	38.565	38.565	38.565	38.565	6204.0
2017-10-02 08:30:00	AAPL	Stock	38.5875	38.5875	38.5875	38.5875	4800.0
2017-10-02 08:35:00	AAPL	Stock	38.5875	38.595	38.5675	38.5675	44468.0
2017-10-02 08:40:00	AAPL	Stock	38.585	38.595	38.5825	38.5825	6348.0
2017-10-02 08:45:00	AAPL	Stock	38.5825	38.5825	38.56	38.5625	4736.0
2017-10-02 08:50:00	AAPL	Stock	38.5625	38.5625	38.5375	38.5375	7084.0
2017-10-02 08:55:00	AAPL	Stock	38.5625	38.5625	38.55	38.55	13500.0
2017-10-02 09:00:00	AAPL	Stock	38.5625	38.58	38.54	38.5575	26912.0
2017-10-02 09:05:00	AAPL	Stock	38.5575	38.5575	38.5525	38.5525	11608.0
2017-10-02 09:10:00	AAPL	Stock	38.57	38.57	38.5625	38.57	2236.0
2017-10-02 09:15:00	AAPL	Stock	38.5675	38.5675	38.555	38.555	2452.0
2017-10-02 09:20:00	AAPL	Stock	38.5625	38.575	38.5625	38.575	7108.0
2017-10-02 09:25:00	AAPL	Stock	38.575	38.575	38.54	38.55	51628.0
2017-10-02 09:30:00	AAPL	Stock	38.565	38.6125	38.355	38.3625	3567364.0
2017-10-02 09:35:00	AAPL	Stock	38.365	38.4875	38.36	38.485	1442860.0
2017-10-02 09:40:00	AAPL	Stock	38.48	38.4825	38.395	38.445	1107436.0
2017-10-02 09:45:00	AAPL	Stock	38.445	38.4625	38.3875	38.3925	1122348.0
2017-10-02 09:50:00	AAPL	Stock	38.39	38.4275	38.3775	38.415	1017088.0
2017-10-02 09:55:00	AAPL	Stock	38.415	38.485	38.4125	38.4825	1136352.0
2017-10-02 10:00:00	AAPL	Stock	38.485	38.4875	38.4325	38.45	1014096.0
2017-10-02 10:05:00	AAPL	Stock	38.45	38.485	38.385	38.415	1167460.0
2017-10-02 10:10:00	AAPL	Stock	38.4125	38.425	38.3825	38.385	901780.0
2017-10-02 10:15:00	AAPL	Stock	38.3875	38.4448	38.3825	38.4112	1129912.0
2017-10-02 10:20:00	AAPL	Stock	38.4125	38.4175	38.3662	38.4025	959608.0
2017-10-02 10:25:00	AAPL	Stock	38.4025	38.4175	38.375	38.41	703100.0

> showing 50 of 357,835 rows — these rows as CSV

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