PREVIEW / etf_1min / 2014-07-18

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-07-18.parquet
  size:    2.0 MB
  rows:    106,186

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-07-18 04:00:00	SPY	ETF	195.96	196.02	195.96	196.02	295.0
2014-07-18 04:05:00	SPY	ETF	195.99	195.99	195.99	195.99	100.0
2014-07-18 04:08:00	SPY	ETF	195.96	195.96	195.96	195.96	164.0
2014-07-18 04:33:00	SPY	ETF	196.02	196.02	196.02	196.02	200.0
2014-07-18 04:42:00	SPY	ETF	196.0	196.0	196.0	196.0	200.0
2014-07-18 04:43:00	SPY	ETF	196.0	196.0	196.0	196.0	100.0
2014-07-18 04:47:00	SPY	ETF	195.98	195.98	195.98	195.98	100.0
2014-07-18 05:02:00	SPY	ETF	195.97	195.97	195.97	195.97	100.0
2014-07-18 05:06:00	SPY	ETF	195.96	195.96	195.96	195.96	200.0
2014-07-18 05:07:00	SPY	ETF	195.96	195.96	195.96	195.96	200.0
2014-07-18 05:14:00	SPY	ETF	195.95	195.95	195.95	195.95	200.0
2014-07-18 05:15:00	SPY	ETF	195.93	195.94	195.9	195.9	1800.0
2014-07-18 05:17:00	SPY	ETF	195.93	195.93	195.93	195.93	500.0
2014-07-18 05:20:00	SPY	ETF	195.97	195.97	195.96	195.96	600.0
2014-07-18 05:23:00	SPY	ETF	195.98	195.98	195.98	195.98	500.0
2014-07-18 05:33:00	SPY	ETF	195.9	195.97	195.9	195.97	300.0
2014-07-18 05:44:00	SPY	ETF	195.89	195.89	195.89	195.89	400.0
2014-07-18 05:45:00	SPY	ETF	195.9	195.9	195.9	195.9	350.0
2014-07-18 05:50:00	SPY	ETF	195.92	195.92	195.92	195.92	200.0
2014-07-18 05:53:00	SPY	ETF	195.75	195.75	195.75	195.75	200.0
2014-07-18 05:55:00	SPY	ETF	195.82	195.82	195.82	195.82	200.0
2014-07-18 05:57:00	SPY	ETF	195.67	195.67	195.67	195.67	600.0
2014-07-18 06:02:00	SPY	ETF	195.83	195.83	195.83	195.83	125.0
2014-07-18 06:03:00	SPY	ETF	195.88	195.88	195.88	195.88	125.0
2014-07-18 06:05:00	SPY	ETF	195.82	195.82	195.82	195.82	300.0
2014-07-18 06:06:00	SPY	ETF	195.94	195.94	195.94	195.94	100.0
2014-07-18 06:08:00	SPY	ETF	195.94	195.94	195.94	195.94	2080.0
2014-07-18 06:11:00	SPY	ETF	195.89	195.92	195.86	195.92	1464.0
2014-07-18 06:12:00	SPY	ETF	195.93	195.97	195.93	195.97	5100.0
2014-07-18 06:13:00	SPY	ETF	196.0	196.0	196.0	196.0	229.0
2014-07-18 06:20:00	SPY	ETF	195.97	195.97	195.89	195.97	10500.0
2014-07-18 06:22:00	SPY	ETF	195.97	195.97	195.96	195.96	10000.0
2014-07-18 06:24:00	SPY	ETF	195.99	195.99	195.99	195.99	100.0
2014-07-18 06:25:00	SPY	ETF	195.96	195.96	195.96	195.96	900.0
2014-07-18 06:30:00	SPY	ETF	195.94	195.94	195.94	195.94	5000.0
2014-07-18 06:32:00	SPY	ETF	195.94	195.95	195.94	195.95	625.0
2014-07-18 06:33:00	SPY	ETF	195.96	195.96	195.96	195.96	430.0
2014-07-18 06:34:00	SPY	ETF	195.95	195.95	195.95	195.95	256.0
2014-07-18 06:36:00	SPY	ETF	195.96	195.98	195.96	195.98	600.0
2014-07-18 06:47:00	SPY	ETF	195.99	196.1	195.97	196.1	3242.0
2014-07-18 06:48:00	SPY	ETF	196.14	196.18	196.13	196.13	800.0
2014-07-18 06:49:00	SPY	ETF	196.2	196.2	196.2	196.2	1000.0
2014-07-18 06:50:00	SPY	ETF	196.1	196.16	196.1	196.16	8015.0
2014-07-18 06:52:00	SPY	ETF	196.13	196.16	196.11	196.16	13900.0
2014-07-18 06:53:00	SPY	ETF	196.17	196.17	196.17	196.17	100.0
2014-07-18 06:54:00	SPY	ETF	196.16	196.16	196.16	196.16	300.0
2014-07-18 06:55:00	SPY	ETF	196.16	196.17	196.16	196.17	2150.0
2014-07-18 06:56:00	SPY	ETF	196.18	196.2	196.18	196.2	15000.0
2014-07-18 06:57:00	SPY	ETF	196.24	196.25	196.24	196.24	15100.0
2014-07-18 06:58:00	SPY	ETF	196.2	196.2	196.2	196.2	5000.0

> showing 50 of 106,186 rows — these rows as CSV

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