PREVIEW / etf_5min / 2014-09-29

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-09-29.parquet
  size:    1.0 MB
  rows:    43,994

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-09-29 04:00:00	SPY	ETF	197.36	197.36	197.21	197.27	12397.0
2014-09-29 04:05:00	SPY	ETF	197.22	197.24	197.19	197.19	4110.0
2014-09-29 04:10:00	SPY	ETF	197.2	197.22	197.2	197.22	450.0
2014-09-29 04:15:00	SPY	ETF	197.21	197.21	197.21	197.21	200.0
2014-09-29 04:20:00	SPY	ETF	197.28	197.4	197.28	197.4	313.0
2014-09-29 04:25:00	SPY	ETF	197.35	197.35	197.35	197.35	236.0
2014-09-29 04:40:00	SPY	ETF	197.23	197.23	197.18	197.18	460.0
2014-09-29 04:50:00	SPY	ETF	197.37	197.38	197.35	197.35	5700.0
2014-09-29 04:55:00	SPY	ETF	197.32	197.32	197.28	197.28	600.0
2014-09-29 05:00:00	SPY	ETF	197.29	197.3	197.29	197.3	3779.0
2014-09-29 05:05:00	SPY	ETF	197.32	197.32	197.28	197.3	1322.0
2014-09-29 05:10:00	SPY	ETF	197.25	197.25	197.2	197.2	476.0
2014-09-29 05:15:00	SPY	ETF	197.21	197.21	197.15	197.15	1070.0
2014-09-29 05:20:00	SPY	ETF	197.23	197.23	197.23	197.23	500.0
2014-09-29 05:25:00	SPY	ETF	197.23	197.23	197.23	197.23	4000.0
2014-09-29 05:30:00	SPY	ETF	197.28	197.28	197.28	197.28	500.0
2014-09-29 05:35:00	SPY	ETF	197.26	197.26	197.26	197.26	1000.0
2014-09-29 05:40:00	SPY	ETF	197.33	197.33	197.33	197.33	500.0
2014-09-29 05:45:00	SPY	ETF	197.33	197.38	197.33	197.38	2900.0
2014-09-29 05:55:00	SPY	ETF	197.28	197.28	197.28	197.28	300.0
2014-09-29 06:00:00	SPY	ETF	197.26	197.26	197.2	197.2	12500.0
2014-09-29 06:05:00	SPY	ETF	197.25	197.33	197.25	197.33	18135.0
2014-09-29 06:10:00	SPY	ETF	197.33	197.38	197.33	197.36	5400.0
2014-09-29 06:15:00	SPY	ETF	197.36	197.36	197.28	197.28	5700.0
2014-09-29 06:20:00	SPY	ETF	197.27	197.27	197.2	197.2	5600.0
2014-09-29 06:25:00	SPY	ETF	197.26	197.3	197.26	197.29	48525.0
2014-09-29 06:30:00	SPY	ETF	197.33	197.33	197.33	197.33	2310.0
2014-09-29 06:35:00	SPY	ETF	197.24	197.24	197.24	197.24	2590.0
2014-09-29 06:40:00	SPY	ETF	197.18	197.26	197.13	197.23	52000.0
2014-09-29 06:45:00	SPY	ETF	197.26	197.26	197.24	197.24	5500.0
2014-09-29 06:50:00	SPY	ETF	197.17	197.17	196.82	196.88	33035.0
2014-09-29 06:55:00	SPY	ETF	196.85	196.98	196.83	196.97	26703.0
2014-09-29 07:00:00	SPY	ETF	197.0	197.0	196.89	196.98	9200.0
2014-09-29 07:05:00	SPY	ETF	196.97	197.03	196.94	196.98	5971.0
2014-09-29 07:10:00	SPY	ETF	196.96	196.96	196.9	196.95	12795.0
2014-09-29 07:15:00	SPY	ETF	196.96	196.97	196.84	196.86	67450.0
2014-09-29 07:20:00	SPY	ETF	196.86	196.86	196.67	196.72	108725.0
2014-09-29 07:25:00	SPY	ETF	196.72	196.81	196.68	196.8	19425.0
2014-09-29 07:30:00	SPY	ETF	196.8	196.84	196.75	196.84	247040.0
2014-09-29 07:35:00	SPY	ETF	196.87	196.94	196.83	196.85	44966.0
2014-09-29 07:40:00	SPY	ETF	196.91	196.91	196.85	196.86	15805.0
2014-09-29 07:45:00	SPY	ETF	196.88	196.94	196.86	196.94	84076.0
2014-09-29 07:50:00	SPY	ETF	196.94	196.97	196.88	196.88	13538.0
2014-09-29 07:55:00	SPY	ETF	196.93	197.01	196.91	197.01	34229.0
2014-09-29 08:00:00	SPY	ETF	197.01	197.04	196.6	196.88	110669.0
2014-09-29 08:05:00	SPY	ETF	197.215	197.215	196.88	196.88	164979.0
2014-09-29 08:10:00	SPY	ETF	196.86	196.86	196.77	196.86	58573.0
2014-09-29 08:15:00	SPY	ETF	196.81	196.9	196.77	196.85	25142.0
2014-09-29 08:20:00	SPY	ETF	196.84	196.88	196.81	196.83	33831.0
2014-09-29 08:25:00	SPY	ETF	196.86	196.88	196.78	196.81	82240.0

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

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