PREVIEW / etf_daily / 2018-03-07

all etf daily files

  file:    by_date/etf_daily/2018/2018-03-07.parquet
  size:    60 KB
  rows:    1,548

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
2018-03-07	SPY	ETF	270.42	273.18	270.2	272.78	87063500.0
2018-03-07	QQQ	ETF	167.26	169.07	166.96	168.93	34609407.0
2018-03-07	IWM	ETF	154.46	156.93	154.22	156.74	22684600.0
2018-03-07	DIA	ETF	245.86	248.58	245.4	248.11	5362600.0
2018-03-07	GLD	ETF	126.22	126.29	125.42	125.72	5158700.0
2018-03-07	TLT	ETF	118.57	118.68	117.96	118.01	4461800.0
2018-03-07	AADR	ETF	60.03	60.62	59.95	60.55	24600.0
2018-03-07	AAXJ	ETF	76.93	77.57	76.66	77.53	566400.0
2018-03-07	ACSI	ETF	31.28	31.39	31.2265	31.39	753.0
2018-03-07	ACTX	ETF	61.9506	69.0306	58.1745	64.3106	1133.0
2018-03-07	ACWF	ETF	30.88	31.1297	30.88	31.0498	17797.0
2018-03-07	ACWI	ETF	72.65	73.17	72.48	73.11	1446000.0
2018-03-07	ACWV	ETF	83.36	83.81	83.21	83.7	244000.0
2018-03-07	ACWX	ETF	49.91	50.18	49.74	50.13	462384.0
2018-03-07	ADRE	ETF	44.9	45.4276	44.9	45.33	3216.0
2018-03-07	AFK	ETF	26.111	26.32	25.7701	26.2148	30696.0
2018-03-07	AFTY	ETF	18.43	18.52	18.42	18.52	3200.0
2018-03-07	AGG	ETF	106.51	106.55	106.37	106.4	3448700.0
2018-03-07	AGGY	ETF	49.12	49.13	49.03	49.04	84800.0
2018-03-07	AGNG	ETF	20.04	20.415	20.04	20.415	1500.0
2018-03-07	AGQ	ETF	32.22	32.22	31.51	31.71	296100.0
2018-03-07	AGZ	ETF	111.4	111.52	111.32	111.33	10509.0
2018-03-07	AGZD	ETF	24.02	24.165	24.02	24.1	13000.0
2018-03-07	AIA	ETF	67.81	68.26	67.5	68.21	39510.0
2018-03-07	AIEQ	ETF	26.81	27.08	26.805	27.08	47900.0
2018-03-07	AIRR	ETF	26.11	26.59	26.11	26.58	7200.0
2018-03-07	AIVI	ETF	43.22	43.3	43.14	43.3	3700.0
2018-03-07	ALTY	ETF	14.23	14.435	14.23	14.4	10300.0
2018-03-07	AMJ	ETF	25.84	26.07	25.6	25.72	1772557.0
2018-03-07	AMLP	ETF	50.55	51.1	50.1	50.45	2056140.0
2018-03-07	AMZA	ETF	76.2	77.0	75.6	76.2	111220.0
2018-03-07	ANGL	ETF	29.21	29.25	29.19	29.24	252100.0
2018-03-07	AOA	ETF	53.87	54.28	53.87	54.19	118200.0
2018-03-07	AOK	ETF	34.22	34.27	34.1408	34.27	66220.0
2018-03-07	AOM	ETF	37.8	37.9	37.761	37.89	104694.0
2018-03-07	AOR	ETF	44.73	44.95	44.6982	44.91	100997.0
2018-03-07	ARGT	ETF	36.94	37.09	36.7	37.02	28300.0
2018-03-07	ARKG	ETF	27.98	28.77	27.93	28.71	135700.0
2018-03-07	ARKK	ETF	42.61	43.66	42.61	43.61	492500.0
2018-03-07	ARKQ	ETF	35.42	35.743	35.322	35.74	56300.0
2018-03-07	ARKW	ETF	52.85	53.899	52.62	53.84	264700.0
2018-03-07	ASEA	ETF	17.7	18.06	17.59	17.79	2300.0
2018-03-07	ASET	ETF	27.379	27.405	27.3342	27.405	1156.0
2018-03-07	ASHR	ETF	31.92	31.98	31.71	31.92	531500.0
2018-03-07	ASHS	ETF	35.11	35.2	34.95	35.16	7600.0
2018-03-07	ASHX	ETF	22.17	22.17	22.17	22.17	190.0
2018-03-07	ATMP	ETF	19.61	19.73	19.38	19.49	102100.0
2018-03-07	BAB	ETF	29.6	29.6072	29.51	29.53	67174.0
2018-03-07	BAL	ETF	55.05	55.05	54.63	54.63	9660.0
2018-03-07	BAR	ETF	13.24	13.24	13.24	13.24	3440.0

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

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