PREVIEW / etf_daily / 2016-06-24

all etf daily files

  file:    by_date/etf_daily/2016/2016-06-24.parquet
  size:    52 KB
  rows:    1,312

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-06-24	SPY	ETF	203.63	210.85	202.72	203.24	333444400.0
2016-06-24	QQQ	ETF	104.81	106.5	104.06	104.29	68012733.0
2016-06-24	IWM	ETF	111.94	114.04	111.5	112.38	74945400.0
2016-06-24	DIA	ETF	174.55	176.68	173.3	173.62	11377900.0
2016-06-24	GLD	ETF	126.62	126.82	125.0	126.0	35782900.0
2016-06-24	TLT	ETF	136.61	136.61	135.3	135.78	17155000.0
2016-06-24	AADR	ETF	37.81	37.81	37.55	37.55	2100.0
2016-06-24	AAXJ	ETF	52.49	53.36	52.06	52.29	2196200.0
2016-06-24	ACTX	ETF	3.54	3.54	3.54	3.54	291.0
2016-06-24	ACWF	ETF	22.512	22.512	22.512	22.512	1788.0
2016-06-24	ACWI	ETF	54.39	55.4	54.24	54.3	5380600.0
2016-06-24	ACWV	ETF	72.66	74.12	72.66	73.4	704600.0
2016-06-24	ACWX	ETF	37.61	38.36	37.45	37.45	1172157.0
2016-06-24	ADRE	ETF	29.76	30.0143	29.7	29.9499	22868.0
2016-06-24	AFK	ETF	19.6	20.3599	19.24	19.8	12849.0
2016-06-24	AFTY	ETF	12.43	12.43	12.231	12.231	5000.0
2016-06-24	AGG	ETF	112.11	112.15	111.79	111.88	4081200.0
2016-06-24	AGGY	ETF	51.355	51.355	51.237	51.3	5300.0
2016-06-24	AGQ	ETF	43.47	43.59	42.22	42.75	351400.0
2016-06-24	AGZ	ETF	115.71	115.888	115.41	115.62	30967.0
2016-06-24	AGZD	ETF	23.695	23.695	23.695	23.695	600.0
2016-06-24	AIA	ETF	42.55	43.42	42.49	42.57	76712.0
2016-06-24	AIQ	ETF	6.05	6.3	5.89	5.9	541627.0
2016-06-24	AIRR	ETF	18.133	18.19	17.99	18.029	1900.0
2016-06-24	AIVI	ETF	36.01	36.57	35.51	35.51	100000.0
2016-06-24	ALTY	ETF	14.83	14.9	14.72	14.83	14300.0
2016-06-24	AMJ	ETF	31.2	32.1	30.4	31.15	5204411.0
2016-06-24	AMLP	ETF	62.5	64.4	62.3	63.15	2788060.0
2016-06-24	AMZA	ETF	112.0	116.2	111.4	112.0	37680.0
2016-06-24	ANGL	ETF	27.11	27.49	27.01	27.21	203600.0
2016-06-24	AOA	ETF	44.42	45.34	44.12	44.61	118900.0
2016-06-24	AOK	ETF	32.14	32.7099	32.0	32.36	35385.0
2016-06-24	AOM	ETF	34.61	35.2524	34.253	34.78	146903.0
2016-06-24	AOR	ETF	39.14	39.6042	39.04	39.12	168548.0
2016-06-24	ARGT	ETF	21.35	21.77	21.03	21.29	71100.0
2016-06-24	ARKG	ETF	16.8	16.8	16.741	16.741	1000.0
2016-06-24	ARKK	ETF	19.21	19.21	18.95	18.96	13700.0
2016-06-24	ARKQ	ETF	19.17	19.17	19.0	19.0	500.0
2016-06-24	ARKW	ETF	21.944	21.944	21.944	21.944	600.0
2016-06-24	ASEA	ETF	12.83	13.19	12.83	12.94	1700.0
2016-06-24	ASET	ETF	25.81	25.81	25.81	25.81	100.0
2016-06-24	ASHR	ETF	23.01	23.39	22.9	22.92	2291900.0
2016-06-24	ASHS	ETF	32.86	33.3	32.66	32.8	40600.0
2016-06-24	ASHX	ETF	21.0599	21.0599	21.0599	21.0599	200.0
2016-06-24	ATMP	ETF	22.01	22.24	21.56	21.56	44600.0
2016-06-24	BAB	ETF	31.3	31.3	31.12	31.22	249537.0
2016-06-24	BAL	ETF	42.6	42.94	42.4887	42.75	11126.0
2016-06-24	BBC	ETF	17.9	18.185	17.6701	17.75	18421.0
2016-06-24	BBH	ETF	99.8	101.43	98.8	98.83	159900.0
2016-06-24	BBP	ETF	25.93	26.24	25.73	25.75	4400.0

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

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