PREVIEW / stock_5min / 2017-09-18

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-09-18.parquet
  size:    5.5 MB
  rows:    357,425
  symbols: 2,965

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-18 04:20:00	AAPL	Stock	40.055	40.055	40.05	40.05	2164.0
2017-09-18 04:35:00	AAPL	Stock	40.1125	40.15	40.1125	40.15	5200.0
2017-09-18 04:40:00	AAPL	Stock	40.15	40.15	40.15	40.15	400.0
2017-09-18 05:20:00	AAPL	Stock	40.125	40.125	40.125	40.125	1200.0
2017-09-18 05:30:00	AAPL	Stock	40.1225	40.1575	40.1225	40.1575	996.0
2017-09-18 05:40:00	AAPL	Stock	40.1225	40.1225	40.1225	40.1225	400.0
2017-09-18 05:45:00	AAPL	Stock	40.125	40.125	40.125	40.125	800.0
2017-09-18 05:50:00	AAPL	Stock	40.15	40.15	40.15	40.15	400.0
2017-09-18 05:55:00	AAPL	Stock	40.15	40.15	40.1375	40.1375	3104.0
2017-09-18 06:00:00	AAPL	Stock	40.16	40.1625	40.14	40.14	4000.0
2017-09-18 06:05:00	AAPL	Stock	40.1425	40.1425	40.1425	40.1425	1200.0
2017-09-18 06:10:00	AAPL	Stock	40.145	40.145	40.145	40.145	400.0
2017-09-18 06:15:00	AAPL	Stock	40.1425	40.15	40.1375	40.1425	5064.0
2017-09-18 06:20:00	AAPL	Stock	40.1475	40.1475	40.1375	40.145	3600.0
2017-09-18 06:25:00	AAPL	Stock	40.145	40.145	40.1375	40.1425	2000.0
2017-09-18 06:35:00	AAPL	Stock	40.1375	40.1375	40.1375	40.1375	400.0
2017-09-18 06:40:00	AAPL	Stock	40.15	40.15	40.15	40.15	1200.0
2017-09-18 06:45:00	AAPL	Stock	40.1375	40.1375	40.1125	40.1125	10988.0
2017-09-18 06:50:00	AAPL	Stock	40.1125	40.15	40.1125	40.15	800.0
2017-09-18 07:00:00	AAPL	Stock	40.1425	40.1425	40.1225	40.1225	6400.0
2017-09-18 07:05:00	AAPL	Stock	40.125	40.14	40.125	40.14	1200.0
2017-09-18 07:10:00	AAPL	Stock	40.135	40.135	40.1175	40.1175	4800.0
2017-09-18 07:15:00	AAPL	Stock	40.1175	40.12	40.1075	40.12	2012.0
2017-09-18 07:20:00	AAPL	Stock	40.13	40.13	40.1	40.1	8804.0
2017-09-18 07:25:00	AAPL	Stock	40.12	40.12	40.09	40.09	17236.0
2017-09-18 07:30:00	AAPL	Stock	40.09	40.1	40.0875	40.1	2800.0
2017-09-18 07:35:00	AAPL	Stock	40.1	40.1	40.075	40.0775	28816.0
2017-09-18 07:40:00	AAPL	Stock	40.0975	40.1	40.0925	40.0925	7180.0
2017-09-18 07:45:00	AAPL	Stock	40.08	40.08	40.0775	40.08	2520.0
2017-09-18 07:50:00	AAPL	Stock	40.0875	40.0875	40.0875	40.0875	5600.0
2017-09-18 07:55:00	AAPL	Stock	40.09	40.09	40.08	40.08	6628.0
2017-09-18 08:00:00	AAPL	Stock	40.08	40.145	40.07	40.0775	87220.0
2017-09-18 08:05:00	AAPL	Stock	40.07	40.075	40.07	40.075	12084.0
2017-09-18 08:10:00	AAPL	Stock	39.97	40.07	39.97	40.05	22080.0
2017-09-18 08:15:00	AAPL	Stock	40.05	40.05	40.025	40.035	17100.0
2017-09-18 08:20:00	AAPL	Stock	40.0475	40.0475	40.035	40.0475	7328.0
2017-09-18 08:25:00	AAPL	Stock	40.0325	40.0475	40.025	40.0475	19648.0
2017-09-18 08:30:00	AAPL	Stock	40.0575	40.0575	40.04	40.05	33628.0
2017-09-18 08:35:00	AAPL	Stock	40.05	40.06	40.04	40.06	14040.0
2017-09-18 08:40:00	AAPL	Stock	40.0525	40.0525	40.0425	40.05	27300.0
2017-09-18 08:45:00	AAPL	Stock	40.06	40.08	40.03	40.03	35880.0
2017-09-18 08:50:00	AAPL	Stock	40.03	40.03	40.01	40.0125	16956.0
2017-09-18 08:55:00	AAPL	Stock	40.02	40.02	40.0025	40.02	15140.0
2017-09-18 09:00:00	AAPL	Stock	40.025	40.0475	40.025	40.0275	2448.0
2017-09-18 09:05:00	AAPL	Stock	40.05	40.0575	40.04	40.0575	11680.0
2017-09-18 09:10:00	AAPL	Stock	40.0575	40.0875	40.055	40.0875	40396.0
2017-09-18 09:15:00	AAPL	Stock	40.0825	40.0925	40.08	40.09	37132.0
2017-09-18 09:20:00	AAPL	Stock	40.09	40.095	40.0875	40.0925	21000.0
2017-09-18 09:25:00	AAPL	Stock	40.075	40.0825	40.04	40.04	46416.0
2017-09-18 09:30:00	AAPL	Stock	40.0275	40.125	39.9275	39.975	5047964.0

> showing 50 of 357,425 rows — these rows as CSV

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