PREVIEW / etf_daily / 2017-09-18

all etf daily files

  file:    by_date/etf_daily/2017/2017-09-18.parquet
  size:    57 KB
  rows:    1,461

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-09-18	SPY	ETF	249.61	250.12	249.28	249.72	46235200.0
2017-09-18	QQQ	ETF	145.88	146.37	145.11	145.55	24858157.0
2017-09-18	IWM	ETF	142.62	143.81	142.6	143.38	24427400.0
2017-09-18	DIA	ETF	222.92	223.39	222.67	223.16	1827300.0
2017-09-18	GLD	ETF	124.71	124.76	123.97	124.36	8859800.0
2017-09-18	TLT	ETF	126.5	126.57	125.84	126.13	6863000.0
2017-09-18	AADR	ETF	56.07	56.07	54.79	55.01	44300.0
2017-09-18	AAXJ	ETF	73.82	73.92	73.61	73.76	934000.0
2017-09-18	ACSI	ETF	29.18	29.18	29.0569	29.0569	1012.0
2017-09-18	ACTX	ETF	71.6856	76.1107	71.3906	72.5707	189.0
2017-09-18	ACWF	ETF	28.981	28.981	28.94	28.9634	1034.0
2017-09-18	ACWI	ETF	68.74	68.85	68.6	68.7	1256600.0
2017-09-18	ACWV	ETF	81.71	81.76	81.51	81.71	97100.0
2017-09-18	ACWX	ETF	48.4	48.52	48.3	48.36	171171.0
2017-09-18	ADRE	ETF	44.0	44.0	43.031	43.13	13309.0
2017-09-18	AFK	ETF	23.4	23.6	23.25	23.45	8352.0
2017-09-18	AFTY	ETF	17.13	17.13	17.0	17.0	5000.0
2017-09-18	AGG	ETF	109.86	109.9	109.77	109.86	1946300.0
2017-09-18	AGGY	ETF	50.86	50.87	50.82	50.848	13500.0
2017-09-18	AGNG	ETF	19.62	19.62	19.54	19.598	5900.0
2017-09-18	AGQ	ETF	36.08	36.14	34.89	35.48	218100.0
2017-09-18	AGZ	ETF	113.8575	113.95	113.8202	113.95	5010.0
2017-09-18	AGZD	ETF	23.94	24.05	23.94	23.955	3800.0
2017-09-18	AIA	ETF	62.25	62.42	62.21	62.33	26266.0
2017-09-18	AIRR	ETF	24.58	24.89	24.58	24.78	16700.0
2017-09-18	AIVI	ETF	42.94	42.96	42.84	42.94	4700.0
2017-09-18	ALTY	ETF	15.646	15.66	15.633	15.633	1100.0
2017-09-18	AMJ	ETF	28.2	28.39	28.2	28.32	1419921.0
2017-09-18	AMLP	ETF	56.3	56.6	56.3	56.55	934720.0
2017-09-18	AMZA	ETF	92.4	93.1	92.4	92.8	69840.0
2017-09-18	ANGL	ETF	30.11	30.13	30.04	30.07	239000.0
2017-09-18	AOA	ETF	53.37	53.48	53.33	53.43	47900.0
2017-09-18	AOK	ETF	34.48	34.5	34.42	34.48	72396.0
2017-09-18	AOM	ETF	37.95	38.0	37.9	37.95	121500.0
2017-09-18	AOR	ETF	44.71	44.78	44.66	44.75	103071.0
2017-09-18	ARCM	ETF	100.0	100.0	100.0	100.0	8000.0
2017-09-18	ARGT	ETF	31.29	31.44	31.1	31.32	55200.0
2017-09-18	ARKG	ETF	25.61	25.73	25.52	25.57	39100.0
2017-09-18	ARKK	ETF	34.14	34.56	34.14	34.36	220600.0
2017-09-18	ARKQ	ETF	31.59	31.77	31.47	31.66	67600.0
2017-09-18	ARKW	ETF	40.95	41.325	40.88	41.21	111300.0
2017-09-18	ASEA	ETF	15.75	15.85	15.75	15.82	2700.0
2017-09-18	ASET	ETF	28.2859	28.34	28.27	28.34	2621.0
2017-09-18	ASHR	ETF	29.78	29.82	29.68	29.7	599200.0
2017-09-18	ASHS	ETF	37.23	37.25	37.15	37.23	8200.0
2017-09-18	ASHX	ETF	21.89	21.89	21.89	21.89	251.0
2017-09-18	ATMP	ETF	21.52	21.6	21.48	21.55	95800.0
2017-09-18	BAB	ETF	30.51	30.52	30.45	30.49	120042.0
2017-09-18	BAL	ETF	45.81	46.0591	45.679	45.7947	5395.0
2017-09-18	BAR	ETF	13.117	13.127	13.0664	13.069	19860.0

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

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