PREVIEW / etf_5min / 2017-01-11

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-01-11.parquet
  size:    1.3 MB
  rows:    55,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
2017-01-11 04:00:00	SPY	ETF	226.15	226.28	226.09	226.09	557.0
2017-01-11 04:05:00	SPY	ETF	226.17	226.17	226.12	226.14	1050.0
2017-01-11 04:10:00	SPY	ETF	226.09	226.09	226.09	226.09	210.0
2017-01-11 04:15:00	SPY	ETF	226.11	226.22	226.06	226.22	7203.0
2017-01-11 04:20:00	SPY	ETF	226.21	226.3	226.2	226.3	6318.0
2017-01-11 04:25:00	SPY	ETF	226.33	226.33	226.33	226.33	900.0
2017-01-11 04:30:00	SPY	ETF	226.3	226.31	226.3	226.3	1601.0
2017-01-11 04:35:00	SPY	ETF	226.27	226.29	226.27	226.29	8301.0
2017-01-11 04:40:00	SPY	ETF	226.4	226.4	226.36	226.36	4382.0
2017-01-11 04:45:00	SPY	ETF	226.32	226.36	226.32	226.36	2602.0
2017-01-11 04:50:00	SPY	ETF	226.36	226.36	226.36	226.36	500.0
2017-01-11 04:55:00	SPY	ETF	226.36	226.52	226.36	226.52	1516.0
2017-01-11 05:10:00	SPY	ETF	226.51	226.51	226.51	226.51	402.0
2017-01-11 05:15:00	SPY	ETF	226.46	226.46	226.46	226.46	1902.0
2017-01-11 05:30:00	SPY	ETF	226.49	226.49	226.42	226.44	2201.0
2017-01-11 05:35:00	SPY	ETF	226.44	226.44	226.44	226.44	400.0
2017-01-11 05:40:00	SPY	ETF	226.49	226.49	226.49	226.49	302.0
2017-01-11 05:55:00	SPY	ETF	226.48	226.48	226.48	226.48	200.0
2017-01-11 06:05:00	SPY	ETF	226.46	226.47	226.46	226.47	1503.0
2017-01-11 06:10:00	SPY	ETF	226.48	226.48	226.46	226.48	2121.0
2017-01-11 06:15:00	SPY	ETF	226.41	226.44	226.41	226.44	1208.0
2017-01-11 06:20:00	SPY	ETF	226.41	226.41	226.41	226.41	201.0
2017-01-11 06:30:00	SPY	ETF	226.44	226.44	226.44	226.44	300.0
2017-01-11 06:40:00	SPY	ETF	226.39	226.39	226.36	226.36	10559.0
2017-01-11 06:45:00	SPY	ETF	226.36	226.36	226.36	226.36	201.0
2017-01-11 06:55:00	SPY	ETF	226.5	226.53	226.5	226.53	754.0
2017-01-11 07:00:00	SPY	ETF	226.48	226.51	226.48	226.48	13501.0
2017-01-11 07:10:00	SPY	ETF	226.48	226.48	226.45	226.45	2313.0
2017-01-11 07:15:00	SPY	ETF	226.39	226.39	226.34	226.34	504.0
2017-01-11 07:20:00	SPY	ETF	226.33	226.36	226.33	226.36	4800.0
2017-01-11 07:25:00	SPY	ETF	226.36	226.36	226.33	226.35	2700.0
2017-01-11 07:30:00	SPY	ETF	226.3	226.3	226.2	226.2	13203.0
2017-01-11 07:35:00	SPY	ETF	226.25	226.25	226.21	226.25	9944.0
2017-01-11 07:40:00	SPY	ETF	226.26	226.26	226.18	226.18	1305.0
2017-01-11 07:45:00	SPY	ETF	226.19	226.22	226.15	226.17	12043.0
2017-01-11 07:50:00	SPY	ETF	226.17	226.2	226.17	226.17	15362.0
2017-01-11 07:55:00	SPY	ETF	226.17	226.17	226.15	226.15	1677.0
2017-01-11 08:00:00	SPY	ETF	226.48	226.48	226.15	226.16	27776.0
2017-01-11 08:05:00	SPY	ETF	226.15	226.16	226.13	226.15	6400.0
2017-01-11 08:10:00	SPY	ETF	226.15	226.16	226.14	226.15	6858.0
2017-01-11 08:15:00	SPY	ETF	226.15	226.16	226.14	226.14	2000.0
2017-01-11 08:20:00	SPY	ETF	226.16	226.17	226.12	226.15	37451.0
2017-01-11 08:25:00	SPY	ETF	226.15	226.17	226.15	226.17	2512.0
2017-01-11 08:30:00	SPY	ETF	226.16	226.23	226.16	226.23	8892.0
2017-01-11 08:35:00	SPY	ETF	226.22	226.23	226.22	226.23	31138.0
2017-01-11 08:40:00	SPY	ETF	226.22	226.23	226.2	226.22	5764.0
2017-01-11 08:45:00	SPY	ETF	226.22	226.25	226.2	226.22	11082.0
2017-01-11 08:50:00	SPY	ETF	226.22	226.27	226.2	226.27	11612.0
2017-01-11 08:55:00	SPY	ETF	226.27	226.3	226.24	226.26	6844.0
2017-01-11 09:00:00	SPY	ETF	226.25	226.48	226.25	226.42	80178.0

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

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