PREVIEW / etf_5min / 2016-05-26

all etf 5-min files

  file:    by_date/etf_5min/2016/2016-05-26.parquet
  size:    1.1 MB
  rows:    46,477

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-05-26 04:00:00	SPY	ETF	209.44	209.44	209.44	209.44	102.0
2016-05-26 04:05:00	SPY	ETF	209.39	209.39	209.37	209.37	32107.0
2016-05-26 04:10:00	SPY	ETF	209.44	209.44	209.44	209.44	253.0
2016-05-26 04:15:00	SPY	ETF	209.42	209.42	209.39	209.41	3206.0
2016-05-26 04:20:00	SPY	ETF	209.39	209.39	209.27	209.29	608.0
2016-05-26 04:25:00	SPY	ETF	209.27	209.29	209.26	209.26	2602.0
2016-05-26 04:30:00	SPY	ETF	209.19	209.29	209.19	209.29	216.0
2016-05-26 04:35:00	SPY	ETF	209.26	209.29	209.26	209.29	301.0
2016-05-26 04:40:00	SPY	ETF	209.31	209.31	209.23	209.23	300.0
2016-05-26 04:45:00	SPY	ETF	209.3	209.34	209.3	209.34	305.0
2016-05-26 04:50:00	SPY	ETF	209.21	209.21	209.21	209.21	101.0
2016-05-26 04:55:00	SPY	ETF	209.16	209.18	209.16	209.18	1101.0
2016-05-26 05:10:00	SPY	ETF	209.29	209.29	209.29	209.29	2003.0
2016-05-26 05:20:00	SPY	ETF	209.31	209.33	209.31	209.33	1155.0
2016-05-26 05:25:00	SPY	ETF	209.28	209.28	209.28	209.28	100.0
2016-05-26 05:30:00	SPY	ETF	209.32	209.34	209.32	209.34	302.0
2016-05-26 05:45:00	SPY	ETF	209.32	209.36	209.32	209.36	202.0
2016-05-26 05:50:00	SPY	ETF	209.37	209.37	209.34	209.34	1101.0
2016-05-26 06:00:00	SPY	ETF	209.39	209.42	209.39	209.39	1223.0
2016-05-26 06:05:00	SPY	ETF	209.41	209.41	209.37	209.37	203.0
2016-05-26 06:10:00	SPY	ETF	209.39	209.39	209.32	209.32	423.0
2016-05-26 06:15:00	SPY	ETF	209.36	209.36	209.36	209.36	1000.0
2016-05-26 06:20:00	SPY	ETF	209.41	209.41	209.39	209.39	562.0
2016-05-26 06:25:00	SPY	ETF	209.37	209.51	209.37	209.51	885.0
2016-05-26 06:30:00	SPY	ETF	209.49	209.5	209.49	209.5	200.0
2016-05-26 06:35:00	SPY	ETF	209.51	209.54	209.51	209.54	317.0
2016-05-26 06:40:00	SPY	ETF	209.51	209.62	209.51	209.61	5628.0
2016-05-26 06:45:00	SPY	ETF	209.57	209.57	209.54	209.54	1003.0
2016-05-26 06:50:00	SPY	ETF	209.54	209.56	209.54	209.56	203.0
2016-05-26 06:55:00	SPY	ETF	209.55	209.55	209.55	209.55	109.0
2016-05-26 07:00:00	SPY	ETF	209.5	209.52	209.47	209.47	4668.0
2016-05-26 07:05:00	SPY	ETF	209.44	209.45	209.44	209.45	512.0
2016-05-26 07:10:00	SPY	ETF	209.49	209.49	209.42	209.42	7494.0
2016-05-26 07:15:00	SPY	ETF	209.44	209.51	209.44	209.51	1551.0
2016-05-26 07:20:00	SPY	ETF	209.51	209.52	209.48	209.52	6134.0
2016-05-26 07:25:00	SPY	ETF	209.49	209.49	209.43	209.43	2573.0
2016-05-26 07:30:00	SPY	ETF	209.42	209.45	209.42	209.45	1102.0
2016-05-26 07:35:00	SPY	ETF	209.52	209.55	209.49	209.49	57404.0
2016-05-26 07:40:00	SPY	ETF	209.49	209.55	209.47	209.52	62481.0
2016-05-26 07:45:00	SPY	ETF	209.57	209.65	209.56	209.6	21301.0
2016-05-26 07:50:00	SPY	ETF	209.61	209.62	209.57	209.57	4554.0
2016-05-26 07:55:00	SPY	ETF	209.57	209.61	209.54	209.6	15461.0
2016-05-26 08:00:00	SPY	ETF	209.46	209.67	209.151	209.151	137442.0
2016-05-26 08:05:00	SPY	ETF	209.68	209.69	209.51	209.51	36600.0
2016-05-26 08:10:00	SPY	ETF	209.53	209.55	209.49	209.51	34138.0
2016-05-26 08:15:00	SPY	ETF	209.52	209.53	209.5	209.5	29524.0
2016-05-26 08:20:00	SPY	ETF	209.46	209.52	209.46	209.48	18362.0
2016-05-26 08:25:00	SPY	ETF	209.51	209.59	209.51	209.59	41482.0
2016-05-26 08:30:00	SPY	ETF	209.6	209.63	209.4	209.43	145134.0
2016-05-26 08:35:00	SPY	ETF	209.43	209.52	209.38	209.52	39342.0

> showing 50 of 46,477 rows — these rows as CSV

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