PREVIEW / etf_1min / 2017-11-17

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-11-17.parquet
  size:    2.6 MB
  rows:    137,957

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-11-17 04:00:00	SPY	ETF	258.22	258.22	258.22	258.22	1054.0
2017-11-17 04:04:00	SPY	ETF	258.25	258.25	258.25	258.25	200.0
2017-11-17 04:08:00	SPY	ETF	258.21	258.21	258.21	258.21	400.0
2017-11-17 04:09:00	SPY	ETF	258.22	258.22	258.22	258.22	100.0
2017-11-17 04:13:00	SPY	ETF	258.21	258.21	258.15	258.15	1200.0
2017-11-17 04:14:00	SPY	ETF	258.23	258.23	258.23	258.23	500.0
2017-11-17 04:19:00	SPY	ETF	258.2	258.2	258.14	258.14	350.0
2017-11-17 04:28:00	SPY	ETF	258.2	258.2	258.2	258.2	100.0
2017-11-17 04:31:00	SPY	ETF	258.2	258.2	258.2	258.2	300.0
2017-11-17 04:38:00	SPY	ETF	258.2	258.2	258.2	258.2	100.0
2017-11-17 04:42:00	SPY	ETF	258.21	258.22	258.21	258.22	400.0
2017-11-17 04:45:00	SPY	ETF	258.18	258.18	258.18	258.18	1000.0
2017-11-17 04:59:00	SPY	ETF	258.22	258.22	258.2	258.2	1000.0
2017-11-17 05:00:00	SPY	ETF	258.2	258.2	258.2	258.2	200.0
2017-11-17 05:07:00	SPY	ETF	258.2	258.2	258.2	258.2	100.0
2017-11-17 05:21:00	SPY	ETF	258.21	258.21	258.21	258.21	100.0
2017-11-17 05:22:00	SPY	ETF	258.2	258.2	258.2	258.2	100.0
2017-11-17 05:24:00	SPY	ETF	258.17	258.17	258.17	258.17	200.0
2017-11-17 05:29:00	SPY	ETF	258.15	258.15	258.15	258.15	300.0
2017-11-17 05:30:00	SPY	ETF	258.15	258.18	258.15	258.18	600.0
2017-11-17 05:38:00	SPY	ETF	258.21	258.21	258.21	258.21	100.0
2017-11-17 05:40:00	SPY	ETF	258.18	258.18	258.15	258.15	1550.0
2017-11-17 05:44:00	SPY	ETF	258.16	258.16	258.15	258.15	500.0
2017-11-17 05:50:00	SPY	ETF	258.15	258.15	258.04	258.04	3650.0
2017-11-17 05:58:00	SPY	ETF	258.28	258.31	258.28	258.3	2300.0
2017-11-17 05:59:00	SPY	ETF	258.28	258.31	258.28	258.3	800.0
2017-11-17 06:01:00	SPY	ETF	258.28	258.28	258.28	258.28	500.0
2017-11-17 06:03:00	SPY	ETF	258.28	258.28	258.28	258.28	300.0
2017-11-17 06:05:00	SPY	ETF	258.28	258.28	258.26	258.26	900.0
2017-11-17 06:06:00	SPY	ETF	258.25	258.25	258.25	258.25	100.0
2017-11-17 06:07:00	SPY	ETF	258.26	258.26	258.26	258.26	500.0
2017-11-17 06:11:00	SPY	ETF	258.31	258.31	258.31	258.31	300.0
2017-11-17 06:12:00	SPY	ETF	258.29	258.29	258.29	258.29	2500.0
2017-11-17 06:13:00	SPY	ETF	258.29	258.29	258.29	258.29	100.0
2017-11-17 06:18:00	SPY	ETF	258.27	258.27	258.27	258.27	1000.0
2017-11-17 06:22:00	SPY	ETF	258.3	258.3	258.3	258.3	1000.0
2017-11-17 06:30:00	SPY	ETF	258.32	258.32	258.32	258.32	300.0
2017-11-17 06:33:00	SPY	ETF	258.32	258.35	258.32	258.35	550.0
2017-11-17 06:34:00	SPY	ETF	258.34	258.34	258.34	258.34	300.0
2017-11-17 06:37:00	SPY	ETF	258.34	258.34	258.34	258.34	200.0
2017-11-17 06:44:00	SPY	ETF	258.39	258.4	258.39	258.4	1300.0
2017-11-17 06:45:00	SPY	ETF	258.4	258.4	258.4	258.4	100.0
2017-11-17 06:47:00	SPY	ETF	258.44	258.44	258.44	258.44	320.0
2017-11-17 06:48:00	SPY	ETF	258.44	258.44	258.44	258.44	500.0
2017-11-17 06:49:00	SPY	ETF	258.42	258.42	258.42	258.42	2500.0
2017-11-17 06:57:00	SPY	ETF	258.44	258.45	258.44	258.45	10000.0
2017-11-17 07:00:00	SPY	ETF	258.45	258.45	258.43	258.43	1200.0
2017-11-17 07:01:00	SPY	ETF	258.47	258.47	258.47	258.47	5300.0
2017-11-17 07:02:00	SPY	ETF	258.49	258.49	258.49	258.49	5000.0
2017-11-17 07:04:00	SPY	ETF	258.47	258.47	258.45	258.45	1890.0

> showing 50 of 137,957 rows — these rows as CSV

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