PREVIEW / etf_5min / 2016-01-20

all etf 5-min files

  file:    by_date/etf_5min/2016/2016-01-20.parquet
  size:    1.5 MB
  rows:    61,426

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-01-20 04:00:00	SPY	ETF	184.05	184.63	183.76	183.94	36167.0
2016-01-20 04:05:00	SPY	ETF	183.94	183.94	183.8	183.85	36159.0
2016-01-20 04:10:00	SPY	ETF	183.66	183.93	183.54	183.93	3443.0
2016-01-20 04:15:00	SPY	ETF	183.8	183.8	183.48	183.63	4576.0
2016-01-20 04:20:00	SPY	ETF	183.63	183.81	183.59	183.75	3970.0
2016-01-20 04:25:00	SPY	ETF	183.83	184.32	183.83	184.32	2491.0
2016-01-20 04:30:00	SPY	ETF	184.4	184.43	184.28	184.28	3675.0
2016-01-20 04:35:00	SPY	ETF	184.37	184.45	184.21	184.21	1208.0
2016-01-20 04:40:00	SPY	ETF	184.32	184.82	184.32	184.6	6515.0
2016-01-20 04:45:00	SPY	ETF	184.53	184.53	184.3	184.51	5719.0
2016-01-20 04:50:00	SPY	ETF	184.6	184.76	184.5	184.75	8510.0
2016-01-20 04:55:00	SPY	ETF	184.7	184.7	184.5	184.5	1420.0
2016-01-20 05:00:00	SPY	ETF	184.55	184.55	184.36	184.37	7890.0
2016-01-20 05:10:00	SPY	ETF	184.35	184.4	184.28	184.28	2493.0
2016-01-20 05:15:00	SPY	ETF	184.2	184.27	184.08	184.27	2760.0
2016-01-20 05:20:00	SPY	ETF	184.35	184.35	184.3	184.3	1100.0
2016-01-20 05:25:00	SPY	ETF	184.45	184.55	184.42	184.54	4115.0
2016-01-20 05:30:00	SPY	ETF	184.55	184.65	184.27	184.27	5625.0
2016-01-20 05:35:00	SPY	ETF	184.5	184.52	184.1	184.1	3660.0
2016-01-20 05:40:00	SPY	ETF	184.11	184.45	184.11	184.24	4260.0
2016-01-20 05:45:00	SPY	ETF	184.32	184.32	184.17	184.17	930.0
2016-01-20 05:50:00	SPY	ETF	184.25	184.25	184.15	184.16	3400.0
2016-01-20 05:55:00	SPY	ETF	184.18	184.18	184.18	184.18	200.0
2016-01-20 06:00:00	SPY	ETF	184.25	184.33	184.21	184.25	68170.0
2016-01-20 06:05:00	SPY	ETF	184.3	184.31	184.2	184.26	40200.0
2016-01-20 06:10:00	SPY	ETF	184.28	184.49	184.28	184.39	6065.0
2016-01-20 06:15:00	SPY	ETF	184.38	184.39	184.28	184.39	3172.0
2016-01-20 06:20:00	SPY	ETF	184.5	184.8	184.45	184.56	36287.0
2016-01-20 06:25:00	SPY	ETF	184.56	184.79	184.56	184.79	29610.0
2016-01-20 06:30:00	SPY	ETF	184.77	184.78	184.6	184.61	20550.0
2016-01-20 06:35:00	SPY	ETF	184.57	184.57	184.45	184.53	13970.0
2016-01-20 06:40:00	SPY	ETF	184.53	184.68	184.46	184.58	21750.0
2016-01-20 06:45:00	SPY	ETF	184.53	184.58	184.36	184.45	25170.0
2016-01-20 06:50:00	SPY	ETF	184.43	184.53	184.4	184.43	8355.0
2016-01-20 06:55:00	SPY	ETF	184.45	184.55	184.4	184.5	15605.0
2016-01-20 07:00:00	SPY	ETF	184.55	184.7	184.49	184.56	65677.0
2016-01-20 07:05:00	SPY	ETF	184.48	184.48	184.15	184.27	60610.0
2016-01-20 07:10:00	SPY	ETF	184.25	184.25	184.09	184.09	90846.0
2016-01-20 07:15:00	SPY	ETF	184.12	184.34	184.09	184.25	33992.0
2016-01-20 07:20:00	SPY	ETF	184.29	184.49	184.27	184.45	37022.0
2016-01-20 07:25:00	SPY	ETF	184.46	184.54	184.34	184.5	11373.0
2016-01-20 07:30:00	SPY	ETF	184.49	184.49	184.3	184.42	56976.0
2016-01-20 07:35:00	SPY	ETF	184.4	184.46	184.25	184.25	71985.0
2016-01-20 07:40:00	SPY	ETF	184.29	184.34	184.23	184.26	33097.0
2016-01-20 07:45:00	SPY	ETF	184.29	184.47	184.28	184.4	92999.0
2016-01-20 07:50:00	SPY	ETF	184.4	184.66	184.38	184.56	158657.0
2016-01-20 07:55:00	SPY	ETF	184.52	184.58	184.42	184.5	54749.0
2016-01-20 08:00:00	SPY	ETF	184.05	184.92	184.05	184.92	437502.0
2016-01-20 08:05:00	SPY	ETF	184.49	184.55	184.39	184.55	128395.0
2016-01-20 08:10:00	SPY	ETF	184.54	184.65	184.46	184.6	161090.0

> showing 50 of 61,426 rows — these rows as CSV

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