PREVIEW / stock_5min / 2016-10-18

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-10-18.parquet
  size:    5.2 MB
  rows:    341,952
  symbols: 3,205

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-10-18 04:00:00	AAPL	Stock	29.475	29.5	29.475	29.5	2020.0
2016-10-18 04:10:00	AAPL	Stock	29.545	29.5475	29.545	29.5475	1596.0
2016-10-18 04:20:00	AAPL	Stock	29.56	29.575	29.56	29.575	3200.0
2016-10-18 04:25:00	AAPL	Stock	29.5675	29.5675	29.5675	29.5675	7296.0
2016-10-18 04:50:00	AAPL	Stock	29.57	29.57	29.57	29.57	472.0
2016-10-18 04:55:00	AAPL	Stock	29.57	29.57	29.57	29.57	880.0
2016-10-18 05:10:00	AAPL	Stock	29.57	29.57	29.57	29.57	800.0
2016-10-18 05:25:00	AAPL	Stock	29.5675	29.5675	29.5675	29.5675	800.0
2016-10-18 05:30:00	AAPL	Stock	29.5775	29.5775	29.5775	29.5775	400.0
2016-10-18 05:40:00	AAPL	Stock	29.5675	29.5675	29.5675	29.5675	3248.0
2016-10-18 05:55:00	AAPL	Stock	29.565	29.565	29.5625	29.5625	7516.0
2016-10-18 06:00:00	AAPL	Stock	29.5475	29.575	29.5475	29.575	5200.0
2016-10-18 06:05:00	AAPL	Stock	29.555	29.5575	29.555	29.5575	800.0
2016-10-18 06:15:00	AAPL	Stock	29.575	29.575	29.575	29.575	1488.0
2016-10-18 06:25:00	AAPL	Stock	29.5625	29.5625	29.5625	29.5625	2232.0
2016-10-18 06:50:00	AAPL	Stock	29.565	29.5725	29.5625	29.5625	3200.0
2016-10-18 06:55:00	AAPL	Stock	29.5625	29.5625	29.5625	29.5625	2864.0
2016-10-18 07:00:00	AAPL	Stock	29.5625	29.5625	29.5475	29.5575	19104.0
2016-10-18 07:05:00	AAPL	Stock	29.555	29.5575	29.5375	29.5375	12952.0
2016-10-18 07:20:00	AAPL	Stock	29.5375	29.57	29.5375	29.57	18308.0
2016-10-18 07:25:00	AAPL	Stock	29.5625	29.5625	29.55	29.55	9600.0
2016-10-18 07:30:00	AAPL	Stock	29.55	29.55	29.55	29.55	3412.0
2016-10-18 07:35:00	AAPL	Stock	29.55	29.555	29.55	29.55	5200.0
2016-10-18 07:40:00	AAPL	Stock	29.55	29.575	29.5425	29.575	16820.0
2016-10-18 07:45:00	AAPL	Stock	29.5725	29.575	29.5575	29.5725	4520.0
2016-10-18 07:50:00	AAPL	Stock	29.5725	29.575	29.5725	29.5725	8640.0
2016-10-18 07:55:00	AAPL	Stock	29.5625	29.5625	29.5525	29.5525	7848.0
2016-10-18 08:00:00	AAPL	Stock	29.55	29.5725	29.325	29.5125	131020.0
2016-10-18 08:05:00	AAPL	Stock	29.515	29.525	29.4975	29.5025	44152.0
2016-10-18 08:10:00	AAPL	Stock	29.5125	29.5225	29.5125	29.5125	16620.0
2016-10-18 08:15:00	AAPL	Stock	29.51	29.5175	29.51	29.5175	11568.0
2016-10-18 08:20:00	AAPL	Stock	29.5175	29.52	29.5125	29.52	20400.0
2016-10-18 08:25:00	AAPL	Stock	29.525	29.555	29.525	29.555	49512.0
2016-10-18 08:30:00	AAPL	Stock	29.555	29.5575	29.545	29.5575	16880.0
2016-10-18 08:35:00	AAPL	Stock	29.56	29.5625	29.5525	29.5625	39220.0
2016-10-18 08:40:00	AAPL	Stock	29.565	29.5925	29.565	29.5775	219820.0
2016-10-18 08:45:00	AAPL	Stock	29.5775	29.6	29.575	29.5875	53324.0
2016-10-18 08:50:00	AAPL	Stock	29.59	29.6	29.5875	29.59	64496.0
2016-10-18 08:55:00	AAPL	Stock	29.595	29.6	29.5925	29.6	41628.0
2016-10-18 09:00:00	AAPL	Stock	29.59	29.6025	29.59	29.6	40224.0
2016-10-18 09:05:00	AAPL	Stock	29.595	29.6125	29.595	29.6125	42152.0
2016-10-18 09:10:00	AAPL	Stock	29.6075	29.625	29.6075	29.6075	282168.0
2016-10-18 09:15:00	AAPL	Stock	29.6075	29.6075	29.59	29.6025	46980.0
2016-10-18 09:20:00	AAPL	Stock	29.6025	29.62	29.59	29.59	58072.0
2016-10-18 09:25:00	AAPL	Stock	29.5825	29.6	29.5025	29.5025	293504.0
2016-10-18 09:30:00	AAPL	Stock	29.545	29.55	29.4528	29.46	7067832.0
2016-10-18 09:35:00	AAPL	Stock	29.4628	29.4875	29.3988	29.4835	3428692.0
2016-10-18 09:40:00	AAPL	Stock	29.4825	29.5	29.47	29.489	2136444.0
2016-10-18 09:45:00	AAPL	Stock	29.4888	29.5525	29.4862	29.5262	2897140.0
2016-10-18 09:50:00	AAPL	Stock	29.525	29.5375	29.48	29.4875	1923952.0

> showing 50 of 341,952 rows — these rows as CSV

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