PREVIEW / etf_5min / 2017-09-11

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-09-11.parquet
  size:    1.2 MB
  rows:    53,818

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-09-11 04:00:00	SPY	ETF	247.87	247.98	247.87	247.89	3781.0
2017-09-11 04:05:00	SPY	ETF	247.94	247.94	247.89	247.89	1150.0
2017-09-11 04:10:00	SPY	ETF	247.88	247.89	247.85	247.85	11610.0
2017-09-11 04:15:00	SPY	ETF	247.87	247.87	247.87	247.87	950.0
2017-09-11 04:20:00	SPY	ETF	247.89	247.89	247.89	247.89	300.0
2017-09-11 04:25:00	SPY	ETF	247.92	247.98	247.92	247.98	1295.0
2017-09-11 04:30:00	SPY	ETF	247.96	248.02	247.96	248.02	2866.0
2017-09-11 04:35:00	SPY	ETF	248.06	248.1	248.06	248.1	610.0
2017-09-11 04:40:00	SPY	ETF	248.08	248.09	248.08	248.09	500.0
2017-09-11 04:45:00	SPY	ETF	248.11	248.11	248.07	248.07	1200.0
2017-09-11 04:50:00	SPY	ETF	248.07	248.07	248.06	248.06	700.0
2017-09-11 04:55:00	SPY	ETF	248.06	248.06	248.04	248.04	200.0
2017-09-11 05:00:00	SPY	ETF	248.09	248.09	248.02	248.02	1602.0
2017-09-11 05:10:00	SPY	ETF	248.06	248.06	248.04	248.06	1400.0
2017-09-11 05:15:00	SPY	ETF	248.03	248.03	248.01	248.01	1206.0
2017-09-11 05:20:00	SPY	ETF	248.04	248.04	248.04	248.04	900.0
2017-09-11 05:25:00	SPY	ETF	248.08	248.08	248.08	248.08	400.0
2017-09-11 05:30:00	SPY	ETF	248.03	248.03	248.0	248.01	950.0
2017-09-11 05:35:00	SPY	ETF	247.98	248.01	247.98	248.0	1100.0
2017-09-11 05:40:00	SPY	ETF	248.01	248.01	248.01	248.01	200.0
2017-09-11 05:45:00	SPY	ETF	248.01	248.04	248.01	248.04	750.0
2017-09-11 05:50:00	SPY	ETF	248.04	248.04	248.04	248.04	1400.0
2017-09-11 05:55:00	SPY	ETF	248.08	248.08	248.06	248.08	16600.0
2017-09-11 06:00:00	SPY	ETF	248.08	248.08	248.08	248.08	400.0
2017-09-11 06:05:00	SPY	ETF	248.09	248.09	248.09	248.09	300.0
2017-09-11 06:10:00	SPY	ETF	248.05	248.05	248.05	248.05	2193.0
2017-09-11 06:15:00	SPY	ETF	248.02	248.02	248.02	248.02	100.0
2017-09-11 06:25:00	SPY	ETF	248.09	248.11	248.09	248.09	3200.0
2017-09-11 06:30:00	SPY	ETF	248.09	248.09	248.02	248.02	15115.0
2017-09-11 06:35:00	SPY	ETF	248.01	248.05	248.01	248.04	17000.0
2017-09-11 06:45:00	SPY	ETF	248.04	248.06	248.03	248.03	15161.0
2017-09-11 06:50:00	SPY	ETF	248.03	248.06	248.03	248.06	905.0
2017-09-11 06:55:00	SPY	ETF	248.05	248.06	248.05	248.06	5154.0
2017-09-11 07:00:00	SPY	ETF	248.04	248.06	248.03	248.04	6971.0
2017-09-11 07:05:00	SPY	ETF	247.96	247.97	247.94	247.94	17133.0
2017-09-11 07:10:00	SPY	ETF	247.93	247.93	247.89	247.92	13738.0
2017-09-11 07:15:00	SPY	ETF	247.89	247.9	247.89	247.89	552.0
2017-09-11 07:20:00	SPY	ETF	247.89	247.93	247.89	247.91	5089.0
2017-09-11 07:25:00	SPY	ETF	247.89	247.9	247.88	247.88	13294.0
2017-09-11 07:30:00	SPY	ETF	247.88	247.9	247.85	247.86	15047.0
2017-09-11 07:35:00	SPY	ETF	247.86	247.9	247.84	247.84	13877.0
2017-09-11 07:40:00	SPY	ETF	247.82	247.83	247.8	247.82	12791.0
2017-09-11 07:45:00	SPY	ETF	247.8	247.82	247.8	247.81	8485.0
2017-09-11 07:50:00	SPY	ETF	247.81	247.83	247.79	247.83	9125.0
2017-09-11 07:55:00	SPY	ETF	247.8	247.82	247.77	247.81	6506.0
2017-09-11 08:00:00	SPY	ETF	247.82	247.86	247.81	247.85	15310.0
2017-09-11 08:05:00	SPY	ETF	247.85	247.89	247.84	247.89	25850.0
2017-09-11 08:10:00	SPY	ETF	247.9	247.93	247.88	247.88	13226.0
2017-09-11 08:15:00	SPY	ETF	247.88	247.89	247.87	247.88	32454.0
2017-09-11 08:20:00	SPY	ETF	247.86	247.89	247.86	247.86	4100.0

> showing 50 of 53,818 rows — these rows as CSV

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