PREVIEW / etf_5min / 2017-11-02

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-11-02.parquet
  size:    1.3 MB
  rows:    54,439

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-11-02 04:00:00	SPY	ETF	257.1	257.1	257.1	257.1	200.0
2017-11-02 04:10:00	SPY	ETF	257.02	257.02	257.02	257.02	100.0
2017-11-02 04:25:00	SPY	ETF	257.13	257.13	257.13	257.13	200.0
2017-11-02 04:30:00	SPY	ETF	257.15	257.15	257.15	257.15	100.0
2017-11-02 04:40:00	SPY	ETF	257.25	257.25	257.25	257.25	100.0
2017-11-02 04:50:00	SPY	ETF	257.19	257.19	257.15	257.15	400.0
2017-11-02 05:00:00	SPY	ETF	257.0	257.0	256.98	256.98	500.0
2017-11-02 05:10:00	SPY	ETF	256.9	256.9	256.9	256.9	100.0
2017-11-02 05:15:00	SPY	ETF	257.02	257.02	257.02	257.02	100.0
2017-11-02 05:25:00	SPY	ETF	257.14	257.14	257.14	257.14	300.0
2017-11-02 05:30:00	SPY	ETF	257.12	257.12	257.12	257.12	500.0
2017-11-02 05:35:00	SPY	ETF	257.14	257.14	257.14	257.14	200.0
2017-11-02 05:40:00	SPY	ETF	257.1	257.1	257.1	257.1	2000.0
2017-11-02 05:45:00	SPY	ETF	257.12	257.12	257.11	257.11	500.0
2017-11-02 05:50:00	SPY	ETF	257.14	257.19	257.14	257.19	500.0
2017-11-02 05:55:00	SPY	ETF	257.14	257.14	257.14	257.14	300.0
2017-11-02 06:05:00	SPY	ETF	257.17	257.17	257.17	257.17	5000.0
2017-11-02 06:10:00	SPY	ETF	257.12	257.12	257.11	257.11	3200.0
2017-11-02 06:15:00	SPY	ETF	257.12	257.12	257.12	257.12	300.0
2017-11-02 06:20:00	SPY	ETF	257.09	257.09	257.09	257.09	300.0
2017-11-02 06:25:00	SPY	ETF	257.07	257.07	257.04	257.04	10300.0
2017-11-02 06:45:00	SPY	ETF	257.09	257.09	257.09	257.09	300.0
2017-11-02 06:50:00	SPY	ETF	257.08	257.12	257.08	257.12	500.0
2017-11-02 07:00:00	SPY	ETF	257.14	257.3	257.14	257.27	1892.0
2017-11-02 07:05:00	SPY	ETF	257.28	257.3	257.28	257.3	2300.0
2017-11-02 07:10:00	SPY	ETF	257.27	257.29	257.25	257.29	435.0
2017-11-02 07:15:00	SPY	ETF	257.25	257.25	257.23	257.23	10065.0
2017-11-02 07:20:00	SPY	ETF	257.21	257.34	257.2	257.24	5850.0
2017-11-02 07:25:00	SPY	ETF	257.24	257.24	257.17	257.17	8029.0
2017-11-02 07:30:00	SPY	ETF	257.2	257.2	257.2	257.2	100.0
2017-11-02 07:35:00	SPY	ETF	257.23	257.24	257.23	257.24	10145.0
2017-11-02 07:40:00	SPY	ETF	257.25	257.25	257.25	257.25	400.0
2017-11-02 07:45:00	SPY	ETF	257.27	257.27	257.27	257.27	2500.0
2017-11-02 07:50:00	SPY	ETF	257.29	257.33	257.29	257.33	13010.0
2017-11-02 07:55:00	SPY	ETF	257.31	257.31	257.28	257.28	4359.0
2017-11-02 08:00:00	SPY	ETF	257.29	257.38	257.17	257.23	41474.0
2017-11-02 08:05:00	SPY	ETF	257.25	257.25	257.19	257.25	6361.0
2017-11-02 08:10:00	SPY	ETF	257.24	257.24	257.2	257.24	4485.0
2017-11-02 08:15:00	SPY	ETF	257.26	257.28	257.24	257.24	2669.0
2017-11-02 08:20:00	SPY	ETF	257.28	257.31	257.28	257.3	5438.0
2017-11-02 08:25:00	SPY	ETF	257.32	257.32	257.32	257.32	517.0
2017-11-02 08:30:00	SPY	ETF	257.28	257.38	257.28	257.38	15126.0
2017-11-02 08:35:00	SPY	ETF	257.38	257.47	257.38	257.46	74173.0
2017-11-02 08:40:00	SPY	ETF	257.44	257.45	257.4	257.43	9934.0
2017-11-02 08:45:00	SPY	ETF	257.44	257.48	257.4	257.48	4242.0
2017-11-02 08:50:00	SPY	ETF	257.48	257.53	257.48	257.51	23314.0
2017-11-02 08:55:00	SPY	ETF	257.51	257.54	257.47	257.51	36365.0
2017-11-02 09:00:00	SPY	ETF	257.49	257.52	257.45	257.45	55063.0
2017-11-02 09:05:00	SPY	ETF	257.45	257.5	257.39	257.45	19912.0
2017-11-02 09:10:00	SPY	ETF	257.43	257.43	257.4	257.42	10191.0

> showing 50 of 54,439 rows — these rows as CSV

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