PREVIEW / stock_5min / 2017-11-07

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-11-07.parquet
  size:    5.6 MB
  rows:    361,231
  symbols: 2,949

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-07 04:00:00	AAPL	Stock	43.55	43.55	43.55	43.55	400.0
2017-11-07 04:05:00	AAPL	Stock	43.6	43.625	43.6	43.625	1600.0
2017-11-07 04:10:00	AAPL	Stock	43.6125	43.6125	43.6125	43.6125	1200.0
2017-11-07 04:40:00	AAPL	Stock	43.6	43.6	43.5875	43.5875	7552.0
2017-11-07 04:45:00	AAPL	Stock	43.575	43.575	43.575	43.575	4000.0
2017-11-07 04:50:00	AAPL	Stock	43.5875	43.5875	43.5875	43.5875	580.0
2017-11-07 05:00:00	AAPL	Stock	43.595	43.595	43.595	43.595	800.0
2017-11-07 05:55:00	AAPL	Stock	43.4675	43.4675	43.4675	43.4675	1200.0
2017-11-07 06:10:00	AAPL	Stock	43.5	43.575	43.5	43.575	3460.0
2017-11-07 06:15:00	AAPL	Stock	43.5375	43.5375	43.5375	43.5375	1200.0
2017-11-07 06:25:00	AAPL	Stock	43.525	43.5275	43.525	43.5275	800.0
2017-11-07 06:30:00	AAPL	Stock	43.525	43.525	43.525	43.525	3160.0
2017-11-07 06:45:00	AAPL	Stock	43.5425	43.55	43.5425	43.55	16888.0
2017-11-07 06:50:00	AAPL	Stock	43.525	43.55	43.525	43.55	820.0
2017-11-07 07:00:00	AAPL	Stock	43.5125	43.5625	43.5075	43.5625	29752.0
2017-11-07 07:05:00	AAPL	Stock	43.55	43.55	43.5375	43.5375	5200.0
2017-11-07 07:10:00	AAPL	Stock	43.55	43.55	43.55	43.55	8752.0
2017-11-07 07:15:00	AAPL	Stock	43.56	43.56	43.555	43.555	904.0
2017-11-07 07:25:00	AAPL	Stock	43.5475	43.5525	43.5475	43.55	1388.0
2017-11-07 07:30:00	AAPL	Stock	43.55	43.5625	43.55	43.5625	6192.0
2017-11-07 07:35:00	AAPL	Stock	43.5375	43.55	43.5375	43.5375	13352.0
2017-11-07 07:40:00	AAPL	Stock	43.5375	43.5375	43.5375	43.5375	800.0
2017-11-07 07:45:00	AAPL	Stock	43.515	43.515	43.4875	43.5	29784.0
2017-11-07 07:50:00	AAPL	Stock	43.5	43.5	43.4725	43.4775	26700.0
2017-11-07 07:55:00	AAPL	Stock	43.4825	43.485	43.4825	43.485	2080.0
2017-11-07 08:00:00	AAPL	Stock	43.485	43.5625	43.4775	43.4975	29640.0
2017-11-07 08:05:00	AAPL	Stock	43.5	43.5325	43.5	43.5325	24580.0
2017-11-07 08:10:00	AAPL	Stock	43.525	43.75	43.5	43.5525	216132.0
2017-11-07 08:15:00	AAPL	Stock	43.5625	43.575	43.5625	43.5625	19164.0
2017-11-07 08:20:00	AAPL	Stock	43.5625	43.5625	43.55	43.55	59412.0
2017-11-07 08:25:00	AAPL	Stock	43.55	43.55	43.5475	43.5475	3592.0
2017-11-07 08:30:00	AAPL	Stock	43.55	43.55	43.535	43.535	6156.0
2017-11-07 08:35:00	AAPL	Stock	43.55	43.55	43.55	43.55	5400.0
2017-11-07 08:40:00	AAPL	Stock	43.55	43.55	43.5325	43.54	4540.0
2017-11-07 08:45:00	AAPL	Stock	43.54	43.55	43.5375	43.54	49608.0
2017-11-07 08:50:00	AAPL	Stock	43.535	43.5375	43.5	43.5075	40812.0
2017-11-07 08:55:00	AAPL	Stock	43.5075	43.535	43.5075	43.5325	15912.0
2017-11-07 09:00:00	AAPL	Stock	43.515	43.525	43.5025	43.5025	6980.0
2017-11-07 09:05:00	AAPL	Stock	43.5125	43.515	43.4775	43.4875	83488.0
2017-11-07 09:10:00	AAPL	Stock	43.4925	43.5	43.4775	43.4825	42108.0
2017-11-07 09:15:00	AAPL	Stock	43.49	43.495	43.485	43.4875	15540.0
2017-11-07 09:20:00	AAPL	Stock	43.4775	43.5025	43.45	43.5025	52484.0
2017-11-07 09:25:00	AAPL	Stock	43.4775	43.505	43.4625	43.4775	27704.0
2017-11-07 09:30:00	AAPL	Stock	43.4775	43.635	43.4	43.575	5494644.0
2017-11-07 09:35:00	AAPL	Stock	43.575	43.6012	43.4825	43.6012	3005332.0
2017-11-07 09:40:00	AAPL	Stock	43.6002	43.695	43.5875	43.69	3098236.0
2017-11-07 09:45:00	AAPL	Stock	43.69	43.8125	43.6775	43.781	4875484.0
2017-11-07 09:50:00	AAPL	Stock	43.7825	43.8125	43.675	43.6775	2830016.0
2017-11-07 09:55:00	AAPL	Stock	43.679	43.7322	43.6325	43.7225	1796532.0
2017-11-07 10:00:00	AAPL	Stock	43.725	43.725	43.5625	43.5737	1885340.0

> showing 50 of 361,231 rows — these rows as CSV

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