PREVIEW / etf_1min / 2018-06-20

all etf 1-min files

  file:    by_date/etf_1min/2018/2018-06-20.parquet
  size:    2.9 MB
  rows:    150,737

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-06-20 04:00:00	SPY	ETF	276.34	276.39	276.34	276.39	840.0
2018-06-20 04:01:00	SPY	ETF	276.25	276.29	276.25	276.29	1426.0
2018-06-20 04:02:00	SPY	ETF	276.26	276.26	276.26	276.26	600.0
2018-06-20 04:03:00	SPY	ETF	276.28	276.28	276.28	276.28	12000.0
2018-06-20 04:04:00	SPY	ETF	276.28	276.28	276.28	276.28	170.0
2018-06-20 04:05:00	SPY	ETF	276.15	276.18	276.15	276.18	5100.0
2018-06-20 04:08:00	SPY	ETF	276.24	276.3	276.24	276.3	2052.0
2018-06-20 04:11:00	SPY	ETF	276.14	276.14	276.14	276.14	100.0
2018-06-20 04:13:00	SPY	ETF	276.12	276.12	276.12	276.12	200.0
2018-06-20 04:15:00	SPY	ETF	276.17	276.17	276.14	276.14	1500.0
2018-06-20 04:17:00	SPY	ETF	276.16	276.16	276.14	276.14	1100.0
2018-06-20 04:18:00	SPY	ETF	276.14	276.14	276.14	276.14	400.0
2018-06-20 04:20:00	SPY	ETF	276.18	276.18	276.18	276.18	200.0
2018-06-20 04:21:00	SPY	ETF	276.14	276.14	276.14	276.14	300.0
2018-06-20 04:27:00	SPY	ETF	276.17	276.17	276.17	276.17	200.0
2018-06-20 04:28:00	SPY	ETF	276.19	276.19	276.19	276.19	200.0
2018-06-20 04:29:00	SPY	ETF	276.22	276.22	276.22	276.22	375.0
2018-06-20 04:31:00	SPY	ETF	276.2	276.2	276.2	276.2	100.0
2018-06-20 04:39:00	SPY	ETF	276.26	276.26	276.26	276.26	150.0
2018-06-20 04:44:00	SPY	ETF	276.26	276.26	276.26	276.26	400.0
2018-06-20 04:48:00	SPY	ETF	276.23	276.23	276.23	276.23	100.0
2018-06-20 04:54:00	SPY	ETF	276.22	276.22	276.22	276.22	250.0
2018-06-20 05:00:00	SPY	ETF	276.31	276.31	276.31	276.31	300.0
2018-06-20 05:03:00	SPY	ETF	276.4	276.4	276.4	276.4	320.0
2018-06-20 05:05:00	SPY	ETF	276.39	276.39	276.39	276.39	120.0
2018-06-20 05:20:00	SPY	ETF	276.46	276.46	276.46	276.46	202.0
2018-06-20 05:27:00	SPY	ETF	276.41	276.41	276.41	276.41	200.0
2018-06-20 05:30:00	SPY	ETF	276.5	276.5	276.5	276.5	160.0
2018-06-20 05:35:00	SPY	ETF	276.47	276.47	276.47	276.47	150.0
2018-06-20 05:50:00	SPY	ETF	276.42	276.5	276.42	276.5	5300.0
2018-06-20 05:58:00	SPY	ETF	276.48	276.48	276.48	276.48	100.0
2018-06-20 06:18:00	SPY	ETF	276.37	276.37	276.37	276.37	610.0
2018-06-20 06:32:00	SPY	ETF	276.48	276.48	276.48	276.48	300.0
2018-06-20 06:40:00	SPY	ETF	276.53	276.53	276.53	276.53	1500.0
2018-06-20 06:42:00	SPY	ETF	276.39	276.39	276.39	276.39	200.0
2018-06-20 06:43:00	SPY	ETF	276.5	276.52	276.5	276.52	690.0
2018-06-20 06:45:00	SPY	ETF	276.55	276.57	276.55	276.57	4310.0
2018-06-20 06:47:00	SPY	ETF	276.47	276.47	276.47	276.47	100.0
2018-06-20 06:52:00	SPY	ETF	276.41	276.41	276.41	276.41	504.0
2018-06-20 06:53:00	SPY	ETF	276.41	276.41	276.41	276.41	896.0
2018-06-20 06:55:00	SPY	ETF	276.4	276.4	276.4	276.4	500.0
2018-06-20 06:58:00	SPY	ETF	276.38	276.38	276.38	276.38	2000.0
2018-06-20 07:00:00	SPY	ETF	276.44	276.45	276.3	276.38	1127.0
2018-06-20 07:01:00	SPY	ETF	276.35	276.35	276.3	276.3	3200.0
2018-06-20 07:02:00	SPY	ETF	276.3	276.3	276.3	276.3	6238.0
2018-06-20 07:04:00	SPY	ETF	276.32	276.32	276.32	276.32	3000.0
2018-06-20 07:05:00	SPY	ETF	276.23	276.23	276.23	276.23	300.0
2018-06-20 07:06:00	SPY	ETF	276.25	276.3	276.25	276.25	4300.0
2018-06-20 07:07:00	SPY	ETF	276.23	276.25	276.23	276.23	2950.0
2018-06-20 07:08:00	SPY	ETF	276.16	276.23	276.16	276.18	1100.0

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

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