PREVIEW / etf_5min / 2014-06-27

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-06-27.parquet
  size:    925 KB
  rows:    40,102

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-06-27 04:00:00	SPY	ETF	195.2	195.21	195.2	195.2	607.0
2014-06-27 04:15:00	SPY	ETF	195.11	195.11	195.11	195.11	200.0
2014-06-27 04:50:00	SPY	ETF	195.29	195.29	195.29	195.29	600.0
2014-06-27 05:55:00	SPY	ETF	195.04	195.04	195.01	195.01	1625.0
2014-06-27 06:00:00	SPY	ETF	195.0	195.02	195.0	195.02	600.0
2014-06-27 06:05:00	SPY	ETF	195.01	195.02	195.0	195.0	30600.0
2014-06-27 06:10:00	SPY	ETF	195.0	195.08	195.0	195.08	3000.0
2014-06-27 06:15:00	SPY	ETF	195.0	195.0	195.0	195.0	100.0
2014-06-27 06:20:00	SPY	ETF	195.0	195.0	195.0	195.0	6000.0
2014-06-27 06:30:00	SPY	ETF	194.95	195.0	194.93	195.0	2400.0
2014-06-27 06:35:00	SPY	ETF	194.89	194.89	194.8	194.86	3152.0
2014-06-27 06:50:00	SPY	ETF	194.93	194.93	194.93	194.93	200.0
2014-06-27 06:55:00	SPY	ETF	194.96	194.96	194.91	194.91	1300.0
2014-06-27 07:00:00	SPY	ETF	194.91	194.95	194.91	194.95	1400.0
2014-06-27 07:05:00	SPY	ETF	194.96	194.97	194.95	194.95	2350.0
2014-06-27 07:10:00	SPY	ETF	194.98	194.98	194.98	194.98	816.0
2014-06-27 07:15:00	SPY	ETF	194.95	194.95	194.9	194.9	3098.0
2014-06-27 07:20:00	SPY	ETF	194.86	194.9	194.86	194.88	9318.0
2014-06-27 07:25:00	SPY	ETF	194.87	194.92	194.86	194.9	7760.0
2014-06-27 07:30:00	SPY	ETF	194.88	194.92	194.86	194.9	11800.0
2014-06-27 07:35:00	SPY	ETF	194.92	194.92	194.9	194.9	53550.0
2014-06-27 07:40:00	SPY	ETF	194.94	194.94	194.92	194.94	30742.0
2014-06-27 07:45:00	SPY	ETF	194.96	194.97	194.95	194.95	5900.0
2014-06-27 07:50:00	SPY	ETF	194.97	195.0	194.95	194.99	23726.0
2014-06-27 07:55:00	SPY	ETF	194.99	194.99	194.96	194.99	3900.0
2014-06-27 08:00:00	SPY	ETF	194.97	195.02	194.9	195.02	36505.0
2014-06-27 08:05:00	SPY	ETF	195.02	195.05	195.0	195.0	15945.0
2014-06-27 08:10:00	SPY	ETF	195.0	195.02	194.99	195.02	11983.0
2014-06-27 08:15:00	SPY	ETF	195.0	195.0	194.96	194.97	13230.0
2014-06-27 08:20:00	SPY	ETF	194.96	194.99	194.94	194.97	12644.0
2014-06-27 08:25:00	SPY	ETF	194.99	194.99	194.93	194.93	12712.0
2014-06-27 08:30:00	SPY	ETF	194.94	194.98	194.9	194.9	20890.0
2014-06-27 08:35:00	SPY	ETF	194.88	194.9	194.86	194.89	15911.0
2014-06-27 08:40:00	SPY	ETF	194.88	194.94	194.88	194.92	7300.0
2014-06-27 08:45:00	SPY	ETF	194.91	194.92	194.85	194.92	29200.0
2014-06-27 08:50:00	SPY	ETF	194.92	194.93	194.9	194.93	2472.0
2014-06-27 08:55:00	SPY	ETF	194.93	194.93	194.87	194.89	8710.0
2014-06-27 09:00:00	SPY	ETF	194.9	194.92	194.87	194.89	25421.0
2014-06-27 09:05:00	SPY	ETF	194.88	194.93	194.88	194.92	10456.0
2014-06-27 09:10:00	SPY	ETF	194.92	194.94	194.9	194.9	19633.0
2014-06-27 09:15:00	SPY	ETF	194.9	194.9	194.76	194.84	138927.0
2014-06-27 09:20:00	SPY	ETF	194.84	194.87	194.81	194.87	87017.0
2014-06-27 09:25:00	SPY	ETF	194.87	194.98	194.85	194.98	466763.0
2014-06-27 09:30:00	SPY	ETF	194.98	195.17	194.98	195.11	2735455.0
2014-06-27 09:35:00	SPY	ETF	195.11	195.3	195.11	195.28	1545655.0
2014-06-27 09:40:00	SPY	ETF	195.28	195.34	195.22	195.263	1282669.0
2014-06-27 09:45:00	SPY	ETF	195.26	195.37	195.25	195.37	1094127.0
2014-06-27 09:50:00	SPY	ETF	195.36	195.37	195.23	195.2301	928913.0
2014-06-27 09:55:00	SPY	ETF	195.24	195.31	195.15	195.25	948507.0
2014-06-27 10:00:00	SPY	ETF	195.24	195.33	195.18	195.18	653163.0

> showing 50 of 40,102 rows — these rows as CSV

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