PREVIEW / etf_daily / 2018-04-04

all etf daily files

  file:    by_date/etf_daily/2018/2018-04-04.parquet
  size:    60 KB
  rows:    1,554

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-04-04	SPY	ETF	256.75	264.36	256.6	263.56	123715300.0
2018-04-04	QQQ	ETF	154.27	160.23	154.04	159.74	65768692.0
2018-04-04	IWM	ETF	148.5	152.58	148.27	152.16	29619700.0
2018-04-04	DIA	ETF	235.05	242.9	234.94	242.46	6437500.0
2018-04-04	GLD	ETF	127.5	127.53	126.32	126.45	7488300.0
2018-04-04	TLT	ETF	121.35	121.46	120.6	120.69	6654300.0
2018-04-04	AADR	ETF	56.59	57.91	56.12	57.89	137200.0
2018-04-04	AAXJ	ETF	74.89	76.96	74.7	76.86	647800.0
2018-04-04	ACSI	ETF	30.2698	30.869	30.26	30.869	1158.0
2018-04-04	ACTX	ETF	57.2305	57.2305	50.7405	53.1005	472.0
2018-04-04	ACWF	ETF	30.1811	30.769	30.1811	30.769	8551.0
2018-04-04	ACWI	ETF	69.92	71.6	69.83	71.51	2327400.0
2018-04-04	ACWV	ETF	82.51	84.01	82.44	83.96	63900.0
2018-04-04	ACWX	ETF	48.61	49.51	48.602	49.49	553410.0
2018-04-04	ADRE	ETF	42.4	43.401	42.4	43.401	5262.0
2018-04-04	AFK	ETF	25.2	25.37	25.17	25.37	5505.0
2018-04-04	AFTY	ETF	17.2	17.53	17.2	17.525	1300.0
2018-04-04	AGG	ETF	106.9	106.93	106.79	106.82	6200900.0
2018-04-04	AGGY	ETF	49.25	49.25	49.18	49.21	44900.0
2018-04-04	AGNG	ETF	19.21	19.71	19.151	19.71	25800.0
2018-04-04	AGQ	ETF	30.96	31.17	30.67	30.9	153900.0
2018-04-04	AGZ	ETF	111.59	111.7	111.58	111.63	20026.0
2018-04-04	AGZD	ETF	24.065	24.065	23.94	24.0	3600.0
2018-04-04	AIA	ETF	65.58	67.3449	65.31	67.26	140643.0
2018-04-04	AIEQ	ETF	25.31	26.0	25.27	25.95	29800.0
2018-04-04	AIRR	ETF	25.29	25.92	25.29	25.9	9300.0
2018-04-04	AIVI	ETF	42.88	43.3	42.88	43.3	7500.0
2018-04-04	ALTY	ETF	14.37	14.48	14.37	14.48	2500.0
2018-04-04	AMJ	ETF	23.68	24.045	23.45	23.95	4145693.0
2018-04-04	AMLP	ETF	46.25	46.95	45.75	46.75	2476980.0
2018-04-04	AMZA	ETF	67.5	68.9	66.9	68.7	93560.0
2018-04-04	ANGL	ETF	28.8	28.92	28.79	28.9	296500.0
2018-04-04	AOA	ETF	52.37	53.33	52.31	53.32	64800.0
2018-04-04	AOK	ETF	33.8	34.05	33.79	34.05	118450.0
2018-04-04	AOM	ETF	37.04	37.56	37.04	37.56	212455.0
2018-04-04	AOR	ETF	43.71	44.35	43.67	44.35	161945.0
2018-04-04	ARGT	ETF	34.86	35.76	34.81	35.75	146200.0
2018-04-04	ARKG	ETF	24.82	26.058	24.82	25.95	52400.0
2018-04-04	ARKK	ETF	37.31	39.34	37.2	39.27	261700.0
2018-04-04	ARKQ	ETF	31.39	32.77	31.08	32.7	41700.0
2018-04-04	ARKW	ETF	47.5	49.576	47.01	49.52	202100.0
2018-04-04	ASEA	ETF	17.54	17.61	17.42	17.42	5900.0
2018-04-04	ASET	ETF	27.23	27.35	27.2062	27.32	3952.0
2018-04-04	ASHR	ETF	30.21	31.02	30.2	30.94	821100.0
2018-04-04	ASHS	ETF	34.44	35.24	34.44	35.17	5500.0
2018-04-04	ASHX	ETF	20.91	20.9155	20.9	20.9	2701.0
2018-04-04	ATMP	ETF	18.09	18.27	17.91	18.19	49100.0
2018-04-04	BAB	ETF	30.06	30.06	29.97	29.97	50343.0
2018-04-04	BAL	ETF	52.26	52.76	52.26	52.41	8261.0
2018-04-04	BAR	ETF	13.414	13.414	13.312	13.312	36430.0

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

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