PREVIEW / etf_daily / 2017-07-03

all etf daily files

  file:    by_date/etf_daily/2017/2017-07-03.parquet
  size:    54 KB
  rows:    1,393

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-07-03	SPY	ETF	242.88	243.38	242.21	242.21	39153800.0
2017-07-03	QQQ	ETF	138.25	138.43	136.1	136.19	32797005.0
2017-07-03	IWM	ETF	141.34	142.5	141.3	142.1	12968200.0
2017-07-03	DIA	ETF	213.95	215.38	213.88	214.49	2134700.0
2017-07-03	GLD	ETF	116.54	116.85	115.94	116.09	12145000.0
2017-07-03	TLT	ETF	125.0	125.04	124.02	124.46	11021100.0
2017-07-03	AADR	ETF	47.21	47.21	46.77	47.01	21000.0
2017-07-03	AAXJ	ETF	67.76	67.89	67.57	67.63	409900.0
2017-07-03	ACSI	ETF	28.86	28.86	28.69	28.77	4525.0
2017-07-03	ACTX	ETF	94.4008	98.5309	92.6308	95.5809	304.0
2017-07-03	ACWF	ETF	27.36	27.36	27.23	27.31	4337.0
2017-07-03	ACWI	ETF	65.67	65.77	65.53	65.57	1465500.0
2017-07-03	ACWV	ETF	79.19	79.23	79.0	79.02	72000.0
2017-07-03	ACWX	ETF	45.57	45.7	45.57	45.58	329504.0
2017-07-03	ADRE	ETF	38.46	38.8799	38.46	38.58	6101.0
2017-07-03	AFK	ETF	22.1	22.1	21.55	21.78	6097.0
2017-07-03	AFTY	ETF	15.235	15.235	15.235	15.235	100.0
2017-07-03	AGG	ETF	109.3	109.3	109.01	109.09	1817300.0
2017-07-03	AGGY	ETF	50.44	50.57	50.38	50.4	8400.0
2017-07-03	AGNG	ETF	18.8	18.871	18.8	18.8	500.0
2017-07-03	AGQ	ETF	32.39	32.56	31.75	31.95	253900.0
2017-07-03	AGZ	ETF	113.55	113.5603	113.34	113.43	6422.0
2017-07-03	AGZD	ETF	23.945	23.945	23.945	23.945	600.0
2017-07-03	AIA	ETF	57.22	57.35	57.15	57.22	26877.0
2017-07-03	AIQ	ETF	13.2501	13.3	13.237	13.25	3828.0
2017-07-03	AIRR	ETF	23.9	24.1	23.78	24.03	15300.0
2017-07-03	AIVI	ETF	40.76	40.89	40.76	40.8	13500.0
2017-07-03	ALTY	ETF	15.73	15.73	15.421	15.48	1200.0
2017-07-03	AMJ	ETF	29.86	30.26	29.86	30.17	520753.0
2017-07-03	AMLP	ETF	59.85	60.45	59.75	60.25	2016640.0
2017-07-03	AMZA	ETF	101.6	103.3	101.5	103.1	149180.0
2017-07-03	ANGL	ETF	29.55	29.57	29.46	29.5	106600.0
2017-07-03	AOA	ETF	53.0	53.71	51.8	51.83	38200.0
2017-07-03	AOK	ETF	34.42	34.42	33.95	33.95	16936.0
2017-07-03	AOM	ETF	37.57	37.57	37.13	37.13	205749.0
2017-07-03	AOR	ETF	44.78	44.78	43.57	43.62	58359.0
2017-07-03	ARCM	ETF	100.09	100.09	100.09	100.09	20.0
2017-07-03	ARGT	ETF	29.45	29.82	29.45	29.81	47000.0
2017-07-03	ARKG	ETF	22.37	22.54	22.21	22.44	13300.0
2017-07-03	ARKK	ETF	29.16	29.179	28.72	28.8	32700.0
2017-07-03	ARKQ	ETF	28.19	28.28	27.866	27.91	16500.0
2017-07-03	ARKW	ETF	35.44	35.44	34.671	34.79	20800.0
2017-07-03	ASEA	ETF	15.1	15.11	15.1	15.11	500.0
2017-07-03	ASET	ETF	27.34	27.34	27.279	27.279	250.0
2017-07-03	ASHR	ETF	27.16	27.21	27.05	27.05	369100.0
2017-07-03	ASHS	ETF	33.07	33.16	33.07	33.13	1900.0
2017-07-03	ATMP	ETF	22.35	22.64	21.99	22.64	5700.0
2017-07-03	BAB	ETF	29.99	30.04	29.7744	29.92	38476.0
2017-07-03	BAL	ETF	45.0	45.17	44.8764	44.88	5240.0
2017-07-03	BBC	ETF	24.2	24.39	23.97	24.38	4197.0

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

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