PREVIEW / etf_5min / 2017-11-27

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-11-27.parquet
  size:    1.2 MB
  rows:    54,289

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-11-27 04:00:00	SPY	ETF	260.35	260.4	260.35	260.4	6552.0
2017-11-27 04:10:00	SPY	ETF	260.53	260.6	260.51	260.6	2100.0
2017-11-27 04:15:00	SPY	ETF	260.62	260.62	260.62	260.62	600.0
2017-11-27 04:20:00	SPY	ETF	260.5	260.5	260.5	260.5	100.0
2017-11-27 04:25:00	SPY	ETF	260.55	260.55	260.55	260.55	100.0
2017-11-27 04:30:00	SPY	ETF	260.52	260.52	260.52	260.52	300.0
2017-11-27 04:40:00	SPY	ETF	260.45	260.45	260.45	260.45	300.0
2017-11-27 04:45:00	SPY	ETF	260.52	260.52	260.47	260.47	10200.0
2017-11-27 04:50:00	SPY	ETF	260.45	260.47	260.44	260.44	14700.0
2017-11-27 04:55:00	SPY	ETF	260.47	260.47	260.4	260.4	2900.0
2017-11-27 05:00:00	SPY	ETF	260.5	260.5	260.5	260.5	300.0
2017-11-27 05:20:00	SPY	ETF	260.5	260.5	260.5	260.5	100.0
2017-11-27 05:30:00	SPY	ETF	260.5	260.5	260.48	260.48	5003.0
2017-11-27 05:45:00	SPY	ETF	260.51	260.51	260.51	260.51	300.0
2017-11-27 05:50:00	SPY	ETF	260.49	260.51	260.49	260.51	700.0
2017-11-27 05:55:00	SPY	ETF	260.54	260.56	260.53	260.54	7268.0
2017-11-27 06:00:00	SPY	ETF	260.59	260.64	260.58	260.6	4831.0
2017-11-27 06:05:00	SPY	ETF	260.62	260.64	260.62	260.64	1400.0
2017-11-27 06:10:00	SPY	ETF	260.66	260.66	260.63	260.63	1702.0
2017-11-27 06:20:00	SPY	ETF	260.62	260.62	260.62	260.62	1200.0
2017-11-27 06:30:00	SPY	ETF	260.61	260.61	260.59	260.59	800.0
2017-11-27 06:35:00	SPY	ETF	260.58	260.59	260.58	260.59	700.0
2017-11-27 06:40:00	SPY	ETF	260.55	260.57	260.54	260.54	1103.0
2017-11-27 06:50:00	SPY	ETF	260.54	260.54	260.54	260.54	600.0
2017-11-27 06:55:00	SPY	ETF	260.56	260.56	260.56	260.56	301.0
2017-11-27 07:00:00	SPY	ETF	260.53	260.53	260.44	260.46	103357.0
2017-11-27 07:05:00	SPY	ETF	260.44	260.44	260.36	260.36	8167.0
2017-11-27 07:10:00	SPY	ETF	260.34	260.36	260.31	260.31	2412.0
2017-11-27 07:15:00	SPY	ETF	260.31	260.32	260.31	260.32	501.0
2017-11-27 07:20:00	SPY	ETF	260.31	260.31	260.25	260.25	5048.0
2017-11-27 07:25:00	SPY	ETF	260.25	260.29	260.24	260.26	4602.0
2017-11-27 07:30:00	SPY	ETF	260.2	260.23	260.2	260.21	2554.0
2017-11-27 07:35:00	SPY	ETF	260.21	260.26	260.21	260.25	10138.0
2017-11-27 07:40:00	SPY	ETF	260.25	260.26	260.23	260.23	8236.0
2017-11-27 07:45:00	SPY	ETF	260.25	260.26	260.22	260.26	2136.0
2017-11-27 07:50:00	SPY	ETF	260.25	260.3	260.25	260.3	102662.0
2017-11-27 07:55:00	SPY	ETF	260.28	260.29	260.27	260.29	14400.0
2017-11-27 08:00:00	SPY	ETF	260.52	260.52	260.18	260.2	22608.0
2017-11-27 08:05:00	SPY	ETF	260.19	260.22	260.18	260.21	7953.0
2017-11-27 08:10:00	SPY	ETF	260.21	260.28	260.21	260.26	16005.0
2017-11-27 08:15:00	SPY	ETF	260.25	260.32	260.24	260.3	11762.0
2017-11-27 08:20:00	SPY	ETF	260.31	260.34	260.3	260.32	13804.0
2017-11-27 08:25:00	SPY	ETF	260.33	260.33	260.31	260.33	2675.0
2017-11-27 08:30:00	SPY	ETF	260.33	260.36	260.33	260.36	8873.0
2017-11-27 08:35:00	SPY	ETF	260.35	260.42	260.35	260.4	62873.0
2017-11-27 08:40:00	SPY	ETF	260.37	260.37	260.34	260.36	107176.0
2017-11-27 08:45:00	SPY	ETF	260.38	260.4	260.37	260.37	13993.0
2017-11-27 08:50:00	SPY	ETF	260.37	260.38	260.35	260.37	12902.0
2017-11-27 08:55:00	SPY	ETF	260.36	260.36	260.27	260.28	85685.0
2017-11-27 09:00:00	SPY	ETF	260.3	260.31	260.24	260.29	64438.0

> showing 50 of 54,289 rows — these rows as CSV

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