PREVIEW / etf_1min / 2018-02-01

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-02-01.parquet
  size:    3.3 MB
  rows:    170,933

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
2018-02-01 04:00:00	SPY	ETF	282.63	282.63	282.63	282.63	200.0
2018-02-01 04:06:00	SPY	ETF	282.68	282.68	282.68	282.68	500.0
2018-02-01 04:07:00	SPY	ETF	282.71	282.71	282.71	282.71	200.0
2018-02-01 04:20:00	SPY	ETF	282.52	282.52	282.52	282.52	200.0
2018-02-01 04:24:00	SPY	ETF	282.55	282.55	282.55	282.55	120.0
2018-02-01 04:27:00	SPY	ETF	282.47	282.47	282.47	282.47	100.0
2018-02-01 04:28:00	SPY	ETF	282.45	282.45	282.45	282.45	500.0
2018-02-01 04:30:00	SPY	ETF	282.42	282.42	282.38	282.38	600.0
2018-02-01 04:39:00	SPY	ETF	282.5	282.51	282.5	282.51	2500.0
2018-02-01 04:59:00	SPY	ETF	282.47	282.47	282.47	282.47	300.0
2018-02-01 05:00:00	SPY	ETF	282.42	282.42	282.42	282.42	1000.0
2018-02-01 05:04:00	SPY	ETF	282.4	282.4	282.4	282.4	150.0
2018-02-01 05:10:00	SPY	ETF	282.5	282.5	282.5	282.5	300.0
2018-02-01 05:11:00	SPY	ETF	282.42	282.42	282.4	282.4	400.0
2018-02-01 05:12:00	SPY	ETF	282.42	282.42	282.42	282.42	200.0
2018-02-01 05:15:00	SPY	ETF	282.4	282.4	282.4	282.4	100.0
2018-02-01 05:16:00	SPY	ETF	282.4	282.42	282.4	282.42	410.0
2018-02-01 05:37:00	SPY	ETF	282.57	282.57	282.57	282.57	300.0
2018-02-01 05:42:00	SPY	ETF	282.55	282.55	282.55	282.55	100.0
2018-02-01 05:43:00	SPY	ETF	282.55	282.55	282.55	282.55	300.0
2018-02-01 05:44:00	SPY	ETF	282.42	282.42	282.42	282.42	300.0
2018-02-01 05:45:00	SPY	ETF	282.42	282.42	282.42	282.42	800.0
2018-02-01 05:46:00	SPY	ETF	282.42	282.42	282.42	282.42	300.0
2018-02-01 05:47:00	SPY	ETF	282.42	282.42	282.42	282.42	400.0
2018-02-01 05:48:00	SPY	ETF	282.42	282.42	282.42	282.42	620.0
2018-02-01 05:49:00	SPY	ETF	282.44	282.44	282.39	282.39	910.0
2018-02-01 05:50:00	SPY	ETF	282.34	282.34	282.3	282.3	920.0
2018-02-01 05:51:00	SPY	ETF	282.31	282.31	282.27	282.27	810.0
2018-02-01 05:52:00	SPY	ETF	282.27	282.27	282.27	282.27	600.0
2018-02-01 05:53:00	SPY	ETF	282.29	282.35	282.29	282.35	900.0
2018-02-01 05:54:00	SPY	ETF	282.32	282.34	282.32	282.34	800.0
2018-02-01 05:55:00	SPY	ETF	282.27	282.28	282.27	282.28	810.0
2018-02-01 05:56:00	SPY	ETF	282.29	282.29	282.29	282.29	600.0
2018-02-01 05:58:00	SPY	ETF	282.29	282.29	282.29	282.29	300.0
2018-02-01 05:59:00	SPY	ETF	282.29	282.29	282.29	282.29	300.0
2018-02-01 06:00:00	SPY	ETF	282.14	282.14	282.14	282.14	610.0
2018-02-01 06:02:00	SPY	ETF	282.19	282.19	282.19	282.19	154.0
2018-02-01 06:04:00	SPY	ETF	282.17	282.17	282.17	282.17	100.0
2018-02-01 06:06:00	SPY	ETF	282.08	282.08	282.08	282.08	100.0
2018-02-01 06:07:00	SPY	ETF	282.08	282.08	282.04	282.04	200.0
2018-02-01 06:08:00	SPY	ETF	282.03	282.03	282.03	282.03	350.0
2018-02-01 06:10:00	SPY	ETF	282.05	282.07	282.05	282.07	915.0
2018-02-01 06:12:00	SPY	ETF	282.13	282.13	282.13	282.13	300.0
2018-02-01 06:18:00	SPY	ETF	282.19	282.19	282.19	282.19	200.0
2018-02-01 06:19:00	SPY	ETF	282.19	282.19	282.19	282.19	300.0
2018-02-01 06:23:00	SPY	ETF	282.23	282.23	282.23	282.23	100.0
2018-02-01 06:31:00	SPY	ETF	282.34	282.34	282.34	282.34	360.0
2018-02-01 06:33:00	SPY	ETF	282.32	282.32	282.32	282.32	300.0
2018-02-01 06:35:00	SPY	ETF	282.32	282.32	282.26	282.26	1000.0
2018-02-01 06:37:00	SPY	ETF	282.32	282.32	282.32	282.32	100.0

> showing 50 of 170,933 rows — these rows as CSV

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