PREVIEW / etf_1min / 2014-09-24

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-09-24.parquet
  size:    2.3 MB
  rows:    114,944

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
2014-09-24 04:09:00	SPY	ETF	198.01	198.09	198.01	198.09	500.0
2014-09-24 04:11:00	SPY	ETF	198.01	198.01	198.01	198.01	100.0
2014-09-24 04:16:00	SPY	ETF	198.0	198.0	198.0	198.0	249.0
2014-09-24 04:20:00	SPY	ETF	198.0	198.0	198.0	198.0	1500.0
2014-09-24 04:27:00	SPY	ETF	198.03	198.03	198.01	198.01	300.0
2014-09-24 04:33:00	SPY	ETF	197.97	197.97	197.97	197.97	1500.0
2014-09-24 04:39:00	SPY	ETF	198.0	198.0	198.0	198.0	2517.0
2014-09-24 04:45:00	SPY	ETF	197.98	197.98	197.98	197.98	152.0
2014-09-24 04:54:00	SPY	ETF	197.89	197.89	197.89	197.89	1500.0
2014-09-24 04:57:00	SPY	ETF	197.95	197.95	197.95	197.95	161.0
2014-09-24 05:02:00	SPY	ETF	197.98	197.98	197.98	197.98	168.0
2014-09-24 05:09:00	SPY	ETF	197.95	197.95	197.95	197.95	100.0
2014-09-24 05:12:00	SPY	ETF	198.0	198.0	198.0	198.0	200.0
2014-09-24 05:15:00	SPY	ETF	198.03	198.03	198.03	198.03	249.0
2014-09-24 05:18:00	SPY	ETF	198.0	198.02	198.0	198.02	1000.0
2014-09-24 05:24:00	SPY	ETF	197.96	197.96	197.96	197.96	239.0
2014-09-24 05:29:00	SPY	ETF	198.0	198.0	198.0	198.0	102.0
2014-09-24 05:34:00	SPY	ETF	197.97	197.97	197.97	197.97	161.0
2014-09-24 05:39:00	SPY	ETF	197.96	197.96	197.96	197.96	3000.0
2014-09-24 05:54:00	SPY	ETF	197.96	197.96	197.96	197.96	100.0
2014-09-24 06:03:00	SPY	ETF	197.97	197.97	197.97	197.97	232.0
2014-09-24 06:06:00	SPY	ETF	197.99	197.99	197.99	197.99	200.0
2014-09-24 06:08:00	SPY	ETF	197.99	197.99	197.98	197.98	1559.0
2014-09-24 06:13:00	SPY	ETF	198.01	198.01	198.01	198.01	500.0
2014-09-24 06:15:00	SPY	ETF	198.01	198.01	198.01	198.01	100.0
2014-09-24 06:16:00	SPY	ETF	198.03	198.04	198.03	198.04	900.0
2014-09-24 06:17:00	SPY	ETF	198.04	198.1	198.04	198.1	650.0
2014-09-24 06:20:00	SPY	ETF	198.07	198.07	198.07	198.07	100.0
2014-09-24 06:22:00	SPY	ETF	198.08	198.12	198.08	198.12	530.0
2014-09-24 06:23:00	SPY	ETF	198.14	198.14	198.14	198.14	500.0
2014-09-24 06:24:00	SPY	ETF	198.14	198.14	198.14	198.14	1000.0
2014-09-24 06:25:00	SPY	ETF	198.15	198.15	198.15	198.15	4200.0
2014-09-24 06:26:00	SPY	ETF	198.15	198.15	198.15	198.15	555.0
2014-09-24 06:27:00	SPY	ETF	198.16	198.16	198.16	198.16	100.0
2014-09-24 06:29:00	SPY	ETF	198.16	198.16	198.16	198.16	2339.0
2014-09-24 06:31:00	SPY	ETF	198.19	198.19	198.19	198.19	2092.0
2014-09-24 06:32:00	SPY	ETF	198.22	198.25	198.22	198.25	400.0
2014-09-24 06:33:00	SPY	ETF	198.26	198.29	198.26	198.29	640.0
2014-09-24 06:34:00	SPY	ETF	198.31	198.32	198.3	198.32	26400.0
2014-09-24 06:39:00	SPY	ETF	198.22	198.22	198.22	198.22	100.0
2014-09-24 06:45:00	SPY	ETF	198.21	198.21	198.21	198.21	400.0
2014-09-24 06:46:00	SPY	ETF	198.24	198.24	198.24	198.24	100.0
2014-09-24 06:47:00	SPY	ETF	198.22	198.24	198.22	198.24	1300.0
2014-09-24 06:51:00	SPY	ETF	198.18	198.22	198.18	198.22	15000.0
2014-09-24 06:52:00	SPY	ETF	198.22	198.22	198.18	198.18	10600.0
2014-09-24 06:54:00	SPY	ETF	198.21	198.21	198.21	198.21	100.0
2014-09-24 06:56:00	SPY	ETF	198.21	198.21	198.21	198.21	200.0
2014-09-24 06:57:00	SPY	ETF	198.21	198.22	198.21	198.22	600.0
2014-09-24 06:58:00	SPY	ETF	198.21	198.21	198.2	198.2	500.0
2014-09-24 06:59:00	SPY	ETF	198.18	198.18	198.17	198.17	200.0

> showing 50 of 114,944 rows — these rows as CSV

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