PREVIEW / etf_5min / 2017-09-22

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-09-22.parquet
  size:    1.1 MB
  rows:    50,045

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-09-22 04:00:00	SPY	ETF	249.22	249.22	249.22	249.22	333.0
2017-09-22 04:05:00	SPY	ETF	249.22	249.22	249.22	249.22	300.0
2017-09-22 04:10:00	SPY	ETF	249.2	249.2	249.2	249.2	100.0
2017-09-22 04:20:00	SPY	ETF	249.19	249.19	249.08	249.09	4125.0
2017-09-22 04:25:00	SPY	ETF	249.09	249.1	249.09	249.1	200.0
2017-09-22 04:30:00	SPY	ETF	249.14	249.14	249.14	249.14	900.0
2017-09-22 04:40:00	SPY	ETF	249.14	249.26	249.14	249.26	2600.0
2017-09-22 04:45:00	SPY	ETF	249.3	249.3	249.24	249.24	200.0
2017-09-22 05:00:00	SPY	ETF	249.21	249.21	249.21	249.21	200.0
2017-09-22 06:00:00	SPY	ETF	249.32	249.32	249.32	249.32	100.0
2017-09-22 06:05:00	SPY	ETF	249.31	249.34	249.31	249.34	1600.0
2017-09-22 06:15:00	SPY	ETF	249.31	249.35	249.31	249.32	3100.0
2017-09-22 06:20:00	SPY	ETF	249.35	249.35	249.35	249.35	1000.0
2017-09-22 06:25:00	SPY	ETF	249.34	249.38	249.34	249.36	3300.0
2017-09-22 06:35:00	SPY	ETF	249.37	249.41	249.37	249.4	6500.0
2017-09-22 06:40:00	SPY	ETF	249.37	249.37	249.37	249.37	300.0
2017-09-22 06:45:00	SPY	ETF	249.37	249.38	249.37	249.38	1200.0
2017-09-22 06:50:00	SPY	ETF	249.39	249.39	249.39	249.39	1000.0
2017-09-22 06:55:00	SPY	ETF	249.38	249.38	249.38	249.38	100.0
2017-09-22 07:00:00	SPY	ETF	249.41	249.41	249.4	249.4	400.0
2017-09-22 07:05:00	SPY	ETF	249.39	249.41	249.39	249.4	1369.0
2017-09-22 07:10:00	SPY	ETF	249.4	249.4	249.35	249.35	8489.0
2017-09-22 07:15:00	SPY	ETF	249.34	249.34	249.3	249.3	13855.0
2017-09-22 07:20:00	SPY	ETF	249.34	249.34	249.34	249.34	10000.0
2017-09-22 07:25:00	SPY	ETF	249.3	249.3	249.26	249.28	7559.0
2017-09-22 07:30:00	SPY	ETF	249.3	249.3	249.26	249.27	12430.0
2017-09-22 07:35:00	SPY	ETF	249.28	249.28	249.27	249.27	4500.0
2017-09-22 07:40:00	SPY	ETF	249.26	249.26	249.24	249.24	4707.0
2017-09-22 07:45:00	SPY	ETF	249.28	249.28	249.22	249.26	13047.0
2017-09-22 07:50:00	SPY	ETF	249.26	249.26	249.21	249.21	8707.0
2017-09-22 07:55:00	SPY	ETF	249.2	249.2	249.13	249.13	29236.0
2017-09-22 08:00:00	SPY	ETF	249.12	249.42	249.12	249.17	13826.0
2017-09-22 08:05:00	SPY	ETF	249.17	249.17	249.09	249.11	71666.0
2017-09-22 08:10:00	SPY	ETF	249.1	249.11	249.05	249.11	10850.0
2017-09-22 08:15:00	SPY	ETF	249.11	249.13	249.1	249.13	6510.0
2017-09-22 08:20:00	SPY	ETF	249.15	249.16	249.12	249.12	11465.0
2017-09-22 08:25:00	SPY	ETF	249.12	249.12	249.09	249.11	3279.0
2017-09-22 08:30:00	SPY	ETF	249.11	249.15	249.08	249.15	4220.0
2017-09-22 08:35:00	SPY	ETF	249.1	249.12	249.1	249.12	10252.0
2017-09-22 08:40:00	SPY	ETF	249.12	249.12	249.05	249.05	10389.0
2017-09-22 08:45:00	SPY	ETF	249.05	249.12	249.04	249.1	9950.0
2017-09-22 08:50:00	SPY	ETF	249.09	249.12	249.07	249.08	12700.0
2017-09-22 08:55:00	SPY	ETF	249.1	249.1	249.03	249.03	48390.0
2017-09-22 09:00:00	SPY	ETF	249.03	249.04	249.0	249.02	42923.0
2017-09-22 09:05:00	SPY	ETF	249.01	249.01	248.97	249.01	653721.0
2017-09-22 09:10:00	SPY	ETF	249.0	249.05	248.99	249.03	7505.0
2017-09-22 09:15:00	SPY	ETF	249.01	249.06	249.0	249.0	21756.0
2017-09-22 09:20:00	SPY	ETF	249.0	249.04	249.0	249.04	6200.0
2017-09-22 09:25:00	SPY	ETF	249.06	249.07	249.0	249.03	109705.0
2017-09-22 09:30:00	SPY	ETF	249.05	249.25	249.02	249.24	1136523.0

> showing 50 of 50,045 rows — these rows as CSV

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