PREVIEW / etf_1min / 2017-01-23

all etf 1-min files

  file:    by_date/etf_1min/2017/2017-01-23.parquet
  size:    2.9 MB
  rows:    148,055

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-23 04:00:00	SPY	ETF	226.28	226.28	226.15	226.23	2465.0
2017-01-23 04:02:00	SPY	ETF	226.16	226.16	226.16	226.16	200.0
2017-01-23 04:08:00	SPY	ETF	226.08	226.14	226.08	226.14	4456.0
2017-01-23 04:09:00	SPY	ETF	226.08	226.08	226.08	226.08	1020.0
2017-01-23 04:11:00	SPY	ETF	226.11	226.11	226.11	226.11	1000.0
2017-01-23 04:12:00	SPY	ETF	226.11	226.11	226.11	226.11	500.0
2017-01-23 04:18:00	SPY	ETF	226.14	226.14	226.11	226.11	3501.0
2017-01-23 04:19:00	SPY	ETF	226.11	226.11	226.11	226.11	1000.0
2017-01-23 04:20:00	SPY	ETF	226.11	226.11	226.11	226.11	1000.0
2017-01-23 04:23:00	SPY	ETF	226.09	226.09	226.09	226.09	1000.0
2017-01-23 04:28:00	SPY	ETF	226.17	226.27	226.17	226.27	1504.0
2017-01-23 04:32:00	SPY	ETF	226.28	226.28	226.28	226.28	500.0
2017-01-23 04:48:00	SPY	ETF	226.35	226.35	226.35	226.35	1127.0
2017-01-23 04:59:00	SPY	ETF	226.31	226.31	226.31	226.31	103.0
2017-01-23 05:19:00	SPY	ETF	226.33	226.34	226.33	226.34	2000.0
2017-01-23 05:22:00	SPY	ETF	226.27	226.27	226.27	226.27	100.0
2017-01-23 05:25:00	SPY	ETF	226.3	226.3	226.3	226.3	300.0
2017-01-23 05:26:00	SPY	ETF	226.3	226.3	226.3	226.3	701.0
2017-01-23 05:30:00	SPY	ETF	226.3	226.3	226.25	226.25	2202.0
2017-01-23 05:43:00	SPY	ETF	226.26	226.26	226.26	226.26	300.0
2017-01-23 05:45:00	SPY	ETF	226.26	226.26	226.26	226.26	203.0
2017-01-23 05:54:00	SPY	ETF	226.26	226.26	226.26	226.26	300.0
2017-01-23 06:00:00	SPY	ETF	226.24	226.24	226.24	226.24	100.0
2017-01-23 06:01:00	SPY	ETF	226.23	226.23	226.23	226.23	500.0
2017-01-23 06:02:00	SPY	ETF	226.25	226.25	226.25	226.25	570.0
2017-01-23 06:03:00	SPY	ETF	226.25	226.25	226.25	226.25	931.0
2017-01-23 06:05:00	SPY	ETF	226.29	226.29	226.29	226.29	1003.0
2017-01-23 06:06:00	SPY	ETF	226.32	226.32	226.32	226.32	900.0
2017-01-23 06:21:00	SPY	ETF	226.41	226.41	226.41	226.41	800.0
2017-01-23 06:24:00	SPY	ETF	226.41	226.41	226.38	226.38	1600.0
2017-01-23 06:33:00	SPY	ETF	226.37	226.37	226.34	226.34	39302.0
2017-01-23 06:34:00	SPY	ETF	226.32	226.32	226.3	226.3	7599.0
2017-01-23 06:35:00	SPY	ETF	226.31	226.31	226.31	226.31	7099.0
2017-01-23 06:48:00	SPY	ETF	226.36	226.36	226.36	226.36	502.0
2017-01-23 06:50:00	SPY	ETF	226.32	226.32	226.32	226.32	100.0
2017-01-23 06:56:00	SPY	ETF	226.29	226.29	226.28	226.28	1500.0
2017-01-23 06:59:00	SPY	ETF	226.27	226.27	226.23	226.23	603.0
2017-01-23 07:00:00	SPY	ETF	226.25	226.25	226.25	226.25	2100.0
2017-01-23 07:01:00	SPY	ETF	226.24	226.25	226.24	226.25	2000.0
2017-01-23 07:02:00	SPY	ETF	226.25	226.25	226.23	226.25	2300.0
2017-01-23 07:04:00	SPY	ETF	226.25	226.28	226.25	226.28	2825.0
2017-01-23 07:06:00	SPY	ETF	226.25	226.25	226.25	226.25	1000.0
2017-01-23 07:08:00	SPY	ETF	226.27	226.3	226.27	226.3	1301.0
2017-01-23 07:09:00	SPY	ETF	226.3	226.3	226.3	226.3	1770.0
2017-01-23 07:10:00	SPY	ETF	226.3	226.3	226.3	226.3	1002.0
2017-01-23 07:12:00	SPY	ETF	226.3	226.3	226.3	226.3	300.0
2017-01-23 07:13:00	SPY	ETF	226.31	226.31	226.31	226.31	200.0
2017-01-23 07:14:00	SPY	ETF	226.3	226.3	226.3	226.3	152.0
2017-01-23 07:15:00	SPY	ETF	226.3	226.3	226.3	226.3	400.0
2017-01-23 07:17:00	SPY	ETF	226.29	226.3	226.28	226.3	2028.0

> showing 50 of 148,055 rows — these rows as CSV

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