PREVIEW / etf_1min / 2017-01-09

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-01-09.parquet
  size:    2.8 MB
  rows:    147,569

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-01-09 04:00:00	SPY	ETF	227.21	227.21	227.21	227.21	600.0
2017-01-09 04:02:00	SPY	ETF	227.21	227.21	227.21	227.21	1800.0
2017-01-09 04:04:00	SPY	ETF	227.2	227.2	227.2	227.2	300.0
2017-01-09 04:06:00	SPY	ETF	227.17	227.17	227.17	227.17	200.0
2017-01-09 04:11:00	SPY	ETF	227.2	227.2	227.2	227.2	400.0
2017-01-09 04:12:00	SPY	ETF	227.2	227.2	227.2	227.2	300.0
2017-01-09 04:17:00	SPY	ETF	227.18	227.18	227.18	227.18	300.0
2017-01-09 04:26:00	SPY	ETF	227.18	227.18	227.18	227.18	300.0
2017-01-09 04:27:00	SPY	ETF	227.2	227.2	227.2	227.2	400.0
2017-01-09 04:28:00	SPY	ETF	227.21	227.21	227.21	227.21	200.0
2017-01-09 04:30:00	SPY	ETF	227.17	227.21	227.17	227.21	2000.0
2017-01-09 04:33:00	SPY	ETF	227.21	227.21	227.19	227.19	900.0
2017-01-09 04:37:00	SPY	ETF	227.21	227.23	227.21	227.22	810.0
2017-01-09 04:45:00	SPY	ETF	227.23	227.23	227.23	227.23	300.0
2017-01-09 04:47:00	SPY	ETF	227.18	227.18	227.18	227.18	300.0
2017-01-09 04:53:00	SPY	ETF	227.12	227.12	227.12	227.12	500.0
2017-01-09 04:54:00	SPY	ETF	227.16	227.16	227.16	227.16	301.0
2017-01-09 04:58:00	SPY	ETF	227.18	227.18	227.18	227.18	303.0
2017-01-09 05:01:00	SPY	ETF	227.21	227.21	227.21	227.21	351.0
2017-01-09 05:04:00	SPY	ETF	227.16	227.16	227.16	227.16	400.0
2017-01-09 05:08:00	SPY	ETF	227.18	227.18	227.18	227.18	300.0
2017-01-09 05:09:00	SPY	ETF	227.17	227.17	227.17	227.17	200.0
2017-01-09 05:16:00	SPY	ETF	227.11	227.11	227.11	227.11	301.0
2017-01-09 05:21:00	SPY	ETF	227.11	227.11	227.11	227.11	200.0
2017-01-09 05:44:00	SPY	ETF	227.11	227.11	227.11	227.11	300.0
2017-01-09 05:46:00	SPY	ETF	227.11	227.11	227.11	227.11	200.0
2017-01-09 05:49:00	SPY	ETF	227.07	227.07	227.07	227.07	2500.0
2017-01-09 05:51:00	SPY	ETF	227.11	227.11	227.11	227.11	300.0
2017-01-09 05:53:00	SPY	ETF	227.08	227.08	227.08	227.08	300.0
2017-01-09 05:58:00	SPY	ETF	227.04	227.04	227.04	227.04	500.0
2017-01-09 05:59:00	SPY	ETF	227.08	227.08	227.08	227.08	300.0
2017-01-09 06:00:00	SPY	ETF	227.08	227.08	227.08	227.08	240.0
2017-01-09 06:04:00	SPY	ETF	227.08	227.08	227.08	227.08	160.0
2017-01-09 06:05:00	SPY	ETF	227.06	227.06	227.03	227.03	503.0
2017-01-09 06:06:00	SPY	ETF	227.02	227.02	227.02	227.02	400.0
2017-01-09 06:11:00	SPY	ETF	227.03	227.03	227.03	227.03	400.0
2017-01-09 06:12:00	SPY	ETF	227.03	227.03	227.03	227.03	300.0
2017-01-09 06:13:00	SPY	ETF	227.0	227.0	227.0	227.0	404.0
2017-01-09 06:14:00	SPY	ETF	226.98	226.98	226.98	226.98	400.0
2017-01-09 06:15:00	SPY	ETF	226.98	226.98	226.98	226.98	500.0
2017-01-09 06:16:00	SPY	ETF	226.98	226.98	226.98	226.98	900.0
2017-01-09 06:21:00	SPY	ETF	226.98	226.98	226.98	226.98	300.0
2017-01-09 06:22:00	SPY	ETF	226.98	226.98	226.98	226.98	1300.0
2017-01-09 06:28:00	SPY	ETF	226.96	226.96	226.93	226.93	2015.0
2017-01-09 06:29:00	SPY	ETF	226.93	226.93	226.93	226.93	200.0
2017-01-09 06:31:00	SPY	ETF	226.92	226.92	226.92	226.92	100.0
2017-01-09 06:32:00	SPY	ETF	226.93	226.94	226.92	226.92	12600.0
2017-01-09 06:34:00	SPY	ETF	226.91	226.91	226.91	226.91	301.0
2017-01-09 06:36:00	SPY	ETF	226.91	226.91	226.91	226.91	100.0
2017-01-09 06:37:00	SPY	ETF	226.91	226.91	226.9	226.9	402.0

> showing 50 of 147,569 rows — these rows as CSV

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