PREVIEW / etf_1min / 2017-12-20

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-12-20.parquet
  size:    2.9 MB
  rows:    149,630

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-12-20 04:00:00	SPY	ETF	267.83	267.95	267.83	267.95	2650.0
2017-12-20 04:11:00	SPY	ETF	267.97	267.97	267.97	267.97	300.0
2017-12-20 04:12:00	SPY	ETF	267.96	267.96	267.96	267.96	500.0
2017-12-20 04:15:00	SPY	ETF	267.96	267.96	267.95	267.95	800.0
2017-12-20 04:17:00	SPY	ETF	268.0	268.0	268.0	268.0	350.0
2017-12-20 04:21:00	SPY	ETF	268.05	268.05	268.05	268.05	1000.0
2017-12-20 04:30:00	SPY	ETF	268.05	268.06	268.05	268.06	300.0
2017-12-20 04:49:00	SPY	ETF	268.0	268.0	268.0	268.0	300.0
2017-12-20 04:51:00	SPY	ETF	268.0	268.0	267.98	267.98	10200.0
2017-12-20 05:01:00	SPY	ETF	267.98	267.98	267.98	267.98	1400.0
2017-12-20 05:03:00	SPY	ETF	267.98	267.98	267.98	267.98	600.0
2017-12-20 05:04:00	SPY	ETF	267.98	267.98	267.98	267.98	300.0
2017-12-20 05:07:00	SPY	ETF	267.95	267.95	267.95	267.95	400.0
2017-12-20 05:09:00	SPY	ETF	267.98	267.98	267.98	267.98	300.0
2017-12-20 05:13:00	SPY	ETF	268.05	268.05	268.05	268.05	100.0
2017-12-20 05:15:00	SPY	ETF	268.02	268.02	268.02	268.02	600.0
2017-12-20 05:17:00	SPY	ETF	268.03	268.03	268.03	268.03	133.0
2017-12-20 05:22:00	SPY	ETF	268.01	268.01	268.01	268.01	2500.0
2017-12-20 05:23:00	SPY	ETF	268.0	268.0	268.0	268.0	300.0
2017-12-20 05:24:00	SPY	ETF	268.0	268.0	268.0	268.0	300.0
2017-12-20 05:30:00	SPY	ETF	268.0	268.0	268.0	268.0	2300.0
2017-12-20 05:32:00	SPY	ETF	268.04	268.04	268.04	268.04	2500.0
2017-12-20 05:33:00	SPY	ETF	268.05	268.05	268.05	268.05	300.0
2017-12-20 05:34:00	SPY	ETF	268.05	268.05	268.05	268.05	100.0
2017-12-20 05:42:00	SPY	ETF	268.03	268.03	268.03	268.03	300.0
2017-12-20 05:45:00	SPY	ETF	268.03	268.03	268.03	268.03	300.0
2017-12-20 05:49:00	SPY	ETF	268.03	268.03	268.03	268.03	300.0
2017-12-20 05:50:00	SPY	ETF	268.05	268.05	268.05	268.05	100.0
2017-12-20 05:53:00	SPY	ETF	268.05	268.05	268.05	268.05	500.0
2017-12-20 05:55:00	SPY	ETF	268.05	268.05	268.05	268.05	800.0
2017-12-20 05:57:00	SPY	ETF	268.1	268.1	268.1	268.1	250.0
2017-12-20 06:01:00	SPY	ETF	268.05	268.05	268.05	268.05	302.0
2017-12-20 06:05:00	SPY	ETF	268.0	268.0	268.0	268.0	350.0
2017-12-20 06:06:00	SPY	ETF	267.99	267.99	267.99	267.99	1000.0
2017-12-20 06:07:00	SPY	ETF	268.04	268.04	268.04	268.04	5100.0
2017-12-20 06:16:00	SPY	ETF	267.98	267.98	267.98	267.98	610.0
2017-12-20 06:20:00	SPY	ETF	267.95	267.95	267.95	267.95	300.0
2017-12-20 06:21:00	SPY	ETF	267.95	267.95	267.95	267.95	250.0
2017-12-20 06:22:00	SPY	ETF	267.95	267.97	267.95	267.97	450.0
2017-12-20 06:23:00	SPY	ETF	267.93	267.93	267.93	267.93	300.0
2017-12-20 06:25:00	SPY	ETF	267.9	267.9	267.86	267.86	450.0
2017-12-20 06:27:00	SPY	ETF	267.98	267.98	267.98	267.98	100.0
2017-12-20 06:28:00	SPY	ETF	267.88	267.88	267.88	267.88	6500.0
2017-12-20 06:31:00	SPY	ETF	267.93	267.93	267.93	267.93	300.0
2017-12-20 06:36:00	SPY	ETF	267.93	267.93	267.93	267.93	525.0
2017-12-20 06:39:00	SPY	ETF	267.93	267.93	267.93	267.93	500.0
2017-12-20 06:43:00	SPY	ETF	267.93	267.93	267.93	267.93	114.0
2017-12-20 06:51:00	SPY	ETF	267.98	267.98	267.98	267.98	100.0
2017-12-20 06:55:00	SPY	ETF	268.0	268.0	268.0	268.0	250.0
2017-12-20 07:00:00	SPY	ETF	268.03	268.05	268.02	268.03	4715.0

> showing 50 of 149,630 rows — these rows as CSV

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