PREVIEW / etf_daily / 2017-10-24

all etf daily files

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

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-24	SPY	ETF	256.6	256.83	256.15	256.56	66935900.0
2017-10-24	QQQ	ETF	148.0	148.3	147.44	147.99	20289467.0
2017-10-24	IWM	ETF	149.39	149.78	149.04	149.17	17527700.0
2017-10-24	DIA	ETF	234.11	234.7	233.96	234.29	3300500.0
2017-10-24	GLD	ETF	121.26	121.71	120.98	121.33	5114100.0
2017-10-24	TLT	ETF	123.37	123.69	123.15	123.43	6842800.0
2017-10-24	AADR	ETF	57.98	58.43	57.7	58.43	40200.0
2017-10-24	AAXJ	ETF	74.69	74.8	74.4	74.49	640200.0
2017-10-24	ACSI	ETF	29.6	29.64	29.6	29.63	3004.0
2017-10-24	ACTX	ETF	50.7405	54.8115	48.9704	49.5604	687.0
2017-10-24	ACWF	ETF	29.79	29.915	29.79	29.82	1283.0
2017-10-24	ACWI	ETF	70.02	70.13	69.96	70.02	677400.0
2017-10-24	ACWV	ETF	82.79	82.84	82.55	82.62	1057100.0
2017-10-24	ACWX	ETF	49.06	49.16	49.01	49.05	541701.0
2017-10-24	ADRE	ETF	42.83	42.964	42.67	42.79	5694.0
2017-10-24	AFK	ETF	23.5421	23.73	23.5421	23.73	3396.0
2017-10-24	AFTY	ETF	17.48	17.53	17.48	17.525	2900.0
2017-10-24	AGG	ETF	109.23	109.29	109.17	109.19	1722300.0
2017-10-24	AGGY	ETF	50.51	50.59	50.51	50.56	42100.0
2017-10-24	AGNG	ETF	19.64	19.755	19.51	19.53	5500.0
2017-10-24	AGQ	ETF	34.25	34.63	33.99	34.27	74000.0
2017-10-24	AGZ	ETF	113.229	113.34	113.229	113.33	6782.0
2017-10-24	AGZD	ETF	24.14	24.14	24.065	24.12	1400.0
2017-10-24	AIA	ETF	63.57	63.68	63.43	63.4547	28051.0
2017-10-24	AIEQ	ETF	25.22	25.28	25.181	25.19	546200.0
2017-10-24	AIRR	ETF	26.2	26.425	26.2	26.27	28200.0
2017-10-24	AIVI	ETF	42.92	42.95	42.84	42.87	13300.0
2017-10-24	ALTY	ETF	15.52	15.73	15.52	15.68	4000.0
2017-10-24	AMJ	ETF	26.89	26.99	26.595	26.77	2770191.0
2017-10-24	AMLP	ETF	53.3	53.5	52.55	52.9	3299320.0
2017-10-24	AMZA	ETF	83.5	84.3	81.7	82.6	286180.0
2017-10-24	ANGL	ETF	30.37	30.39	30.34	30.35	208200.0
2017-10-24	AOA	ETF	54.15	54.25	54.14	54.2	47600.0
2017-10-24	AOK	ETF	34.61	34.61	34.6	34.6	48636.0
2017-10-24	AOM	ETF	38.11	38.13	38.05	38.1	112486.0
2017-10-24	AOR	ETF	45.17	45.2	45.1166	45.16	88668.0
2017-10-24	ARGT	ETF	32.14	32.23	31.89	32.01	128800.0
2017-10-24	ARKG	ETF	26.4	26.4	25.785	25.82	48100.0
2017-10-24	ARKK	ETF	34.63	34.63	34.27	34.36	98900.0
2017-10-24	ARKQ	ETF	32.78	32.95	32.66	32.83	32700.0
2017-10-24	ARKW	ETF	41.45	41.62	41.3	41.5	49700.0
2017-10-24	ASEA	ETF	15.71	15.73	15.67	15.67	3500.0
2017-10-24	ASET	ETF	28.26	28.26	28.2283	28.24	2007.0
2017-10-24	ASHR	ETF	30.05	30.27	30.05	30.26	679200.0
2017-10-24	ASHS	ETF	36.33	36.36	36.28	36.36	7600.0
2017-10-24	ASHX	ETF	22.35	22.35	22.35	22.35	296.0
2017-10-24	ATMP	ETF	20.4	20.4	20.12	20.25	62300.0
2017-10-24	BAB	ETF	30.39	30.39	30.25	30.31	92148.0
2017-10-24	BAL	ETF	45.97	46.1272	45.77	46.06	2367.0
2017-10-24	BAR	ETF	12.757	12.797	12.757	12.797	15200.0

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

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