PREVIEW / etf_5min / 2016-07-22

all etf 5-min files

  file:    by_date/etf_5min/2016/2016-07-22.parquet
  size:    1.1 MB
  rows:    46,814

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-07-22 04:00:00	SPY	ETF	216.39	216.39	216.38	216.38	400.0
2016-07-22 04:05:00	SPY	ETF	216.42	216.46	216.42	216.46	1983.0
2016-07-22 04:15:00	SPY	ETF	216.5	216.5	216.5	216.5	452.0
2016-07-22 04:20:00	SPY	ETF	216.45	216.45	216.26	216.26	305.0
2016-07-22 04:30:00	SPY	ETF	216.33	216.33	216.33	216.33	102.0
2016-07-22 04:35:00	SPY	ETF	216.45	216.45	216.45	216.45	107.0
2016-07-22 04:40:00	SPY	ETF	216.5	216.65	216.5	216.65	507.0
2016-07-22 04:45:00	SPY	ETF	216.65	216.65	216.65	216.65	603.0
2016-07-22 04:50:00	SPY	ETF	216.62	216.63	216.62	216.63	1330.0
2016-07-22 04:55:00	SPY	ETF	216.63	216.63	216.63	216.63	302.0
2016-07-22 05:10:00	SPY	ETF	216.68	216.73	216.68	216.73	206.0
2016-07-22 05:15:00	SPY	ETF	216.68	216.68	216.68	216.68	807.0
2016-07-22 05:20:00	SPY	ETF	216.67	216.71	216.67	216.71	2004.0
2016-07-22 05:25:00	SPY	ETF	216.7	216.78	216.7	216.78	2530.0
2016-07-22 05:30:00	SPY	ETF	216.75	216.75	216.73	216.73	3320.0
2016-07-22 05:35:00	SPY	ETF	216.71	216.74	216.71	216.74	309.0
2016-07-22 05:45:00	SPY	ETF	216.64	216.69	216.64	216.69	1502.0
2016-07-22 05:50:00	SPY	ETF	216.55	216.61	216.51	216.51	19514.0
2016-07-22 05:55:00	SPY	ETF	216.54	216.54	216.45	216.45	1803.0
2016-07-22 06:00:00	SPY	ETF	216.42	216.42	216.42	216.42	118.0
2016-07-22 06:05:00	SPY	ETF	216.49	216.54	216.49	216.53	3648.0
2016-07-22 06:15:00	SPY	ETF	216.57	216.57	216.57	216.57	1000.0
2016-07-22 06:20:00	SPY	ETF	216.6	216.6	216.59	216.59	904.0
2016-07-22 06:25:00	SPY	ETF	216.58	216.58	216.58	216.58	301.0
2016-07-22 06:40:00	SPY	ETF	216.64	216.64	216.58	216.58	2501.0
2016-07-22 06:45:00	SPY	ETF	216.65	216.65	216.64	216.64	393.0
2016-07-22 07:00:00	SPY	ETF	216.6	216.6	216.58	216.6	1699.0
2016-07-22 07:05:00	SPY	ETF	216.64	216.64	216.62	216.62	203.0
2016-07-22 07:10:00	SPY	ETF	216.62	216.62	216.55	216.55	3304.0
2016-07-22 07:15:00	SPY	ETF	216.62	216.66	216.62	216.65	5202.0
2016-07-22 07:20:00	SPY	ETF	216.63	216.66	216.63	216.66	2214.0
2016-07-22 07:25:00	SPY	ETF	216.62	216.62	216.55	216.55	22482.0
2016-07-22 07:30:00	SPY	ETF	216.57	216.57	216.57	216.57	100.0
2016-07-22 07:35:00	SPY	ETF	216.57	216.59	216.57	216.59	4002.0
2016-07-22 07:40:00	SPY	ETF	216.58	216.58	216.55	216.55	25000.0
2016-07-22 07:45:00	SPY	ETF	216.56	216.56	216.53	216.53	13179.0
2016-07-22 07:50:00	SPY	ETF	216.54	216.55	216.53	216.54	6012.0
2016-07-22 07:55:00	SPY	ETF	216.53	216.54	216.37	216.44	42017.0
2016-07-22 08:00:00	SPY	ETF	216.46	216.62	216.31	216.41	87915.0
2016-07-22 08:05:00	SPY	ETF	216.43	216.52	216.42	216.5	42523.0
2016-07-22 08:10:00	SPY	ETF	216.49	216.52	216.49	216.52	8392.0
2016-07-22 08:15:00	SPY	ETF	216.49	216.52	216.48	216.52	7403.0
2016-07-22 08:20:00	SPY	ETF	216.54	216.55	216.5	216.52	19553.0
2016-07-22 08:25:00	SPY	ETF	216.52	216.52	216.51	216.51	1200.0
2016-07-22 08:30:00	SPY	ETF	216.53	216.56	216.5	216.5	12535.0
2016-07-22 08:35:00	SPY	ETF	216.51	216.54	216.49	216.54	13564.0
2016-07-22 08:40:00	SPY	ETF	216.54	216.54	216.46	216.46	24968.0
2016-07-22 08:45:00	SPY	ETF	216.47	216.5	216.46	216.5	8570.0
2016-07-22 08:50:00	SPY	ETF	216.5	216.5	216.47	216.48	4605.0
2016-07-22 08:55:00	SPY	ETF	216.48	216.5	216.47	216.5	58945.0

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

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