PREVIEW / etf_5min / 2017-01-09

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-01-09.parquet
  size:    1.3 MB
  rows:    54,893

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.2	227.2	2700.0
2017-01-09 04:05:00	SPY	ETF	227.17	227.17	227.17	227.17	200.0
2017-01-09 04:10:00	SPY	ETF	227.2	227.2	227.2	227.2	700.0
2017-01-09 04:15:00	SPY	ETF	227.18	227.18	227.18	227.18	300.0
2017-01-09 04:25:00	SPY	ETF	227.18	227.21	227.18	227.21	900.0
2017-01-09 04:30:00	SPY	ETF	227.17	227.21	227.17	227.19	2900.0
2017-01-09 04:35: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.18	227.18	600.0
2017-01-09 04:50:00	SPY	ETF	227.12	227.16	227.12	227.16	801.0
2017-01-09 04:55:00	SPY	ETF	227.18	227.18	227.18	227.18	303.0
2017-01-09 05:00:00	SPY	ETF	227.21	227.21	227.16	227.16	751.0
2017-01-09 05:05:00	SPY	ETF	227.18	227.18	227.17	227.17	500.0
2017-01-09 05:15:00	SPY	ETF	227.11	227.11	227.11	227.11	301.0
2017-01-09 05:20:00	SPY	ETF	227.11	227.11	227.11	227.11	200.0
2017-01-09 05:40:00	SPY	ETF	227.11	227.11	227.11	227.11	300.0
2017-01-09 05:45:00	SPY	ETF	227.11	227.11	227.07	227.07	2700.0
2017-01-09 05:50:00	SPY	ETF	227.11	227.11	227.08	227.08	600.0
2017-01-09 05:55:00	SPY	ETF	227.04	227.08	227.04	227.08	800.0
2017-01-09 06:00:00	SPY	ETF	227.08	227.08	227.08	227.08	400.0
2017-01-09 06:05:00	SPY	ETF	227.06	227.06	227.02	227.02	903.0
2017-01-09 06:10:00	SPY	ETF	227.03	227.03	226.98	226.98	1504.0
2017-01-09 06:15:00	SPY	ETF	226.98	226.98	226.98	226.98	1400.0
2017-01-09 06:20:00	SPY	ETF	226.98	226.98	226.98	226.98	1600.0
2017-01-09 06:25:00	SPY	ETF	226.96	226.96	226.93	226.93	2215.0
2017-01-09 06:30:00	SPY	ETF	226.92	226.94	226.91	226.91	13001.0
2017-01-09 06:35:00	SPY	ETF	226.91	226.91	226.9	226.9	502.0
2017-01-09 06:40:00	SPY	ETF	226.86	226.93	226.83	226.93	5656.0
2017-01-09 06:45:00	SPY	ETF	226.95	226.98	226.95	226.97	504.0
2017-01-09 06:50:00	SPY	ETF	226.97	226.97	226.96	226.96	1200.0
2017-01-09 06:55:00	SPY	ETF	226.96	226.96	226.96	226.96	300.0
2017-01-09 07:00:00	SPY	ETF	226.95	227.05	226.95	227.01	11699.0
2017-01-09 07:05:00	SPY	ETF	227.01	227.01	226.98	226.99	1251.0
2017-01-09 07:10:00	SPY	ETF	226.96	226.96	226.95	226.95	6100.0
2017-01-09 07:15:00	SPY	ETF	226.95	226.95	226.95	226.95	5600.0
2017-01-09 07:20:00	SPY	ETF	226.95	227.01	226.92	226.92	6506.0
2017-01-09 07:25:00	SPY	ETF	226.9	226.95	226.9	226.95	375.0
2017-01-09 07:35:00	SPY	ETF	227.03	227.03	227.03	227.03	302.0
2017-01-09 07:40:00	SPY	ETF	227.0	227.0	227.0	227.0	6600.0
2017-01-09 07:45:00	SPY	ETF	227.0	227.06	227.0	227.03	6016.0
2017-01-09 07:50:00	SPY	ETF	227.02	227.06	227.01	227.03	1631.0
2017-01-09 07:55:00	SPY	ETF	227.03	227.06	227.03	227.06	1591.0
2017-01-09 08:00:00	SPY	ETF	226.91	227.06	226.91	227.0	25483.0
2017-01-09 08:05:00	SPY	ETF	227.01	227.03	227.0	227.03	2630.0
2017-01-09 08:10:00	SPY	ETF	227.03	227.09	227.01	227.09	14930.0
2017-01-09 08:15:00	SPY	ETF	227.09	227.11	227.07	227.08	12823.0
2017-01-09 08:20:00	SPY	ETF	227.08	227.08	227.02	227.05	10687.0
2017-01-09 08:25:00	SPY	ETF	227.07	227.07	227.0	227.0	61371.0
2017-01-09 08:30:00	SPY	ETF	227.0	227.04	226.99	227.01	80043.0
2017-01-09 08:35:00	SPY	ETF	227.04	227.07	227.03	227.06	4750.0
2017-01-09 08:40:00	SPY	ETF	227.06	227.08	227.04	227.05	14697.0

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

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