PREVIEW / etf_1min / 2017-10-26

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-10-26.parquet
  size:    2.7 MB
  rows:    143,572

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-10-26 04:02:00	SPY	ETF	255.65	255.65	255.65	255.65	300.0
2017-10-26 04:22:00	SPY	ETF	255.61	255.61	255.61	255.61	300.0
2017-10-26 04:40:00	SPY	ETF	255.61	255.61	255.61	255.61	1000.0
2017-10-26 04:51:00	SPY	ETF	255.56	255.56	255.56	255.56	100.0
2017-10-26 04:52:00	SPY	ETF	255.53	255.53	255.53	255.53	2600.0
2017-10-26 04:58:00	SPY	ETF	255.52	255.52	255.5	255.5	300.0
2017-10-26 05:03:00	SPY	ETF	255.5	255.5	255.5	255.5	100.0
2017-10-26 05:29:00	SPY	ETF	255.5	255.5	255.5	255.5	500.0
2017-10-26 05:32:00	SPY	ETF	255.5	255.5	255.5	255.5	100.0
2017-10-26 05:33:00	SPY	ETF	255.5	255.5	255.5	255.5	2000.0
2017-10-26 05:34:00	SPY	ETF	255.5	255.5	255.5	255.5	3000.0
2017-10-26 05:40:00	SPY	ETF	255.5	255.5	255.5	255.5	10000.0
2017-10-26 05:41:00	SPY	ETF	255.48	255.48	255.48	255.48	20000.0
2017-10-26 05:42:00	SPY	ETF	255.48	255.48	255.48	255.48	5000.0
2017-10-26 05:51:00	SPY	ETF	255.53	255.53	255.53	255.53	100.0
2017-10-26 06:00:00	SPY	ETF	255.61	255.61	255.61	255.61	700.0
2017-10-26 06:03:00	SPY	ETF	255.62	255.62	255.62	255.62	300.0
2017-10-26 06:06:00	SPY	ETF	255.62	255.62	255.62	255.62	200.0
2017-10-26 06:23:00	SPY	ETF	255.72	255.72	255.72	255.72	3000.0
2017-10-26 06:25:00	SPY	ETF	255.75	255.75	255.71	255.71	3100.0
2017-10-26 06:26:00	SPY	ETF	255.75	255.75	255.75	255.75	1800.0
2017-10-26 06:27:00	SPY	ETF	255.75	255.75	255.75	255.75	500.0
2017-10-26 06:28:00	SPY	ETF	255.75	255.75	255.75	255.75	100.0
2017-10-26 06:38:00	SPY	ETF	255.74	255.74	255.72	255.72	10000.0
2017-10-26 06:39:00	SPY	ETF	255.74	255.74	255.73	255.73	7000.0
2017-10-26 06:46:00	SPY	ETF	255.78	255.78	255.78	255.78	100.0
2017-10-26 06:52:00	SPY	ETF	255.82	255.82	255.82	255.82	1000.0
2017-10-26 06:54:00	SPY	ETF	255.81	255.82	255.81	255.82	600.0
2017-10-26 06:56:00	SPY	ETF	255.87	255.88	255.87	255.87	3200.0
2017-10-26 07:01:00	SPY	ETF	255.85	255.85	255.85	255.85	1500.0
2017-10-26 07:02:00	SPY	ETF	255.83	255.83	255.83	255.83	100.0
2017-10-26 07:03:00	SPY	ETF	255.85	255.85	255.85	255.85	100.0
2017-10-26 07:05:00	SPY	ETF	255.85	255.85	255.85	255.85	6350.0
2017-10-26 07:07:00	SPY	ETF	255.89	255.89	255.89	255.89	5000.0
2017-10-26 07:10:00	SPY	ETF	255.9	255.92	255.9	255.92	9000.0
2017-10-26 07:11:00	SPY	ETF	255.9	255.9	255.89	255.9	3500.0
2017-10-26 07:14:00	SPY	ETF	255.98	255.98	255.98	255.98	105.0
2017-10-26 07:15:00	SPY	ETF	255.97	255.97	255.97	255.97	100.0
2017-10-26 07:16:00	SPY	ETF	255.97	255.97	255.96	255.96	300.0
2017-10-26 07:17:00	SPY	ETF	255.92	255.92	255.92	255.92	3014.0
2017-10-26 07:19:00	SPY	ETF	255.91	255.91	255.91	255.91	6000.0
2017-10-26 07:22:00	SPY	ETF	255.93	255.93	255.93	255.93	1000.0
2017-10-26 07:23:00	SPY	ETF	255.96	255.96	255.96	255.96	350.0
2017-10-26 07:24:00	SPY	ETF	255.96	255.96	255.96	255.96	7700.0
2017-10-26 07:25:00	SPY	ETF	255.98	256.0	255.98	256.0	4580.0
2017-10-26 07:26:00	SPY	ETF	256.0	256.0	256.0	256.0	4000.0
2017-10-26 07:27:00	SPY	ETF	256.0	256.06	256.0	256.06	37158.0
2017-10-26 07:28:00	SPY	ETF	256.02	256.04	256.02	256.03	2100.0
2017-10-26 07:30:00	SPY	ETF	256.0	256.01	256.0	256.01	600.0
2017-10-26 07:31:00	SPY	ETF	256.0	256.0	256.0	256.0	6000.0

> showing 50 of 143,572 rows — these rows as CSV

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