PREVIEW / stock_5min / 2017-12-27

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-12-27.parquet
  size:    5.5 MB
  rows:    358,978
  symbols: 2,918

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-12-27 04:00:00	AAPL	Stock	42.7775	42.7775	42.725	42.725	3780.0
2017-12-27 04:20:00	AAPL	Stock	42.725	42.725	42.725	42.725	596.0
2017-12-27 04:40:00	AAPL	Stock	42.725	42.725	42.725	42.725	3648.0
2017-12-27 04:55:00	AAPL	Stock	42.725	42.725	42.725	42.725	3440.0
2017-12-27 05:30:00	AAPL	Stock	42.6875	42.6875	42.6875	42.6875	2472.0
2017-12-27 05:35:00	AAPL	Stock	42.6875	42.6875	42.6875	42.6875	1200.0
2017-12-27 05:45:00	AAPL	Stock	42.7	42.7	42.6875	42.6875	1200.0
2017-12-27 05:55:00	AAPL	Stock	42.7	42.7	42.7	42.7	2400.0
2017-12-27 06:10:00	AAPL	Stock	42.7	42.7	42.7	42.7	800.0
2017-12-27 06:35:00	AAPL	Stock	42.675	42.675	42.675	42.675	2600.0
2017-12-27 06:50:00	AAPL	Stock	42.6375	42.6375	42.6375	42.6375	788.0
2017-12-27 07:00:00	AAPL	Stock	42.6625	42.675	42.655	42.655	2064.0
2017-12-27 07:05:00	AAPL	Stock	42.6525	42.7	42.6525	42.6775	14356.0
2017-12-27 07:10:00	AAPL	Stock	42.6775	42.6875	42.675	42.675	10800.0
2017-12-27 07:15:00	AAPL	Stock	42.675	42.685	42.675	42.685	19700.0
2017-12-27 07:20:00	AAPL	Stock	42.6775	42.6775	42.6775	42.6775	800.0
2017-12-27 07:25:00	AAPL	Stock	42.6775	42.6775	42.6775	42.6775	400.0
2017-12-27 07:30:00	AAPL	Stock	42.675	42.675	42.65	42.65	28000.0
2017-12-27 07:35:00	AAPL	Stock	42.6375	42.6375	42.6	42.6125	27168.0
2017-12-27 07:40:00	AAPL	Stock	42.6025	42.6025	42.5975	42.6	4892.0
2017-12-27 07:45:00	AAPL	Stock	42.6	42.625	42.6	42.625	7832.0
2017-12-27 07:50:00	AAPL	Stock	42.6425	42.6425	42.6425	42.6425	400.0
2017-12-27 08:00:00	AAPL	Stock	42.6375	42.6975	42.59	42.6225	12528.0
2017-12-27 08:05:00	AAPL	Stock	42.6025	42.6025	42.5625	42.5625	25280.0
2017-12-27 08:10:00	AAPL	Stock	42.5625	42.5875	42.545	42.5675	69380.0
2017-12-27 08:15:00	AAPL	Stock	42.59	42.59	42.575	42.575	6540.0
2017-12-27 08:20:00	AAPL	Stock	42.5925	42.6425	42.5925	42.635	35044.0
2017-12-27 08:25:00	AAPL	Stock	42.6375	42.6625	42.625	42.65	16080.0
2017-12-27 08:30:00	AAPL	Stock	42.675	42.685	42.655	42.675	33780.0
2017-12-27 08:35:00	AAPL	Stock	42.675	42.685	42.6125	42.625	39976.0
2017-12-27 08:40:00	AAPL	Stock	42.625	42.635	42.625	42.625	13916.0
2017-12-27 08:45:00	AAPL	Stock	42.6275	42.6425	42.625	42.6425	7812.0
2017-12-27 08:50:00	AAPL	Stock	42.6425	42.6425	42.6125	42.6125	13328.0
2017-12-27 08:55:00	AAPL	Stock	42.625	42.6425	42.625	42.6425	13764.0
2017-12-27 09:00:00	AAPL	Stock	42.6625	42.675	42.6525	42.675	13696.0
2017-12-27 09:05:00	AAPL	Stock	42.6675	42.6675	42.625	42.625	57928.0
2017-12-27 09:10:00	AAPL	Stock	42.6325	42.6375	42.6325	42.6375	4568.0
2017-12-27 09:15:00	AAPL	Stock	42.625	42.6325	42.61	42.615	37880.0
2017-12-27 09:20:00	AAPL	Stock	42.61	42.625	42.61	42.615	6284.0
2017-12-27 09:25:00	AAPL	Stock	42.625	42.6425	42.5075	42.5225	739704.0
2017-12-27 09:30:00	AAPL	Stock	42.525	42.695	42.4275	42.6235	6970464.0
2017-12-27 09:35:00	AAPL	Stock	42.6213	42.6225	42.5	42.5575	2629500.0
2017-12-27 09:40:00	AAPL	Stock	42.56	42.585	42.5225	42.5475	1344936.0
2017-12-27 09:45:00	AAPL	Stock	42.5462	42.5638	42.49	42.5075	2519956.0
2017-12-27 09:50:00	AAPL	Stock	42.505	42.535	42.5	42.5075	1708224.0
2017-12-27 09:55:00	AAPL	Stock	42.5025	42.535	42.5	42.5305	1215188.0
2017-12-27 10:00:00	AAPL	Stock	42.5325	42.5575	42.4975	42.519	1935032.0
2017-12-27 10:05:00	AAPL	Stock	42.52	42.5462	42.4975	42.5325	1210616.0
2017-12-27 10:10:00	AAPL	Stock	42.5312	42.5488	42.4975	42.5175	1343208.0
2017-12-27 10:15:00	AAPL	Stock	42.5175	42.5275	42.5	42.5262	736704.0

> showing 50 of 358,978 rows — these rows as CSV

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