PREVIEW / etf_5min / 2017-01-31

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-01-31.parquet
  size:    1.3 MB
  rows:    56,975

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-31 04:05:00	SPY	ETF	227.4	227.4	227.35	227.35	400.0
2017-01-31 04:20:00	SPY	ETF	227.33	227.43	227.33	227.43	600.0
2017-01-31 04:25:00	SPY	ETF	227.45	227.47	227.45	227.46	603.0
2017-01-31 04:45:00	SPY	ETF	227.5	227.5	227.5	227.5	403.0
2017-01-31 04:50:00	SPY	ETF	227.55	227.55	227.55	227.55	224.0
2017-01-31 04:55:00	SPY	ETF	227.5	227.5	227.5	227.5	402.0
2017-01-31 05:00:00	SPY	ETF	227.47	227.47	227.47	227.47	400.0
2017-01-31 05:15:00	SPY	ETF	227.42	227.42	227.42	227.42	300.0
2017-01-31 05:25:00	SPY	ETF	227.28	227.28	227.25	227.25	507.0
2017-01-31 05:30:00	SPY	ETF	227.23	227.24	227.23	227.23	3502.0
2017-01-31 05:35:00	SPY	ETF	227.2	227.22	227.2	227.22	6100.0
2017-01-31 05:40:00	SPY	ETF	227.19	227.19	227.19	227.19	215.0
2017-01-31 05:45:00	SPY	ETF	227.17	227.17	227.13	227.15	2051.0
2017-01-31 05:55:00	SPY	ETF	227.25	227.3	227.25	227.3	1302.0
2017-01-31 06:05:00	SPY	ETF	227.34	227.34	227.34	227.34	2500.0
2017-01-31 06:10:00	SPY	ETF	227.37	227.38	227.37	227.38	1700.0
2017-01-31 06:20:00	SPY	ETF	227.46	227.46	227.46	227.46	1002.0
2017-01-31 06:25:00	SPY	ETF	227.46	227.46	227.45	227.45	1602.0
2017-01-31 06:30:00	SPY	ETF	227.45	227.45	227.45	227.45	5000.0
2017-01-31 06:35:00	SPY	ETF	227.38	227.38	227.37	227.37	10192.0
2017-01-31 06:45:00	SPY	ETF	227.35	227.35	227.29	227.29	7200.0
2017-01-31 06:50:00	SPY	ETF	227.34	227.34	227.34	227.34	1503.0
2017-01-31 07:00:00	SPY	ETF	227.37	227.37	227.35	227.37	1502.0
2017-01-31 07:05:00	SPY	ETF	227.37	227.37	227.35	227.35	2999.0
2017-01-31 07:10:00	SPY	ETF	227.34	227.38	227.33	227.38	1713.0
2017-01-31 07:15:00	SPY	ETF	227.42	227.42	227.42	227.42	400.0
2017-01-31 07:20:00	SPY	ETF	227.39	227.39	227.39	227.39	501.0
2017-01-31 07:25:00	SPY	ETF	227.4	227.4	227.4	227.4	201.0
2017-01-31 07:30:00	SPY	ETF	227.37	227.37	227.12	227.12	29459.0
2017-01-31 07:35:00	SPY	ETF	227.14	227.2	227.14	227.17	2971.0
2017-01-31 07:40:00	SPY	ETF	227.21	227.23	227.15	227.15	25571.0
2017-01-31 07:45:00	SPY	ETF	227.14	227.15	227.07	227.07	12963.0
2017-01-31 07:50:00	SPY	ETF	227.02	227.06	227.01	227.04	31205.0
2017-01-31 07:55:00	SPY	ETF	227.04	227.07	227.0	227.06	53193.0
2017-01-31 08:00:00	SPY	ETF	227.04	227.41	227.02	227.13	111887.0
2017-01-31 08:05:00	SPY	ETF	227.12	227.16	227.12	227.14	7969.0
2017-01-31 08:10:00	SPY	ETF	227.15	227.17	227.15	227.17	12436.0
2017-01-31 08:15:00	SPY	ETF	227.17	227.18	227.11	227.13	13077.0
2017-01-31 08:20:00	SPY	ETF	227.13	227.23	227.13	227.2	3456.0
2017-01-31 08:25:00	SPY	ETF	227.22	227.27	227.22	227.22	23839.0
2017-01-31 08:30:00	SPY	ETF	227.22	227.38	227.15	227.15	173037.0
2017-01-31 08:35:00	SPY	ETF	227.16	227.16	227.05	227.12	101189.0
2017-01-31 08:40:00	SPY	ETF	227.13	227.15	227.06	227.09	83063.0
2017-01-31 08:45:00	SPY	ETF	227.09	227.19	227.07	227.19	8500.0
2017-01-31 08:50:00	SPY	ETF	227.19	227.23	227.19	227.19	3889.0
2017-01-31 08:55:00	SPY	ETF	227.15	227.2	227.14	227.14	6235.0
2017-01-31 09:00:00	SPY	ETF	227.2	227.2	227.16	227.18	27146.0
2017-01-31 09:05:00	SPY	ETF	227.2	227.23	227.19	227.19	13863.0
2017-01-31 09:10:00	SPY	ETF	227.19	227.2	227.13	227.13	27226.0
2017-01-31 09:15:00	SPY	ETF	227.15	227.17	227.1	227.17	18720.0

> showing 50 of 56,975 rows — these rows as CSV

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