PREVIEW / etf_5min / 2017-02-06

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-02-06.parquet
  size:    1.2 MB
  rows:    54,601

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-02-06 04:05:00	SPY	ETF	229.37	229.44	229.37	229.41	2610.0
2017-02-06 04:20:00	SPY	ETF	229.49	229.49	229.49	229.49	200.0
2017-02-06 04:25:00	SPY	ETF	229.46	229.46	229.46	229.46	100.0
2017-02-06 04:30:00	SPY	ETF	229.44	229.44	229.42	229.42	322.0
2017-02-06 04:35:00	SPY	ETF	229.39	229.4	229.39	229.4	900.0
2017-02-06 04:40:00	SPY	ETF	229.39	229.39	229.39	229.39	340.0
2017-02-06 04:45:00	SPY	ETF	229.39	229.39	229.39	229.39	300.0
2017-02-06 04:55:00	SPY	ETF	229.46	229.46	229.46	229.46	5260.0
2017-02-06 05:00:00	SPY	ETF	229.49	229.49	229.49	229.49	200.0
2017-02-06 05:05:00	SPY	ETF	229.5	229.54	229.5	229.54	200.0
2017-02-06 05:20:00	SPY	ETF	229.54	229.54	229.54	229.54	100.0
2017-02-06 05:25:00	SPY	ETF	229.54	229.54	229.54	229.54	300.0
2017-02-06 05:30:00	SPY	ETF	229.51	229.51	229.51	229.51	800.0
2017-02-06 05:35:00	SPY	ETF	229.51	229.51	229.51	229.51	500.0
2017-02-06 05:40:00	SPY	ETF	229.54	229.54	229.54	229.54	2000.0
2017-02-06 05:50:00	SPY	ETF	229.54	229.54	229.49	229.49	1350.0
2017-02-06 05:55:00	SPY	ETF	229.49	229.49	229.49	229.49	1100.0
2017-02-06 06:00:00	SPY	ETF	229.49	229.49	229.49	229.49	100.0
2017-02-06 06:05:00	SPY	ETF	229.51	229.51	229.51	229.51	100.0
2017-02-06 06:15:00	SPY	ETF	229.47	229.47	229.47	229.47	300.0
2017-02-06 06:20:00	SPY	ETF	229.42	229.42	229.31	229.31	4450.0
2017-02-06 06:25:00	SPY	ETF	229.31	229.31	229.26	229.26	600.0
2017-02-06 06:30:00	SPY	ETF	229.25	229.25	229.22	229.22	600.0
2017-02-06 06:40:00	SPY	ETF	229.26	229.26	229.26	229.26	10000.0
2017-02-06 06:45:00	SPY	ETF	229.26	229.26	229.26	229.26	1400.0
2017-02-06 06:50:00	SPY	ETF	229.27	229.27	229.27	229.27	500.0
2017-02-06 06:55:00	SPY	ETF	229.24	229.24	229.24	229.24	200.0
2017-02-06 07:00:00	SPY	ETF	229.24	229.26	229.24	229.24	2305.0
2017-02-06 07:05:00	SPY	ETF	229.24	229.27	229.19	229.21	2700.0
2017-02-06 07:10:00	SPY	ETF	229.25	229.25	229.22	229.22	2370.0
2017-02-06 07:15:00	SPY	ETF	229.22	229.22	229.22	229.22	1500.0
2017-02-06 07:20:00	SPY	ETF	229.22	229.22	229.15	229.16	25800.0
2017-02-06 07:25:00	SPY	ETF	229.17	229.17	229.17	229.17	1000.0
2017-02-06 07:30:00	SPY	ETF	229.17	229.2	229.16	229.2	1900.0
2017-02-06 07:35:00	SPY	ETF	229.2	229.2	229.2	229.2	100.0
2017-02-06 07:40:00	SPY	ETF	229.18	229.18	229.18	229.18	300.0
2017-02-06 07:45:00	SPY	ETF	229.19	229.19	229.19	229.19	200.0
2017-02-06 07:50:00	SPY	ETF	229.18	229.18	229.17	229.17	1078.0
2017-02-06 07:55:00	SPY	ETF	229.17	229.17	228.98	228.98	18925.0
2017-02-06 08:00:00	SPY	ETF	228.95	229.28	228.86	228.94	84563.0
2017-02-06 08:05:00	SPY	ETF	228.92	228.97	228.91	228.97	13547.0
2017-02-06 08:10:00	SPY	ETF	228.99	228.99	228.95	228.97	18768.0
2017-02-06 08:15:00	SPY	ETF	228.95	228.97	228.8	228.8	38807.0
2017-02-06 08:20:00	SPY	ETF	228.8	228.87	228.77	228.85	34385.0
2017-02-06 08:25:00	SPY	ETF	228.86	228.89	228.84	228.88	49975.0
2017-02-06 08:30:00	SPY	ETF	228.85	228.85	228.58	228.61	121810.0
2017-02-06 08:35:00	SPY	ETF	228.6	228.71	228.6	228.7	52959.0
2017-02-06 08:40:00	SPY	ETF	228.69	228.79	228.69	228.79	5465.0
2017-02-06 08:45:00	SPY	ETF	228.79	229.042	228.78	228.79	31716.0
2017-02-06 08:50:00	SPY	ETF	228.8	228.82	228.77	228.78	61011.0

> showing 50 of 54,601 rows — these rows as CSV

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