PREVIEW / etf_1min / 2017-06-08

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-06-08.parquet
  size:    2.6 MB
  rows:    137,004

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-08 04:09:00	SPY	ETF	243.7	243.73	243.7	243.73	2000.0
2017-06-08 04:10:00	SPY	ETF	243.73	243.73	243.68	243.68	1825.0
2017-06-08 04:16:00	SPY	ETF	243.69	243.69	243.69	243.69	2000.0
2017-06-08 04:20:00	SPY	ETF	243.71	243.71	243.71	243.71	370.0
2017-06-08 04:26:00	SPY	ETF	243.73	243.73	243.71	243.71	4000.0
2017-06-08 04:29:00	SPY	ETF	243.76	243.76	243.76	243.76	400.0
2017-06-08 04:41:00	SPY	ETF	243.78	243.78	243.78	243.78	400.0
2017-06-08 04:44:00	SPY	ETF	243.81	243.81	243.81	243.81	900.0
2017-06-08 04:52:00	SPY	ETF	243.76	243.76	243.76	243.76	500.0
2017-06-08 05:06:00	SPY	ETF	243.81	243.81	243.81	243.81	4000.0
2017-06-08 05:18:00	SPY	ETF	243.86	243.86	243.86	243.86	1900.0
2017-06-08 05:21:00	SPY	ETF	243.88	243.92	243.88	243.92	400.0
2017-06-08 05:23:00	SPY	ETF	243.88	243.88	243.86	243.86	1000.0
2017-06-08 05:40:00	SPY	ETF	243.86	243.86	243.86	243.86	400.0
2017-06-08 05:41:00	SPY	ETF	243.86	243.86	243.86	243.86	300.0
2017-06-08 05:48:00	SPY	ETF	243.85	243.85	243.85	243.85	300.0
2017-06-08 05:49:00	SPY	ETF	243.88	243.88	243.83	243.83	3400.0
2017-06-08 06:00:00	SPY	ETF	243.87	243.87	243.87	243.87	100.0
2017-06-08 06:04:00	SPY	ETF	243.86	243.86	243.86	243.86	400.0
2017-06-08 06:06:00	SPY	ETF	243.86	243.86	243.86	243.86	300.0
2017-06-08 06:16:00	SPY	ETF	243.83	243.83	243.83	243.83	1500.0
2017-06-08 06:17:00	SPY	ETF	243.9	243.9	243.9	243.9	2000.0
2017-06-08 06:19:00	SPY	ETF	243.91	243.91	243.91	243.91	380.0
2017-06-08 06:22:00	SPY	ETF	243.93	243.93	243.93	243.93	1000.0
2017-06-08 06:23:00	SPY	ETF	243.94	243.94	243.94	243.94	300.0
2017-06-08 06:27:00	SPY	ETF	243.93	243.95	243.93	243.94	4000.0
2017-06-08 06:30:00	SPY	ETF	243.96	243.96	243.96	243.96	4600.0
2017-06-08 06:33:00	SPY	ETF	243.97	243.97	243.97	243.97	500.0
2017-06-08 06:38:00	SPY	ETF	243.97	243.98	243.97	243.98	30000.0
2017-06-08 06:45:00	SPY	ETF	243.97	244.0	243.97	244.0	2950.0
2017-06-08 06:46:00	SPY	ETF	243.99	244.0	243.98	244.0	23700.0
2017-06-08 06:47:00	SPY	ETF	244.0	244.0	244.0	244.0	18900.0
2017-06-08 06:52:00	SPY	ETF	243.98	244.08	243.98	244.08	3220.0
2017-06-08 06:54:00	SPY	ETF	244.03	244.03	244.0	244.0	20000.0
2017-06-08 06:55:00	SPY	ETF	244.0	244.0	244.0	244.0	1200.0
2017-06-08 06:59:00	SPY	ETF	244.03	244.03	244.03	244.03	200.0
2017-06-08 07:01:00	SPY	ETF	244.03	244.06	244.03	244.03	7357.0
2017-06-08 07:02:00	SPY	ETF	244.05	244.05	244.03	244.05	4750.0
2017-06-08 07:03:00	SPY	ETF	244.05	244.05	244.05	244.05	3396.0
2017-06-08 07:04:00	SPY	ETF	244.07	244.07	244.07	244.07	22840.0
2017-06-08 07:05:00	SPY	ETF	244.07	244.07	244.07	244.07	900.0
2017-06-08 07:06:00	SPY	ETF	244.07	244.07	244.07	244.07	13700.0
2017-06-08 07:07:00	SPY	ETF	244.07	244.07	244.07	244.07	5000.0
2017-06-08 07:08:00	SPY	ETF	244.07	244.07	244.06	244.06	8520.0
2017-06-08 07:09:00	SPY	ETF	244.05	244.06	244.05	244.06	4480.0
2017-06-08 07:10:00	SPY	ETF	244.04	244.04	244.04	244.04	3000.0
2017-06-08 07:11:00	SPY	ETF	244.05	244.05	244.05	244.05	460.0
2017-06-08 07:12:00	SPY	ETF	244.03	244.05	244.03	244.04	37938.0
2017-06-08 07:14:00	SPY	ETF	244.06	244.06	244.06	244.06	1000.0
2017-06-08 07:15:00	SPY	ETF	244.05	244.05	244.05	244.05	350.0

> showing 50 of 137,004 rows — these rows as CSV

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