PREVIEW / etf_5min / 2016-06-27

all etf 5-min files

  file:    by_date/etf_5min/2016/2016-06-27.parquet
  size:    1.4 MB
  rows:    59,687

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
2016-06-27 04:00:00	SPY	ETF	202.3	202.44	202.3	202.37	600.0
2016-06-27 04:05:00	SPY	ETF	202.45	202.5	202.25	202.25	1600.0
2016-06-27 04:10:00	SPY	ETF	202.15	202.27	202.15	202.27	905.0
2016-06-27 04:15:00	SPY	ETF	202.24	202.25	202.02	202.02	52812.0
2016-06-27 04:20:00	SPY	ETF	202.02	202.02	201.75	201.83	7664.0
2016-06-27 04:25:00	SPY	ETF	201.72	201.72	201.68	201.71	20885.0
2016-06-27 04:30:00	SPY	ETF	201.68	201.7	201.6	201.63	12309.0
2016-06-27 04:35:00	SPY	ETF	201.6	201.7	201.55	201.55	19430.0
2016-06-27 04:40:00	SPY	ETF	201.52	201.61	201.52	201.61	1345.0
2016-06-27 04:45:00	SPY	ETF	201.61	201.78	201.61	201.78	33805.0
2016-06-27 04:50:00	SPY	ETF	201.78	201.8	201.53	201.58	18384.0
2016-06-27 04:55:00	SPY	ETF	201.66	201.86	201.66	201.86	11966.0
2016-06-27 05:00:00	SPY	ETF	201.76	201.94	201.76	201.76	1043.0
2016-06-27 05:05:00	SPY	ETF	201.94	201.96	201.9	201.91	1834.0
2016-06-27 05:10:00	SPY	ETF	201.86	202.0	201.86	202.0	5091.0
2016-06-27 05:15:00	SPY	ETF	202.14	202.14	202.09	202.13	1362.0
2016-06-27 05:20:00	SPY	ETF	202.03	202.05	201.68	201.68	10876.0
2016-06-27 05:25:00	SPY	ETF	201.65	201.73	201.65	201.67	8819.0
2016-06-27 05:30:00	SPY	ETF	201.65	201.65	201.6	201.63	5856.0
2016-06-27 05:35:00	SPY	ETF	201.63	201.63	201.53	201.53	11431.0
2016-06-27 05:40:00	SPY	ETF	201.53	201.53	201.47	201.47	3861.0
2016-06-27 05:45:00	SPY	ETF	201.48	201.51	201.46	201.46	4801.0
2016-06-27 05:50:00	SPY	ETF	201.51	201.53	201.51	201.53	3555.0
2016-06-27 05:55:00	SPY	ETF	201.53	201.55	201.53	201.55	2309.0
2016-06-27 06:00:00	SPY	ETF	201.53	201.58	201.52	201.56	4962.0
2016-06-27 06:05:00	SPY	ETF	201.53	201.6	201.41	201.41	18066.0
2016-06-27 06:10:00	SPY	ETF	201.38	201.41	201.33	201.38	16984.0
2016-06-27 06:15:00	SPY	ETF	201.33	201.38	201.21	201.38	15827.0
2016-06-27 06:20:00	SPY	ETF	201.38	201.48	201.35	201.41	3988.0
2016-06-27 06:25:00	SPY	ETF	201.29	201.29	201.2	201.26	1119.0
2016-06-27 06:30:00	SPY	ETF	201.21	201.26	201.17	201.19	12926.0
2016-06-27 06:35:00	SPY	ETF	201.19	201.19	201.04	201.09	39098.0
2016-06-27 06:40:00	SPY	ETF	201.06	201.06	200.99	201.06	27805.0
2016-06-27 06:45:00	SPY	ETF	201.02	201.08	200.88	200.97	11290.0
2016-06-27 06:50:00	SPY	ETF	201.09	201.14	201.09	201.14	4074.0
2016-06-27 06:55:00	SPY	ETF	201.1	201.1	200.89	200.9	66882.0
2016-06-27 07:00:00	SPY	ETF	200.88	201.07	200.88	201.07	15566.0
2016-06-27 07:05:00	SPY	ETF	201.0	201.2	201.0	201.05	34342.0
2016-06-27 07:10:00	SPY	ETF	201.02	201.09	200.94	200.94	18363.0
2016-06-27 07:15:00	SPY	ETF	200.94	200.97	200.8	200.8	21297.0
2016-06-27 07:20:00	SPY	ETF	200.79	200.95	200.79	200.82	13781.0
2016-06-27 07:25:00	SPY	ETF	200.8	200.97	200.75	200.95	30677.0
2016-06-27 07:30:00	SPY	ETF	200.98	201.02	200.75	200.75	30885.0
2016-06-27 07:35:00	SPY	ETF	200.8	200.82	200.73	200.77	61376.0
2016-06-27 07:40:00	SPY	ETF	200.74	200.84	200.74	200.78	59766.0
2016-06-27 07:45:00	SPY	ETF	200.8	200.8	200.54	200.58	174060.0
2016-06-27 07:50:00	SPY	ETF	200.55	200.8	200.54	200.74	151818.0
2016-06-27 07:55:00	SPY	ETF	200.75	200.78	200.57	200.66	143858.0
2016-06-27 08:00:00	SPY	ETF	200.66	201.1	200.57	200.95	150194.0
2016-06-27 08:05:00	SPY	ETF	201.32	201.32	200.94	201.11	190513.0

> showing 50 of 59,687 rows — these rows as CSV

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