PREVIEW / etf_daily / 2021-07-16

all etf daily files

  file:    by_date/etf_daily/2021/2021-07-16.parquet
  size:    91 KB
  rows:    2,416

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-07-16	SPY	ETF	436.01	436.06	430.92	431.34	75874700.0
2021-07-16	QQQ	ETF	361.4	362.41	357.24	357.6	47261961.0
2021-07-16	IWM	ETF	219.83	219.88	214.47	214.95	36620200.0
2021-07-16	DIA	ETF	350.72	350.74	346.34	346.74	5710400.0
2021-07-16	GLD	ETF	170.65	170.95	169.28	169.41	9460300.0
2021-07-16	TLT	ETF	147.34	148.34	147.32	148.21	12787900.0
2021-07-16	AAA	ETF	25.014	25.014	25.01	25.01	1025.0
2021-07-16	AAAU	ETF	18.15	18.17	18.0	18.01	258800.0
2021-07-16	AADR	ETF	64.81	64.81	64.15	64.15	500.0
2021-07-16	AAXJ	ETF	92.5	92.63	91.62	91.81	134100.0
2021-07-16	ABEQ	ETF	27.46	27.46	27.32	27.342	2500.0
2021-07-16	ACES	ETF	69.17	69.17	67.67	67.9	49100.0
2021-07-16	ACIO	ETF	30.756	30.76	30.62	30.65	22600.0
2021-07-16	ACSI	ETF	50.97	50.97	50.3321	50.3321	862.0
2021-07-16	ACTV	ETF	37.7	37.71	37.38	37.3873	2918.0
2021-07-16	ACVF	ETF	32.22	32.23	31.918	31.923	3000.0
2021-07-16	ACWF	ETF	37.885	37.885	37.611	37.611	10593.0
2021-07-16	ACWI	ETF	101.95	101.97	100.87	100.97	2193400.0
2021-07-16	ACWV	ETF	104.39	104.72	104.25	104.25	123600.0
2021-07-16	ACWX	ETF	57.07	57.12	56.54	56.59	1163403.0
2021-07-16	ADFI	ETF	9.75	9.77	9.75	9.75	1900.0
2021-07-16	ADIV	ETF	18.32	18.32	18.32	18.32	500.0
2021-07-16	ADME	ETF	40.435	40.435	40.22	40.23	15400.0
2021-07-16	ADRE	ETF	55.94	55.94	54.9499	54.9499	7634.0
2021-07-16	AESR	ETF	13.811	13.811	13.658	13.658	11400.0
2021-07-16	AFIF	ETF	9.7	9.7	9.67	9.6949	72344.0
2021-07-16	AFK	ETF	21.78	21.78	21.3701	21.45	9221.0
2021-07-16	AFLG	ETF	25.57	25.57	25.417	25.417	600.0
2021-07-16	AFMC	ETF	24.8	24.8	24.538	24.538	900.0
2021-07-16	AFSM	ETF	25.32	25.32	25.037	25.037	600.0
2021-07-16	AFTY	ETF	22.27	22.27	22.15	22.203	4900.0
2021-07-16	AGG	ETF	115.77	115.96	115.76	115.9	3869500.0
2021-07-16	AGGY	ETF	52.6	52.68	52.6	52.63	49500.0
2021-07-16	AGNG	ETF	30.27	30.289	30.19	30.28	3100.0
2021-07-16	AGOX	ETF	26.1	26.1	25.542	25.542	3300.0
2021-07-16	AGQ	ETF	45.7	45.94	43.96	44.14	1370400.0
2021-07-16	AGZ	ETF	118.82	118.93	118.82	118.909	14391.0
2021-07-16	AGZD	ETF	23.49	23.51	23.43	23.48	31000.0
2021-07-16	AIA	ETF	89.9	89.96	88.79	88.91	55393.0
2021-07-16	AIEQ	ETF	39.91	40.0	39.55	39.623	27500.0
2021-07-16	AIQ	ETF	30.49	30.55	30.1	30.11	23765.0
2021-07-16	AIRR	ETF	40.225	40.302	39.409	39.42	26600.0
2021-07-16	AIVI	ETF	43.35	43.37	43.21	43.25	2600.0
2021-07-16	ALTL	ETF	42.49	42.8	42.344	42.45	12719.0
2021-07-16	ALTY	ETF	13.51	13.54	13.48	13.48	4900.0
2021-07-16	AMJ	ETF	18.62	18.63	18.14	18.18	366928.0
2021-07-16	AMLP	ETF	34.5	34.6	33.58	33.73	2248800.0
2021-07-16	AMNA	ETF	32.19	32.19	32.19	32.19	0.0
2021-07-16	AMND	ETF	33.8722	33.8722	33.8722	33.8722	2.0
2021-07-16	AMOM	ETF	36.08	36.08	35.37	35.58	19400.0

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

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