PREVIEW / etf_5min / 2017-12-21

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-12-21.parquet
  size:    1.3 MB
  rows:    57,926

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-12-21 04:00:00	SPY	ETF	267.07	267.07	267.07	267.07	205.0
2017-12-21 04:05:00	SPY	ETF	267.04	267.05	267.04	267.05	300.0
2017-12-21 04:10:00	SPY	ETF	267.08	267.08	267.08	267.08	100.0
2017-12-21 04:20:00	SPY	ETF	267.1	267.1	267.1	267.1	2750.0
2017-12-21 04:35:00	SPY	ETF	267.07	267.07	267.07	267.07	100.0
2017-12-21 04:45:00	SPY	ETF	267.09	267.1	267.09	267.1	2006.0
2017-12-21 05:10:00	SPY	ETF	267.14	267.14	267.14	267.14	500.0
2017-12-21 05:15:00	SPY	ETF	267.19	267.2	267.18	267.18	995.0
2017-12-21 05:20:00	SPY	ETF	267.2	267.2	267.2	267.2	100.0
2017-12-21 05:30:00	SPY	ETF	267.24	267.3	267.24	267.29	5100.0
2017-12-21 05:45:00	SPY	ETF	267.3	267.3	267.29	267.29	350.0
2017-12-21 05:55:00	SPY	ETF	267.3	267.3	267.3	267.3	100.0
2017-12-21 06:05:00	SPY	ETF	267.31	267.4	267.31	267.4	647.0
2017-12-21 06:10:00	SPY	ETF	267.37	267.41	267.37	267.41	750.0
2017-12-21 06:15:00	SPY	ETF	267.43	267.43	267.43	267.43	174.0
2017-12-21 06:25:00	SPY	ETF	267.42	267.45	267.42	267.45	3120.0
2017-12-21 06:30:00	SPY	ETF	267.44	267.44	267.44	267.44	475.0
2017-12-21 06:40:00	SPY	ETF	267.44	267.44	267.44	267.44	400.0
2017-12-21 06:45:00	SPY	ETF	267.47	267.5	267.47	267.5	500.0
2017-12-21 06:50:00	SPY	ETF	267.49	267.5	267.47	267.47	1154.0
2017-12-21 06:55:00	SPY	ETF	267.44	267.49	267.44	267.49	1102.0
2017-12-21 07:00:00	SPY	ETF	267.5	267.51	267.47	267.51	9531.0
2017-12-21 07:05:00	SPY	ETF	267.52	267.52	267.49	267.5	26816.0
2017-12-21 07:10:00	SPY	ETF	267.52	267.52	267.49	267.49	25003.0
2017-12-21 07:15:00	SPY	ETF	267.49	267.5	267.48	267.5	5401.0
2017-12-21 07:20:00	SPY	ETF	267.48	267.5	267.46	267.5	4514.0
2017-12-21 07:25:00	SPY	ETF	267.5	267.51	267.49	267.5	80379.0
2017-12-21 07:30:00	SPY	ETF	267.5	267.5	267.48	267.48	30375.0
2017-12-21 07:35:00	SPY	ETF	267.5	267.53	267.5	267.52	34735.0
2017-12-21 07:40:00	SPY	ETF	267.52	267.52	267.49	267.49	23014.0
2017-12-21 07:45:00	SPY	ETF	267.5	267.54	267.5	267.53	36353.0
2017-12-21 07:50:00	SPY	ETF	267.51	267.51	267.49	267.49	3901.0
2017-12-21 07:55:00	SPY	ETF	267.49	267.49	267.45	267.45	17935.0
2017-12-21 08:00:00	SPY	ETF	267.51	267.51	267.43	267.45	140200.0
2017-12-21 08:05:00	SPY	ETF	267.48	267.49	267.46	267.47	6718.0
2017-12-21 08:10:00	SPY	ETF	267.49	267.51	267.48	267.51	23951.0
2017-12-21 08:15:00	SPY	ETF	267.51	267.51	267.46	267.46	92435.0
2017-12-21 08:20:00	SPY	ETF	267.48	267.48	267.42	267.46	32291.0
2017-12-21 08:25:00	SPY	ETF	267.49	267.51	267.48	267.49	47186.0
2017-12-21 08:30:00	SPY	ETF	267.46	267.51	267.45	267.49	43791.0
2017-12-21 08:35:00	SPY	ETF	267.49	267.59	267.48	267.55	28824.0
2017-12-21 08:40:00	SPY	ETF	267.56	267.56	267.56	267.56	5942.0
2017-12-21 08:45:00	SPY	ETF	267.57	267.62	267.57	267.6	56225.0
2017-12-21 08:50:00	SPY	ETF	267.61	267.75	267.61	267.7	283073.0
2017-12-21 08:55:00	SPY	ETF	267.7	267.72	267.67	267.69	46725.0
2017-12-21 09:00:00	SPY	ETF	267.69	267.76	267.69	267.7	24342.0
2017-12-21 09:05:00	SPY	ETF	267.68	267.74	267.68	267.74	34739.0
2017-12-21 09:10:00	SPY	ETF	267.73	267.76	267.72	267.76	42149.0
2017-12-21 09:15:00	SPY	ETF	267.74	267.78	267.71	267.76	19602.0
2017-12-21 09:20:00	SPY	ETF	267.74	267.74	267.68	267.7	27989.0

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

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