PREVIEW / etf_1min / 2016-11-02

all etf 1-min files

  file:    by_date/etf_1min/2016/2016-11-02.parquet
  size:    2.8 MB
  rows:    150,546

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
2016-11-02 04:00:00	SPY	ETF	210.41	210.41	210.41	210.41	150.0
2016-11-02 04:02:00	SPY	ETF	210.37	210.37	210.37	210.37	100.0
2016-11-02 04:04:00	SPY	ETF	210.32	210.32	210.29	210.29	401.0
2016-11-02 04:05:00	SPY	ETF	210.25	210.26	210.2	210.2	801.0
2016-11-02 04:06:00	SPY	ETF	210.2	210.2	210.2	210.2	400.0
2016-11-02 04:08:00	SPY	ETF	210.24	210.24	210.2	210.2	8732.0
2016-11-02 04:12:00	SPY	ETF	210.2	210.2	210.2	210.2	204.0
2016-11-02 04:14:00	SPY	ETF	210.19	210.19	210.19	210.19	101.0
2016-11-02 04:16:00	SPY	ETF	210.11	210.11	210.08	210.08	1015.0
2016-11-02 04:17:00	SPY	ETF	210.19	210.19	210.19	210.19	1004.0
2016-11-02 04:22:00	SPY	ETF	210.15	210.15	210.15	210.15	108.0
2016-11-02 04:26:00	SPY	ETF	210.31	210.31	210.31	210.31	502.0
2016-11-02 04:27:00	SPY	ETF	210.24	210.24	210.23	210.23	9899.0
2016-11-02 04:28:00	SPY	ETF	210.17	210.17	210.17	210.17	210.0
2016-11-02 04:29:00	SPY	ETF	210.23	210.23	210.23	210.23	300.0
2016-11-02 04:37:00	SPY	ETF	210.12	210.12	210.11	210.11	801.0
2016-11-02 04:38:00	SPY	ETF	210.11	210.11	210.11	210.11	201.0
2016-11-02 04:41:00	SPY	ETF	210.08	210.08	210.08	210.08	201.0
2016-11-02 04:43:00	SPY	ETF	210.1	210.1	210.1	210.1	601.0
2016-11-02 04:45:00	SPY	ETF	210.07	210.07	210.07	210.07	107.0
2016-11-02 04:50:00	SPY	ETF	210.23	210.23	210.23	210.23	507.0
2016-11-02 04:54:00	SPY	ETF	210.28	210.28	210.28	210.28	110.0
2016-11-02 05:02:00	SPY	ETF	210.25	210.25	210.25	210.25	890.0
2016-11-02 05:20:00	SPY	ETF	210.3	210.3	210.3	210.3	1003.0
2016-11-02 05:27:00	SPY	ETF	210.31	210.31	210.31	210.31	101.0
2016-11-02 05:34:00	SPY	ETF	210.22	210.25	210.22	210.25	3101.0
2016-11-02 05:43:00	SPY	ETF	210.33	210.37	210.33	210.37	403.0
2016-11-02 05:50:00	SPY	ETF	210.4	210.42	210.4	210.42	304.0
2016-11-02 05:52:00	SPY	ETF	210.42	210.42	210.42	210.42	502.0
2016-11-02 05:53:00	SPY	ETF	210.49	210.52	210.46	210.52	812.0
2016-11-02 05:55:00	SPY	ETF	210.5	210.5	210.5	210.5	301.0
2016-11-02 05:56:00	SPY	ETF	210.5	210.5	210.5	210.5	300.0
2016-11-02 05:57:00	SPY	ETF	210.55	210.56	210.55	210.56	702.0
2016-11-02 05:58:00	SPY	ETF	210.6	210.6	210.6	210.6	103.0
2016-11-02 05:59:00	SPY	ETF	210.61	210.61	210.61	210.61	901.0
2016-11-02 06:01:00	SPY	ETF	210.61	210.61	210.61	210.61	301.0
2016-11-02 06:03:00	SPY	ETF	210.53	210.53	210.53	210.53	401.0
2016-11-02 06:07:00	SPY	ETF	210.51	210.51	210.51	210.51	102.0
2016-11-02 06:08:00	SPY	ETF	210.48	210.48	210.48	210.48	101.0
2016-11-02 06:09:00	SPY	ETF	210.47	210.51	210.47	210.51	859.0
2016-11-02 06:11:00	SPY	ETF	210.46	210.46	210.46	210.46	1404.0
2016-11-02 06:15:00	SPY	ETF	210.37	210.37	210.37	210.37	2550.0
2016-11-02 06:16:00	SPY	ETF	210.37	210.38	210.37	210.38	301.0
2016-11-02 06:17:00	SPY	ETF	210.4	210.45	210.4	210.45	806.0
2016-11-02 06:18:00	SPY	ETF	210.42	210.42	210.42	210.42	2500.0
2016-11-02 06:19:00	SPY	ETF	210.42	210.42	210.42	210.42	102.0
2016-11-02 06:23:00	SPY	ETF	210.35	210.35	210.35	210.35	100.0
2016-11-02 06:24:00	SPY	ETF	210.34	210.35	210.34	210.35	1100.0
2016-11-02 06:25:00	SPY	ETF	210.37	210.37	210.37	210.37	202.0
2016-11-02 06:26:00	SPY	ETF	210.38	210.38	210.37	210.38	1606.0

> showing 50 of 150,546 rows — these rows as CSV

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