PREVIEW / etf_daily / 2017-10-31

all etf daily files

  file:    by_date/etf_daily/2017/2017-10-31.parquet
  size:    58 KB
  rows:    1,493

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-10-31	SPY	ETF	257.18	257.44	256.81	257.15	60304800.0
2017-10-31	QQQ	ETF	152.04	152.37	151.63	152.15	26319327.0
2017-10-31	IWM	ETF	148.79	149.83	148.64	149.26	22449400.0
2017-10-31	DIA	ETF	233.64	233.91	233.2	233.63	1772000.0
2017-10-31	GLD	ETF	120.82	120.84	120.38	120.67	3910500.0
2017-10-31	TLT	ETF	124.53	124.66	124.4	124.46	4424300.0
2017-10-31	AADR	ETF	57.16	57.51	57.01	57.5	40900.0
2017-10-31	AAXJ	ETF	75.14	75.35	74.98	75.31	872800.0
2017-10-31	ACSI	ETF	29.51	29.6	29.51	29.599	2122.0
2017-10-31	ACTX	ETF	47.2004	47.2004	46.0204	46.6104	77.0
2017-10-31	ACWF	ETF	29.9699	30.019	29.89	29.89	3495.0
2017-10-31	ACWI	ETF	70.21	70.36	70.15	70.3	1247400.0
2017-10-31	ACWV	ETF	82.52	82.63	82.46	82.6	125000.0
2017-10-31	ACWX	ETF	49.18	49.3	49.13	49.28	391692.0
2017-10-31	ADRE	ETF	42.54	43.0	42.54	42.9076	14691.0
2017-10-31	AFK	ETF	23.61	23.6275	23.41	23.4301	7594.0
2017-10-31	AFTY	ETF	17.87	17.96	17.87	17.957	2300.0
2017-10-31	AGG	ETF	109.52	109.55	109.44	109.47	3719900.0
2017-10-31	AGGY	ETF	50.69	50.7	50.67	50.69	19000.0
2017-10-31	AGNG	ETF	19.44	19.48	19.25	19.428	9700.0
2017-10-31	AGQ	ETF	33.42	33.54	33.0	33.29	68300.0
2017-10-31	AGZ	ETF	113.54	113.59	113.51	113.5513	24120.0
2017-10-31	AGZD	ETF	24.08	24.125	24.07	24.105	3600.0
2017-10-31	AIA	ETF	64.65	64.7	64.54	64.68	68454.0
2017-10-31	AIEQ	ETF	24.83	24.97	24.77	24.91	179900.0
2017-10-31	AIRR	ETF	26.52	26.95	26.52	26.82	39900.0
2017-10-31	AIVI	ETF	43.0	43.12	42.95	43.08	4400.0
2017-10-31	ALTY	ETF	15.5	15.52	15.49	15.519	4800.0
2017-10-31	AMJ	ETF	27.06	27.15	26.87	27.06	2379213.0
2017-10-31	AMLP	ETF	53.75	53.85	53.2	53.6	2481160.0
2017-10-31	AMZA	ETF	84.0	84.0	83.0	83.8	80630.0
2017-10-31	ANGL	ETF	30.26	30.28	30.2	30.23	302100.0
2017-10-31	AOA	ETF	54.29	54.44	54.26	54.34	105100.0
2017-10-31	AOK	ETF	34.66	34.7115	34.615	34.65	101748.0
2017-10-31	AOM	ETF	38.2	38.23	38.1444	38.16	160160.0
2017-10-31	AOR	ETF	45.25	45.32	45.2289	45.3	162201.0
2017-10-31	ARGT	ETF	31.88	32.07	31.76	32.0	83000.0
2017-10-31	ARKG	ETF	25.92	26.169	25.68	25.96	62500.0
2017-10-31	ARKK	ETF	35.05	35.64	35.05	35.51	234800.0
2017-10-31	ARKQ	ETF	33.16	33.52	33.093	33.48	58100.0
2017-10-31	ARKW	ETF	42.82	43.29	42.61	43.195	135800.0
2017-10-31	ASEA	ETF	15.89	15.91	15.89	15.91	1200.0
2017-10-31	ASET	ETF	28.069	28.189	28.06	28.189	2973.0
2017-10-31	ASHR	ETF	30.59	30.64	30.56	30.62	485000.0
2017-10-31	ASHS	ETF	36.12	36.12	36.09	36.1	2300.0
2017-10-31	ASHX	ETF	22.58	22.69	22.58	22.69	1461.0
2017-10-31	ATMP	ETF	20.47	20.57	20.41	20.55	20500.0
2017-10-31	BAB	ETF	30.44	30.475	30.4	30.46	125776.0
2017-10-31	BAL	ETF	45.23	45.38	45.2032	45.38	2239.0
2017-10-31	BAR	ETF	12.705	12.705	12.705	12.705	2020.0

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

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