PREVIEW / etf_1min / 2017-09-21

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-09-21.parquet
  size:    2.5 MB
  rows:    129,843

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-21 04:01:00	SPY	ETF	249.87	249.87	249.87	249.87	100.0
2017-09-21 04:02:00	SPY	ETF	249.75	249.75	249.75	249.75	1500.0
2017-09-21 04:03:00	SPY	ETF	249.76	249.76	249.75	249.75	500.0
2017-09-21 04:06:00	SPY	ETF	249.8	249.8	249.77	249.77	800.0
2017-09-21 04:11:00	SPY	ETF	249.78	249.78	249.78	249.78	3000.0
2017-09-21 04:18:00	SPY	ETF	249.81	249.81	249.81	249.81	480.0
2017-09-21 04:19:00	SPY	ETF	249.78	249.78	249.75	249.75	300.0
2017-09-21 04:29:00	SPY	ETF	249.8	249.8	249.78	249.78	1300.0
2017-09-21 04:36:00	SPY	ETF	249.83	249.83	249.8	249.8	500.0
2017-09-21 04:56:00	SPY	ETF	249.88	249.88	249.88	249.88	500.0
2017-09-21 05:13:00	SPY	ETF	249.85	249.85	249.85	249.85	400.0
2017-09-21 05:19:00	SPY	ETF	249.86	249.86	249.85	249.85	405.0
2017-09-21 05:22:00	SPY	ETF	249.85	249.85	249.83	249.83	500.0
2017-09-21 05:43:00	SPY	ETF	249.9	249.9	249.9	249.9	100.0
2017-09-21 05:52:00	SPY	ETF	249.85	249.85	249.85	249.85	105.0
2017-09-21 05:59:00	SPY	ETF	249.9	249.9	249.9	249.9	500.0
2017-09-21 06:41:00	SPY	ETF	249.9	249.9	249.9	249.9	1380.0
2017-09-21 06:50:00	SPY	ETF	249.92	249.92	249.92	249.92	600.0
2017-09-21 07:08:00	SPY	ETF	249.95	249.95	249.95	249.95	286.0
2017-09-21 07:15:00	SPY	ETF	249.94	249.94	249.91	249.91	400.0
2017-09-21 07:17:00	SPY	ETF	249.91	249.91	249.91	249.91	300.0
2017-09-21 07:18:00	SPY	ETF	249.92	249.92	249.92	249.92	100.0
2017-09-21 07:21:00	SPY	ETF	249.95	249.95	249.95	249.95	100.0
2017-09-21 07:22:00	SPY	ETF	249.95	249.95	249.95	249.95	216.0
2017-09-21 07:26:00	SPY	ETF	249.97	249.97	249.97	249.97	200.0
2017-09-21 07:27:00	SPY	ETF	249.97	249.97	249.97	249.97	200.0
2017-09-21 07:28:00	SPY	ETF	249.97	249.97	249.92	249.97	4791.0
2017-09-21 07:32:00	SPY	ETF	249.91	249.91	249.91	249.91	300.0
2017-09-21 07:33:00	SPY	ETF	249.91	249.91	249.91	249.91	306.0
2017-09-21 07:34:00	SPY	ETF	249.91	249.91	249.91	249.91	300.0
2017-09-21 07:35:00	SPY	ETF	249.92	249.92	249.92	249.92	100.0
2017-09-21 07:37:00	SPY	ETF	249.95	249.95	249.95	249.95	1300.0
2017-09-21 07:40:00	SPY	ETF	249.93	249.93	249.91	249.91	565.0
2017-09-21 07:42:00	SPY	ETF	249.91	249.91	249.91	249.91	300.0
2017-09-21 07:44:00	SPY	ETF	249.91	249.91	249.91	249.91	392.0
2017-09-21 07:49:00	SPY	ETF	249.91	249.91	249.91	249.91	100.0
2017-09-21 07:50:00	SPY	ETF	249.89	249.89	249.89	249.89	300.0
2017-09-21 07:52:00	SPY	ETF	249.91	249.91	249.91	249.91	800.0
2017-09-21 07:53:00	SPY	ETF	249.91	249.91	249.91	249.91	2405.0
2017-09-21 08:00:00	SPY	ETF	249.95	249.95	249.94	249.94	905.0
2017-09-21 08:01:00	SPY	ETF	249.92	249.93	249.91	249.91	10000.0
2017-09-21 08:02:00	SPY	ETF	249.93	249.94	249.93	249.94	600.0
2017-09-21 08:03:00	SPY	ETF	249.93	249.93	249.93	249.93	1020.0
2017-09-21 08:05:00	SPY	ETF	249.92	249.92	249.91	249.91	2600.0
2017-09-21 08:06:00	SPY	ETF	249.93	249.93	249.93	249.93	300.0
2017-09-21 08:07:00	SPY	ETF	249.93	249.93	249.93	249.93	1100.0
2017-09-21 08:08:00	SPY	ETF	249.93	249.93	249.91	249.91	3861.0
2017-09-21 08:09:00	SPY	ETF	249.91	249.91	249.9	249.9	283.0
2017-09-21 08:11:00	SPY	ETF	249.9	249.91	249.9	249.91	700.0
2017-09-21 08:12:00	SPY	ETF	249.91	249.91	249.91	249.91	8300.0

> showing 50 of 129,843 rows — these rows as CSV

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