PREVIEW / etf_daily / 2017-07-11

all etf daily files

  file:    by_date/etf_daily/2017/2017-07-11.parquet
  size:    56 KB
  rows:    1,438

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-07-11	SPY	ETF	242.37	242.55	240.85	242.19	50354600.0
2017-07-11	QQQ	ETF	138.44	139.22	137.94	139.05	31517660.0
2017-07-11	IWM	ETF	139.78	140.38	138.98	140.29	16192900.0
2017-07-11	DIA	ETF	213.91	214.29	212.68	213.98	1577600.0
2017-07-11	GLD	ETF	115.26	115.77	114.88	115.62	6637900.0
2017-07-11	TLT	ETF	122.86	123.33	122.71	123.11	4425600.0
2017-07-11	AADR	ETF	47.39	47.59	47.04	47.47	31000.0
2017-07-11	AAXJ	ETF	67.92	68.18	67.76	68.13	444400.0
2017-07-11	ACSI	ETF	28.48	28.48	28.3575	28.44	15905.0
2017-07-11	ACTX	ETF	92.6308	92.6308	82.6007	83.7808	430.0
2017-07-11	ACWF	ETF	27.43	27.4499	27.35	27.35	4770.0
2017-07-11	ACWI	ETF	65.48	65.65	65.22	65.6	1039200.0
2017-07-11	ACWV	ETF	78.42	78.51	78.14	78.46	219900.0
2017-07-11	ACWX	ETF	45.52	45.71	45.42	45.7	323758.0
2017-07-11	ADRE	ETF	38.92	39.25	38.92	39.1035	9352.0
2017-07-11	AFK	ETF	21.63	21.66	21.49	21.55	23349.0
2017-07-11	AFTY	ETF	15.5	15.59	15.5	15.59	1300.0
2017-07-11	AGG	ETF	108.97	109.1	108.93	109.05	1969100.0
2017-07-11	AGGY	ETF	50.35	50.39	50.33	50.39	18900.0
2017-07-11	AGNG	ETF	18.645	18.645	18.614	18.614	400.0
2017-07-11	AGQ	ETF	30.0	30.69	29.74	30.66	239000.0
2017-07-11	AGZ	ETF	113.32	113.47	113.2797	113.36	30461.0
2017-07-11	AGZD	ETF	24.005	24.02	24.0	24.02	21800.0
2017-07-11	AIA	ETF	57.72	57.7799	57.43	57.7199	40113.0
2017-07-11	AIQ	ETF	13.2001	13.25	13.2	13.2	22043.0
2017-07-11	AIRR	ETF	23.64	23.77	23.61	23.72	8400.0
2017-07-11	AIVI	ETF	40.45	40.67	40.44	40.59	45400.0
2017-07-11	ALTY	ETF	15.44	15.44	15.44	15.44	1000.0
2017-07-11	AMJ	ETF	29.38	29.57	29.335	29.53	1049060.0
2017-07-11	AMLP	ETF	59.3	59.45	59.05	59.45	1245040.0
2017-07-11	AMZA	ETF	94.9	95.3	94.25	95.3	80700.0
2017-07-11	ANGL	ETF	29.33	29.37	29.26	29.3	162000.0
2017-07-11	AOA	ETF	51.31	51.41	51.15	51.39	40100.0
2017-07-11	AOK	ETF	33.79	33.8	33.7001	33.78	71370.0
2017-07-11	AOM	ETF	36.89	36.985	36.86	36.9	124025.0
2017-07-11	AOR	ETF	43.21	43.336	43.15	43.25	67282.0
2017-07-11	ARCM	ETF	100.09	100.09	100.09	100.09	20.0
2017-07-11	ARGT	ETF	29.43	29.6	29.25	29.52	60800.0
2017-07-11	ARKG	ETF	21.99	22.21	21.974	22.2	17400.0
2017-07-11	ARKK	ETF	28.6	28.9	28.57	28.9	34100.0
2017-07-11	ARKQ	ETF	28.27	28.7	28.251	28.7	22600.0
2017-07-11	ARKW	ETF	35.12	35.482	35.12	35.482	17200.0
2017-07-11	ASEA	ETF	15.01	15.05	14.97	15.05	3000.0
2017-07-11	ASET	ETF	26.8763	26.9498	26.8763	26.9498	576.0
2017-07-11	ASHR	ETF	27.33	27.4	27.29	27.4	674500.0
2017-07-11	ASHS	ETF	33.03	33.04	32.86	32.88	6000.0
2017-07-11	ASHX	ETF	20.9	20.9	20.78	20.81	1450.0
2017-07-11	ATMP	ETF	22.19	22.24	22.13	22.18	11500.0
2017-07-11	BAB	ETF	29.96	29.965	29.895	29.94	59707.0
2017-07-11	BAL	ETF	44.15	44.56	44.15	44.53	26832.0

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

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