PREVIEW / etf_1min / 2017-03-23

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-03-23.parquet
  size:    2.7 MB
  rows:    142,606

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-03-23 04:00:00	SPY	ETF	234.25	234.25	234.25	234.25	100.0
2017-03-23 04:06:00	SPY	ETF	234.21	234.21	234.21	234.21	100.0
2017-03-23 04:20:00	SPY	ETF	234.15	234.15	234.15	234.15	103.0
2017-03-23 04:24:00	SPY	ETF	234.15	234.15	234.15	234.15	300.0
2017-03-23 04:30:00	SPY	ETF	234.17	234.17	234.17	234.17	285.0
2017-03-23 04:33:00	SPY	ETF	234.17	234.17	234.17	234.17	400.0
2017-03-23 04:35:00	SPY	ETF	234.0	234.0	234.0	234.0	2800.0
2017-03-23 04:40:00	SPY	ETF	234.16	234.16	234.16	234.16	350.0
2017-03-23 04:44:00	SPY	ETF	234.13	234.13	234.13	234.13	200.0
2017-03-23 04:46:00	SPY	ETF	234.12	234.12	234.12	234.12	101.0
2017-03-23 05:02:00	SPY	ETF	234.12	234.14	234.12	234.14	1610.0
2017-03-23 05:10:00	SPY	ETF	234.09	234.09	234.09	234.09	9501.0
2017-03-23 05:12:00	SPY	ETF	234.09	234.14	234.09	234.14	1300.0
2017-03-23 05:14:00	SPY	ETF	234.17	234.17	234.17	234.17	3212.0
2017-03-23 05:17:00	SPY	ETF	234.22	234.24	234.18	234.18	5456.0
2017-03-23 05:22:00	SPY	ETF	234.28	234.28	234.28	234.28	400.0
2017-03-23 05:23:00	SPY	ETF	234.3	234.35	234.3	234.35	343.0
2017-03-23 05:27:00	SPY	ETF	234.35	234.35	234.35	234.35	102.0
2017-03-23 05:33:00	SPY	ETF	234.37	234.38	234.37	234.38	3900.0
2017-03-23 05:44:00	SPY	ETF	234.3	234.3	234.3	234.3	1000.0
2017-03-23 05:58:00	SPY	ETF	234.2	234.2	234.2	234.2	2002.0
2017-03-23 06:06:00	SPY	ETF	234.29	234.29	234.29	234.29	200.0
2017-03-23 06:19:00	SPY	ETF	234.19	234.19	234.19	234.19	500.0
2017-03-23 06:22:00	SPY	ETF	234.17	234.17	234.17	234.17	100.0
2017-03-23 06:25:00	SPY	ETF	234.19	234.19	234.19	234.19	300.0
2017-03-23 06:29:00	SPY	ETF	234.17	234.19	234.17	234.17	2852.0
2017-03-23 06:49:00	SPY	ETF	234.39	234.39	234.39	234.39	332.0
2017-03-23 06:50:00	SPY	ETF	234.4	234.4	234.4	234.4	1502.0
2017-03-23 06:53:00	SPY	ETF	234.4	234.4	234.4	234.4	203.0
2017-03-23 06:54:00	SPY	ETF	234.42	234.42	234.42	234.42	1799.0
2017-03-23 06:58:00	SPY	ETF	234.46	234.5	234.46	234.5	2214.0
2017-03-23 07:00:00	SPY	ETF	234.51	234.51	234.51	234.51	206.0
2017-03-23 07:01:00	SPY	ETF	234.57	234.57	234.57	234.57	112.0
2017-03-23 07:02:00	SPY	ETF	234.56	234.56	234.56	234.56	330.0
2017-03-23 07:05:00	SPY	ETF	234.53	234.53	234.53	234.53	201.0
2017-03-23 07:06:00	SPY	ETF	234.58	234.58	234.58	234.58	1613.0
2017-03-23 07:07:00	SPY	ETF	234.58	234.58	234.55	234.55	537.0
2017-03-23 07:08:00	SPY	ETF	234.56	234.56	234.52	234.52	4863.0
2017-03-23 07:10:00	SPY	ETF	234.53	234.54	234.53	234.54	400.0
2017-03-23 07:11:00	SPY	ETF	234.53	234.53	234.49	234.49	1602.0
2017-03-23 07:12:00	SPY	ETF	234.47	234.47	234.47	234.47	103.0
2017-03-23 07:14:00	SPY	ETF	234.43	234.47	234.41	234.47	4101.0
2017-03-23 07:15:00	SPY	ETF	234.5	234.51	234.49	234.49	13000.0
2017-03-23 07:18:00	SPY	ETF	234.5	234.5	234.5	234.5	400.0
2017-03-23 07:20:00	SPY	ETF	234.49	234.49	234.49	234.49	657.0
2017-03-23 07:22:00	SPY	ETF	234.46	234.46	234.46	234.46	1300.0
2017-03-23 07:23:00	SPY	ETF	234.48	234.48	234.48	234.48	300.0
2017-03-23 07:25:00	SPY	ETF	234.46	234.46	234.46	234.46	599.0
2017-03-23 07:26:00	SPY	ETF	234.44	234.44	234.43	234.43	2310.0
2017-03-23 07:27:00	SPY	ETF	234.44	234.44	234.41	234.41	304.0

> showing 50 of 142,606 rows — these rows as CSV

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