PREVIEW / etf_5min / 2016-12-28

all etf 5-min files

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

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-28 04:00:00	SPY	ETF	226.27	226.27	226.27	226.27	375.0
2016-12-28 04:35:00	SPY	ETF	226.37	226.38	226.37	226.38	800.0
2016-12-28 04:50:00	SPY	ETF	226.38	226.38	226.38	226.38	2498.0
2016-12-28 05:10:00	SPY	ETF	226.39	226.4	226.39	226.4	1400.0
2016-12-28 05:20:00	SPY	ETF	226.43	226.44	226.43	226.44	1402.0
2016-12-28 05:30:00	SPY	ETF	226.42	226.42	226.42	226.42	700.0
2016-12-28 05:50:00	SPY	ETF	226.42	226.42	226.41	226.41	1500.0
2016-12-28 05:55:00	SPY	ETF	226.44	226.44	226.44	226.44	3000.0
2016-12-28 06:00:00	SPY	ETF	226.43	226.45	226.41	226.41	3002.0
2016-12-28 06:15:00	SPY	ETF	226.38	226.38	226.38	226.38	100.0
2016-12-28 06:20:00	SPY	ETF	226.38	226.38	226.38	226.38	100.0
2016-12-28 06:40:00	SPY	ETF	226.38	226.38	226.38	226.38	700.0
2016-12-28 06:45:00	SPY	ETF	226.38	226.38	226.38	226.38	300.0
2016-12-28 06:55:00	SPY	ETF	226.41	226.41	226.41	226.41	100.0
2016-12-28 07:00:00	SPY	ETF	226.44	226.44	226.43	226.43	11656.0
2016-12-28 07:05:00	SPY	ETF	226.43	226.45	226.42	226.45	23000.0
2016-12-28 07:25:00	SPY	ETF	226.37	226.4	226.37	226.4	4292.0
2016-12-28 07:30:00	SPY	ETF	226.39	226.41	226.39	226.41	3200.0
2016-12-28 07:35:00	SPY	ETF	226.39	226.45	226.38	226.44	8933.0
2016-12-28 07:40:00	SPY	ETF	226.44	226.45	226.38	226.41	112104.0
2016-12-28 07:45:00	SPY	ETF	226.43	226.43	226.42	226.43	2601.0
2016-12-28 07:55:00	SPY	ETF	226.44	226.45	226.44	226.45	10662.0
2016-12-28 08:00:00	SPY	ETF	226.45	226.53	226.43	226.53	71552.0
2016-12-28 08:05:00	SPY	ETF	226.54	226.55	226.53	226.53	78420.0
2016-12-28 08:10:00	SPY	ETF	226.53	226.53	226.51	226.53	24950.0
2016-12-28 08:15:00	SPY	ETF	226.53	226.53	226.51	226.51	12842.0
2016-12-28 08:20:00	SPY	ETF	226.53	226.57	226.53	226.55	17037.0
2016-12-28 08:25:00	SPY	ETF	226.53	226.54	226.5	226.5	24404.0
2016-12-28 08:30:00	SPY	ETF	226.52	226.54	226.51	226.54	16547.0
2016-12-28 08:35:00	SPY	ETF	226.53	226.54	226.51	226.53	38269.0
2016-12-28 08:40:00	SPY	ETF	226.51	226.53	226.47	226.53	33120.0
2016-12-28 08:45:00	SPY	ETF	226.52	226.52	226.5	226.5	7104.0
2016-12-28 08:50:00	SPY	ETF	226.5	226.51	226.43	226.51	36650.0
2016-12-28 08:55:00	SPY	ETF	226.51	226.55	226.51	226.55	19723.0
2016-12-28 09:00:00	SPY	ETF	226.56	226.6	226.56	226.56	13467.0
2016-12-28 09:05:00	SPY	ETF	226.56	226.58	226.55	226.57	47519.0
2016-12-28 09:10:00	SPY	ETF	226.57	226.57	226.53	226.53	20837.0
2016-12-28 09:15:00	SPY	ETF	226.55	226.63	226.55	226.63	20730.0
2016-12-28 09:20:00	SPY	ETF	226.61	226.61	226.54	226.54	23052.0
2016-12-28 09:25:00	SPY	ETF	226.54	226.57	226.53	226.57	36863.0
2016-12-28 09:30:00	SPY	ETF	226.57	226.59	226.46	226.48	1306139.0
2016-12-28 09:35:00	SPY	ETF	226.48	226.53	226.31	226.32	636004.0
2016-12-28 09:40:00	SPY	ETF	226.32	226.33	225.93	226.02	934877.0
2016-12-28 09:45:00	SPY	ETF	226.03	226.07	225.87	225.9381	697917.0
2016-12-28 09:50:00	SPY	ETF	225.92	225.94	225.6	225.6399	1235536.0
2016-12-28 09:55:00	SPY	ETF	225.63	225.66	225.5	225.53	984603.0
2016-12-28 10:00:00	SPY	ETF	225.52	225.56	225.39	225.5492	1076488.0
2016-12-28 10:05:00	SPY	ETF	225.54	225.58	225.47	225.495	421613.0
2016-12-28 10:10:00	SPY	ETF	225.49	225.5158	225.32	225.455	910447.0
2016-12-28 10:15:00	SPY	ETF	225.45	225.57	225.42	225.4436	558173.0

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

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