PREVIEW / stock_5min / 2017-02-21

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-02-21.parquet
  size:    5.5 MB
  rows:    361,386
  symbols: 3,122

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-02-21 04:00:00	AAPL	Stock	34.005	34.005	34.0025	34.005	41328.0
2017-02-21 04:05:00	AAPL	Stock	34.0625	34.0625	34.0625	34.0625	2400.0
2017-02-21 04:15:00	AAPL	Stock	34.075	34.075	34.055	34.0625	1200.0
2017-02-21 04:20:00	AAPL	Stock	34.065	34.0775	34.065	34.0775	6800.0
2017-02-21 04:25:00	AAPL	Stock	34.0675	34.075	34.0675	34.075	4400.0
2017-02-21 04:30:00	AAPL	Stock	34.085	34.085	34.08	34.08	4264.0
2017-02-21 04:40:00	AAPL	Stock	34.08	34.08	34.08	34.08	400.0
2017-02-21 04:55:00	AAPL	Stock	34.0875	34.0875	34.0875	34.0875	664.0
2017-02-21 05:20:00	AAPL	Stock	34.15	34.15	34.15	34.15	800.0
2017-02-21 05:25:00	AAPL	Stock	34.1125	34.1125	34.1125	34.1125	436.0
2017-02-21 05:40:00	AAPL	Stock	34.1125	34.1125	34.1125	34.1125	1200.0
2017-02-21 06:00:00	AAPL	Stock	34.1125	34.1125	34.1125	34.1125	2684.0
2017-02-21 06:10:00	AAPL	Stock	34.095	34.095	34.0675	34.0675	3556.0
2017-02-21 06:15:00	AAPL	Stock	34.0875	34.11	34.0875	34.105	4424.0
2017-02-21 06:25:00	AAPL	Stock	34.1225	34.1225	34.1225	34.1225	432.0
2017-02-21 06:40:00	AAPL	Stock	34.1175	34.125	34.1175	34.125	1600.0
2017-02-21 06:45:00	AAPL	Stock	34.145	34.15	34.145	34.15	5200.0
2017-02-21 06:50:00	AAPL	Stock	34.15	34.15	34.125	34.125	13072.0
2017-02-21 06:55:00	AAPL	Stock	34.125	34.125	34.125	34.125	8076.0
2017-02-21 07:00:00	AAPL	Stock	34.1225	34.125	34.1125	34.1125	5512.0
2017-02-21 07:05:00	AAPL	Stock	34.115	34.145	34.0975	34.0975	34024.0
2017-02-21 07:10:00	AAPL	Stock	34.1025	34.1175	34.1	34.1175	31864.0
2017-02-21 07:15:00	AAPL	Stock	34.1125	34.1175	34.1025	34.1025	5860.0
2017-02-21 07:20:00	AAPL	Stock	34.1125	34.1175	34.11	34.1175	12192.0
2017-02-21 07:25:00	AAPL	Stock	34.1125	34.1175	34.1125	34.1175	800.0
2017-02-21 07:30:00	AAPL	Stock	34.1175	34.1225	34.1175	34.1225	14904.0
2017-02-21 07:35:00	AAPL	Stock	34.1175	34.1175	34.1	34.1125	28984.0
2017-02-21 07:40:00	AAPL	Stock	34.1125	34.115	34.1025	34.1025	9000.0
2017-02-21 07:55:00	AAPL	Stock	34.1125	34.1125	34.0975	34.0975	9600.0
2017-02-21 08:00:00	AAPL	Stock	34.0975	34.1375	33.85	34.07	157156.0
2017-02-21 08:05:00	AAPL	Stock	34.0875	34.1	34.0625	34.095	22872.0
2017-02-21 08:10:00	AAPL	Stock	34.07	34.08	34.07	34.08	7380.0
2017-02-21 08:15:00	AAPL	Stock	34.0775	34.09	34.0725	34.0875	30948.0
2017-02-21 08:20:00	AAPL	Stock	34.0825	34.0825	34.0775	34.0775	8656.0
2017-02-21 08:25:00	AAPL	Stock	34.075	34.0825	34.0375	34.0575	82552.0
2017-02-21 08:30:00	AAPL	Stock	34.0525	34.0625	34.05	34.05	8000.0
2017-02-21 08:35:00	AAPL	Stock	34.07	34.0725	34.0675	34.0725	33624.0
2017-02-21 08:40:00	AAPL	Stock	34.0625	34.0725	34.0625	34.0725	18400.0
2017-02-21 08:45:00	AAPL	Stock	34.0725	34.0825	34.0625	34.0825	24856.0
2017-02-21 08:50:00	AAPL	Stock	34.0825	34.1025	34.08	34.1	49812.0
2017-02-21 08:55:00	AAPL	Stock	34.1	34.1075	34.095	34.105	39488.0
2017-02-21 09:00:00	AAPL	Stock	34.11	34.1175	34.0975	34.0975	47780.0
2017-02-21 09:05:00	AAPL	Stock	34.1	34.1225	34.1	34.1225	29516.0
2017-02-21 09:10:00	AAPL	Stock	34.1225	34.125	34.1125	34.125	39604.0
2017-02-21 09:15:00	AAPL	Stock	34.1175	34.135	34.1175	34.135	24068.0
2017-02-21 09:20:00	AAPL	Stock	34.125	34.125	34.1175	34.12	11396.0
2017-02-21 09:25:00	AAPL	Stock	34.12	34.1375	34.06	34.06	264476.0
2017-02-21 09:30:00	AAPL	Stock	34.06	34.155	34.04	34.1075	7967228.0
2017-02-21 09:35:00	AAPL	Stock	34.1	34.1475	34.075	34.105	3071544.0
2017-02-21 09:40:00	AAPL	Stock	34.105	34.1075	33.995	34.0928	3409444.0

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

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