PREVIEW / etf_daily / 2021-10-05

all etf daily files

  file:    by_date/etf_daily/2021/2021-10-05.parquet
  size:    95 KB
  rows:    2,523

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-10-05	SPY	ETF	430.24	435.49	429.39	433.1	90682500.0
2021-10-05	QQQ	ETF	353.71	359.69	353.48	357.38	47232904.0
2021-10-05	IWM	ETF	220.96	223.06	219.88	221.02	20407600.0
2021-10-05	DIA	ETF	341.13	344.87	340.47	343.13	3826100.0
2021-10-05	GLD	ETF	163.94	164.85	163.49	164.59	5617300.0
2021-10-05	TLT	ETF	144.6	144.7	143.46	143.58	22659200.0
2021-10-05	AAA	ETF	25.0	25.0	24.99	24.99	2341.0
2021-10-05	AAAU	ETF	17.44	17.54	17.4	17.5	201000.0
2021-10-05	AADR	ETF	62.77	63.3	62.77	63.3	1400.0
2021-10-05	AAXJ	ETF	83.6	84.31	83.6	83.99	717500.0
2021-10-05	ABEQ	ETF	27.085	27.2	27.05	27.168	4600.0
2021-10-05	ACES	ETF	64.84	65.074	64.125	64.54	53900.0
2021-10-05	ACIO	ETF	29.99	30.16	29.99	30.061	15100.0
2021-10-05	ACSI	ETF	49.42	49.6416	49.42	49.6416	1127.0
2021-10-05	ACT	ETF	21.39	21.42	20.15	20.84	113217.0
2021-10-05	ACTV	ETF	38.62	38.7	38.4	38.64	34067.0
2021-10-05	ACTX	ETF	1.05	1.05	1.005	1.005	836.0
2021-10-05	ACVF	ETF	32.1	32.459	32.07	32.34	13400.0
2021-10-05	ACWF	ETF	36.74	37.0615	36.6603	36.83	26911.0
2021-10-05	ACWI	ETF	99.82	100.85	99.67	100.38	3388900.0
2021-10-05	ACWV	ETF	102.36	103.01	102.27	102.66	115800.0
2021-10-05	ACWX	ETF	55.04	55.485	55.0	55.32	1279547.0
2021-10-05	ADFI	ETF	9.66	9.69	9.66	9.67	1400.0
2021-10-05	ADIV	ETF	16.793	16.793	16.793	16.793	100.0
2021-10-05	ADME	ETF	39.62	39.82	39.526	39.68	9800.0
2021-10-05	ADRE	ETF	47.11	47.7239	47.11	47.59	63846.0
2021-10-05	AEMB	ETF	48.8	48.8	48.8	48.8	100.0
2021-10-05	AESR	ETF	13.66	13.82	13.66	13.72	30600.0
2021-10-05	AFIF	ETF	9.65	9.66	9.63	9.64	54208.0
2021-10-05	AFK	ETF	20.85	20.95	20.81	20.8845	4515.0
2021-10-05	AFLG	ETF	25.53	25.53	25.53	25.53	1200.0
2021-10-05	AFMC	ETF	25.205	25.205	25.205	25.205	1000.0
2021-10-05	AFSM	ETF	26.3	26.33	26.297	26.297	1000.0
2021-10-05	AFTY	ETF	20.17	20.17	20.17	20.17	500.0
2021-10-05	AGG	ETF	114.82	114.87	114.61	114.65	7421900.0
2021-10-05	AGGY	ETF	52.01	52.047	51.91	51.93	54900.0
2021-10-05	AGNG	ETF	28.8	29.26	28.642	28.799	3100.0
2021-10-05	AGOV	ETF	99.285	99.285	99.285	99.285	10.0
2021-10-05	AGOX	ETF	25.86	26.02	25.73	25.88	46400.0
2021-10-05	AGQ	ETF	33.03	33.53	32.64	33.38	791000.0
2021-10-05	AGZ	ETF	118.45	118.5115	118.4	118.4	29845.0
2021-10-05	AGZD	ETF	23.435	23.435	23.425	23.425	18000.0
2021-10-05	AIA	ETF	76.33	77.141	76.24	76.82	75950.0
2021-10-05	AIEQ	ETF	40.84	41.5	40.84	41.231	10200.0
2021-10-05	AIQ	ETF	29.69	30.22	29.69	30.07	15975.0
2021-10-05	AIRR	ETF	41.33	41.799	41.27	41.72	16600.0
2021-10-05	AIVI	ETF	40.81	40.99	40.81	40.97	3100.0
2021-10-05	ALTL	ETF	41.47	43.05	40.97	41.1813	27955.0
2021-10-05	ALTY	ETF	13.34	13.34	13.23	13.28	20300.0
2021-10-05	AMJ	ETF	18.96	19.1882	18.5794	18.77	1006337.0

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

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