PREVIEW / etf_5min / 2017-01-17

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-01-17.parquet
  size:    1.3 MB
  rows:    57,095

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-17 04:00:00	SPY	ETF	226.64	226.64	226.45	226.53	4693.0
2017-01-17 04:05:00	SPY	ETF	226.47	226.47	226.43	226.47	1200.0
2017-01-17 04:10:00	SPY	ETF	226.45	226.45	226.43	226.43	600.0
2017-01-17 04:20:00	SPY	ETF	226.3	226.3	226.3	226.3	101.0
2017-01-17 04:30:00	SPY	ETF	226.47	226.47	226.47	226.47	224.0
2017-01-17 04:55:00	SPY	ETF	226.4	226.4	226.4	226.4	160.0
2017-01-17 05:15:00	SPY	ETF	226.35	226.37	226.33	226.37	300.0
2017-01-17 05:20:00	SPY	ETF	226.31	226.31	226.19	226.21	2310.0
2017-01-17 05:25:00	SPY	ETF	226.31	226.31	226.31	226.31	200.0
2017-01-17 05:30:00	SPY	ETF	226.25	226.25	226.23	226.23	502.0
2017-01-17 05:40:00	SPY	ETF	226.28	226.28	226.28	226.28	726.0
2017-01-17 05:45:00	SPY	ETF	226.18	226.18	226.18	226.18	401.0
2017-01-17 05:50:00	SPY	ETF	226.13	226.13	226.1	226.1	4600.0
2017-01-17 05:55:00	SPY	ETF	226.1	226.1	226.0	226.01	9077.0
2017-01-17 06:00:00	SPY	ETF	226.08	226.1	226.05	226.05	9599.0
2017-01-17 06:05:00	SPY	ETF	226.1	226.1	226.08	226.08	3495.0
2017-01-17 06:10:00	SPY	ETF	226.08	226.08	225.98	225.98	2622.0
2017-01-17 06:15:00	SPY	ETF	226.01	226.01	225.99	225.99	321.0
2017-01-17 06:25:00	SPY	ETF	226.09	226.09	226.09	226.09	105.0
2017-01-17 06:30:00	SPY	ETF	226.1	226.11	226.04	226.04	3207.0
2017-01-17 06:35:00	SPY	ETF	226.06	226.06	226.03	226.03	2402.0
2017-01-17 06:40:00	SPY	ETF	226.03	226.03	225.82	225.9	12039.0
2017-01-17 06:45:00	SPY	ETF	226.1	226.1	226.05	226.05	2024.0
2017-01-17 06:50:00	SPY	ETF	226.1	226.25	226.1	226.24	11904.0
2017-01-17 06:55:00	SPY	ETF	226.23	226.25	226.16	226.16	5112.0
2017-01-17 07:00:00	SPY	ETF	226.18	226.41	226.17	226.41	5786.0
2017-01-17 07:05:00	SPY	ETF	226.38	226.4	226.36	226.36	7105.0
2017-01-17 07:10:00	SPY	ETF	226.4	226.4	226.38	226.38	923.0
2017-01-17 07:15:00	SPY	ETF	226.32	226.44	226.29	226.44	3126.0
2017-01-17 07:20:00	SPY	ETF	226.48	226.54	226.48	226.5	13822.0
2017-01-17 07:25:00	SPY	ETF	226.55	226.55	226.47	226.52	5360.0
2017-01-17 07:30:00	SPY	ETF	226.46	226.46	226.4	226.43	6308.0
2017-01-17 07:35:00	SPY	ETF	226.45	226.5	226.42	226.5	15201.0
2017-01-17 07:40:00	SPY	ETF	226.5	226.64	226.5	226.6	17646.0
2017-01-17 07:45:00	SPY	ETF	226.61	226.68	226.6	226.65	52714.0
2017-01-17 07:50:00	SPY	ETF	226.67	226.69	226.65	226.66	15904.0
2017-01-17 07:55:00	SPY	ETF	226.65	226.66	226.65	226.65	2548.0
2017-01-17 08:00:00	SPY	ETF	226.66	226.68	226.19	226.5	121147.0
2017-01-17 08:05:00	SPY	ETF	226.5	226.52	226.47	226.5	29796.0
2017-01-17 08:10:00	SPY	ETF	226.51	226.52	226.45	226.45	25083.0
2017-01-17 08:15:00	SPY	ETF	226.45	226.47	226.42	226.47	33690.0
2017-01-17 08:20:00	SPY	ETF	226.45	226.46	226.34	226.34	73497.0
2017-01-17 08:25:00	SPY	ETF	226.34	226.54	226.34	226.5	24173.0
2017-01-17 08:30:00	SPY	ETF	226.46	226.5	226.38	226.46	27379.0
2017-01-17 08:35:00	SPY	ETF	226.46	226.47	226.42	226.47	4025.0
2017-01-17 08:40:00	SPY	ETF	226.49	226.55	226.48	226.52	22481.0
2017-01-17 08:45:00	SPY	ETF	226.5	226.5	226.41	226.5	14811.0
2017-01-17 08:50:00	SPY	ETF	226.52	226.63	226.52	226.57	51693.0
2017-01-17 08:55:00	SPY	ETF	226.55	226.57	226.5	226.52	12917.0
2017-01-17 09:00:00	SPY	ETF	226.51	226.52	226.36	226.38	37375.0

> showing 50 of 57,095 rows — these rows as CSV

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