PREVIEW / etf_daily / 2021-08-05

all etf daily files

  file:    by_date/etf_daily/2021/2021-08-05.parquet
  size:    92 KB
  rows:    2,426

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
2021-08-05	SPY	ETF	440.22	441.85	439.88	441.76	38969700.0
2021-08-05	QQQ	ETF	368.18	369.91	367.45	369.67	21443925.0
2021-08-05	IWM	ETF	219.09	222.44	218.68	222.03	23915200.0
2021-08-05	DIA	ETF	348.85	350.65	348.67	350.61	2261400.0
2021-08-05	GLD	ETF	169.37	169.44	168.2	168.86	8015000.0
2021-08-05	TLT	ETF	150.76	150.92	150.0	150.29	15345400.0
2021-08-05	AAA	ETF	25.01	25.01	25.01	25.01	53.0
2021-08-05	AAAU	ETF	18.01	18.01	17.89	17.96	313800.0
2021-08-05	AADR	ETF	68.27	68.5	68.26	68.39	1100.0
2021-08-05	AAXJ	ETF	88.82	89.18	88.77	88.97	1709600.0
2021-08-05	ABEQ	ETF	27.618	27.625	27.577	27.625	1600.0
2021-08-05	ACES	ETF	72.0	72.119	71.04	71.82	51200.0
2021-08-05	ACIO	ETF	30.75	30.8	30.75	30.795	32500.0
2021-08-05	ACSI	ETF	50.8243	50.8243	50.8243	50.8243	15.0
2021-08-05	ACTV	ETF	38.07	38.11	37.89	38.1021	4300.0
2021-08-05	ACTX	ETF	1.87	1.87	1.87	1.87	5398.0
2021-08-05	ACVF	ETF	32.86	32.86	32.71	32.757	3200.0
2021-08-05	ACWF	ETF	38.64	38.66	38.48	38.5554	14478.0
2021-08-05	ACWI	ETF	102.92	103.17	102.86	103.12	2043200.0
2021-08-05	ACWV	ETF	105.29	105.47	105.22	105.46	89300.0
2021-08-05	ACWX	ETF	57.37	57.48	57.322	57.38	485539.0
2021-08-05	ADFI	ETF	9.76	9.77	9.67	9.763	3900.0
2021-08-05	ADIV	ETF	18.34	18.34	18.34	18.34	100.0
2021-08-05	ADME	ETF	40.641	40.719	40.63	40.719	34300.0
2021-08-05	ADRE	ETF	53.51	53.686	53.4812	53.5133	2206.0
2021-08-05	AESR	ETF	13.97	13.98	13.95	13.98	24300.0
2021-08-05	AFIF	ETF	9.69	9.71	9.68	9.69	35378.0
2021-08-05	AFK	ETF	21.92	21.92	21.76	21.76	2990.0
2021-08-05	AFLG	ETF	26.08	26.127	26.08	26.127	1000.0
2021-08-05	AFMC	ETF	25.576	25.576	25.576	25.576	100.0
2021-08-05	AFSM	ETF	26.133	26.133	26.133	26.133	800.0
2021-08-05	AFTY	ETF	20.88	20.88	20.53	20.59	5000.0
2021-08-05	AGG	ETF	116.46	116.48	116.28	116.31	3283100.0
2021-08-05	AGGY	ETF	52.96	52.96	52.75	52.86	60900.0
2021-08-05	AGNG	ETF	30.671	30.83	30.671	30.83	2600.0
2021-08-05	AGOV	ETF	100.52	100.655	100.52	100.655	241.0
2021-08-05	AGOX	ETF	26.351	26.399	26.15	26.328	24500.0
2021-08-05	AGQ	ETF	43.25	43.31	42.04	42.29	674100.0
2021-08-05	AGZ	ETF	119.18	119.28	119.1401	119.2	15317.0
2021-08-05	AGZD	ETF	23.36	23.46	23.36	23.455	97800.0
2021-08-05	AIA	ETF	84.71	85.085	84.6403	84.89	246540.0
2021-08-05	AIEQ	ETF	41.46	41.9	41.46	41.9	50400.0
2021-08-05	AIQ	ETF	30.75	31.04	30.75	31.04	45613.0
2021-08-05	AIRR	ETF	41.21	41.75	41.16	41.47	30100.0
2021-08-05	AIVI	ETF	43.82	43.82	43.75	43.75	3700.0
2021-08-05	ALTL	ETF	42.68	42.84	42.6067	42.8	14863.0
2021-08-05	ALTY	ETF	13.53	13.64	13.53	13.61	24400.0
2021-08-05	AMJ	ETF	17.75	18.08	17.65	17.72	358242.0
2021-08-05	AMLP	ETF	32.79	33.37	32.52	32.53	2787000.0
2021-08-05	AMNA	ETF	31.8961	31.8961	31.8961	31.8961	1.0

> showing 50 of 2,426 rows — these rows as CSV

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