PREVIEW / etf_5min / 2017-02-02

all etf 5-min files

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

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-02 04:00:00	SPY	ETF	227.04	227.08	226.86	226.87	1250.0
2017-02-02 04:05:00	SPY	ETF	226.9	226.93	226.85	226.85	2110.0
2017-02-02 04:10:00	SPY	ETF	226.84	226.87	226.84	226.87	200.0
2017-02-02 04:30:00	SPY	ETF	226.82	226.82	226.82	226.82	200.0
2017-02-02 04:35:00	SPY	ETF	226.83	226.83	226.75	226.75	403.0
2017-02-02 04:40:00	SPY	ETF	226.77	226.77	226.77	226.77	300.0
2017-02-02 04:45:00	SPY	ETF	226.8	226.8	226.8	226.8	953.0
2017-02-02 04:55:00	SPY	ETF	226.78	226.83	226.78	226.83	2060.0
2017-02-02 05:00:00	SPY	ETF	226.77	226.77	226.74	226.74	505.0
2017-02-02 05:05:00	SPY	ETF	226.74	226.77	226.74	226.77	1020.0
2017-02-02 05:10:00	SPY	ETF	226.71	226.71	226.7	226.7	443.0
2017-02-02 05:15:00	SPY	ETF	226.69	226.69	226.68	226.68	2902.0
2017-02-02 05:20:00	SPY	ETF	226.7	226.83	226.69	226.82	53672.0
2017-02-02 05:25:00	SPY	ETF	226.77	226.81	226.77	226.81	4401.0
2017-02-02 05:30:00	SPY	ETF	226.85	226.85	226.85	226.85	804.0
2017-02-02 05:35:00	SPY	ETF	226.9	226.9	226.9	226.9	1999.0
2017-02-02 05:45:00	SPY	ETF	226.85	226.91	226.85	226.87	2302.0
2017-02-02 05:50:00	SPY	ETF	226.86	226.89	226.86	226.89	4503.0
2017-02-02 06:00:00	SPY	ETF	226.93	226.93	226.93	226.93	2300.0
2017-02-02 06:05:00	SPY	ETF	226.9	226.93	226.9	226.93	608.0
2017-02-02 06:15:00	SPY	ETF	226.99	227.07	226.99	227.07	247.0
2017-02-02 06:20:00	SPY	ETF	227.09	227.09	227.07	227.07	1080.0
2017-02-02 06:25:00	SPY	ETF	227.01	227.01	227.01	227.01	200.0
2017-02-02 06:30:00	SPY	ETF	226.97	226.97	226.97	226.97	600.0
2017-02-02 06:35:00	SPY	ETF	227.04	227.04	227.04	227.04	100.0
2017-02-02 06:45:00	SPY	ETF	226.95	226.95	226.95	226.95	200.0
2017-02-02 06:50:00	SPY	ETF	227.05	227.05	227.05	227.05	202.0
2017-02-02 06:55:00	SPY	ETF	227.01	227.02	227.01	227.02	400.0
2017-02-02 07:00:00	SPY	ETF	227.0	227.04	226.94	227.02	2326.0
2017-02-02 07:05:00	SPY	ETF	226.96	226.96	226.95	226.95	3004.0
2017-02-02 07:10:00	SPY	ETF	226.98	227.02	226.97	227.02	2501.0
2017-02-02 07:15:00	SPY	ETF	226.97	227.04	226.97	227.04	3078.0
2017-02-02 07:20:00	SPY	ETF	227.02	227.02	226.97	226.99	11950.0
2017-02-02 07:25:00	SPY	ETF	227.08	227.08	227.01	227.01	9426.0
2017-02-02 07:30:00	SPY	ETF	227.02	227.1	227.02	227.08	12183.0
2017-02-02 07:35:00	SPY	ETF	227.09	227.12	227.06	227.09	9502.0
2017-02-02 07:40:00	SPY	ETF	227.07	227.24	227.07	227.24	7725.0
2017-02-02 07:45:00	SPY	ETF	227.25	227.26	227.19	227.19	5776.0
2017-02-02 07:55:00	SPY	ETF	227.12	227.19	227.12	227.15	32175.0
2017-02-02 08:00:00	SPY	ETF	227.15	227.18	226.839	227.14	30855.0
2017-02-02 08:05:00	SPY	ETF	227.14	227.16	227.07	227.08	8606.0
2017-02-02 08:10:00	SPY	ETF	227.08	227.09	227.06	227.06	10072.0
2017-02-02 08:15:00	SPY	ETF	227.05	227.09	226.97	227.09	48523.0
2017-02-02 08:20:00	SPY	ETF	227.09	227.09	227.02	227.02	24510.0
2017-02-02 08:25:00	SPY	ETF	227.01	227.03	226.98	227.02	17332.0
2017-02-02 08:30:00	SPY	ETF	227.02	227.12	227.01	227.06	23134.0
2017-02-02 08:35:00	SPY	ETF	227.12	227.16	227.09	227.12	18814.0
2017-02-02 08:40:00	SPY	ETF	227.1	227.1	226.99	226.99	33301.0
2017-02-02 08:45:00	SPY	ETF	226.98	227.03	226.88	226.96	105107.0
2017-02-02 08:50:00	SPY	ETF	226.96	227.0	226.91	226.96	33527.0

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

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