PREVIEW / etf_1min / 2016-11-07

all etf 1-min files

  file:    by_date/etf_1min/2016/2016-11-07.parquet
  size:    2.8 MB
  rows:    145,408

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-11-07 04:00:00	SPY	ETF	209.86	211.11	209.86	211.11	5663.0
2016-11-07 04:01:00	SPY	ETF	210.99	211.25	210.99	211.25	4335.0
2016-11-07 04:02:00	SPY	ETF	211.3	211.3	211.05	211.05	753.0
2016-11-07 04:03:00	SPY	ETF	211.11	211.3	211.11	211.27	1441.0
2016-11-07 04:04:00	SPY	ETF	211.05	211.3	211.05	211.3	831.0
2016-11-07 04:05:00	SPY	ETF	211.27	211.3	210.92	211.25	7008.0
2016-11-07 04:06:00	SPY	ETF	211.28	211.3	211.25	211.3	2130.0
2016-11-07 04:08:00	SPY	ETF	211.27	211.3	211.16	211.22	1660.0
2016-11-07 04:10:00	SPY	ETF	211.2	211.29	211.2	211.23	960.0
2016-11-07 04:11:00	SPY	ETF	211.28	211.36	211.28	211.36	1690.0
2016-11-07 04:14:00	SPY	ETF	211.32	211.36	211.31	211.36	1241.0
2016-11-07 04:15:00	SPY	ETF	211.29	211.29	211.29	211.29	100.0
2016-11-07 04:16:00	SPY	ETF	211.36	211.4	211.35	211.4	1634.0
2016-11-07 04:17:00	SPY	ETF	211.35	211.4	211.35	211.35	1578.0
2016-11-07 04:19:00	SPY	ETF	211.34	211.4	211.34	211.4	589.0
2016-11-07 04:23:00	SPY	ETF	211.45	211.47	211.45	211.47	1680.0
2016-11-07 04:24:00	SPY	ETF	211.45	211.45	211.45	211.45	101.0
2016-11-07 04:25:00	SPY	ETF	211.5	211.5	211.5	211.5	279.0
2016-11-07 04:27:00	SPY	ETF	211.55	211.61	211.55	211.61	544.0
2016-11-07 04:30:00	SPY	ETF	211.6	211.61	211.55	211.57	504.0
2016-11-07 04:31:00	SPY	ETF	211.57	211.57	211.57	211.57	301.0
2016-11-07 04:32:00	SPY	ETF	211.6	211.62	211.6	211.62	560.0
2016-11-07 04:33:00	SPY	ETF	211.64	211.64	211.64	211.64	7605.0
2016-11-07 04:34:00	SPY	ETF	211.64	211.64	211.64	211.64	201.0
2016-11-07 04:35:00	SPY	ETF	211.63	211.63	211.62	211.62	728.0
2016-11-07 04:36:00	SPY	ETF	211.62	211.62	211.62	211.62	1953.0
2016-11-07 04:37:00	SPY	ETF	211.62	211.62	211.62	211.62	2495.0
2016-11-07 04:38:00	SPY	ETF	211.63	211.66	211.63	211.66	448.0
2016-11-07 04:39:00	SPY	ETF	211.6	211.6	211.6	211.6	209.0
2016-11-07 04:41:00	SPY	ETF	211.59	211.6	211.59	211.6	900.0
2016-11-07 04:42:00	SPY	ETF	211.62	211.62	211.62	211.62	132.0
2016-11-07 04:43:00	SPY	ETF	211.59	211.59	211.59	211.59	160.0
2016-11-07 04:46:00	SPY	ETF	211.6	211.6	211.6	211.6	304.0
2016-11-07 04:47:00	SPY	ETF	211.59	211.59	211.59	211.59	525.0
2016-11-07 04:48:00	SPY	ETF	211.59	211.59	211.59	211.59	100.0
2016-11-07 04:49:00	SPY	ETF	211.59	211.6	211.57	211.6	2752.0
2016-11-07 04:50:00	SPY	ETF	211.58	211.58	211.57	211.57	700.0
2016-11-07 04:52:00	SPY	ETF	211.57	211.59	211.57	211.58	5998.0
2016-11-07 04:53:00	SPY	ETF	211.59	211.59	211.59	211.59	136.0
2016-11-07 04:54:00	SPY	ETF	211.6	211.63	211.6	211.63	502.0
2016-11-07 04:55:00	SPY	ETF	211.57	211.61	211.57	211.61	800.0
2016-11-07 04:56:00	SPY	ETF	211.61	211.61	211.61	211.61	442.0
2016-11-07 04:57:00	SPY	ETF	211.54	211.54	211.54	211.54	700.0
2016-11-07 04:58:00	SPY	ETF	211.56	211.56	211.54	211.54	302.0
2016-11-07 04:59:00	SPY	ETF	211.53	211.54	211.53	211.54	1000.0
2016-11-07 05:01:00	SPY	ETF	211.54	211.54	211.54	211.54	507.0
2016-11-07 05:03:00	SPY	ETF	211.53	211.53	211.53	211.53	300.0
2016-11-07 05:04:00	SPY	ETF	211.52	211.53	211.52	211.53	3600.0
2016-11-07 05:05:00	SPY	ETF	211.53	211.53	211.53	211.53	200.0
2016-11-07 05:08:00	SPY	ETF	211.46	211.48	211.46	211.48	825.0

> showing 50 of 145,408 rows — these rows as CSV

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