PREVIEW / etf_daily / 2017-06-29

all etf daily files

  file:    by_date/etf_daily/2017/2017-06-29.parquet
  size:    56 KB
  rows:    1,430

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-06-29	SPY	ETF	243.66	243.72	239.96	241.35	106949700.0
2017-06-29	QQQ	ETF	139.4	139.44	136.25	137.59	88769351.0
2017-06-29	IWM	ETF	142.24	142.35	139.65	141.14	38794900.0
2017-06-29	DIA	ETF	214.52	214.55	211.7	212.61	4372600.0
2017-06-29	GLD	ETF	117.97	118.64	117.91	118.32	7705200.0
2017-06-29	TLT	ETF	125.01	125.72	124.9	125.41	9115800.0
2017-06-29	AADR	ETF	46.59	46.59	45.96	46.22	4300.0
2017-06-29	AAXJ	ETF	67.75	67.75	66.78	67.16	1239800.0
2017-06-29	ACSI	ETF	28.79	28.85	28.59	28.6899	12408.0
2017-06-29	ACTX	ETF	97.3509	97.3509	82.6007	87.9108	769.0
2017-06-29	ACWF	ETF	27.28	27.28	27.04	27.06	1348.0
2017-06-29	ACWI	ETF	65.86	65.89	65.0	65.33	1690400.0
2017-06-29	ACWV	ETF	79.54	79.54	78.7	78.99	119900.0
2017-06-29	ACWX	ETF	45.81	45.86	45.28	45.51	669257.0
2017-06-29	ADRE	ETF	38.5	38.5	38.0	38.2108	4522.0
2017-06-29	AFK	ETF	21.65	21.82	21.5	21.51	3290.0
2017-06-29	AFTY	ETF	15.34	15.34	15.275	15.275	6000.0
2017-06-29	AGG	ETF	109.53	109.68	109.47	109.65	3377200.0
2017-06-29	AGGY	ETF	50.5	50.57	50.5	50.57	10000.0
2017-06-29	AGNG	ETF	18.94	19.11	18.75	18.76	4400.0
2017-06-29	AGQ	ETF	33.97	34.39	33.82	33.91	96400.0
2017-06-29	AGZ	ETF	113.65	113.99	113.5701	113.83	15684.0
2017-06-29	AGZD	ETF	23.94	23.97	23.935	23.945	13400.0
2017-06-29	AIA	ETF	57.62	57.62	56.92	57.12	40453.0
2017-06-29	AIQ	ETF	13.25	13.3	13.2	13.2	14888.0
2017-06-29	AIRR	ETF	23.79	23.844	23.37	23.57	63300.0
2017-06-29	AIVI	ETF	40.89	40.93	40.64	40.75	81600.0
2017-06-29	ALTY	ETF	15.581	15.581	15.433	15.433	6700.0
2017-06-29	AMJ	ETF	29.36	29.74	29.3411	29.45	2285343.0
2017-06-29	AMLP	ETF	59.1	59.65	58.95	59.05	2885480.0
2017-06-29	AMZA	ETF	99.2	100.8	99.1	99.8	113280.0
2017-06-29	ANGL	ETF	29.59	29.59	29.41	29.52	629600.0
2017-06-29	AOA	ETF	52.01	52.04	51.55	51.62	42700.0
2017-06-29	AOK	ETF	34.07	34.07	33.93	33.95	59669.0
2017-06-29	AOM	ETF	37.43	37.43	37.13	37.26	81106.0
2017-06-29	AOR	ETF	43.82	43.82	43.48	43.57	79310.0
2017-06-29	ARCM	ETF	100.15	100.15	100.15	100.15	20.0
2017-06-29	ARGT	ETF	29.4	29.4	28.86	29.11	145900.0
2017-06-29	ARKG	ETF	23.0	23.01	22.46	22.55	41600.0
2017-06-29	ARKK	ETF	29.75	29.75	28.845	29.227	68800.0
2017-06-29	ARKQ	ETF	28.7	28.7	27.88	28.18	35600.0
2017-06-29	ARKW	ETF	35.94	35.94	34.79	35.208	42900.0
2017-06-29	ASEA	ETF	15.06	15.16	15.03	15.07	9300.0
2017-06-29	ASET	ETF	27.1102	27.1102	27.1102	27.1102	572.0
2017-06-29	ASHR	ETF	27.11	27.17	27.02	27.09	944100.0
2017-06-29	ASHS	ETF	32.75	32.83	32.68	32.69	2000.0
2017-06-29	ATMP	ETF	22.18	22.29	22.06	22.17	42700.0
2017-06-29	BAB	ETF	29.83	29.9799	29.8	29.88	122789.0
2017-06-29	BAL	ETF	44.45	44.45	44.0801	44.17	7506.0
2017-06-29	BBC	ETF	24.83	24.83	24.16	24.45	5879.0

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

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