PREVIEW / etf_1min / 2017-01-24

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-01-24.parquet
  size:    3.1 MB
  rows:    155,215

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-01-24 04:00:00	SPY	ETF	226.14	226.14	226.14	226.14	300.0
2017-01-24 04:09:00	SPY	ETF	226.11	226.11	226.11	226.11	100.0
2017-01-24 04:13:00	SPY	ETF	226.13	226.13	226.13	226.13	1900.0
2017-01-24 04:14:00	SPY	ETF	226.19	226.19	226.19	226.19	3011.0
2017-01-24 04:16:00	SPY	ETF	226.23	226.24	226.23	226.24	3000.0
2017-01-24 04:17:00	SPY	ETF	226.22	226.22	226.22	226.22	100.0
2017-01-24 04:21:00	SPY	ETF	226.18	226.18	226.18	226.18	100.0
2017-01-24 04:22:00	SPY	ETF	226.18	226.18	226.18	226.18	300.0
2017-01-24 04:23:00	SPY	ETF	226.21	226.21	226.21	226.21	400.0
2017-01-24 04:26:00	SPY	ETF	226.21	226.21	226.21	226.21	300.0
2017-01-24 04:30:00	SPY	ETF	226.16	226.16	226.16	226.16	1000.0
2017-01-24 04:31:00	SPY	ETF	226.16	226.16	226.16	226.16	300.0
2017-01-24 04:38:00	SPY	ETF	226.23	226.36	226.21	226.36	9000.0
2017-01-24 04:40:00	SPY	ETF	226.26	226.26	226.26	226.26	101.0
2017-01-24 04:44:00	SPY	ETF	226.21	226.21	226.21	226.21	2100.0
2017-01-24 04:51:00	SPY	ETF	226.24	226.24	226.24	226.24	300.0
2017-01-24 04:54:00	SPY	ETF	226.29	226.29	226.29	226.29	600.0
2017-01-24 05:02:00	SPY	ETF	226.36	226.36	226.36	226.36	300.0
2017-01-24 05:04:00	SPY	ETF	226.36	226.36	226.36	226.36	1600.0
2017-01-24 05:07:00	SPY	ETF	226.45	226.47	226.45	226.47	200.0
2017-01-24 05:08:00	SPY	ETF	226.45	226.45	226.45	226.45	1000.0
2017-01-24 05:09:00	SPY	ETF	226.47	226.49	226.47	226.49	300.0
2017-01-24 05:10:00	SPY	ETF	226.42	226.42	226.42	226.42	200.0
2017-01-24 05:16:00	SPY	ETF	226.41	226.41	226.41	226.41	700.0
2017-01-24 05:28:00	SPY	ETF	226.36	226.36	226.36	226.36	1000.0
2017-01-24 05:48:00	SPY	ETF	226.44	226.44	226.44	226.44	300.0
2017-01-24 06:03:00	SPY	ETF	226.34	226.34	226.34	226.34	300.0
2017-01-24 06:18:00	SPY	ETF	226.25	226.25	226.25	226.25	2002.0
2017-01-24 06:23:00	SPY	ETF	226.3	226.3	226.3	226.3	919.0
2017-01-24 06:25:00	SPY	ETF	226.31	226.31	226.31	226.31	900.0
2017-01-24 06:26:00	SPY	ETF	226.3	226.3	226.3	226.3	300.0
2017-01-24 06:27:00	SPY	ETF	226.3	226.3	226.3	226.3	600.0
2017-01-24 06:38:00	SPY	ETF	226.31	226.31	226.31	226.31	300.0
2017-01-24 06:48:00	SPY	ETF	226.21	226.21	226.21	226.21	202.0
2017-01-24 06:51:00	SPY	ETF	226.2	226.25	226.2	226.25	602.0
2017-01-24 06:58:00	SPY	ETF	226.25	226.25	226.25	226.25	1400.0
2017-01-24 07:08:00	SPY	ETF	226.26	226.26	226.26	226.26	100.0
2017-01-24 07:12:00	SPY	ETF	226.26	226.26	226.26	226.26	1577.0
2017-01-24 07:13:00	SPY	ETF	226.26	226.26	226.26	226.26	350.0
2017-01-24 07:15:00	SPY	ETF	226.23	226.23	226.22	226.23	7500.0
2017-01-24 07:27:00	SPY	ETF	226.21	226.22	226.21	226.21	2400.0
2017-01-24 07:34:00	SPY	ETF	226.24	226.24	226.23	226.23	540.0
2017-01-24 07:35:00	SPY	ETF	226.24	226.24	226.24	226.24	160.0
2017-01-24 07:40:00	SPY	ETF	226.21	226.21	226.21	226.21	500.0
2017-01-24 07:41:00	SPY	ETF	226.21	226.21	226.21	226.21	146.0
2017-01-24 07:47:00	SPY	ETF	226.2	226.2	226.2	226.2	1400.0
2017-01-24 07:52:00	SPY	ETF	226.21	226.21	226.21	226.21	100.0
2017-01-24 07:56:00	SPY	ETF	226.24	226.24	226.24	226.24	1000.0
2017-01-24 07:58:00	SPY	ETF	226.25	226.25	226.25	226.25	502.0
2017-01-24 08:00:00	SPY	ETF	226.21	226.22	226.21	226.22	3324.0

> showing 50 of 155,215 rows — these rows as CSV

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