PREVIEW / etf_daily / 2017-03-10

all etf daily files

  file:    by_date/etf_daily/2017/2017-03-10.parquet
  size:    54 KB
  rows:    1,375

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2017-03-10	SPY	ETF	237.97	238.02	236.59	237.69	81991700.0
2017-03-10	QQQ	ETF	131.42	131.6	130.82	131.39	21922601.0
2017-03-10	IWM	ETF	136.29	136.31	134.84	135.96	39516600.0
2017-03-10	DIA	ETF	209.69	209.7	208.36	209.15	3004000.0
2017-03-10	GLD	ETF	114.45	114.73	114.13	114.72	7929500.0
2017-03-10	TLT	ETF	117.14	117.32	116.68	117.25	9218500.0
2017-03-10	AADR	ETF	44.92	44.92	44.68	44.8	8200.0
2017-03-10	AAXJ	ETF	60.37	60.57	60.3	60.56	415000.0
2017-03-10	ACSI	ETF	27.925	27.925	27.8539	27.8697	4720.0
2017-03-10	ACTX	ETF	96.7609	99.7109	93.1028	97.3509	749.0
2017-03-10	ACWI	ETF	62.78	62.93	62.57	62.78	2343200.0
2017-03-10	ACWV	ETF	76.27	76.39	76.09	76.38	118000.0
2017-03-10	ACWX	ETF	42.57	42.66	42.48	42.63	401064.0
2017-03-10	ADRE	ETF	35.465	35.5096	35.3425	35.5096	8897.0
2017-03-10	AFK	ETF	20.3	20.49	20.21	20.3252	9246.0
2017-03-10	AGG	ETF	107.23	107.32	107.16	107.3	1906000.0
2017-03-10	AGGY	ETF	49.2	49.24	49.17	49.221	10400.0
2017-03-10	AGQ	ETF	35.86	36.29	35.59	36.23	199600.0
2017-03-10	AGZ	ETF	112.53	112.53	112.06	112.3393	26123.0
2017-03-10	AGZD	ETF	24.085	24.095	24.04	24.04	7800.0
2017-03-10	AIA	ETF	50.51	50.6987	50.51	50.6987	8280.0
2017-03-10	AIQ	ETF	9.8501	10.05	9.85	9.85	4360.0
2017-03-10	AIRR	ETF	23.75	23.824	23.547	23.72	27300.0
2017-03-10	AIVI	ETF	38.78	38.9	38.73	38.86	29200.0
2017-03-10	ALTY	ETF	15.16	15.22	15.127	15.16	5500.0
2017-03-10	AMJ	ETF	32.19	32.2567	31.8516	32.01	2707644.0
2017-03-10	AMLP	ETF	63.6	63.8	63.15	63.4	2222680.0
2017-03-10	AMZA	ETF	111.5	111.5	109.8	110.25	57720.0
2017-03-10	ANGL	ETF	28.99	29.02	28.73	28.83	1735300.0
2017-03-10	AOA	ETF	49.42	49.48	49.3	49.42	40900.0
2017-03-10	AOK	ETF	32.9	32.9499	32.85	32.92	140456.0
2017-03-10	AOM	ETF	35.99	36.01	35.9	36.01	141831.0
2017-03-10	AOR	ETF	42.0	42.0	41.81	41.92	152858.0
2017-03-10	ARGT	ETF	26.45	26.53	26.3	26.41	19500.0
2017-03-10	ARKG	ETF	20.4	20.48	20.33	20.33	7700.0
2017-03-10	ARKK	ETF	23.19	23.21	23.17	23.21	800.0
2017-03-10	ARKQ	ETF	23.455	23.48	23.442	23.45	5500.0
2017-03-10	ARKW	ETF	28.85	28.87	28.288	28.4	12700.0
2017-03-10	ASEA	ETF	13.62	13.67	13.59	13.59	900.0
2017-03-10	ASET	ETF	25.78	25.78	25.78	25.78	242.0
2017-03-10	ASHR	ETF	24.63	24.75	24.63	24.74	227600.0
2017-03-10	ASHS	ETF	33.88	33.89	33.87	33.88	1900.0
2017-03-10	ASHX	ETF	19.3499	19.3499	19.3499	19.3499	300.0
2017-03-10	ATMP	ETF	23.75	23.81	23.45	23.66	38400.0
2017-03-10	BAB	ETF	29.09	29.1609	29.02	29.07	127510.0
2017-03-10	BAL	ETF	50.41	50.41	50.1606	50.1606	1650.0
2017-03-10	BBC	ETF	23.36	23.5428	23.13	23.53	24594.0
2017-03-10	BBH	ETF	121.48	122.36	120.77	122.28	36400.0
2017-03-10	BBP	ETF	38.41	38.41	37.835	38.26	5100.0
2017-03-10	BFOR	ETF	9.0525	9.09	9.0225	9.0725	38000.0

> showing 50 of 1,375 rows — these rows as CSV

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