PREVIEW / etf_1min / 2017-02-16

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-02-16.parquet
  size:    2.9 MB
  rows:    150,828

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-16 04:00:00	SPY	ETF	235.0	235.0	235.0	235.0	100.0
2017-02-16 04:04:00	SPY	ETF	234.92	234.92	234.88	234.88	1600.0
2017-02-16 04:05:00	SPY	ETF	234.94	234.94	234.94	234.94	400.0
2017-02-16 04:06:00	SPY	ETF	234.94	234.94	234.94	234.94	100.0
2017-02-16 04:08:00	SPY	ETF	234.97	234.97	234.94	234.94	1550.0
2017-02-16 04:15:00	SPY	ETF	234.93	234.93	234.93	234.93	500.0
2017-02-16 04:16:00	SPY	ETF	234.93	234.93	234.93	234.93	300.0
2017-02-16 04:25:00	SPY	ETF	234.95	234.95	234.95	234.95	200.0
2017-02-16 04:26:00	SPY	ETF	234.94	234.94	234.9	234.9	300.0
2017-02-16 04:30:00	SPY	ETF	234.97	234.97	234.97	234.97	500.0
2017-02-16 04:38:00	SPY	ETF	234.92	234.92	234.92	234.92	500.0
2017-02-16 04:40:00	SPY	ETF	234.92	234.95	234.92	234.95	400.0
2017-02-16 04:41:00	SPY	ETF	234.94	234.95	234.94	234.95	1200.0
2017-02-16 04:51:00	SPY	ETF	234.87	234.87	234.87	234.87	100.0
2017-02-16 04:55:00	SPY	ETF	234.89	234.89	234.89	234.89	200.0
2017-02-16 05:07:00	SPY	ETF	234.85	234.85	234.81	234.81	2786.0
2017-02-16 05:08:00	SPY	ETF	234.84	234.84	234.84	234.84	400.0
2017-02-16 05:14:00	SPY	ETF	234.82	234.9	234.82	234.9	539.0
2017-02-16 05:16:00	SPY	ETF	234.89	234.89	234.89	234.89	100.0
2017-02-16 05:17:00	SPY	ETF	234.85	234.85	234.81	234.81	1800.0
2017-02-16 05:21:00	SPY	ETF	234.89	234.89	234.89	234.89	100.0
2017-02-16 05:23:00	SPY	ETF	234.84	234.84	234.81	234.81	500.0
2017-02-16 05:26:00	SPY	ETF	234.81	234.81	234.81	234.81	350.0
2017-02-16 05:27:00	SPY	ETF	234.81	234.81	234.81	234.81	400.0
2017-02-16 05:28:00	SPY	ETF	234.81	234.81	234.81	234.81	700.0
2017-02-16 05:33:00	SPY	ETF	234.81	234.81	234.81	234.81	300.0
2017-02-16 05:40:00	SPY	ETF	234.81	234.81	234.81	234.81	500.0
2017-02-16 05:42:00	SPY	ETF	234.81	234.81	234.81	234.81	2000.0
2017-02-16 05:45:00	SPY	ETF	234.8	234.8	234.8	234.8	300.0
2017-02-16 05:54:00	SPY	ETF	234.78	234.78	234.78	234.78	300.0
2017-02-16 05:58:00	SPY	ETF	234.83	234.83	234.83	234.83	600.0
2017-02-16 06:03:00	SPY	ETF	234.9	234.9	234.9	234.9	5300.0
2017-02-16 06:04:00	SPY	ETF	234.92	234.92	234.92	234.92	145.0
2017-02-16 06:06:00	SPY	ETF	234.91	234.91	234.9	234.91	9200.0
2017-02-16 06:10:00	SPY	ETF	234.88	234.88	234.88	234.88	100.0
2017-02-16 06:12:00	SPY	ETF	234.86	234.86	234.86	234.86	100.0
2017-02-16 06:13:00	SPY	ETF	234.88	234.88	234.83	234.85	1496.0
2017-02-16 06:16:00	SPY	ETF	234.85	234.85	234.85	234.85	250.0
2017-02-16 06:26:00	SPY	ETF	234.86	234.86	234.86	234.86	600.0
2017-02-16 06:28:00	SPY	ETF	234.83	234.83	234.83	234.83	500.0
2017-02-16 06:36:00	SPY	ETF	234.88	234.88	234.88	234.88	102.0
2017-02-16 06:42:00	SPY	ETF	234.82	234.82	234.82	234.82	120.0
2017-02-16 06:44:00	SPY	ETF	234.86	234.86	234.83	234.83	1700.0
2017-02-16 06:46:00	SPY	ETF	234.83	234.83	234.83	234.83	500.0
2017-02-16 06:48:00	SPY	ETF	234.83	234.83	234.83	234.83	200.0
2017-02-16 06:49:00	SPY	ETF	234.86	234.86	234.86	234.86	300.0
2017-02-16 06:50:00	SPY	ETF	234.83	234.83	234.82	234.82	400.0
2017-02-16 06:54:00	SPY	ETF	234.86	234.86	234.86	234.86	500.0
2017-02-16 06:55:00	SPY	ETF	234.86	234.86	234.86	234.86	300.0
2017-02-16 07:00:00	SPY	ETF	234.88	234.88	234.83	234.88	1900.0

> showing 50 of 150,828 rows — these rows as CSV

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