PREVIEW / etf_5min / 2016-12-29

all etf 5-min files

  file:    by_date/etf_5min/2016/2016-12-29.parquet
  size:    1.3 MB
  rows:    54,556

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-12-29 04:00:00	SPY	ETF	224.3	224.45	224.3	224.45	500.0
2016-12-29 04:20:00	SPY	ETF	224.49	224.49	224.49	224.49	300.0
2016-12-29 04:40:00	SPY	ETF	224.44	224.44	224.44	224.44	100.0
2016-12-29 04:45:00	SPY	ETF	224.41	224.41	224.41	224.41	652.0
2016-12-29 04:50:00	SPY	ETF	224.43	224.43	224.43	224.43	200.0
2016-12-29 04:55:00	SPY	ETF	224.42	224.42	224.41	224.41	4000.0
2016-12-29 05:05:00	SPY	ETF	224.42	224.42	224.4	224.4	500.0
2016-12-29 05:10:00	SPY	ETF	224.4	224.4	224.4	224.4	175.0
2016-12-29 05:20:00	SPY	ETF	224.44	224.44	224.44	224.44	400.0
2016-12-29 05:30:00	SPY	ETF	224.51	224.54	224.51	224.54	5004.0
2016-12-29 05:40:00	SPY	ETF	224.51	224.51	224.51	224.51	400.0
2016-12-29 05:45:00	SPY	ETF	224.56	224.6	224.56	224.6	202.0
2016-12-29 05:55:00	SPY	ETF	224.54	224.54	224.54	224.54	301.0
2016-12-29 06:30:00	SPY	ETF	224.52	224.52	224.52	224.52	201.0
2016-12-29 06:35:00	SPY	ETF	224.49	224.49	224.47	224.47	605.0
2016-12-29 06:50:00	SPY	ETF	224.5	224.5	224.5	224.5	200.0
2016-12-29 06:55:00	SPY	ETF	224.5	224.5	224.5	224.5	100.0
2016-12-29 07:05:00	SPY	ETF	224.48	224.55	224.48	224.53	6104.0
2016-12-29 07:10:00	SPY	ETF	224.54	224.56	224.54	224.55	5330.0
2016-12-29 07:20:00	SPY	ETF	224.57	224.57	224.57	224.57	3201.0
2016-12-29 07:25:00	SPY	ETF	224.55	224.55	224.55	224.55	3000.0
2016-12-29 07:30:00	SPY	ETF	224.56	224.61	224.56	224.61	26293.0
2016-12-29 07:35:00	SPY	ETF	224.61	224.63	224.61	224.63	9304.0
2016-12-29 07:40:00	SPY	ETF	224.61	224.61	224.6	224.6	20101.0
2016-12-29 07:45:00	SPY	ETF	224.59	224.6	224.59	224.6	12899.0
2016-12-29 07:50:00	SPY	ETF	224.6	224.62	224.6	224.62	17025.0
2016-12-29 07:55:00	SPY	ETF	224.62	224.63	224.6	224.63	9502.0
2016-12-29 08:00:00	SPY	ETF	224.55	224.66	224.55	224.62	26940.0
2016-12-29 08:05:00	SPY	ETF	224.63	224.68	224.63	224.68	4083.0
2016-12-29 08:10:00	SPY	ETF	224.68	224.69	224.65	224.68	19100.0
2016-12-29 08:15:00	SPY	ETF	224.68	224.69	224.63	224.67	6936.0
2016-12-29 08:20:00	SPY	ETF	224.67	224.67	224.51	224.51	33726.0
2016-12-29 08:25:00	SPY	ETF	224.55	224.63	224.55	224.59	4717.0
2016-12-29 08:30:00	SPY	ETF	224.63	224.63	224.57	224.57	15203.0
2016-12-29 08:35:00	SPY	ETF	224.57	224.57	224.46	224.5	26233.0
2016-12-29 08:40:00	SPY	ETF	224.5	224.59	224.49	224.59	18800.0
2016-12-29 08:45:00	SPY	ETF	224.59	224.6	224.57	224.6	38856.0
2016-12-29 08:50:00	SPY	ETF	224.56	224.57	224.52	224.52	4614.0
2016-12-29 08:55:00	SPY	ETF	224.52	224.57	224.52	224.52	3941.0
2016-12-29 09:00:00	SPY	ETF	224.53	224.53	224.47	224.5	4407.0
2016-12-29 09:05:00	SPY	ETF	224.49	224.54	224.49	224.54	3110.0
2016-12-29 09:10:00	SPY	ETF	224.56	224.59	224.54	224.59	10645.0
2016-12-29 09:15:00	SPY	ETF	224.59	224.6	224.54	224.56	4044.0
2016-12-29 09:20:00	SPY	ETF	224.55	224.6	224.54	224.55	21729.0
2016-12-29 09:25:00	SPY	ETF	224.54	224.55	224.4	224.45	116031.0
2016-12-29 09:30:00	SPY	ETF	224.48	224.8	224.47	224.7842	1725176.0
2016-12-29 09:35:00	SPY	ETF	224.78	224.85	224.73	224.82	857877.0
2016-12-29 09:40:00	SPY	ETF	224.82	224.89	224.66	224.66	631385.0
2016-12-29 09:45:00	SPY	ETF	224.66	224.71	224.41	224.41	643288.0
2016-12-29 09:50:00	SPY	ETF	224.4	224.54	224.39	224.52	359954.0

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

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