PREVIEW / stock_5min / 2017-10-20

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-10-20.parquet
  size:    5.4 MB
  rows:    348,996
  symbols: 2,948

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-10-20 04:00:00	AAPL	Stock	39.05	39.1875	39.05	39.1875	2632.0
2017-10-20 04:10:00	AAPL	Stock	39.15	39.15	39.15	39.15	1200.0
2017-10-20 04:25:00	AAPL	Stock	39.175	39.175	39.175	39.175	800.0
2017-10-20 04:40:00	AAPL	Stock	39.125	39.125	39.1225	39.125	1400.0
2017-10-20 04:45:00	AAPL	Stock	39.15	39.15	39.15	39.15	400.0
2017-10-20 04:55:00	AAPL	Stock	39.15	39.15	39.15	39.15	400.0
2017-10-20 05:10:00	AAPL	Stock	39.1625	39.1625	39.1625	39.1625	400.0
2017-10-20 05:20:00	AAPL	Stock	39.15	39.1625	39.15	39.1625	1600.0
2017-10-20 05:25:00	AAPL	Stock	39.1625	39.1625	39.145	39.145	2000.0
2017-10-20 05:30:00	AAPL	Stock	39.145	39.145	39.145	39.145	800.0
2017-10-20 05:35:00	AAPL	Stock	39.1625	39.1625	39.1625	39.1625	400.0
2017-10-20 05:40:00	AAPL	Stock	39.1375	39.1375	39.1375	39.1375	800.0
2017-10-20 05:45:00	AAPL	Stock	39.125	39.125	39.125	39.125	488.0
2017-10-20 06:05:00	AAPL	Stock	39.175	39.185	39.175	39.185	8432.0
2017-10-20 06:10:00	AAPL	Stock	39.175	39.175	39.175	39.175	2800.0
2017-10-20 06:35:00	AAPL	Stock	39.175	39.175	39.15	39.15	5200.0
2017-10-20 06:45:00	AAPL	Stock	39.1525	39.1525	39.1525	39.1525	2000.0
2017-10-20 06:55:00	AAPL	Stock	39.1525	39.1525	39.1525	39.1525	400.0
2017-10-20 07:00:00	AAPL	Stock	39.175	39.1875	39.1125	39.1125	28460.0
2017-10-20 07:05:00	AAPL	Stock	39.115	39.115	39.1	39.1	7688.0
2017-10-20 07:10:00	AAPL	Stock	39.1	39.1	39.0875	39.0875	12476.0
2017-10-20 07:15:00	AAPL	Stock	39.0875	39.11	39.0775	39.0775	5372.0
2017-10-20 07:20:00	AAPL	Stock	39.0825	39.0825	39.0825	39.0825	400.0
2017-10-20 07:25:00	AAPL	Stock	39.08	39.1175	39.0775	39.0775	7200.0
2017-10-20 07:30:00	AAPL	Stock	39.1	39.115	39.0775	39.11	18768.0
2017-10-20 07:35:00	AAPL	Stock	39.125	39.1625	39.125	39.1625	18140.0
2017-10-20 07:40:00	AAPL	Stock	39.15	39.16	39.1375	39.145	37596.0
2017-10-20 07:45:00	AAPL	Stock	39.15	39.1575	39.15	39.1525	3600.0
2017-10-20 07:50:00	AAPL	Stock	39.16	39.16	39.16	39.16	7600.0
2017-10-20 07:55:00	AAPL	Stock	39.16	39.16	39.135	39.1375	11600.0
2017-10-20 08:00:00	AAPL	Stock	39.175	39.175	39.0875	39.1125	121760.0
2017-10-20 08:05:00	AAPL	Stock	39.1175	39.1275	39.1125	39.125	6340.0
2017-10-20 08:10:00	AAPL	Stock	39.125	39.1525	39.125	39.1525	37116.0
2017-10-20 08:15:00	AAPL	Stock	39.155	39.1575	39.15	39.1575	18352.0
2017-10-20 08:20:00	AAPL	Stock	39.15	39.1625	39.145	39.15	24796.0
2017-10-20 08:25:00	AAPL	Stock	39.1575	39.1625	39.1575	39.1625	15080.0
2017-10-20 08:30:00	AAPL	Stock	39.1625	39.1625	39.1575	39.16	10244.0
2017-10-20 08:35:00	AAPL	Stock	39.1575	39.16	39.1575	39.1575	13352.0
2017-10-20 08:40:00	AAPL	Stock	39.1575	39.165	39.1525	39.1525	12568.0
2017-10-20 08:45:00	AAPL	Stock	39.165	39.165	39.1475	39.1525	12436.0
2017-10-20 08:50:00	AAPL	Stock	39.155	39.1575	39.1475	39.15	18024.0
2017-10-20 08:55:00	AAPL	Stock	39.145	39.1575	39.1375	39.15	43544.0
2017-10-20 09:00:00	AAPL	Stock	39.15	39.1575	39.15	39.1575	11104.0
2017-10-20 09:05:00	AAPL	Stock	39.1575	39.17	39.15	39.17	78148.0
2017-10-20 09:10:00	AAPL	Stock	39.175	39.1975	39.165	39.175	71472.0
2017-10-20 09:15:00	AAPL	Stock	39.18	39.2125	39.175	39.1875	79584.0
2017-10-20 09:20:00	AAPL	Stock	39.1875	39.27	39.1875	39.2625	218184.0
2017-10-20 09:25:00	AAPL	Stock	39.25	39.3	39.225	39.225	285852.0
2017-10-20 09:30:00	AAPL	Stock	39.2275	39.2625	39.1525	39.2	6499588.0
2017-10-20 09:35:00	AAPL	Stock	39.1975	39.2125	39.135	39.135	1895968.0

> showing 50 of 348,996 rows — these rows as CSV

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