PREVIEW / etf_5min / 2016-10-06

all etf 5-min files

  file:    by_date/etf_5min/2016/2016-10-06.parquet
  size:    1.1 MB
  rows:    49,005

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
2016-10-06 04:05:00	SPY	ETF	215.74	215.74	215.61	215.61	9310.0
2016-10-06 04:15:00	SPY	ETF	215.58	215.58	215.58	215.58	500.0
2016-10-06 04:20:00	SPY	ETF	215.73	215.73	215.73	215.73	400.0
2016-10-06 04:30:00	SPY	ETF	215.73	215.73	215.73	215.73	500.0
2016-10-06 04:35:00	SPY	ETF	215.74	215.74	215.74	215.74	500.0
2016-10-06 04:45:00	SPY	ETF	215.68	215.68	215.68	215.68	100.0
2016-10-06 04:50:00	SPY	ETF	215.75	215.78	215.75	215.78	1300.0
2016-10-06 05:05:00	SPY	ETF	215.73	215.73	215.73	215.73	200.0
2016-10-06 05:10:00	SPY	ETF	215.78	215.78	215.78	215.78	900.0
2016-10-06 05:15:00	SPY	ETF	215.75	215.75	215.75	215.75	3700.0
2016-10-06 05:20:00	SPY	ETF	215.68	215.68	215.6	215.6	200.0
2016-10-06 05:25:00	SPY	ETF	215.6	215.6	215.58	215.58	300.0
2016-10-06 05:30:00	SPY	ETF	215.5	215.54	215.5	215.54	603.0
2016-10-06 05:35:00	SPY	ETF	215.41	215.41	215.38	215.38	1357.0
2016-10-06 05:40:00	SPY	ETF	215.39	215.39	215.39	215.39	448.0
2016-10-06 05:45:00	SPY	ETF	215.32	215.34	215.26	215.3	1553.0
2016-10-06 05:50:00	SPY	ETF	215.34	215.34	215.34	215.34	203.0
2016-10-06 05:55:00	SPY	ETF	215.35	215.35	215.23	215.23	1329.0
2016-10-06 06:00:00	SPY	ETF	215.16	215.19	215.16	215.19	4401.0
2016-10-06 06:05:00	SPY	ETF	215.19	215.26	215.19	215.19	2618.0
2016-10-06 06:10:00	SPY	ETF	215.24	215.24	215.21	215.23	4364.0
2016-10-06 06:15:00	SPY	ETF	215.21	215.21	215.1	215.1	605.0
2016-10-06 06:20:00	SPY	ETF	215.13	215.13	215.13	215.13	2500.0
2016-10-06 06:35:00	SPY	ETF	215.26	215.26	215.21	215.22	592.0
2016-10-06 06:45:00	SPY	ETF	215.28	215.28	215.26	215.26	2959.0
2016-10-06 06:50:00	SPY	ETF	215.26	215.27	215.23	215.27	4040.0
2016-10-06 06:55:00	SPY	ETF	215.29	215.29	215.27	215.27	400.0
2016-10-06 07:00:00	SPY	ETF	215.27	215.27	215.23	215.26	6103.0
2016-10-06 07:05:00	SPY	ETF	215.24	215.24	215.21	215.21	39922.0
2016-10-06 07:10:00	SPY	ETF	215.22	215.25	215.21	215.25	4547.0
2016-10-06 07:15:00	SPY	ETF	215.23	215.25	215.22	215.25	8185.0
2016-10-06 07:20:00	SPY	ETF	215.29	215.3	215.26	215.3	9813.0
2016-10-06 07:25:00	SPY	ETF	215.34	215.36	215.32	215.34	47740.0
2016-10-06 07:30:00	SPY	ETF	215.32	215.47	215.32	215.46	71810.0
2016-10-06 07:35:00	SPY	ETF	215.47	215.5	215.47	215.48	27438.0
2016-10-06 07:40:00	SPY	ETF	215.45	215.45	215.37	215.37	12036.0
2016-10-06 07:45:00	SPY	ETF	215.35	215.35	215.31	215.31	5413.0
2016-10-06 07:50:00	SPY	ETF	215.31	215.36	215.31	215.35	53939.0
2016-10-06 07:55:00	SPY	ETF	215.33	215.41	215.33	215.41	13877.0
2016-10-06 08:00:00	SPY	ETF	215.24	215.4	215.22	215.27	26238.0
2016-10-06 08:05:00	SPY	ETF	215.28	215.34	215.28	215.29	12441.0
2016-10-06 08:10:00	SPY	ETF	215.28	215.28	215.23	215.23	6552.0
2016-10-06 08:15:00	SPY	ETF	215.23	215.27	215.22	215.23	93587.0
2016-10-06 08:20:00	SPY	ETF	215.23	215.23	215.15	215.2	45033.0
2016-10-06 08:25:00	SPY	ETF	215.22	215.3	215.22	215.25	235330.0
2016-10-06 08:30:00	SPY	ETF	215.25	215.35	215.25	215.3	20977.0
2016-10-06 08:35:00	SPY	ETF	215.32	215.35	215.29	215.3	20193.0
2016-10-06 08:40:00	SPY	ETF	215.29	215.38	215.27	215.38	15955.0
2016-10-06 08:45:00	SPY	ETF	215.36	215.44	215.34	215.44	35696.0
2016-10-06 08:50:00	SPY	ETF	215.44	215.47	215.38	215.4	40136.0

> showing 50 of 49,005 rows — these rows as CSV

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