PREVIEW / etf_daily / 2017-06-30

all etf daily files

  file:    by_date/etf_daily/2017/2017-06-30.parquet
  size:    56 KB
  rows:    1,422

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-30	SPY	ETF	242.28	242.71	241.58	241.8	86820700.0
2017-06-30	QQQ	ETF	138.0	138.6687	137.19	137.64	68898255.0
2017-06-30	IWM	ETF	141.25	141.67	140.77	140.92	22798500.0
2017-06-30	DIA	ETF	213.15	213.99	212.97	213.24	2216600.0
2017-06-30	GLD	ETF	118.08	118.41	117.95	118.02	7272600.0
2017-06-30	TLT	ETF	125.19	125.39	124.85	125.12	10189800.0
2017-06-30	AADR	ETF	46.5	46.7	46.27	46.7	4000.0
2017-06-30	AAXJ	ETF	67.5	67.67	67.37	67.45	361000.0
2017-06-30	ACSI	ETF	28.77	28.77	28.7	28.73	3492.0
2017-06-30	ACTX	ETF	89.0908	99.1209	89.0908	94.4008	288.0
2017-06-30	ACWF	ETF	27.264	27.31	27.264	27.31	2960.0
2017-06-30	ACWI	ETF	65.6	65.63	65.3	65.49	3787300.0
2017-06-30	ACWV	ETF	79.09	79.29	78.96	79.1	118300.0
2017-06-30	ACWX	ETF	45.65	45.65	45.37	45.59	706681.0
2017-06-30	ADRE	ETF	38.3685	38.565	38.2894	38.53	6330.0
2017-06-30	AFK	ETF	21.55	21.6783	21.5217	21.6	2997.0
2017-06-30	AFTY	ETF	15.38	15.385	15.35	15.385	3300.0
2017-06-30	AGG	ETF	109.62	109.63	109.46	109.51	2626900.0
2017-06-30	AGGY	ETF	50.47	50.55	50.47	50.5	45800.0
2017-06-30	AGNG	ETF	18.816	18.909	18.816	18.909	200.0
2017-06-30	AGQ	ETF	33.82	34.05	33.79	33.82	64900.0
2017-06-30	AGZ	ETF	113.7883	114.02	113.64	113.7	11960.0
2017-06-30	AGZD	ETF	23.945	23.97	23.94	23.97	4000.0
2017-06-30	AIA	ETF	57.36	57.36	57.11	57.17	51728.0
2017-06-30	AIQ	ETF	13.25	13.3	13.25	13.3	3333.0
2017-06-30	AIRR	ETF	23.64	23.805	23.6	23.71	34500.0
2017-06-30	AIVI	ETF	40.84	40.85	40.58	40.8	25800.0
2017-06-30	ALTY	ETF	15.5	15.55	15.453	15.453	3100.0
2017-06-30	AMJ	ETF	29.66	29.87	29.57	29.7	3491457.0
2017-06-30	AMLP	ETF	59.5	59.85	59.25	59.8	4488020.0
2017-06-30	AMZA	ETF	100.6	101.4	99.9	101.0	157290.0
2017-06-30	ANGL	ETF	29.58	29.64	29.55	29.64	530600.0
2017-06-30	AOA	ETF	51.86	51.87	51.69	51.79	18300.0
2017-06-30	AOK	ETF	34.0	34.025	33.956	33.98	24595.0
2017-06-30	AOM	ETF	37.29	37.3183	37.22	37.27	45825.0
2017-06-30	AOR	ETF	43.63	43.6999	43.58	43.61	37699.0
2017-06-30	ARCM	ETF	100.15	100.15	100.15	100.15	20.0
2017-06-30	ARGT	ETF	29.15	29.45	29.02	29.29	355900.0
2017-06-30	ARKG	ETF	22.7	22.7	22.31	22.383	43900.0
2017-06-30	ARKK	ETF	29.26	29.26	28.91	28.95	123100.0
2017-06-30	ARKQ	ETF	28.13	28.4	28.05	28.12	34100.0
2017-06-30	ARKW	ETF	35.43	35.43	35.03	35.091	34100.0
2017-06-30	ASEA	ETF	15.17	15.17	15.1	15.11	2400.0
2017-06-30	ASET	ETF	27.1632	27.22	27.156	27.205	1658.0
2017-06-30	ASHR	ETF	27.2	27.3	27.16	27.26	710800.0
2017-06-30	ASHS	ETF	33.16	33.16	32.95	33.06	14400.0
2017-06-30	ATMP	ETF	22.26	22.36	22.21	22.29	22600.0
2017-06-30	BAB	ETF	29.98	30.01	29.87	29.96	217492.0
2017-06-30	BAL	ETF	44.23	45.3779	44.23	45.34	15385.0
2017-06-30	BBC	ETF	24.0632	24.2594	24.02	24.02	4238.0

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

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