PREVIEW / stock_5min / 2017-12-21

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-12-21.parquet
  size:    5.7 MB
  rows:    366,622
  symbols: 2,937

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-21 04:30:00	AAPL	Stock	43.5	43.5	43.5	43.5	400.0
2017-12-21 05:00:00	AAPL	Stock	43.4575	43.4575	43.4575	43.4575	616.0
2017-12-21 05:05:00	AAPL	Stock	43.4625	43.5	43.4625	43.5	972.0
2017-12-21 05:10:00	AAPL	Stock	43.4625	43.4625	43.4625	43.4625	1372.0
2017-12-21 05:15:00	AAPL	Stock	43.455	43.455	43.455	43.455	400.0
2017-12-21 05:40:00	AAPL	Stock	43.455	43.455	43.455	43.455	400.0
2017-12-21 05:55:00	AAPL	Stock	43.4625	43.4625	43.4625	43.4625	540.0
2017-12-21 06:15:00	AAPL	Stock	43.465	43.465	43.465	43.465	796.0
2017-12-21 06:30:00	AAPL	Stock	43.48	43.48	43.48	43.48	924.0
2017-12-21 06:35:00	AAPL	Stock	43.55	43.55	43.55	43.55	400.0
2017-12-21 06:55:00	AAPL	Stock	43.515	43.515	43.5025	43.5025	1080.0
2017-12-21 07:00:00	AAPL	Stock	43.5	43.525	43.5	43.525	2200.0
2017-12-21 07:05:00	AAPL	Stock	43.5375	43.5375	43.5375	43.5375	4656.0
2017-12-21 07:15:00	AAPL	Stock	43.54	43.54	43.54	43.54	1200.0
2017-12-21 07:25:00	AAPL	Stock	43.5125	43.5375	43.5125	43.5375	800.0
2017-12-21 07:30:00	AAPL	Stock	43.5125	43.515	43.5125	43.515	2452.0
2017-12-21 07:35:00	AAPL	Stock	43.5275	43.5375	43.5125	43.5375	3636.0
2017-12-21 07:40:00	AAPL	Stock	43.5475	43.5475	43.5475	43.5475	400.0
2017-12-21 07:45:00	AAPL	Stock	43.56	43.565	43.56	43.565	6408.0
2017-12-21 07:50:00	AAPL	Stock	43.57	43.5875	43.5625	43.5625	12900.0
2017-12-21 07:55:00	AAPL	Stock	43.575	43.575	43.5625	43.5625	5800.0
2017-12-21 08:00:00	AAPL	Stock	43.5375	43.5875	43.505	43.5875	30188.0
2017-12-21 08:05:00	AAPL	Stock	43.5875	43.5875	43.5875	43.5875	5600.0
2017-12-21 08:10:00	AAPL	Stock	43.5875	43.605	43.5875	43.605	5200.0
2017-12-21 08:15:00	AAPL	Stock	43.62	43.635	43.6075	43.625	26256.0
2017-12-21 08:20:00	AAPL	Stock	43.6275	43.6275	43.6125	43.625	10248.0
2017-12-21 08:25:00	AAPL	Stock	43.635	43.6375	43.625	43.6375	4060.0
2017-12-21 08:30:00	AAPL	Stock	43.6375	43.6375	43.5875	43.5875	23764.0
2017-12-21 08:35:00	AAPL	Stock	43.6025	43.63	43.5875	43.615	21616.0
2017-12-21 08:40:00	AAPL	Stock	43.62	43.62	43.6125	43.6125	4360.0
2017-12-21 08:45:00	AAPL	Stock	43.615	43.625	43.615	43.625	2400.0
2017-12-21 08:50:00	AAPL	Stock	43.625	43.6325	43.6175	43.6325	33060.0
2017-12-21 08:55:00	AAPL	Stock	43.6375	43.6375	43.625	43.635	3796.0
2017-12-21 09:00:00	AAPL	Stock	43.625	43.625	43.59	43.6125	64348.0
2017-12-21 09:05:00	AAPL	Stock	43.6	43.6	43.5875	43.59	40108.0
2017-12-21 09:10:00	AAPL	Stock	43.59	43.59	43.5625	43.58	40232.0
2017-12-21 09:15:00	AAPL	Stock	43.575	43.5775	43.5275	43.5425	50720.0
2017-12-21 09:20:00	AAPL	Stock	43.54	43.56	43.5375	43.5525	10936.0
2017-12-21 09:25:00	AAPL	Stock	43.5375	43.59	43.5225	43.555	83812.0
2017-12-21 09:30:00	AAPL	Stock	43.5425	43.785	43.525	43.76	3851952.0
2017-12-21 09:35:00	AAPL	Stock	43.7625	43.8275	43.74	43.8125	2498192.0
2017-12-21 09:40:00	AAPL	Stock	43.8125	43.8125	43.7125	43.755	1105100.0
2017-12-21 09:45:00	AAPL	Stock	43.7525	43.7975	43.7325	43.7725	884160.0
2017-12-21 09:50:00	AAPL	Stock	43.7722	43.78	43.69	43.7	1155528.0
2017-12-21 09:55:00	AAPL	Stock	43.7	43.72	43.675	43.72	1067508.0
2017-12-21 10:00:00	AAPL	Stock	43.72	43.78	43.705	43.755	1026028.0
2017-12-21 10:05:00	AAPL	Stock	43.7525	43.7525	43.6825	43.7052	744784.0
2017-12-21 10:10:00	AAPL	Stock	43.705	43.715	43.6425	43.6825	921812.0
2017-12-21 10:15:00	AAPL	Stock	43.6825	43.7025	43.67	43.674	716164.0
2017-12-21 10:20:00	AAPL	Stock	43.6725	43.7245	43.65	43.71	972688.0

> showing 50 of 366,622 rows — these rows as CSV

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