PREVIEW / etf_5min / 2017-09-26

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-09-26.parquet
  size:    1.2 MB
  rows:    52,303

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-26 04:00:00	SPY	ETF	249.26	249.26	249.1	249.1	700.0
2017-09-26 04:10:00	SPY	ETF	249.08	249.08	249.08	249.08	1100.0
2017-09-26 04:15:00	SPY	ETF	249.09	249.09	249.08	249.08	3400.0
2017-09-26 04:20:00	SPY	ETF	249.08	249.08	249.08	249.08	6100.0
2017-09-26 04:25:00	SPY	ETF	249.07	249.07	249.05	249.05	500.0
2017-09-26 04:30:00	SPY	ETF	249.05	249.05	249.05	249.05	800.0
2017-09-26 04:35:00	SPY	ETF	249.08	249.08	249.08	249.08	4000.0
2017-09-26 04:50:00	SPY	ETF	249.14	249.14	249.14	249.14	1500.0
2017-09-26 05:15:00	SPY	ETF	249.17	249.17	249.17	249.17	400.0
2017-09-26 05:20:00	SPY	ETF	249.23	249.23	249.23	249.23	100.0
2017-09-26 05:40:00	SPY	ETF	249.2	249.23	249.2	249.23	500.0
2017-09-26 06:05:00	SPY	ETF	249.22	249.22	249.22	249.22	300.0
2017-09-26 06:10:00	SPY	ETF	249.25	249.25	249.25	249.25	600.0
2017-09-26 06:20:00	SPY	ETF	249.27	249.27	249.27	249.27	300.0
2017-09-26 06:25:00	SPY	ETF	249.27	249.27	249.27	249.27	600.0
2017-09-26 06:30:00	SPY	ETF	249.27	249.27	249.27	249.27	400.0
2017-09-26 06:40:00	SPY	ETF	249.23	249.23	249.23	249.23	8125.0
2017-09-26 06:50:00	SPY	ETF	249.2	249.23	249.2	249.21	2848.0
2017-09-26 07:00:00	SPY	ETF	249.13	249.14	249.13	249.14	14310.0
2017-09-26 07:05:00	SPY	ETF	249.14	249.14	249.02	249.03	33374.0
2017-09-26 07:10:00	SPY	ETF	249.09	249.14	249.09	249.14	10208.0
2017-09-26 07:15:00	SPY	ETF	249.14	249.15	249.14	249.15	1099.0
2017-09-26 07:20:00	SPY	ETF	249.16	249.18	249.16	249.18	2402.0
2017-09-26 07:25:00	SPY	ETF	249.19	249.21	249.18	249.21	3475.0
2017-09-26 07:30:00	SPY	ETF	249.21	249.23	249.18	249.18	5302.0
2017-09-26 07:35:00	SPY	ETF	249.18	249.18	249.18	249.18	1150.0
2017-09-26 07:40:00	SPY	ETF	249.22	249.22	249.22	249.22	10100.0
2017-09-26 07:45:00	SPY	ETF	249.21	249.22	249.19	249.19	8620.0
2017-09-26 07:50:00	SPY	ETF	249.19	249.19	249.12	249.12	5331.0
2017-09-26 07:55:00	SPY	ETF	249.13	249.15	249.11	249.15	7345.0
2017-09-26 08:00:00	SPY	ETF	249.14	249.19	249.01	249.17	18235.0
2017-09-26 08:05:00	SPY	ETF	249.13	249.15	249.13	249.15	5783.0
2017-09-26 08:10:00	SPY	ETF	249.13	249.16	249.13	249.16	3103.0
2017-09-26 08:15:00	SPY	ETF	249.13	249.13	249.12	249.12	10658.0
2017-09-26 08:20:00	SPY	ETF	249.11	249.16	249.09	249.14	34132.0
2017-09-26 08:25:00	SPY	ETF	249.13	249.14	249.13	249.14	1100.0
2017-09-26 08:30:00	SPY	ETF	249.16	249.25	249.16	249.25	54512.0
2017-09-26 08:35:00	SPY	ETF	249.21	249.23	249.21	249.23	800.0
2017-09-26 08:40:00	SPY	ETF	249.25	249.31	249.23	249.31	7883.0
2017-09-26 08:45:00	SPY	ETF	249.31	249.39	249.31	249.36	64905.0
2017-09-26 08:50:00	SPY	ETF	249.38	249.39	249.37	249.37	54338.0
2017-09-26 08:55:00	SPY	ETF	249.36	249.38	249.36	249.37	7056.0
2017-09-26 09:00:00	SPY	ETF	249.36	249.46	249.34	249.43	31898.0
2017-09-26 09:05:00	SPY	ETF	249.41	249.46	249.41	249.46	2109.0
2017-09-26 09:10:00	SPY	ETF	249.44	249.44	249.42	249.42	36153.0
2017-09-26 09:15:00	SPY	ETF	249.43	249.44	249.42	249.44	42765.0
2017-09-26 09:20:00	SPY	ETF	249.42	249.44	249.41	249.42	12510.0
2017-09-26 09:25:00	SPY	ETF	249.42	249.45	249.41	249.42	30359.0
2017-09-26 09:30:00	SPY	ETF	249.42	249.51	249.31	249.47	1048347.0
2017-09-26 09:35:00	SPY	ETF	249.48	249.64	249.48	249.55	440957.0

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

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