PREVIEW / etf_1min / 2014-08-20

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-08-20.parquet
  size:    2.0 MB
  rows:    104,826

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-08-20 04:00:00	SPY	ETF	198.12	198.12	198.12	198.12	397.0
2014-08-20 04:01:00	SPY	ETF	198.06	198.06	198.06	198.06	100.0
2014-08-20 04:02:00	SPY	ETF	198.05	198.05	198.04	198.04	5205.0
2014-08-20 04:03:00	SPY	ETF	198.02	198.02	198.01	198.01	239.0
2014-08-20 04:05:00	SPY	ETF	198.06	198.06	198.06	198.06	4000.0
2014-08-20 04:07:00	SPY	ETF	197.95	197.95	197.95	197.95	8000.0
2014-08-20 04:15:00	SPY	ETF	197.95	197.95	197.95	197.95	118.0
2014-08-20 04:16:00	SPY	ETF	197.95	197.95	197.95	197.95	1000.0
2014-08-20 04:17:00	SPY	ETF	197.95	197.95	197.95	197.95	600.0
2014-08-20 04:29:00	SPY	ETF	198.04	198.04	198.02	198.02	300.0
2014-08-20 04:30:00	SPY	ETF	197.97	197.97	197.97	197.97	300.0
2014-08-20 04:37:00	SPY	ETF	197.98	197.98	197.98	197.98	450.0
2014-08-20 04:46:00	SPY	ETF	197.98	197.98	197.98	197.98	300.0
2014-08-20 05:09:00	SPY	ETF	198.03	198.03	198.03	198.03	300.0
2014-08-20 05:23:00	SPY	ETF	198.04	198.04	198.04	198.04	122.0
2014-08-20 05:24:00	SPY	ETF	198.04	198.06	198.04	198.06	5800.0
2014-08-20 05:25:00	SPY	ETF	198.05	198.05	198.02	198.02	1575.0
2014-08-20 05:31:00	SPY	ETF	198.05	198.05	198.05	198.05	1567.0
2014-08-20 05:34:00	SPY	ETF	198.08	198.08	198.05	198.05	1249.0
2014-08-20 05:37:00	SPY	ETF	198.05	198.05	198.05	198.05	1000.0
2014-08-20 05:38:00	SPY	ETF	198.01	198.01	197.99	197.99	500.0
2014-08-20 06:12:00	SPY	ETF	198.1	198.1	198.1	198.1	200.0
2014-08-20 06:16:00	SPY	ETF	198.1	198.11	198.1	198.11	7073.0
2014-08-20 06:17:00	SPY	ETF	198.11	198.11	198.11	198.11	1000.0
2014-08-20 06:18:00	SPY	ETF	198.11	198.11	198.11	198.11	1000.0
2014-08-20 06:19:00	SPY	ETF	198.13	198.13	198.13	198.13	100.0
2014-08-20 06:20:00	SPY	ETF	198.12	198.12	198.12	198.12	100.0
2014-08-20 06:29:00	SPY	ETF	198.1	198.1	198.1	198.1	179.0
2014-08-20 06:31:00	SPY	ETF	198.15	198.18	198.15	198.18	400.0
2014-08-20 06:32:00	SPY	ETF	198.22	198.23	198.22	198.23	300.0
2014-08-20 06:33:00	SPY	ETF	198.23	198.23	198.23	198.23	404.0
2014-08-20 06:34:00	SPY	ETF	198.25	198.25	198.2	198.2	5296.0
2014-08-20 06:37:00	SPY	ETF	198.22	198.22	198.22	198.22	600.0
2014-08-20 06:44:00	SPY	ETF	198.15	198.15	198.15	198.15	103.0
2014-08-20 06:48:00	SPY	ETF	198.17	198.17	198.17	198.17	500.0
2014-08-20 06:52:00	SPY	ETF	198.18	198.18	198.18	198.18	571.0
2014-08-20 06:53:00	SPY	ETF	198.15	198.15	198.15	198.15	500.0
2014-08-20 06:54:00	SPY	ETF	198.14	198.14	198.14	198.14	1110.0
2014-08-20 06:55:00	SPY	ETF	198.15	198.17	198.15	198.17	6500.0
2014-08-20 06:56:00	SPY	ETF	198.17	198.17	198.17	198.17	3268.0
2014-08-20 06:57:00	SPY	ETF	198.17	198.17	198.14	198.17	1400.0
2014-08-20 07:00:00	SPY	ETF	198.18	198.18	198.17	198.17	2000.0
2014-08-20 07:01:00	SPY	ETF	198.16	198.17	198.15	198.17	4700.0
2014-08-20 07:02:00	SPY	ETF	198.15	198.15	198.14	198.14	1100.0
2014-08-20 07:03:00	SPY	ETF	198.14	198.19	198.14	198.19	2400.0
2014-08-20 07:04:00	SPY	ETF	198.19	198.19	198.19	198.19	3630.0
2014-08-20 07:05:00	SPY	ETF	198.22	198.22	198.22	198.22	450.0
2014-08-20 07:08:00	SPY	ETF	198.23	198.23	198.23	198.23	100.0
2014-08-20 07:10:00	SPY	ETF	198.24	198.25	198.24	198.25	376.0
2014-08-20 07:11:00	SPY	ETF	198.24	198.24	198.24	198.24	500.0

> showing 50 of 104,826 rows — these rows as CSV

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