PREVIEW / etf_1min / 2017-06-27

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-06-27.parquet
  size:    2.8 MB
  rows:    145,618

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-06-27 04:00:00	SPY	ETF	243.03	243.03	243.0	243.0	460.0
2017-06-27 04:21:00	SPY	ETF	242.93	242.93	242.93	242.93	100.0
2017-06-27 04:22:00	SPY	ETF	242.9	242.9	242.9	242.9	200.0
2017-06-27 04:23:00	SPY	ETF	242.85	242.85	242.76	242.76	1010.0
2017-06-27 04:25:00	SPY	ETF	242.66	242.66	242.66	242.66	130.0
2017-06-27 04:37:00	SPY	ETF	242.85	242.85	242.85	242.85	1500.0
2017-06-27 04:43:00	SPY	ETF	242.9	242.9	242.9	242.9	1000.0
2017-06-27 04:52:00	SPY	ETF	243.03	243.03	243.03	243.03	100.0
2017-06-27 04:53:00	SPY	ETF	242.98	242.98	242.98	242.98	200.0
2017-06-27 04:56:00	SPY	ETF	242.98	242.98	242.98	242.98	300.0
2017-06-27 05:02:00	SPY	ETF	243.06	243.06	243.06	243.06	500.0
2017-06-27 05:23:00	SPY	ETF	243.22	243.22	243.22	243.22	100.0
2017-06-27 05:47:00	SPY	ETF	243.08	243.08	243.08	243.08	100.0
2017-06-27 05:48:00	SPY	ETF	243.07	243.07	243.07	243.07	103.0
2017-06-27 05:49:00	SPY	ETF	242.99	242.99	242.99	242.99	400.0
2017-06-27 05:57:00	SPY	ETF	243.01	243.01	243.01	243.01	400.0
2017-06-27 06:15:00	SPY	ETF	243.01	243.01	243.0	243.0	21300.0
2017-06-27 06:16:00	SPY	ETF	243.0	243.0	242.94	242.94	29800.0
2017-06-27 06:18:00	SPY	ETF	242.94	242.94	242.94	242.94	300.0
2017-06-27 06:29:00	SPY	ETF	243.04	243.04	243.04	243.04	400.0
2017-06-27 06:34:00	SPY	ETF	243.06	243.06	243.06	243.06	300.0
2017-06-27 06:51:00	SPY	ETF	243.06	243.06	243.06	243.06	155.0
2017-06-27 06:54:00	SPY	ETF	243.11	243.12	243.11	243.12	5000.0
2017-06-27 06:59:00	SPY	ETF	243.1	243.1	243.1	243.1	300.0
2017-06-27 07:00:00	SPY	ETF	243.07	243.07	243.04	243.04	500.0
2017-06-27 07:01:00	SPY	ETF	243.02	243.02	242.94	243.0	19800.0
2017-06-27 07:03:00	SPY	ETF	243.02	243.02	243.02	243.02	100.0
2017-06-27 07:05:00	SPY	ETF	243.0	243.0	242.94	242.97	34200.0
2017-06-27 07:06:00	SPY	ETF	242.92	242.95	242.92	242.95	3100.0
2017-06-27 07:07:00	SPY	ETF	242.91	242.91	242.91	242.91	100.0
2017-06-27 07:08:00	SPY	ETF	242.92	242.92	242.92	242.92	100.0
2017-06-27 07:10:00	SPY	ETF	242.96	242.96	242.89	242.89	4910.0
2017-06-27 07:12:00	SPY	ETF	242.9	242.9	242.89	242.89	2000.0
2017-06-27 07:17:00	SPY	ETF	243.01	243.01	243.01	243.01	6000.0
2017-06-27 07:20:00	SPY	ETF	242.99	242.99	242.95	242.95	25400.0
2017-06-27 07:21:00	SPY	ETF	242.99	243.0	242.99	243.0	15169.0
2017-06-27 07:22:00	SPY	ETF	243.0	243.01	243.0	243.01	12011.0
2017-06-27 07:27:00	SPY	ETF	242.92	242.94	242.92	242.94	300.0
2017-06-27 07:28:00	SPY	ETF	242.92	242.94	242.92	242.94	1500.0
2017-06-27 07:29:00	SPY	ETF	242.92	242.94	242.92	242.94	500.0
2017-06-27 07:30:00	SPY	ETF	242.92	242.94	242.88	242.88	5769.0
2017-06-27 07:32:00	SPY	ETF	242.93	242.94	242.93	242.94	1938.0
2017-06-27 07:35:00	SPY	ETF	242.96	242.96	242.96	242.96	969.0
2017-06-27 07:36:00	SPY	ETF	242.98	243.0	242.98	243.0	1204.0
2017-06-27 07:37:00	SPY	ETF	243.0	243.02	243.0	243.02	2607.0
2017-06-27 07:42:00	SPY	ETF	243.0	243.0	243.0	243.0	150.0
2017-06-27 07:45:00	SPY	ETF	243.01	243.01	243.01	243.01	989.0
2017-06-27 07:46:00	SPY	ETF	243.04	243.05	243.04	243.05	1069.0
2017-06-27 07:48:00	SPY	ETF	243.05	243.05	243.05	243.05	969.0
2017-06-27 07:53:00	SPY	ETF	243.06	243.08	243.06	243.07	7938.0

> showing 50 of 145,618 rows — these rows as CSV

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