PREVIEW / etf_5min / 2017-07-20

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-07-20.parquet
  size:    1.2 MB
  rows:    52,034

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-07-20 04:00:00	SPY	ETF	247.1	247.28	247.1	247.28	1446.0
2017-07-20 04:05:00	SPY	ETF	247.27	247.27	247.27	247.27	500.0
2017-07-20 04:20:00	SPY	ETF	247.22	247.23	247.21	247.21	400.0
2017-07-20 04:25:00	SPY	ETF	247.15	247.16	247.15	247.15	8801.0
2017-07-20 04:30:00	SPY	ETF	247.18	247.26	247.16	247.24	16906.0
2017-07-20 04:35:00	SPY	ETF	247.26	247.26	247.26	247.26	301.0
2017-07-20 04:45:00	SPY	ETF	247.24	247.26	247.24	247.26	800.0
2017-07-20 05:00:00	SPY	ETF	247.11	247.11	247.05	247.05	1000.0
2017-07-20 05:05:00	SPY	ETF	247.08	247.08	247.08	247.08	100.0
2017-07-20 05:10:00	SPY	ETF	247.11	247.11	247.11	247.11	301.0
2017-07-20 05:30:00	SPY	ETF	247.16	247.18	247.16	247.18	800.0
2017-07-20 05:35:00	SPY	ETF	247.19	247.19	247.17	247.17	1325.0
2017-07-20 05:40:00	SPY	ETF	247.16	247.16	247.16	247.16	400.0
2017-07-20 05:45:00	SPY	ETF	247.16	247.16	247.16	247.16	400.0
2017-07-20 05:50:00	SPY	ETF	247.12	247.12	247.12	247.12	101.0
2017-07-20 06:00:00	SPY	ETF	247.12	247.12	247.12	247.12	100.0
2017-07-20 06:10:00	SPY	ETF	247.16	247.16	247.16	247.16	1100.0
2017-07-20 06:15:00	SPY	ETF	247.16	247.16	247.14	247.14	900.0
2017-07-20 06:20:00	SPY	ETF	247.18	247.18	247.18	247.18	901.0
2017-07-20 06:30:00	SPY	ETF	247.19	247.19	247.19	247.19	300.0
2017-07-20 06:45:00	SPY	ETF	247.1	247.14	247.1	247.12	2300.0
2017-07-20 06:50:00	SPY	ETF	247.12	247.12	247.12	247.12	600.0
2017-07-20 06:55:00	SPY	ETF	247.1	247.1	247.1	247.1	300.0
2017-07-20 07:00:00	SPY	ETF	247.08	247.12	247.08	247.12	2039.0
2017-07-20 07:05:00	SPY	ETF	247.12	247.12	247.12	247.12	300.0
2017-07-20 07:15:00	SPY	ETF	247.1	247.11	247.1	247.11	4100.0
2017-07-20 07:20:00	SPY	ETF	247.11	247.11	247.1	247.11	1700.0
2017-07-20 07:25:00	SPY	ETF	247.1	247.13	247.1	247.13	2302.0
2017-07-20 07:30:00	SPY	ETF	247.14	247.16	247.12	247.12	2965.0
2017-07-20 07:35:00	SPY	ETF	247.12	247.12	247.1	247.1	600.0
2017-07-20 07:40:00	SPY	ETF	247.12	247.15	247.1	247.15	17441.0
2017-07-20 07:45:00	SPY	ETF	247.18	247.2	247.17	247.18	11196.0
2017-07-20 07:50:00	SPY	ETF	247.18	247.21	247.16	247.16	3159.0
2017-07-20 07:55:00	SPY	ETF	247.2	247.23	247.19	247.23	791.0
2017-07-20 08:00:00	SPY	ETF	247.1	247.28	247.1	247.23	6327.0
2017-07-20 08:05:00	SPY	ETF	247.25	247.26	247.21	247.21	8393.0
2017-07-20 08:10:00	SPY	ETF	247.2	247.21	247.2	247.21	1716.0
2017-07-20 08:15:00	SPY	ETF	247.23	247.37	247.21	247.36	59848.0
2017-07-20 08:20:00	SPY	ETF	247.35	247.45	247.35	247.42	67098.0
2017-07-20 08:25:00	SPY	ETF	247.43	247.46	247.42	247.44	16521.0
2017-07-20 08:30:00	SPY	ETF	247.44	247.5	247.4	247.47	48571.0
2017-07-20 08:35:00	SPY	ETF	247.47	247.48	247.37	247.37	62613.0
2017-07-20 08:40:00	SPY	ETF	247.37	247.37	247.24	247.24	56114.0
2017-07-20 08:45:00	SPY	ETF	247.24	247.3	247.1	247.15	63912.0
2017-07-20 08:50:00	SPY	ETF	247.15	247.18	247.14	247.18	30510.0
2017-07-20 08:55:00	SPY	ETF	247.16	247.26	247.16	247.19	17970.0
2017-07-20 09:00:00	SPY	ETF	247.2	247.26	247.2	247.26	49176.0
2017-07-20 09:05:00	SPY	ETF	247.26	247.3	247.26	247.3	10929.0
2017-07-20 09:10:00	SPY	ETF	247.31	247.37	247.29	247.36	17753.0
2017-07-20 09:15:00	SPY	ETF	247.34	247.37	247.34	247.34	63212.0

> showing 50 of 52,034 rows — these rows as CSV

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