PREVIEW / etf_5min / 2014-05-07

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-05-07.parquet
  size:    995 KB
  rows:    43,133

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.02	187.02	627.0
2014-05-07 04:05:00	SPY	ETF	186.93	187.0	186.9	187.0	783.0
2014-05-07 04:10:00	SPY	ETF	187.0	187.0	186.99	186.99	3235.0
2014-05-07 04:20:00	SPY	ETF	186.96	186.96	186.96	186.96	373.0
2014-05-07 04:35:00	SPY	ETF	186.98	186.98	186.98	186.98	200.0
2014-05-07 04:55:00	SPY	ETF	187.09	187.1	187.09	187.1	307.0
2014-05-07 05:25:00	SPY	ETF	187.04	187.04	187.04	187.04	350.0
2014-05-07 05:30: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	186.98	186.98	2650.0
2014-05-07 05:45: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.95	186.86	186.95	1500.0
2014-05-07 06:00:00	SPY	ETF	186.9	186.9	186.87	186.87	3140.0
2014-05-07 06:15:00	SPY	ETF	186.91	186.91	186.91	186.91	250.0
2014-05-07 06:30:00	SPY	ETF	186.88	186.88	186.88	186.88	100.0
2014-05-07 06:35:00	SPY	ETF	186.92	186.92	186.92	186.92	100.0
2014-05-07 06:40:00	SPY	ETF	186.95	186.95	186.95	186.95	452.0
2014-05-07 06:50:00	SPY	ETF	186.95	186.95	186.95	186.95	100.0
2014-05-07 06:55:00	SPY	ETF	187.02	187.02	187.01	187.01	300.0
2014-05-07 07:00:00	SPY	ETF	187.04	187.1	187.03	187.1	15640.0
2014-05-07 07:05:00	SPY	ETF	187.1	187.27	187.1	187.22	21628.0
2014-05-07 07:10:00	SPY	ETF	187.26	187.29	187.25	187.28	12700.0
2014-05-07 07:15:00	SPY	ETF	187.29	187.35	187.25	187.33	66300.0
2014-05-07 07:20:00	SPY	ETF	187.33	187.39	187.31	187.34	27247.0
2014-05-07 07:25:00	SPY	ETF	187.39	187.4	187.35	187.35	18830.0
2014-05-07 07:30:00	SPY	ETF	187.36	187.41	187.36	187.4	30150.0
2014-05-07 07:35:00	SPY	ETF	187.4	187.41	187.31	187.31	10672.0
2014-05-07 07:40:00	SPY	ETF	187.34	187.37	187.34	187.37	7070.0
2014-05-07 07:45:00	SPY	ETF	187.31	187.33	187.29	187.32	5433.0
2014-05-07 07:50:00	SPY	ETF	187.32	187.35	187.3	187.32	46877.0
2014-05-07 07:55:00	SPY	ETF	187.32	187.35	187.24	187.27	16169.0
2014-05-07 08:00:00	SPY	ETF	187.31	187.39	187.26	187.34	98529.0
2014-05-07 08:05:00	SPY	ETF	187.34	187.57	187.32	187.56	125175.0
2014-05-07 08:10:00	SPY	ETF	187.55	187.65	187.54	187.61	170466.0
2014-05-07 08:15:00	SPY	ETF	187.61	187.72	187.6	187.64	182300.0
2014-05-07 08:20:00	SPY	ETF	187.64	187.64	187.58	187.58	69703.0
2014-05-07 08:25:00	SPY	ETF	187.6	187.63	187.54	187.54	122701.0
2014-05-07 08:30:00	SPY	ETF	187.54	187.54	187.41	187.47	145693.0
2014-05-07 08:35:00	SPY	ETF	187.46	187.52	187.46	187.46	59811.0
2014-05-07 08:40:00	SPY	ETF	187.48	187.48	187.4	187.43	84382.0
2014-05-07 08:45:00	SPY	ETF	187.45	187.46	187.36	187.38	71972.0
2014-05-07 08:50:00	SPY	ETF	187.38	187.39	187.35	187.35	68494.0
2014-05-07 08:55:00	SPY	ETF	187.36	187.46	187.35	187.4	79834.0
2014-05-07 09:00:00	SPY	ETF	187.4	187.43	187.38	187.38	52322.0
2014-05-07 09:05:00	SPY	ETF	187.38	187.39	187.34	187.34	30292.0
2014-05-07 09:10:00	SPY	ETF	187.34	187.35	187.2	187.2	103859.0
2014-05-07 09:15:00	SPY	ETF	187.21	187.21	187.15	187.15	97084.0
2014-05-07 09:20:00	SPY	ETF	187.16	187.23	187.16	187.19	92683.0
2014-05-07 09:25:00	SPY	ETF	187.18	187.42	187.17	187.42	410121.0
2014-05-07 09:30:00	SPY	ETF	187.43	187.69	187.29	187.62	2877157.0

> showing 50 of 43,133 rows — these rows as CSV

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