PREVIEW / etf_5min / 2017-07-31

all etf 5-min files

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

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-31 04:00:00	SPY	ETF	247.12	247.12	247.12	247.12	1223.0
2017-07-31 04:05:00	SPY	ETF	247.1	247.2	247.1	247.12	529.0
2017-07-31 04:10:00	SPY	ETF	247.25	247.25	247.25	247.25	1300.0
2017-07-31 04:15:00	SPY	ETF	247.25	247.25	247.24	247.24	487.0
2017-07-31 04:20:00	SPY	ETF	247.25	247.25	247.25	247.25	1800.0
2017-07-31 04:25:00	SPY	ETF	247.24	247.24	247.24	247.24	240.0
2017-07-31 04:30:00	SPY	ETF	247.22	247.22	247.22	247.22	300.0
2017-07-31 04:35:00	SPY	ETF	247.17	247.17	247.17	247.17	500.0
2017-07-31 04:40:00	SPY	ETF	247.2	247.2	247.2	247.2	500.0
2017-07-31 04:50:00	SPY	ETF	247.16	247.18	247.15	247.15	1400.0
2017-07-31 04:55:00	SPY	ETF	247.16	247.16	247.16	247.16	800.0
2017-07-31 05:00:00	SPY	ETF	247.18	247.18	247.15	247.16	3701.0
2017-07-31 05:05:00	SPY	ETF	247.13	247.13	247.06	247.06	2837.0
2017-07-31 05:10:00	SPY	ETF	247.11	247.11	247.11	247.11	300.0
2017-07-31 05:15:00	SPY	ETF	247.15	247.15	247.15	247.15	2500.0
2017-07-31 05:20:00	SPY	ETF	247.18	247.2	247.18	247.2	4700.0
2017-07-31 05:25:00	SPY	ETF	247.2	247.32	247.2	247.31	55636.0
2017-07-31 05:30:00	SPY	ETF	247.32	247.32	247.29	247.29	600.0
2017-07-31 05:35:00	SPY	ETF	247.28	247.28	247.28	247.28	600.0
2017-07-31 05:40:00	SPY	ETF	247.26	247.26	247.25	247.26	1500.0
2017-07-31 05:45:00	SPY	ETF	247.28	247.28	247.28	247.28	300.0
2017-07-31 05:50:00	SPY	ETF	247.26	247.28	247.26	247.28	700.0
2017-07-31 05:55:00	SPY	ETF	247.26	247.26	247.26	247.26	100.0
2017-07-31 06:00:00	SPY	ETF	247.22	247.22	247.1	247.1	12400.0
2017-07-31 06:10:00	SPY	ETF	247.14	247.14	247.14	247.14	220.0
2017-07-31 06:20:00	SPY	ETF	247.18	247.18	247.18	247.18	300.0
2017-07-31 06:25:00	SPY	ETF	247.2	247.2	247.18	247.18	1300.0
2017-07-31 06:30:00	SPY	ETF	247.2	247.2	247.2	247.2	300.0
2017-07-31 06:35:00	SPY	ETF	247.2	247.2	247.2	247.2	400.0
2017-07-31 06:40:00	SPY	ETF	247.16	247.16	247.16	247.16	300.0
2017-07-31 06:45:00	SPY	ETF	247.15	247.15	247.15	247.15	300.0
2017-07-31 06:50:00	SPY	ETF	247.15	247.18	247.15	247.18	1018.0
2017-07-31 07:00:00	SPY	ETF	247.17	247.2	247.17	247.2	3425.0
2017-07-31 07:05:00	SPY	ETF	247.21	247.3	247.19	247.3	28660.0
2017-07-31 07:10:00	SPY	ETF	247.29	247.29	247.29	247.29	100.0
2017-07-31 07:15:00	SPY	ETF	247.24	247.24	247.24	247.24	4000.0
2017-07-31 07:20:00	SPY	ETF	247.29	247.29	247.29	247.29	2500.0
2017-07-31 07:25:00	SPY	ETF	247.26	247.26	247.26	247.26	525.0
2017-07-31 07:30:00	SPY	ETF	247.3	247.3	247.3	247.3	5000.0
2017-07-31 07:35:00	SPY	ETF	247.27	247.28	247.27	247.28	8600.0
2017-07-31 07:40:00	SPY	ETF	247.28	247.32	247.28	247.29	50600.0
2017-07-31 07:45:00	SPY	ETF	247.27	247.33	247.26	247.33	2926.0
2017-07-31 07:50:00	SPY	ETF	247.28	247.28	247.28	247.28	11100.0
2017-07-31 07:55:00	SPY	ETF	247.3	247.31	247.28	247.29	2815.0
2017-07-31 08:00:00	SPY	ETF	247.31	247.31	247.18	247.24	26010.0
2017-07-31 08:05:00	SPY	ETF	247.27	247.27	247.22	247.24	17220.0
2017-07-31 08:10:00	SPY	ETF	247.29	247.36	247.29	247.35	37380.0
2017-07-31 08:15:00	SPY	ETF	247.35	247.36	247.34	247.36	4602.0
2017-07-31 08:20:00	SPY	ETF	247.34	247.34	247.33	247.34	2325.0
2017-07-31 08:25:00	SPY	ETF	247.36	247.36	247.34	247.35	6295.0

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

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