PREVIEW / etf_daily / 2017-08-04

all etf daily files

  file:    by_date/etf_daily/2017/2017-08-04.parquet
  size:    56 KB
  rows:    1,437

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-08-04	SPY	ETF	247.52	247.79	246.97	247.41	60191800.0
2017-08-04	QQQ	ETF	143.65	143.97	143.06	143.65	29472909.0
2017-08-04	IWM	ETF	139.91	140.32	139.49	140.21	16473500.0
2017-08-04	DIA	ETF	220.64	220.67	220.03	220.57	1877700.0
2017-08-04	GLD	ETF	119.97	120.04	119.22	119.65	8644800.0
2017-08-04	TLT	ETF	125.15	125.18	124.44	124.93	8485500.0
2017-08-04	AADR	ETF	49.91	50.08	49.76	49.99	8700.0
2017-08-04	AAXJ	ETF	71.0	71.19	70.81	71.19	1017600.0
2017-08-04	ACSI	ETF	29.3	29.33	29.28	29.33	11401.0
2017-08-04	ACTX	ETF	94.4008	102.0709	92.0408	97.3509	783.0
2017-08-04	ACWI	ETF	67.56	67.6	67.34	67.53	1141400.0
2017-08-04	ACWV	ETF	80.92	80.99	80.59	80.75	54800.0
2017-08-04	ACWX	ETF	47.49	47.5	47.29	47.48	477505.0
2017-08-04	ADRE	ETF	41.57	41.61	41.4711	41.4711	5795.0
2017-08-04	AFK	ETF	22.97	22.9823	22.8125	22.88	11399.0
2017-08-04	AFTY	ETF	16.05	16.05	16.03	16.03	1100.0
2017-08-04	AGG	ETF	109.7	109.72	109.54	109.68	2300900.0
2017-08-04	AGGY	ETF	50.78	50.78	50.66	50.74	17000.0
2017-08-04	AGNG	ETF	18.52	18.71	18.52	18.617	1200.0
2017-08-04	AGQ	ETF	32.75	32.8	31.79	32.08	198700.0
2017-08-04	AGZ	ETF	113.87	113.87	113.7603	113.83	13054.0
2017-08-04	AGZD	ETF	23.99	24.02	23.99	24.015	6400.0
2017-08-04	AIA	ETF	60.49	60.52	60.25	60.43	41956.0
2017-08-04	AIQ	ETF	13.2	13.2	12.95	13.15	39804.0
2017-08-04	AIRR	ETF	23.71	23.93	23.71	23.71	23500.0
2017-08-04	AIVI	ETF	42.21	42.21	41.99	42.1	15900.0
2017-08-04	ALTY	ETF	15.65	15.659	15.61	15.63	14200.0
2017-08-04	AMJ	ETF	29.76	29.86	29.51	29.57	659215.0
2017-08-04	AMLP	ETF	59.6	59.65	59.05	59.1	1561560.0
2017-08-04	AMUB	ETF	18.75	18.75	18.69	18.7	3750.0
2017-08-04	AMZA	ETF	97.0	97.0	96.0	96.1	50500.0
2017-08-04	ANGL	ETF	29.87	29.9	29.83	29.89	243700.0
2017-08-04	AOA	ETF	52.68	52.73	52.59	52.73	38700.0
2017-08-04	AOK	ETF	34.27	34.27	34.17	34.25	47320.0
2017-08-04	AOM	ETF	37.61	37.64	37.53	37.62	37257.0
2017-08-04	AOR	ETF	44.23	44.25	44.1351	44.25	85652.0
2017-08-04	ARCM	ETF	100.0	100.0	100.0	100.0	18300.0
2017-08-04	ARGT	ETF	28.87	28.99	28.7	28.83	161100.0
2017-08-04	ARKG	ETF	22.553	22.79	22.55	22.764	42600.0
2017-08-04	ARKK	ETF	30.18	30.43	30.18	30.4	68600.0
2017-08-04	ARKQ	ETF	29.58	29.58	29.4	29.489	15300.0
2017-08-04	ARKW	ETF	37.2	37.542	37.18	37.38	35700.0
2017-08-04	ASEA	ETF	15.36	15.4	15.36	15.4	1600.0
2017-08-04	ASET	ETF	28.0	28.08	28.0	28.08	1272.0
2017-08-04	ASHR	ETF	27.95	28.04	27.91	27.92	872500.0
2017-08-04	ASHS	ETF	33.76	33.79	33.7	33.75	4600.0
2017-08-04	ASHX	ETF	21.0956	21.0956	21.0956	21.0956	151.0
2017-08-04	ATMP	ETF	22.5	22.55	22.37	22.41	62000.0
2017-08-04	BAB	ETF	30.23	30.3846	30.1	30.16	280388.0
2017-08-04	BAL	ETF	46.49	46.75	46.49	46.63	8725.0

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

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