PREVIEW / stock_5min / 2017-09-15

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-09-15.parquet
  size:    5.4 MB
  rows:    352,383
  symbols: 2,974

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-09-15 05:40:00	AAPL	Stock	39.55	39.55	39.5375	39.5375	5200.0
2017-09-15 05:50:00	AAPL	Stock	39.57	39.57	39.57	39.57	400.0
2017-09-15 06:00:00	AAPL	Stock	39.5375	39.5375	39.5375	39.5375	16492.0
2017-09-15 06:25:00	AAPL	Stock	39.5175	39.5175	39.5175	39.5175	440.0
2017-09-15 06:35:00	AAPL	Stock	39.5125	39.5125	39.5125	39.5125	2980.0
2017-09-15 06:40:00	AAPL	Stock	39.505	39.505	39.505	39.505	2000.0
2017-09-15 06:45:00	AAPL	Stock	39.55	39.5675	39.55	39.5675	3688.0
2017-09-15 07:05:00	AAPL	Stock	39.5275	39.5275	39.525	39.525	3504.0
2017-09-15 07:10:00	AAPL	Stock	39.535	39.5625	39.535	39.5625	4808.0
2017-09-15 07:15:00	AAPL	Stock	39.5675	39.5675	39.555	39.5675	4400.0
2017-09-15 07:25:00	AAPL	Stock	39.575	39.575	39.57	39.57	800.0
2017-09-15 07:30:00	AAPL	Stock	39.6	39.6	39.6	39.6	4000.0
2017-09-15 07:35:00	AAPL	Stock	39.62	39.64	39.6125	39.64	37940.0
2017-09-15 07:40:00	AAPL	Stock	39.6425	39.6725	39.6375	39.6725	15096.0
2017-09-15 07:45:00	AAPL	Stock	39.675	39.675	39.655	39.6575	29676.0
2017-09-15 07:50:00	AAPL	Stock	39.675	39.675	39.65	39.655	46352.0
2017-09-15 07:55:00	AAPL	Stock	39.63	39.63	39.63	39.63	400.0
2017-09-15 08:00:00	AAPL	Stock	39.6425	39.675	39.575	39.6325	58952.0
2017-09-15 08:05:00	AAPL	Stock	39.625	39.6375	39.625	39.6375	12176.0
2017-09-15 08:10:00	AAPL	Stock	39.6375	39.65	39.6375	39.6475	23848.0
2017-09-15 08:15:00	AAPL	Stock	39.6375	39.65	39.635	39.6375	27152.0
2017-09-15 08:20:00	AAPL	Stock	39.6475	39.65	39.645	39.65	11100.0
2017-09-15 08:25:00	AAPL	Stock	39.6425	39.65	39.6375	39.6375	14984.0
2017-09-15 08:30:00	AAPL	Stock	39.65	39.65	39.615	39.625	27164.0
2017-09-15 08:35:00	AAPL	Stock	39.625	39.645	39.625	39.645	2356.0
2017-09-15 08:40:00	AAPL	Stock	39.645	39.65	39.6375	39.65	35080.0
2017-09-15 08:45:00	AAPL	Stock	39.655	39.655	39.625	39.625	13600.0
2017-09-15 08:50:00	AAPL	Stock	39.625	39.6425	39.625	39.6375	12000.0
2017-09-15 08:55:00	AAPL	Stock	39.6375	39.6375	39.6	39.61	34444.0
2017-09-15 09:00:00	AAPL	Stock	39.6125	39.6125	39.575	39.5875	21348.0
2017-09-15 09:05:00	AAPL	Stock	39.595	39.595	39.5625	39.5925	29544.0
2017-09-15 09:10:00	AAPL	Stock	39.575	39.5825	39.57	39.5825	5668.0
2017-09-15 09:15:00	AAPL	Stock	39.5775	39.58	39.565	39.565	15928.0
2017-09-15 09:20:00	AAPL	Stock	39.575	39.6075	39.565	39.595	23276.0
2017-09-15 09:25:00	AAPL	Stock	39.6125	39.665	39.545	39.545	423708.0
2017-09-15 09:30:00	AAPL	Stock	39.6175	39.6375	39.5	39.59	31546764.0
2017-09-15 09:35:00	AAPL	Stock	39.59	39.7875	39.59	39.76	3501052.0
2017-09-15 09:40:00	AAPL	Stock	39.76	39.7652	39.65	39.6915	2836776.0
2017-09-15 09:45:00	AAPL	Stock	39.695	39.7975	39.6825	39.7925	2771260.0
2017-09-15 09:50:00	AAPL	Stock	39.7925	39.8575	39.785	39.8225	3157816.0
2017-09-15 09:55:00	AAPL	Stock	39.8212	39.9725	39.8212	39.915	3850604.0
2017-09-15 10:00:00	AAPL	Stock	39.915	40.0175	39.895	40.0022	3722240.0
2017-09-15 10:05:00	AAPL	Stock	40.0012	40.05	39.9375	40.015	2748176.0
2017-09-15 10:10:00	AAPL	Stock	40.0175	40.055	39.9802	40.0075	2846712.0
2017-09-15 10:15:00	AAPL	Stock	40.0025	40.055	39.995	39.995	1778748.0
2017-09-15 10:20:00	AAPL	Stock	39.9975	40.0162	39.955	39.9975	1837524.0
2017-09-15 10:25:00	AAPL	Stock	39.995	40.0325	39.98	39.995	1297500.0
2017-09-15 10:30:00	AAPL	Stock	39.9938	40.04	39.985	40.0225	1736736.0
2017-09-15 10:35:00	AAPL	Stock	40.025	40.0425	39.98	40.0338	1553840.0
2017-09-15 10:40:00	AAPL	Stock	40.035	40.105	40.03	40.105	1922004.0

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

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