PREVIEW / etf_daily / 2017-09-22

all etf daily files

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

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-22	SPY	ETF	249.05	249.63	249.02	249.44	51214000.0
2017-09-22	QQQ	ETF	144.0	144.53	143.855	144.32	21702401.0
2017-09-22	IWM	ETF	143.67	144.67	143.56	144.3	25203000.0
2017-09-22	DIA	ETF	223.22	223.46	222.82	223.2	2448400.0
2017-09-22	GLD	ETF	123.03	123.39	122.93	123.24	6011900.0
2017-09-22	TLT	ETF	126.5	126.73	126.06	126.2	5660700.0
2017-09-22	AADR	ETF	55.28	55.58	55.28	55.52	30800.0
2017-09-22	AAXJ	ETF	72.98	73.0	72.83	72.92	634700.0
2017-09-22	ACSI	ETF	28.85	28.86	28.799	28.81	1550.0
2017-09-22	ACTX	ETF	73.7507	76.7007	70.8006	72.8067	168.0
2017-09-22	ACWF	ETF	28.9128	28.9128	28.9128	28.9128	120.0
2017-09-22	ACWI	ETF	68.69	68.77	68.63	68.69	951800.0
2017-09-22	ACWV	ETF	81.09	81.19	81.02	81.11	207500.0
2017-09-22	ACWX	ETF	48.46	48.53	48.41	48.46	157912.0
2017-09-22	ADRE	ETF	42.62	42.7954	42.62	42.7	6850.0
2017-09-22	AFK	ETF	23.53	23.76	23.4701	23.498	4268.0
2017-09-22	AFTY	ETF	17.12	17.12	17.0	17.019	7400.0
2017-09-22	AGG	ETF	109.86	109.9	109.75	109.77	1461800.0
2017-09-22	AGGY	ETF	50.86	50.86	50.787	50.845	10100.0
2017-09-22	AGNG	ETF	19.4	19.47	19.37	19.4	3400.0
2017-09-22	AGQ	ETF	34.36	34.65	34.27	34.53	54200.0
2017-09-22	AGZ	ETF	113.8	113.8496	113.77	113.84	7261.0
2017-09-22	AGZD	ETF	24.005	24.045	24.005	24.045	2200.0
2017-09-22	AIA	ETF	61.86	61.86	61.7331	61.81	24209.0
2017-09-22	AIRR	ETF	25.02	25.2	24.966	25.18	26100.0
2017-09-22	AIVI	ETF	43.08	43.14	43.03	43.05	5700.0
2017-09-22	ALTY	ETF	15.622	15.65	15.622	15.65	4100.0
2017-09-22	AMJ	ETF	27.77	28.01	27.75	27.92	1272417.0
2017-09-22	AMLP	ETF	55.4	55.75	55.25	55.55	1088040.0
2017-09-22	AMZA	ETF	91.3	92.0	90.9	91.5	78690.0
2017-09-22	ANGL	ETF	30.18	30.18	30.12	30.18	188000.0
2017-09-22	AOA	ETF	53.34	53.42	53.3	53.36	32400.0
2017-09-22	AOK	ETF	34.43	34.46	34.4001	34.44	53430.0
2017-09-22	AOM	ETF	37.91	37.95	37.8658	37.94	60426.0
2017-09-22	AOR	ETF	44.69	44.72	44.6601	44.7	143481.0
2017-09-22	ARGT	ETF	31.35	31.82	31.29	31.73	42200.0
2017-09-22	ARKG	ETF	25.8	25.88	25.64	25.766	13700.0
2017-09-22	ARKK	ETF	33.98	34.03	33.85	33.9	89300.0
2017-09-22	ARKQ	ETF	31.36	31.53	31.22	31.35	15800.0
2017-09-22	ARKW	ETF	40.55	40.61	40.33	40.6	74000.0
2017-09-22	ASET	ETF	28.14	28.14	28.0959	28.0959	507.0
2017-09-22	ASHR	ETF	29.55	29.59	29.5	29.53	327300.0
2017-09-22	ASHS	ETF	36.52	36.53	36.5	36.51	4900.0
2017-09-22	ATMP	ETF	21.26	21.26	21.04	21.16	32500.0
2017-09-22	BAB	ETF	30.53	30.576	30.4501	30.47	56947.0
2017-09-22	BAL	ETF	45.04	45.2714	44.781	45.16	11832.0
2017-09-22	BAR	ETF	12.965	12.974	12.965	12.974	7650.0
2017-09-22	BBC	ETF	28.74	28.74	28.1158	28.2	8304.0
2017-09-22	BBH	ETF	133.05	133.65	132.73	133.57	8400.0
2017-09-22	BBP	ETF	40.96	40.96	40.3	40.528	3200.0

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

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