PREVIEW / etf_5min / 2018-07-18

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-07-18.parquet
  size:    1.3 MB
  rows:    55,355

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
2018-07-18 04:00:00	SPY	ETF	280.89	280.89	280.89	280.89	210.0
2018-07-18 04:10:00	SPY	ETF	280.5	280.5	280.4	280.4	799.0
2018-07-18 04:15:00	SPY	ETF	280.48	280.48	280.38	280.38	690.0
2018-07-18 04:20:00	SPY	ETF	280.42	280.48	280.42	280.45	800.0
2018-07-18 04:25:00	SPY	ETF	280.47	280.49	280.45	280.49	633.0
2018-07-18 04:30:00	SPY	ETF	280.52	280.52	280.47	280.5	3000.0
2018-07-18 04:35:00	SPY	ETF	280.55	280.55	280.42	280.42	1400.0
2018-07-18 04:40:00	SPY	ETF	280.47	280.47	280.42	280.47	2200.0
2018-07-18 04:45:00	SPY	ETF	280.45	280.52	280.45	280.45	4000.0
2018-07-18 04:50:00	SPY	ETF	280.5	280.5	280.47	280.5	2100.0
2018-07-18 04:55:00	SPY	ETF	280.52	280.54	280.47	280.52	7400.0
2018-07-18 05:00:00	SPY	ETF	280.56	280.61	280.56	280.61	1600.0
2018-07-18 05:05:00	SPY	ETF	280.59	280.64	280.59	280.64	800.0
2018-07-18 05:10:00	SPY	ETF	280.64	280.64	280.61	280.61	2110.0
2018-07-18 05:15:00	SPY	ETF	280.64	280.69	280.63	280.69	2345.0
2018-07-18 05:25:00	SPY	ETF	280.69	280.69	280.69	280.69	200.0
2018-07-18 06:00:00	SPY	ETF	280.64	280.64	280.64	280.64	400.0
2018-07-18 06:05:00	SPY	ETF	280.65	280.68	280.61	280.65	3600.0
2018-07-18 06:10:00	SPY	ETF	280.61	280.61	280.61	280.61	400.0
2018-07-18 06:15:00	SPY	ETF	280.6	280.6	280.6	280.6	1000.0
2018-07-18 06:20:00	SPY	ETF	280.56	280.56	280.53	280.53	2902.0
2018-07-18 06:25:00	SPY	ETF	280.55	280.55	280.55	280.55	300.0
2018-07-18 06:30:00	SPY	ETF	280.55	280.55	280.55	280.55	300.0
2018-07-18 06:35:00	SPY	ETF	280.51	280.57	280.51	280.57	600.0
2018-07-18 06:40:00	SPY	ETF	280.51	280.51	280.49	280.49	1400.0
2018-07-18 06:45:00	SPY	ETF	280.49	280.49	280.47	280.47	800.0
2018-07-18 06:50:00	SPY	ETF	280.47	280.5	280.45	280.45	1194.0
2018-07-18 06:55:00	SPY	ETF	280.53	280.55	280.53	280.55	900.0
2018-07-18 07:00:00	SPY	ETF	280.51	280.54	280.49	280.54	8336.0
2018-07-18 07:05:00	SPY	ETF	280.54	280.54	280.49	280.49	3738.0
2018-07-18 07:10:00	SPY	ETF	280.5	280.57	280.49	280.57	10050.0
2018-07-18 07:15:00	SPY	ETF	280.52	280.52	280.51	280.51	6358.0
2018-07-18 07:20:00	SPY	ETF	280.52	280.53	280.47	280.47	28672.0
2018-07-18 07:25:00	SPY	ETF	280.44	280.48	280.42	280.42	5092.0
2018-07-18 07:30:00	SPY	ETF	280.39	280.41	280.37	280.41	15410.0
2018-07-18 07:35:00	SPY	ETF	280.46	280.52	280.46	280.52	7600.0
2018-07-18 07:40:00	SPY	ETF	280.49	280.49	280.47	280.47	1500.0
2018-07-18 07:45:00	SPY	ETF	280.46	280.5	280.44	280.5	1076.0
2018-07-18 07:50:00	SPY	ETF	280.45	280.45	280.39	280.41	8900.0
2018-07-18 07:55:00	SPY	ETF	280.45	280.47	280.4	280.4	26360.0
2018-07-18 08:00:00	SPY	ETF	280.4101	280.76	280.29	280.3	12857.0
2018-07-18 08:05:00	SPY	ETF	280.26	280.28	280.16	280.19	41004.0
2018-07-18 08:10:00	SPY	ETF	280.23	280.26	280.21	280.26	7675.0
2018-07-18 08:15:00	SPY	ETF	280.29	280.29	280.16	280.19	20844.0
2018-07-18 08:20:00	SPY	ETF	280.24	280.25	280.19	280.25	4006.0
2018-07-18 08:25:00	SPY	ETF	280.23	280.25	280.18	280.1901	11231.0
2018-07-18 08:30:00	SPY	ETF	280.2	280.26	280.16	280.24	10218.0
2018-07-18 08:35:00	SPY	ETF	280.24	280.24	280.19	280.22	167616.0
2018-07-18 08:40:00	SPY	ETF	280.23	280.29	280.23	280.27	42078.0
2018-07-18 08:45:00	SPY	ETF	280.27	280.32	280.26	280.31	27636.0

> showing 50 of 55,355 rows — these rows as CSV

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