PREVIEW / etf_daily / 2017-06-28

all etf daily files

  file:    by_date/etf_daily/2017/2017-06-28.parquet
  size:    55 KB
  rows:    1,407

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-06-28	SPY	ETF	242.5	243.72	242.23	243.49	70042600.0
2017-06-28	QQQ	ETF	138.54	140.14	137.74	140.02	57427180.0
2017-06-28	IWM	ETF	140.67	142.26	140.4	141.98	25085400.0
2017-06-28	DIA	ETF	212.93	214.53	212.93	214.24	4693700.0
2017-06-28	GLD	ETF	119.06	119.06	118.69	118.9	4220100.0
2017-06-28	TLT	ETF	126.67	126.71	125.98	126.47	7357900.0
2017-06-28	AADR	ETF	46.31	46.7	46.29	46.7	6200.0
2017-06-28	AAXJ	ETF	67.84	68.01	67.65	67.9	3285200.0
2017-06-28	ACSI	ETF	28.84	28.86	28.84	28.84	15706.0
2017-06-28	ACTX	ETF	96.4659	99.7109	88.5008	97.3509	385.0
2017-06-28	ACWF	ETF	27.3677	27.39	27.31	27.39	3704.0
2017-06-28	ACWI	ETF	65.62	66.02	65.62	65.93	1859100.0
2017-06-28	ACWV	ETF	79.69	79.84	79.59	79.77	85000.0
2017-06-28	ACWX	ETF	45.75	45.995	45.71	45.98	302250.0
2017-06-28	ADRE	ETF	38.47	38.84	38.469	38.82	3918.0
2017-06-28	AFK	ETF	21.54	21.88	21.54	21.88	2544.0
2017-06-28	AFTY	ETF	15.3	15.3	15.28	15.29	5400.0
2017-06-28	AGG	ETF	109.85	109.88	109.68	109.86	12184400.0
2017-06-28	AGGY	ETF	50.71	50.71	50.58	50.62	11500.0
2017-06-28	AGNG	ETF	18.886	19.161	18.886	19.161	24400.0
2017-06-28	AGQ	ETF	34.58	34.73	34.31	34.73	94600.0
2017-06-28	AGZ	ETF	113.74	114.01	113.74	113.82	8147.0
2017-06-28	AGZD	ETF	23.955	23.975	23.95	23.975	7800.0
2017-06-28	AIA	ETF	57.55	57.6903	57.4	57.65	27484.0
2017-06-28	AIQ	ETF	13.25	13.3	13.2	13.2	14602.0
2017-06-28	AIRR	ETF	23.55	23.906	23.55	23.82	19600.0
2017-06-28	AIVI	ETF	40.99	41.15	40.99	41.15	36900.0
2017-06-28	ALTY	ETF	15.59	15.595	15.503	15.595	2100.0
2017-06-28	AMJ	ETF	28.83	29.4	28.82	29.26	1593009.0
2017-06-28	AMLP	ETF	57.95	59.2	57.95	58.85	2123460.0
2017-06-28	AMZA	ETF	96.6	99.18	96.56	98.7	129590.0
2017-06-28	ANGL	ETF	29.56	29.62	29.51	29.61	829600.0
2017-06-28	AOA	ETF	51.95	52.12	51.85	52.05	28300.0
2017-06-28	AOK	ETF	34.09	34.15	34.022	34.14	41556.0
2017-06-28	AOM	ETF	37.39	37.5	37.3101	37.41	76648.0
2017-06-28	AOR	ETF	43.77	43.91	43.7201	43.91	69798.0
2017-06-28	ARCM	ETF	100.15	100.15	100.15	100.15	20.0
2017-06-28	ARGT	ETF	29.05	29.48	28.91	29.45	51200.0
2017-06-28	ARKG	ETF	22.607	23.08	22.563	23.06	13000.0
2017-06-28	ARKK	ETF	29.34	29.81	29.22	29.786	89300.0
2017-06-28	ARKQ	ETF	28.53	28.72	28.188	28.71	14500.0
2017-06-28	ARKW	ETF	35.56	35.985	35.35	35.96	48000.0
2017-06-28	ASEA	ETF	15.16	15.16	15.16	15.16	800.0
2017-06-28	ASET	ETF	27.21	27.43	27.21	27.43	2388.0
2017-06-28	ASHR	ETF	27.0	27.09	26.93	27.07	585600.0
2017-06-28	ASHS	ETF	32.65	32.7	32.65	32.7	700.0
2017-06-28	ASHX	ETF	20.6145	20.6145	20.58	20.58	313.0
2017-06-28	ATMP	ETF	21.86	22.14	21.86	22.05	111700.0
2017-06-28	BAB	ETF	30.07	30.14	29.98	29.99	327884.0
2017-06-28	BAL	ETF	44.15	44.61	44.15	44.57	3410.0

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

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