PREVIEW / etf_1min / 2014-05-07

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-05-07.parquet
  size:    2.2 MB
  rows:    115,770

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-05-07 04:00:00	SPY	ETF	187.03	187.03	187.03	187.03	400.0
2014-05-07 04:03:00	SPY	ETF	187.02	187.02	187.02	187.02	227.0
2014-05-07 04:06:00	SPY	ETF	186.93	186.93	186.93	186.93	100.0
2014-05-07 04:07:00	SPY	ETF	186.9	186.9	186.9	186.9	500.0
2014-05-07 04:09:00	SPY	ETF	187.0	187.0	187.0	187.0	183.0
2014-05-07 04:11:00	SPY	ETF	187.0	187.0	187.0	187.0	3000.0
2014-05-07 04:12:00	SPY	ETF	186.99	186.99	186.99	186.99	235.0
2014-05-07 04:22:00	SPY	ETF	186.96	186.96	186.96	186.96	373.0
2014-05-07 04:39:00	SPY	ETF	186.98	186.98	186.98	186.98	200.0
2014-05-07 04:56:00	SPY	ETF	187.09	187.09	187.09	187.09	107.0
2014-05-07 04:59:00	SPY	ETF	187.1	187.1	187.1	187.1	200.0
2014-05-07 05:29:00	SPY	ETF	187.04	187.04	187.04	187.04	350.0
2014-05-07 05:31:00	SPY	ETF	187.01	187.01	187.01	187.01	1000.0
2014-05-07 05:35:00	SPY	ETF	187.0	187.0	187.0	187.0	2400.0
2014-05-07 05:36:00	SPY	ETF	186.98	186.98	186.98	186.98	250.0
2014-05-07 05:46:00	SPY	ETF	187.03	187.03	187.02	187.02	2128.0
2014-05-07 05:50:00	SPY	ETF	186.94	186.94	186.94	186.94	100.0
2014-05-07 05:55:00	SPY	ETF	186.86	186.9	186.86	186.9	1400.0
2014-05-07 05:59:00	SPY	ETF	186.95	186.95	186.95	186.95	100.0
2014-05-07 06:00:00	SPY	ETF	186.9	186.9	186.9	186.9	140.0
2014-05-07 06:02:00	SPY	ETF	186.87	186.87	186.87	186.87	3000.0
2014-05-07 06:17:00	SPY	ETF	186.91	186.91	186.91	186.91	250.0
2014-05-07 06:32:00	SPY	ETF	186.88	186.88	186.88	186.88	100.0
2014-05-07 06:38:00	SPY	ETF	186.92	186.92	186.92	186.92	100.0
2014-05-07 06:43:00	SPY	ETF	186.95	186.95	186.95	186.95	452.0
2014-05-07 06:54:00	SPY	ETF	186.95	186.95	186.95	186.95	100.0
2014-05-07 06:57:00	SPY	ETF	187.02	187.02	187.02	187.02	100.0
2014-05-07 06:59:00	SPY	ETF	187.01	187.01	187.01	187.01	200.0
2014-05-07 07:00:00	SPY	ETF	187.04	187.06	187.04	187.06	5040.0
2014-05-07 07:01:00	SPY	ETF	187.03	187.03	187.03	187.03	100.0
2014-05-07 07:04:00	SPY	ETF	187.05	187.1	187.05	187.1	10500.0
2014-05-07 07:05:00	SPY	ETF	187.1	187.12	187.1	187.12	1480.0
2014-05-07 07:06:00	SPY	ETF	187.1	187.13	187.1	187.13	1300.0
2014-05-07 07:07:00	SPY	ETF	187.15	187.22	187.15	187.22	5798.0
2014-05-07 07:08:00	SPY	ETF	187.21	187.27	187.21	187.21	10100.0
2014-05-07 07:09:00	SPY	ETF	187.26	187.26	187.22	187.22	2950.0
2014-05-07 07:10:00	SPY	ETF	187.26	187.26	187.26	187.26	1000.0
2014-05-07 07:11:00	SPY	ETF	187.25	187.25	187.25	187.25	1000.0
2014-05-07 07:12:00	SPY	ETF	187.25	187.25	187.25	187.25	3500.0
2014-05-07 07:13:00	SPY	ETF	187.26	187.29	187.26	187.29	1000.0
2014-05-07 07:14:00	SPY	ETF	187.27	187.28	187.25	187.28	6200.0
2014-05-07 07:15:00	SPY	ETF	187.29	187.34	187.28	187.31	23900.0
2014-05-07 07:16:00	SPY	ETF	187.31	187.31	187.28	187.28	4100.0
2014-05-07 07:18:00	SPY	ETF	187.25	187.27	187.25	187.27	3000.0
2014-05-07 07:19:00	SPY	ETF	187.28	187.35	187.28	187.33	35300.0
2014-05-07 07:20:00	SPY	ETF	187.33	187.35	187.32	187.35	5560.0
2014-05-07 07:21:00	SPY	ETF	187.36	187.38	187.31	187.31	5660.0
2014-05-07 07:22:00	SPY	ETF	187.35	187.39	187.35	187.39	2927.0
2014-05-07 07:23:00	SPY	ETF	187.34	187.34	187.34	187.34	1000.0
2014-05-07 07:24:00	SPY	ETF	187.34	187.37	187.32	187.34	12100.0

> showing 50 of 115,770 rows — these rows as CSV

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