PREVIEW / etf_daily / 2017-09-13

all etf daily files

  file:    by_date/etf_daily/2017/2017-09-13.parquet
  size:    56 KB
  rows:    1,446

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-13	SPY	ETF	249.72	250.21	249.59	250.17	59228000.0
2017-09-13	QQQ	ETF	145.95	146.44	145.73	146.42	28450864.0
2017-09-13	IWM	ETF	141.41	142.22	141.32	141.96	25052500.0
2017-09-13	DIA	ETF	221.35	221.79	221.2	221.76	1720800.0
2017-09-13	GLD	ETF	126.4	126.45	125.5	125.61	8491000.0
2017-09-13	TLT	ETF	126.91	126.92	126.28	126.29	6740000.0
2017-09-13	AADR	ETF	54.48	54.76	54.47	54.6	38800.0
2017-09-13	AAXJ	ETF	72.69	72.69	72.45	72.56	788900.0
2017-09-13	ACSI	ETF	29.0735	29.1	29.04	29.1	2274.0
2017-09-13	ACTX	ETF	76.7007	76.7007	71.9806	72.5707	335.0
2017-09-13	ACWF	ETF	28.5497	28.5999	28.5497	28.5999	387.0
2017-09-13	ACWI	ETF	68.45	68.46	68.31	68.41	1079900.0
2017-09-13	ACWV	ETF	81.78	81.78	81.5	81.52	38900.0
2017-09-13	ACWX	ETF	48.25	48.25	48.05	48.09	151497.0
2017-09-13	ADRE	ETF	43.13	43.46	43.13	43.28	15660.0
2017-09-13	AFK	ETF	23.68	23.81	23.4679	23.54	11279.0
2017-09-13	AFTY	ETF	17.23	17.23	17.12	17.14	3400.0
2017-09-13	AGG	ETF	110.0	110.04	109.86	109.87	1304100.0
2017-09-13	AGGY	ETF	50.91	50.91	50.804	50.849	11600.0
2017-09-13	AGNG	ETF	19.599	19.599	19.5	19.5	300.0
2017-09-13	AGQ	ETF	38.01	38.02	37.38	37.74	111700.0
2017-09-13	AGZ	ETF	114.16	114.16	114.032	114.06	16841.0
2017-09-13	AGZD	ETF	23.9	23.955	23.9	23.955	2000.0
2017-09-13	AIA	ETF	61.26	61.26	61.0909	61.1	26816.0
2017-09-13	AIRR	ETF	24.18	24.383	24.18	24.37	24200.0
2017-09-13	AIVI	ETF	42.94	42.94	42.72	42.73	7400.0
2017-09-13	ALTY	ETF	15.59	15.63	15.57	15.63	3800.0
2017-09-13	AMJ	ETF	28.08	28.38	28.08	28.37	2335203.0
2017-09-13	AMLP	ETF	56.15	56.65	56.1	56.6	2359440.0
2017-09-13	AMZA	ETF	92.3	93.6	92.3	93.6	39370.0
2017-09-13	ANGL	ETF	30.0	30.1	29.95	30.07	139600.0
2017-09-13	AOA	ETF	53.25	53.26	53.15	53.23	34000.0
2017-09-13	AOK	ETF	34.42	34.4574	34.4	34.4	34865.0
2017-09-13	AOM	ETF	37.86	37.94	37.82	37.85	59451.0
2017-09-13	AOR	ETF	44.62	44.63	44.5746	44.62	67469.0
2017-09-13	ARCM	ETF	100.075	100.075	99.95	99.95	80.0
2017-09-13	ARGT	ETF	31.25	31.34	31.09	31.22	57400.0
2017-09-13	ARKG	ETF	25.42	25.52	25.21	25.5	35400.0
2017-09-13	ARKK	ETF	33.82	33.86	33.51	33.72	121300.0
2017-09-13	ARKQ	ETF	30.85	30.86	30.58	30.78	14500.0
2017-09-13	ARKW	ETF	40.35	40.35	40.099	40.17	90200.0
2017-09-13	ASEA	ETF	15.62	15.64	15.51	15.64	3100.0
2017-09-13	ASET	ETF	28.3	28.3	28.22	28.22	576.0
2017-09-13	ASHR	ETF	29.88	29.9	29.76	29.78	373400.0
2017-09-13	ASHS	ETF	37.17	37.5	37.17	37.42	12000.0
2017-09-13	ATMP	ETF	21.77	21.77	21.47	21.58	54300.0
2017-09-13	BAB	ETF	30.72	30.72	30.6	30.62	61148.0
2017-09-13	BAL	ETF	45.57	45.763	45.15	45.7253	6805.0
2017-09-13	BAR	ETF	13.312	13.312	13.216	13.23	68970.0
2017-09-13	BBC	ETF	27.6959	27.91	27.6755	27.745	9095.0

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

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