PREVIEW / etf_1min / 2017-11-07

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-11-07.parquet
  size:    2.8 MB
  rows:    147,076

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-11-07 04:01:00	SPY	ETF	258.93	259.0	258.92	258.96	2365.0
2017-11-07 04:02:00	SPY	ETF	258.97	258.97	258.97	258.97	800.0
2017-11-07 04:03:00	SPY	ETF	258.97	258.97	258.97	258.97	600.0
2017-11-07 04:04:00	SPY	ETF	258.97	258.97	258.97	258.97	500.0
2017-11-07 04:05:00	SPY	ETF	258.97	258.97	258.97	258.97	500.0
2017-11-07 04:06:00	SPY	ETF	258.96	258.99	258.96	258.99	600.0
2017-11-07 04:08:00	SPY	ETF	259.02	259.02	259.02	259.02	520.0
2017-11-07 04:09:00	SPY	ETF	258.99	258.99	258.99	258.99	500.0
2017-11-07 04:10:00	SPY	ETF	258.97	258.97	258.97	258.97	300.0
2017-11-07 04:11:00	SPY	ETF	259.0	259.0	259.0	259.0	500.0
2017-11-07 04:12:00	SPY	ETF	259.02	259.02	259.02	259.02	800.0
2017-11-07 04:14:00	SPY	ETF	259.02	259.02	259.02	259.02	500.0
2017-11-07 04:15:00	SPY	ETF	259.02	259.02	259.02	259.02	1000.0
2017-11-07 04:18:00	SPY	ETF	259.04	259.04	259.04	259.04	500.0
2017-11-07 04:19:00	SPY	ETF	259.02	259.02	259.02	259.02	300.0
2017-11-07 04:24:00	SPY	ETF	259.04	259.04	259.04	259.04	1000.0
2017-11-07 04:25:00	SPY	ETF	259.04	259.04	259.04	259.04	500.0
2017-11-07 04:27:00	SPY	ETF	259.04	259.04	259.04	259.04	900.0
2017-11-07 04:32:00	SPY	ETF	259.0	259.0	259.0	259.0	900.0
2017-11-07 04:36:00	SPY	ETF	258.99	258.99	258.99	258.99	100.0
2017-11-07 04:39:00	SPY	ETF	259.02	259.02	259.02	259.02	400.0
2017-11-07 04:41:00	SPY	ETF	258.99	258.99	258.97	258.97	3300.0
2017-11-07 04:44:00	SPY	ETF	258.9	258.9	258.9	258.9	1308.0
2017-11-07 04:45:00	SPY	ETF	258.83	258.85	258.83	258.85	1539.0
2017-11-07 04:46:00	SPY	ETF	258.85	258.85	258.85	258.85	100.0
2017-11-07 04:47:00	SPY	ETF	258.87	258.87	258.87	258.87	500.0
2017-11-07 04:48:00	SPY	ETF	258.9	258.9	258.9	258.9	300.0
2017-11-07 04:51:00	SPY	ETF	258.92	258.92	258.92	258.92	1100.0
2017-11-07 04:52:00	SPY	ETF	258.9	258.9	258.9	258.9	900.0
2017-11-07 04:54:00	SPY	ETF	258.9	258.9	258.9	258.9	1200.0
2017-11-07 04:56:00	SPY	ETF	258.95	258.95	258.95	258.95	400.0
2017-11-07 04:57:00	SPY	ETF	258.95	258.95	258.95	258.95	700.0
2017-11-07 05:02:00	SPY	ETF	258.92	258.92	258.92	258.92	300.0
2017-11-07 05:11:00	SPY	ETF	258.87	258.87	258.87	258.87	400.0
2017-11-07 05:22:00	SPY	ETF	258.83	258.83	258.83	258.83	100.0
2017-11-07 05:50:00	SPY	ETF	258.8	258.8	258.8	258.8	100.0
2017-11-07 06:10:00	SPY	ETF	258.9	258.9	258.9	258.9	350.0
2017-11-07 06:11:00	SPY	ETF	258.86	258.86	258.86	258.86	4950.0
2017-11-07 06:13:00	SPY	ETF	258.85	258.85	258.85	258.85	100.0
2017-11-07 06:15:00	SPY	ETF	258.86	258.86	258.86	258.86	100.0
2017-11-07 06:26:00	SPY	ETF	258.8	258.8	258.8	258.8	300.0
2017-11-07 06:29:00	SPY	ETF	258.78	258.78	258.78	258.78	610.0
2017-11-07 06:34:00	SPY	ETF	258.8	258.8	258.8	258.8	300.0
2017-11-07 06:35:00	SPY	ETF	258.84	258.84	258.84	258.84	300.0
2017-11-07 06:39:00	SPY	ETF	258.8	258.8	258.8	258.8	300.0
2017-11-07 06:42:00	SPY	ETF	258.81	258.81	258.81	258.81	100.0
2017-11-07 06:44:00	SPY	ETF	258.83	258.83	258.83	258.83	100.0
2017-11-07 06:49:00	SPY	ETF	258.83	258.83	258.83	258.83	100.0
2017-11-07 06:50:00	SPY	ETF	258.86	258.9	258.86	258.9	5100.0
2017-11-07 06:55:00	SPY	ETF	258.79	258.79	258.79	258.79	110.0

> showing 50 of 147,076 rows — these rows as CSV

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