PREVIEW / etf_1min / 2016-12-28

all etf 1-min files

  file:    by_date/etf_1min/2016/2016-12-28.parquet
  size:    2.8 MB
  rows:    147,183

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:36:00	SPY	ETF	226.37	226.38	226.37	226.38	800.0
2016-12-28 04:51:00	SPY	ETF	226.38	226.38	226.38	226.38	2498.0
2016-12-28 05:13:00	SPY	ETF	226.39	226.39	226.39	226.39	100.0
2016-12-28 05:14:00	SPY	ETF	226.4	226.4	226.4	226.4	1300.0
2016-12-28 05:20:00	SPY	ETF	226.43	226.44	226.43	226.44	1402.0
2016-12-28 05:34: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.42	226.42	1400.0
2016-12-28 05:54:00	SPY	ETF	226.41	226.41	226.41	226.41	100.0
2016-12-28 05:58:00	SPY	ETF	226.44	226.44	226.44	226.44	1000.0
2016-12-28 05:59:00	SPY	ETF	226.44	226.44	226.44	226.44	2000.0
2016-12-28 06:01:00	SPY	ETF	226.43	226.45	226.43	226.45	1100.0
2016-12-28 06:03:00	SPY	ETF	226.45	226.45	226.41	226.41	1902.0
2016-12-28 06:18:00	SPY	ETF	226.38	226.38	226.38	226.38	100.0
2016-12-28 06:22:00	SPY	ETF	226.38	226.38	226.38	226.38	100.0
2016-12-28 06:43:00	SPY	ETF	226.38	226.38	226.38	226.38	400.0
2016-12-28 06:44:00	SPY	ETF	226.38	226.38	226.38	226.38	300.0
2016-12-28 06:49:00	SPY	ETF	226.38	226.38	226.38	226.38	300.0
2016-12-28 06:59: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.44	226.44	202.0
2016-12-28 07:02:00	SPY	ETF	226.43	226.43	226.43	226.43	8000.0
2016-12-28 07:03:00	SPY	ETF	226.43	226.43	226.43	226.43	1050.0
2016-12-28 07:04:00	SPY	ETF	226.43	226.43	226.43	226.43	2404.0
2016-12-28 07:05:00	SPY	ETF	226.43	226.43	226.42	226.42	22100.0
2016-12-28 07:07:00	SPY	ETF	226.43	226.45	226.43	226.45	900.0
2016-12-28 07:26:00	SPY	ETF	226.37	226.37	226.37	226.37	1600.0
2016-12-28 07:28:00	SPY	ETF	226.39	226.39	226.39	226.39	691.0
2016-12-28 07:29:00	SPY	ETF	226.4	226.4	226.4	226.4	2001.0
2016-12-28 07:32:00	SPY	ETF	226.39	226.39	226.39	226.39	200.0
2016-12-28 07:33:00	SPY	ETF	226.39	226.41	226.39	226.41	3000.0
2016-12-28 07:35:00	SPY	ETF	226.39	226.39	226.38	226.38	5600.0
2016-12-28 07:36:00	SPY	ETF	226.4	226.4	226.4	226.4	302.0
2016-12-28 07:39:00	SPY	ETF	226.43	226.45	226.43	226.44	3031.0
2016-12-28 07:40:00	SPY	ETF	226.44	226.44	226.43	226.43	3300.0
2016-12-28 07:41:00	SPY	ETF	226.44	226.44	226.44	226.44	500.0
2016-12-28 07:43:00	SPY	ETF	226.44	226.45	226.38	226.38	105204.0
2016-12-28 07:44:00	SPY	ETF	226.42	226.42	226.41	226.41	3100.0
2016-12-28 07:45:00	SPY	ETF	226.43	226.43	226.43	226.43	501.0
2016-12-28 07:47:00	SPY	ETF	226.42	226.43	226.42	226.43	1200.0
2016-12-28 07:48:00	SPY	ETF	226.43	226.43	226.43	226.43	900.0
2016-12-28 07:55:00	SPY	ETF	226.44	226.45	226.44	226.44	3301.0
2016-12-28 07:56:00	SPY	ETF	226.45	226.45	226.44	226.45	1111.0
2016-12-28 07:57:00	SPY	ETF	226.44	226.44	226.44	226.44	450.0
2016-12-28 07:58:00	SPY	ETF	226.45	226.45	226.45	226.45	300.0
2016-12-28 07:59:00	SPY	ETF	226.45	226.45	226.45	226.45	5500.0
2016-12-28 08:00:00	SPY	ETF	226.45	226.46	226.43	226.45	23591.0
2016-12-28 08:01:00	SPY	ETF	226.46	226.48	226.46	226.48	15152.0
2016-12-28 08:02:00	SPY	ETF	226.49	226.51	226.49	226.51	14056.0
2016-12-28 08:03:00	SPY	ETF	226.51	226.52	226.5	226.52	11601.0
2016-12-28 08:04:00	SPY	ETF	226.51	226.53	226.51	226.53	7152.0

> showing 50 of 147,183 rows — these rows as CSV

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