PREVIEW / etf_1min / 2017-12-14

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-12-14.parquet
  size:    2.8 MB
  rows:    145,207

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-12-14 04:00:00	SPY	ETF	267.18	267.4	267.18	267.4	1440.0
2017-12-14 04:01:00	SPY	ETF	267.28	267.28	267.28	267.28	190.0
2017-12-14 04:24:00	SPY	ETF	267.3	267.3	267.3	267.3	100.0
2017-12-14 04:30:00	SPY	ETF	267.38	267.38	267.38	267.38	240.0
2017-12-14 05:08:00	SPY	ETF	267.4	267.4	267.4	267.4	500.0
2017-12-14 05:11:00	SPY	ETF	267.36	267.36	267.36	267.36	100.0
2017-12-14 05:21:00	SPY	ETF	267.2	267.2	267.2	267.2	1000.0
2017-12-14 05:29:00	SPY	ETF	267.26	267.26	267.26	267.26	300.0
2017-12-14 05:33:00	SPY	ETF	267.23	267.23	267.23	267.23	1483.0
2017-12-14 05:41:00	SPY	ETF	267.26	267.32	267.26	267.32	200.0
2017-12-14 05:51:00	SPY	ETF	267.23	267.23	267.23	267.23	1070.0
2017-12-14 05:55:00	SPY	ETF	267.2	267.2	267.2	267.2	3100.0
2017-12-14 06:00:00	SPY	ETF	267.19	267.19	267.19	267.19	200.0
2017-12-14 06:03:00	SPY	ETF	267.19	267.19	267.19	267.19	500.0
2017-12-14 06:17:00	SPY	ETF	267.26	267.26	267.26	267.26	400.0
2017-12-14 06:18:00	SPY	ETF	267.21	267.21	267.21	267.21	500.0
2017-12-14 06:20:00	SPY	ETF	267.23	267.23	267.23	267.23	600.0
2017-12-14 06:25:00	SPY	ETF	267.23	267.23	267.23	267.23	300.0
2017-12-14 06:29:00	SPY	ETF	267.26	267.26	267.26	267.26	100.0
2017-12-14 06:30:00	SPY	ETF	267.25	267.25	267.25	267.25	101.0
2017-12-14 06:33:00	SPY	ETF	267.21	267.21	267.21	267.21	500.0
2017-12-14 06:34:00	SPY	ETF	267.21	267.21	267.21	267.21	100.0
2017-12-14 06:36:00	SPY	ETF	267.21	267.21	267.21	267.21	300.0
2017-12-14 06:41:00	SPY	ETF	267.23	267.23	267.23	267.23	500.0
2017-12-14 06:42:00	SPY	ETF	267.23	267.23	267.23	267.23	2000.0
2017-12-14 06:43:00	SPY	ETF	267.25	267.26	267.25	267.26	1200.0
2017-12-14 06:44:00	SPY	ETF	267.21	267.21	267.21	267.21	1000.0
2017-12-14 06:45:00	SPY	ETF	267.23	267.23	267.23	267.23	900.0
2017-12-14 06:55:00	SPY	ETF	267.17	267.19	267.17	267.19	500.0
2017-12-14 07:00:00	SPY	ETF	267.15	267.16	267.11	267.16	1607.0
2017-12-14 07:02:00	SPY	ETF	267.16	267.16	267.15	267.15	1295.0
2017-12-14 07:04:00	SPY	ETF	267.16	267.16	267.16	267.16	3500.0
2017-12-14 07:07:00	SPY	ETF	267.18	267.18	267.18	267.18	200.0
2017-12-14 07:09:00	SPY	ETF	267.21	267.21	267.21	267.21	100.0
2017-12-14 07:10:00	SPY	ETF	267.21	267.21	267.21	267.21	124.0
2017-12-14 07:11:00	SPY	ETF	267.2	267.2	267.2	267.2	311.0
2017-12-14 07:12:00	SPY	ETF	267.18	267.18	267.18	267.18	1000.0
2017-12-14 07:13:00	SPY	ETF	267.18	267.18	267.18	267.18	232.0
2017-12-14 07:15:00	SPY	ETF	267.16	267.16	267.16	267.16	100.0
2017-12-14 07:16:00	SPY	ETF	267.14	267.14	267.14	267.14	380.0
2017-12-14 07:20:00	SPY	ETF	267.16	267.16	267.16	267.16	100.0
2017-12-14 07:21:00	SPY	ETF	267.14	267.14	267.14	267.14	350.0
2017-12-14 07:22:00	SPY	ETF	267.16	267.16	267.14	267.14	900.0
2017-12-14 07:24:00	SPY	ETF	267.13	267.14	267.13	267.14	3100.0
2017-12-14 07:25:00	SPY	ETF	267.15	267.15	267.15	267.15	200.0
2017-12-14 07:27:00	SPY	ETF	267.15	267.15	267.15	267.15	300.0
2017-12-14 07:28:00	SPY	ETF	267.17	267.17	267.17	267.17	300.0
2017-12-14 07:29:00	SPY	ETF	267.17	267.17	267.17	267.17	300.0
2017-12-14 07:30:00	SPY	ETF	267.17	267.17	267.16	267.16	440.0
2017-12-14 07:35:00	SPY	ETF	267.17	267.17	267.12	267.12	10000.0

> showing 50 of 145,207 rows — these rows as CSV

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