PREVIEW / etf_daily / 2021-08-04

all etf daily files

  file:    by_date/etf_daily/2021/2021-08-04.parquet
  size:    91 KB
  rows:    2,421

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-04	SPY	ETF	439.78	441.12	438.73	438.98	46732200.0
2021-08-04	QQQ	ETF	366.77	368.32	365.63	367.34	29602236.0
2021-08-04	IWM	ETF	219.1	221.2	217.89	218.11	25588500.0
2021-08-04	DIA	ETF	349.59	350.08	347.88	347.99	3118500.0
2021-08-04	GLD	ETF	171.28	171.4	168.99	169.53	9796300.0
2021-08-04	TLT	ETF	151.5	151.82	149.72	151.06	18267900.0
2021-08-04	AAA	ETF	25.005	25.005	24.9901	25.005	304.0
2021-08-04	AAAU	ETF	18.2	18.22	17.96	18.02	574400.0
2021-08-04	AAXJ	ETF	89.26	89.75	89.13	89.32	1507800.0
2021-08-04	ABEQ	ETF	27.687	27.7	27.616	27.616	7200.0
2021-08-04	ACES	ETF	72.06	72.83	71.67	71.91	29700.0
2021-08-04	ACIO	ETF	30.6	31.355	30.6	30.68	52600.0
2021-08-04	ACSI	ETF	50.5536	50.5536	50.5536	50.5536	49.0
2021-08-04	ACTV	ETF	38.1628	38.1628	37.6859	37.6859	3416.0
2021-08-04	ACTX	ETF	1.995	2.0	1.87	2.0	2021.0
2021-08-04	ACVF	ETF	32.618	32.665	32.59	32.665	4500.0
2021-08-04	ACWF	ETF	38.73	38.8	38.6219	38.6219	15683.0
2021-08-04	ACWI	ETF	102.82	103.02	102.57	102.68	2425600.0
2021-08-04	ACWV	ETF	105.55	105.63	105.04	105.22	116100.0
2021-08-04	ACWX	ETF	57.37	57.51	57.17	57.2	567629.0
2021-08-04	ADFI	ETF	9.79	9.79	9.76	9.775	2300.0
2021-08-04	ADIV	ETF	18.257	18.257	18.257	18.257	100.0
2021-08-04	ADME	ETF	40.365	40.63	40.365	40.54	49200.0
2021-08-04	ADRE	ETF	53.44	54.0	53.44	53.7152	5888.0
2021-08-04	AEMB	ETF	50.057	50.057	50.057	50.057	100.0
2021-08-04	AESR	ETF	13.96	13.97	13.91	13.925	8400.0
2021-08-04	AFIF	ETF	9.73	9.73	9.68	9.705	19799.0
2021-08-04	AFK	ETF	21.89	21.98	21.83	21.836	5075.0
2021-08-04	AFLG	ETF	26.06	26.06	26.034	26.034	500.0
2021-08-04	AFMC	ETF	25.53	25.53	25.378	25.378	100.0
2021-08-04	AFTY	ETF	20.66	20.66	20.57	20.59	11400.0
2021-08-04	AGG	ETF	116.77	116.83	116.3	116.57	4654300.0
2021-08-04	AGGY	ETF	53.06	53.104	52.87	53.01	68800.0
2021-08-04	AGNG	ETF	30.85	30.93	30.83	30.83	17700.0
2021-08-04	AGOV	ETF	100.2	100.2467	100.2	100.2467	455.0
2021-08-04	AGOX	ETF	26.49	26.49	26.15	26.166	13600.0
2021-08-04	AGQ	ETF	45.06	45.24	42.9	43.12	873400.0
2021-08-04	AGZ	ETF	119.41	119.5	119.2637	119.35	18550.0
2021-08-04	AGZD	ETF	23.405	23.455	23.405	23.45	14600.0
2021-08-04	AIA	ETF	84.97	85.645	84.91	85.3	86520.0
2021-08-04	AIEQ	ETF	41.4	41.718	41.4	41.473	6200.0
2021-08-04	AIQ	ETF	30.66	30.84	30.6305	30.83	10537.0
2021-08-04	AIRR	ETF	41.07	41.3	40.94	40.97	22800.0
2021-08-04	AIVI	ETF	44.07	44.07	43.88	43.88	26600.0
2021-08-04	ALTL	ETF	43.79	43.79	42.5958	42.7	24010.0
2021-08-04	ALTY	ETF	13.56	13.608	13.521	13.55	14600.0
2021-08-04	AMJ	ETF	18.08	18.14	17.7	17.71	460285.0
2021-08-04	AMLP	ETF	33.18	33.47	32.61	32.7	3186200.0
2021-08-04	AMNA	ETF	31.898	31.898	31.898	31.898	30.0
2021-08-04	AMND	ETF	33.4348	33.4348	33.4348	33.4348	2.0

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

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