PREVIEW / etf_daily / 2017-12-19

all etf daily files

  file:    by_date/etf_daily/2017/2017-12-19.parquet
  size:    59 KB
  rows:    1,536

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-12-19	SPY	ETF	268.48	268.53	267.09	267.17	82382900.0
2017-12-19	QQQ	ETF	158.34	158.5	157.26	157.7	31414968.0
2017-12-19	IWM	ETF	154.75	154.77	152.82	153.08	24313600.0
2017-12-19	DIA	ETF	248.31	248.34	246.94	247.4	2773600.0
2017-12-19	GLD	ETF	119.67	119.9	119.53	119.82	4018900.0
2017-12-19	TLT	ETF	126.32	126.38	125.07	125.53	11045800.0
2017-12-19	AADR	ETF	58.46	58.48	58.12	58.46	16900.0
2017-12-19	AAXJ	ETF	74.81	74.81	74.35	74.52	3122200.0
2017-12-19	ACSI	ETF	31.41	31.44	31.309	31.309	1883.0
2017-12-19	ACTX	ETF	75.5207	82.0107	72.5707	76.1107	422.0
2017-12-19	ACWF	ETF	30.44	30.44	30.355	30.355	2795.0
2017-12-19	ACWI	ETF	72.03	72.03	71.69	71.73	1458300.0
2017-12-19	ACWV	ETF	84.21	84.32	83.8	83.8	196600.0
2017-12-19	ACWX	ETF	49.48	49.49	49.25	49.31	579100.0
2017-12-19	ADRE	ETF	42.29	42.4283	42.1937	42.3542	6997.0
2017-12-19	AFK	ETF	24.39	24.5999	24.21	24.23	12961.0
2017-12-19	AFTY	ETF	17.52	17.52	17.32	17.321	11600.0
2017-12-19	AGG	ETF	109.14	109.16	108.89	109.01	2820900.0
2017-12-19	AGGY	ETF	50.7	50.7	50.55	50.609	72800.0
2017-12-19	AGNG	ETF	19.6	19.603	19.442	19.469	3000.0
2017-12-19	AGQ	ETF	30.7	30.96	30.49	30.81	200600.0
2017-12-19	AGZ	ETF	113.16	113.16	112.97	113.01	15032.0
2017-12-19	AGZD	ETF	24.145	24.24	24.075	24.24	13600.0
2017-12-19	AIA	ETF	65.66	65.66	65.1	65.28	35806.0
2017-12-19	AIEQ	ETF	26.06	26.09	25.92	25.93	93400.0
2017-12-19	AIRR	ETF	27.59	27.59	27.2	27.215	8700.0
2017-12-19	AIVI	ETF	43.39	43.39	43.19	43.27	14600.0
2017-12-19	ALTY	ETF	15.42	15.42	15.39	15.39	1000.0
2017-12-19	AMJ	ETF	27.51	27.57	27.16	27.16	3969402.0
2017-12-19	AMLP	ETF	54.35	54.35	53.65	53.75	3220680.0
2017-12-19	AMZA	ETF	86.4	86.5	85.1	85.2	109170.0
2017-12-19	ANGL	ETF	29.98	29.99	29.87	29.9	1296000.0
2017-12-19	AOA	ETF	56.4	56.4	55.62	55.65	136100.0
2017-12-19	AOK	ETF	34.7	34.7	34.53	34.5392	114775.0
2017-12-19	AOM	ETF	38.82	38.96	38.6	38.64	150047.0
2017-12-19	AOR	ETF	46.23	46.23	46.04	46.07	81887.0
2017-12-19	ARGT	ETF	35.23	35.58	34.98	35.43	108400.0
2017-12-19	ARKG	ETF	24.68	24.68	24.27	24.36	41200.0
2017-12-19	ARKK	ETF	39.79	39.82	38.676	39.09	614200.0
2017-12-19	ARKQ	ETF	35.38	35.38	34.73	34.87	57500.0
2017-12-19	ARKW	ETF	50.32	50.35	48.74	49.37	356500.0
2017-12-19	ASEA	ETF	16.98	17.0	16.59	16.75	2300.0
2017-12-19	ASET	ETF	28.8139	28.83	28.66	28.709	2061.0
2017-12-19	ASHR	ETF	30.62	30.62	30.45	30.51	1044600.0
2017-12-19	ASHS	ETF	34.69	34.69	34.27	34.29	8500.0
2017-12-19	ASHX	ETF	22.53	22.53	22.47	22.5	813.0
2017-12-19	ATMP	ETF	20.63	20.72	20.5	20.5	301500.0
2017-12-19	BAB	ETF	30.55	30.574	30.4	30.45	318723.0
2017-12-19	BAL	ETF	50.09	50.09	49.68	49.69	1602.0
2017-12-19	BAR	ETF	12.598	12.598	12.595	12.595	2860.0

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

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