PREVIEW / etf_1min / 2017-09-28

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-09-28.parquet
  size:    2.6 MB
  rows:    135,593

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-28 04:02:00	SPY	ETF	249.91	249.91	249.91	249.91	25000.0
2017-09-28 04:05:00	SPY	ETF	249.91	249.91	249.91	249.91	425.0
2017-09-28 04:10:00	SPY	ETF	249.92	249.92	249.9	249.9	1100.0
2017-09-28 04:20:00	SPY	ETF	249.9	249.9	249.9	249.9	600.0
2017-09-28 04:28:00	SPY	ETF	249.92	249.92	249.92	249.92	2300.0
2017-09-28 04:29:00	SPY	ETF	249.91	249.91	249.91	249.91	1525.0
2017-09-28 04:30:00	SPY	ETF	249.91	249.91	249.91	249.91	23475.0
2017-09-28 04:31:00	SPY	ETF	249.91	249.91	249.87	249.87	15400.0
2017-09-28 04:32:00	SPY	ETF	249.84	249.84	249.84	249.84	1200.0
2017-09-28 04:36:00	SPY	ETF	249.98	249.98	249.98	249.98	109.0
2017-09-28 04:38:00	SPY	ETF	249.97	249.97	249.97	249.97	340.0
2017-09-28 04:40:00	SPY	ETF	249.92	249.92	249.92	249.92	4500.0
2017-09-28 04:41:00	SPY	ETF	249.9	249.9	249.9	249.9	300.0
2017-09-28 04:52:00	SPY	ETF	249.93	249.94	249.93	249.94	3000.0
2017-09-28 04:54:00	SPY	ETF	250.01	250.01	249.97	249.97	1500.0
2017-09-28 04:56:00	SPY	ETF	250.03	250.03	250.03	250.03	1000.0
2017-09-28 04:59:00	SPY	ETF	249.99	249.99	249.99	249.99	500.0
2017-09-28 05:01:00	SPY	ETF	249.96	249.96	249.96	249.96	500.0
2017-09-28 05:10:00	SPY	ETF	250.01	250.01	250.01	250.01	100.0
2017-09-28 05:11:00	SPY	ETF	250.01	250.01	250.01	250.01	103.0
2017-09-28 05:12:00	SPY	ETF	250.01	250.01	250.01	250.01	100.0
2017-09-28 05:22:00	SPY	ETF	249.91	249.91	249.87	249.87	403.0
2017-09-28 05:38:00	SPY	ETF	250.04	250.04	250.04	250.04	1005.0
2017-09-28 05:40:00	SPY	ETF	249.97	249.97	249.97	249.97	400.0
2017-09-28 05:44:00	SPY	ETF	249.97	249.97	249.97	249.97	300.0
2017-09-28 05:45:00	SPY	ETF	249.97	249.97	249.97	249.97	300.0
2017-09-28 05:46:00	SPY	ETF	249.97	249.97	249.97	249.97	300.0
2017-09-28 05:48:00	SPY	ETF	250.0	250.0	250.0	250.0	300.0
2017-09-28 06:02:00	SPY	ETF	249.95	249.95	249.95	249.95	400.0
2017-09-28 06:23:00	SPY	ETF	249.95	249.95	249.95	249.95	300.0
2017-09-28 06:25:00	SPY	ETF	249.95	249.95	249.95	249.95	402.0
2017-09-28 06:38:00	SPY	ETF	249.96	249.96	249.96	249.96	200.0
2017-09-28 06:51:00	SPY	ETF	249.95	249.95	249.9	249.9	423.0
2017-09-28 06:53:00	SPY	ETF	249.9	249.9	249.9	249.9	500.0
2017-09-28 06:55:00	SPY	ETF	249.9	249.9	249.9	249.9	500.0
2017-09-28 06:56:00	SPY	ETF	249.87	249.87	249.87	249.87	401.0
2017-09-28 07:03:00	SPY	ETF	249.89	249.89	249.85	249.85	3801.0
2017-09-28 07:09:00	SPY	ETF	249.86	249.86	249.86	249.86	900.0
2017-09-28 07:10:00	SPY	ETF	249.86	249.86	249.86	249.86	765.0
2017-09-28 07:11:00	SPY	ETF	249.86	249.86	249.86	249.86	400.0
2017-09-28 07:13:00	SPY	ETF	249.87	249.87	249.87	249.87	400.0
2017-09-28 07:14:00	SPY	ETF	249.91	249.91	249.91	249.91	100.0
2017-09-28 07:16:00	SPY	ETF	249.91	249.91	249.91	249.91	202.0
2017-09-28 07:17:00	SPY	ETF	249.91	249.91	249.91	249.91	3600.0
2017-09-28 07:21:00	SPY	ETF	249.86	249.86	249.85	249.85	10902.0
2017-09-28 07:22:00	SPY	ETF	249.85	249.87	249.85	249.85	11400.0
2017-09-28 07:24:00	SPY	ETF	249.87	249.87	249.87	249.87	10000.0
2017-09-28 07:28:00	SPY	ETF	249.86	249.86	249.85	249.85	13400.0
2017-09-28 07:30:00	SPY	ETF	249.87	249.87	249.87	249.87	401.0
2017-09-28 07:33:00	SPY	ETF	249.85	249.85	249.85	249.85	401.0

> showing 50 of 135,593 rows — these rows as CSV

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