PREVIEW / etf_daily / 2016-01-20

all etf daily files

  file:    by_date/etf_daily/2016/2016-01-20.parquet
  size:    51 KB
  rows:    1,258

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
2016-01-20	SPY	ETF	185.03	187.5	181.02	185.65	286547800.0
2016-01-20	QQQ	ETF	99.48	101.83	97.25	100.75	86674981.0
2016-01-20	IWM	ETF	97.43	100.33	95.06	99.18	94385800.0
2016-01-20	DIA	ETF	157.25	158.88	154.38	157.61	16436000.0
2016-01-20	GLD	ETF	105.17	106.16	104.94	105.37	10120900.0
2016-01-20	TLT	ETF	126.98	127.92	126.42	126.68	17283300.0
2016-01-20	AADR	ETF	34.2	34.49	33.98	34.49	5200.0
2016-01-20	AAXJ	ETF	46.84	47.42	46.14	47.06	2594100.0
2016-01-20	ACTX	ETF	5.9001	6.4901	5.9001	6.4901	795.0
2016-01-20	ACWF	ETF	20.24	20.7	20.22	20.67	9825.0
2016-01-20	ACWI	ETF	50.11	50.63	49.09	50.26	6873500.0
2016-01-20	ACWV	ETF	65.09	65.3	63.82	64.95	1237100.0
2016-01-20	ACWX	ETF	35.18	35.42	34.465	35.19	2929853.0
2016-01-20	ADRE	ETF	25.56	25.74	24.85	25.55	107044.0
2016-01-20	AFK	ETF	14.81	15.11	14.68	14.97	82551.0
2016-01-20	AFTY	ETF	12.18	12.39	12.04	12.39	39500.0
2016-01-20	AGG	ETF	109.1	109.18	108.87	108.91	4349900.0
2016-01-20	AGGY	ETF	49.426	49.63	49.259	49.63	466900.0
2016-01-20	AGQ	ETF	28.03	28.5	27.88	28.33	185700.0
2016-01-20	AGZ	ETF	113.82	114.0899	113.6801	113.82	60868.0
2016-01-20	AGZD	ETF	23.75	23.755	23.7	23.715	8600.0
2016-01-20	AIA	ETF	36.89	37.21	36.2999	36.99	30991.0
2016-01-20	AIQ	ETF	6.77	6.95	6.23	6.91	25579.0
2016-01-20	AIRR	ETF	13.811	14.49	13.77	14.42	194800.0
2016-01-20	AIVI	ETF	34.54	34.64	33.84	34.45	99100.0
2016-01-20	ALTY	ETF	12.116	12.116	12.116	12.116	300.0
2016-01-20	AMJ	ETF	22.34	22.36	20.35	21.32	9289676.0
2016-01-20	AMLP	ETF	44.3	44.5	41.25	42.8	6603100.0
2016-01-20	AMZA	ETF	72.7	72.7	63.29	66.0	14770.0
2016-01-20	ANGL	ETF	23.56	23.62	23.24	23.35	201500.0
2016-01-20	AOA	ETF	41.32	41.55	40.59	41.34	129700.0
2016-01-20	AOK	ETF	30.66	30.8499	30.5501	30.75	91654.0
2016-01-20	AOM	ETF	32.77	32.869	32.5101	32.8	101260.0
2016-01-20	AOR	ETF	36.54	36.68	36.1202	36.56	208570.0
2016-01-20	ARGT	ETF	15.63	15.63	15.07	15.63	20800.0
2016-01-20	ARKG	ETF	17.46	17.46	17.46	17.46	200.0
2016-01-20	ARKK	ETF	16.72	17.08	16.41	17.05	4200.0
2016-01-20	ARKQ	ETF	15.83	16.01	15.83	16.0	16500.0
2016-01-20	ARKW	ETF	18.77	18.844	18.49	18.49	2400.0
2016-01-20	ASEA	ETF	11.2	11.2	11.01	11.19	4700.0
2016-01-20	ASET	ETF	22.43	22.43	21.95	22.42	5020.0
2016-01-20	ASHR	ETF	23.16	23.45	22.92	23.33	1887300.0
2016-01-20	ASHS	ETF	32.53	32.84	32.13	32.47	117000.0
2016-01-20	ASHX	ETF	21.054	21.055	21.05	21.05	1109.0
2016-01-20	ATMP	ETF	14.61	14.61	13.41	14.04	253000.0
2016-01-20	BAB	ETF	29.82	29.9399	29.78	29.8	432258.0
2016-01-20	BAL	ETF	40.9101	41.19	40.87	40.96	12150.0
2016-01-20	BBC	ETF	19.46	21.4034	19.058	21.09	19220.0
2016-01-20	BBH	ETF	104.5	110.45	103.3	109.04	257700.0
2016-01-20	BBP	ETF	23.115	25.57	23.115	25.17	12700.0

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

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