PREVIEW / etf_5min / 2017-02-01

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-02-01.parquet
  size:    1.3 MB
  rows:    56,621

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-01 04:15:00	SPY	ETF	227.9	228.0	227.9	228.0	300.0
2017-02-01 04:30:00	SPY	ETF	228.0	228.0	228.0	228.0	1800.0
2017-02-01 04:50:00	SPY	ETF	227.96	228.03	227.96	228.03	2116.0
2017-02-01 04:55:00	SPY	ETF	228.05	228.08	228.05	228.08	1302.0
2017-02-01 05:00:00	SPY	ETF	228.06	228.06	228.02	228.02	1506.0
2017-02-01 05:05:00	SPY	ETF	228.02	228.02	228.02	228.02	1300.0
2017-02-01 05:10:00	SPY	ETF	228.02	228.13	228.02	228.13	9754.0
2017-02-01 05:25:00	SPY	ETF	228.15	228.15	228.15	228.15	700.0
2017-02-01 05:30:00	SPY	ETF	228.14	228.14	228.14	228.14	800.0
2017-02-01 05:35:00	SPY	ETF	228.14	228.14	228.1	228.1	1300.0
2017-02-01 05:40:00	SPY	ETF	228.05	228.08	228.05	228.08	603.0
2017-02-01 05:45:00	SPY	ETF	228.05	228.05	228.05	228.05	300.0
2017-02-01 05:50:00	SPY	ETF	228.08	228.08	228.08	228.08	401.0
2017-02-01 05:55:00	SPY	ETF	228.0	228.06	228.0	228.06	200.0
2017-02-01 06:05:00	SPY	ETF	228.02	228.08	228.02	228.08	1001.0
2017-02-01 06:10:00	SPY	ETF	228.05	228.05	228.03	228.03	5000.0
2017-02-01 06:15:00	SPY	ETF	228.05	228.05	228.05	228.05	100.0
2017-02-01 06:25:00	SPY	ETF	228.05	228.05	228.05	228.05	200.0
2017-02-01 06:35:00	SPY	ETF	228.04	228.04	228.01	228.01	2975.0
2017-02-01 06:40:00	SPY	ETF	227.94	227.94	227.94	227.94	612.0
2017-02-01 06:50:00	SPY	ETF	227.98	227.98	227.98	227.98	100.0
2017-02-01 06:55:00	SPY	ETF	227.96	227.96	227.96	227.96	10100.0
2017-02-01 07:00:00	SPY	ETF	228.02	228.06	228.02	228.04	7957.0
2017-02-01 07:05:00	SPY	ETF	228.04	228.05	228.03	228.04	5901.0
2017-02-01 07:10:00	SPY	ETF	228.06	228.07	228.06	228.07	1002.0
2017-02-01 07:15:00	SPY	ETF	228.08	228.09	228.08	228.09	22553.0
2017-02-01 07:20:00	SPY	ETF	228.08	228.08	228.02	228.02	2974.0
2017-02-01 07:25:00	SPY	ETF	227.99	228.03	227.99	228.03	10200.0
2017-02-01 07:35:00	SPY	ETF	228.03	228.03	228.01	228.01	791.0
2017-02-01 07:40:00	SPY	ETF	228.01	228.03	228.0	228.02	38498.0
2017-02-01 07:45:00	SPY	ETF	228.06	228.06	228.02	228.05	7278.0
2017-02-01 07:50:00	SPY	ETF	228.02	228.06	228.02	228.06	3001.0
2017-02-01 07:55:00	SPY	ETF	228.08	228.11	228.08	228.1	29528.0
2017-02-01 08:00:00	SPY	ETF	228.09	228.09	227.97	228.03	42033.0
2017-02-01 08:05:00	SPY	ETF	228.03	228.06	228.01	228.04	7432.0
2017-02-01 08:10:00	SPY	ETF	228.06	228.1	228.05	228.08	8754.0
2017-02-01 08:15:00	SPY	ETF	228.11	228.23	228.11	228.2	68074.0
2017-02-01 08:20:00	SPY	ETF	228.22	228.26	228.22	228.26	70805.0
2017-02-01 08:25:00	SPY	ETF	228.23	228.26	228.16	228.19	25892.0
2017-02-01 08:30:00	SPY	ETF	228.21	228.21	228.15	228.15	51903.0
2017-02-01 08:35:00	SPY	ETF	228.19	228.2	228.14	228.16	10879.0
2017-02-01 08:40:00	SPY	ETF	228.15	228.22	228.15	228.2	90200.0
2017-02-01 08:45:00	SPY	ETF	228.2	228.28	228.19	228.22	45738.0
2017-02-01 08:50:00	SPY	ETF	228.21	228.22	227.53	228.22	55604.0
2017-02-01 08:55:00	SPY	ETF	228.23	228.23	228.13	228.15	60294.0
2017-02-01 09:00:00	SPY	ETF	228.18	228.22	228.13	228.13	39648.0
2017-02-01 09:05:00	SPY	ETF	228.13	228.16	228.1	228.1	41085.0
2017-02-01 09:10:00	SPY	ETF	228.11	228.24	228.11	228.22	112589.0
2017-02-01 09:15:00	SPY	ETF	228.22	228.26	228.21	228.23	33836.0
2017-02-01 09:20:00	SPY	ETF	228.23	228.28	228.23	228.28	59780.0

> showing 50 of 56,621 rows — these rows as CSV

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