PREVIEW / etf_1min / 2017-09-20

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-09-20.parquet
  size:    2.7 MB
  rows:    134,962

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-20 04:00:00	SPY	ETF	249.97	249.97	249.85	249.85	800.0
2017-09-20 04:07:00	SPY	ETF	249.97	249.97	249.97	249.97	400.0
2017-09-20 04:09:00	SPY	ETF	249.95	249.95	249.95	249.95	500.0
2017-09-20 04:12:00	SPY	ETF	249.99	249.99	249.99	249.99	241.0
2017-09-20 04:13:00	SPY	ETF	250.01	250.01	250.01	250.01	5000.0
2017-09-20 04:17:00	SPY	ETF	249.95	249.95	249.95	249.95	500.0
2017-09-20 04:18:00	SPY	ETF	249.97	249.97	249.97	249.97	300.0
2017-09-20 04:22:00	SPY	ETF	250.0	250.0	250.0	250.0	300.0
2017-09-20 04:25:00	SPY	ETF	250.0	250.0	250.0	250.0	2100.0
2017-09-20 04:29:00	SPY	ETF	249.97	249.97	249.97	249.97	300.0
2017-09-20 04:31:00	SPY	ETF	249.97	249.97	249.97	249.97	500.0
2017-09-20 04:39:00	SPY	ETF	250.0	250.0	250.0	250.0	1100.0
2017-09-20 04:52:00	SPY	ETF	250.05	250.05	250.05	250.05	300.0
2017-09-20 05:19:00	SPY	ETF	250.0	250.0	250.0	250.0	1000.0
2017-09-20 05:22:00	SPY	ETF	250.0	250.0	250.0	250.0	700.0
2017-09-20 05:30:00	SPY	ETF	250.0	250.0	250.0	250.0	4000.0
2017-09-20 05:32:00	SPY	ETF	250.02	250.02	250.02	250.02	1400.0
2017-09-20 06:12:00	SPY	ETF	250.0	250.0	250.0	250.0	300.0
2017-09-20 06:13:00	SPY	ETF	250.03	250.03	250.03	250.03	200.0
2017-09-20 06:19:00	SPY	ETF	250.03	250.03	250.03	250.03	2000.0
2017-09-20 06:24:00	SPY	ETF	250.03	250.03	250.03	250.03	200.0
2017-09-20 06:41:00	SPY	ETF	249.97	249.97	249.97	249.97	100.0
2017-09-20 06:47:00	SPY	ETF	249.97	249.97	249.97	249.97	900.0
2017-09-20 06:48:00	SPY	ETF	249.97	249.97	249.97	249.97	300.0
2017-09-20 06:49:00	SPY	ETF	249.97	249.97	249.97	249.97	600.0
2017-09-20 06:55:00	SPY	ETF	249.97	249.97	249.97	249.97	1100.0
2017-09-20 06:59:00	SPY	ETF	250.01	250.01	250.01	250.01	15000.0
2017-09-20 07:00:00	SPY	ETF	250.02	250.02	250.02	250.02	3005.0
2017-09-20 07:07:00	SPY	ETF	250.02	250.02	250.02	250.02	6000.0
2017-09-20 07:09:00	SPY	ETF	250.01	250.01	250.01	250.01	100.0
2017-09-20 07:11:00	SPY	ETF	250.0	250.02	250.0	250.02	6320.0
2017-09-20 07:19:00	SPY	ETF	250.04	250.05	250.04	250.05	4285.0
2017-09-20 07:20:00	SPY	ETF	250.05	250.06	250.05	250.06	15715.0
2017-09-20 07:21:00	SPY	ETF	250.04	250.07	250.04	250.06	20000.0
2017-09-20 07:25:00	SPY	ETF	250.04	250.04	250.03	250.03	500.0
2017-09-20 07:27:00	SPY	ETF	250.05	250.05	250.05	250.05	200.0
2017-09-20 07:30:00	SPY	ETF	250.05	250.08	250.05	250.08	520.0
2017-09-20 07:31:00	SPY	ETF	250.05	250.05	250.05	250.05	100.0
2017-09-20 07:32:00	SPY	ETF	250.07	250.08	250.07	250.08	805.0
2017-09-20 07:34:00	SPY	ETF	250.07	250.07	250.07	250.07	100.0
2017-09-20 07:35:00	SPY	ETF	250.06	250.06	250.06	250.06	1400.0
2017-09-20 07:40:00	SPY	ETF	250.05	250.05	250.01	250.01	4537.0
2017-09-20 07:45:00	SPY	ETF	250.01	250.01	250.01	250.01	1500.0
2017-09-20 07:47:00	SPY	ETF	249.99	249.99	249.98	249.98	400.0
2017-09-20 07:48:00	SPY	ETF	249.99	249.99	249.99	249.99	600.0
2017-09-20 07:49:00	SPY	ETF	249.99	249.99	249.99	249.99	3400.0
2017-09-20 07:50:00	SPY	ETF	249.99	249.99	249.99	249.99	600.0
2017-09-20 07:53:00	SPY	ETF	249.99	250.05	249.99	250.05	4900.0
2017-09-20 07:54:00	SPY	ETF	250.03	250.03	250.03	250.03	1500.0
2017-09-20 07:56:00	SPY	ETF	250.01	250.01	250.01	250.01	300.0

> showing 50 of 134,962 rows — these rows as CSV

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