PREVIEW / etf_daily / 2022-06-16

all etf daily files

  file:    by_date/etf_daily/2022/2022-06-16.parquet
  size:    103 KB
  rows:    2,761

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
2022-06-16	SPY	ETF	370.51	370.94	364.08	366.65	134473300.0
2022-06-16	QQQ	ETF	275.59	276.06	269.28	271.39	81910297.0
2022-06-16	IWM	ETF	167.84	168.42	162.78	163.9	43810600.0
2022-06-16	DIA	ETF	301.37	301.66	298.02	299.9	4943500.0
2022-06-16	GLD	ETF	170.56	172.77	170.17	172.69	8823600.0
2022-06-16	TLT	ETF	108.45	111.72	108.12	111.72	26067300.0
2022-06-16	AAA	ETF	24.46	24.46	24.46	24.46	0.0
2022-06-16	AAAU	ETF	18.16	18.4	18.13	18.4	1254400.0
2022-06-16	AADR	ETF	49.72	49.77	49.29	49.57	7400.0
2022-06-16	AAXJ	ETF	67.59	67.94	67.14	67.56	1474600.0
2022-06-16	ABEQ	ETF	26.79	26.85	26.71	26.81	8500.0
2022-06-16	ACES	ETF	47.86	48.37	45.78	46.28	241400.0
2022-06-16	ACIO	ETF	28.73	28.73	28.158	28.26	28800.0
2022-06-16	ACSI	ETF	40.7101	40.7101	40.6635	40.6635	298.0
2022-06-16	ACT	ETF	22.15	22.97	21.015	21.47	1228041.0
2022-06-16	ACTV	ETF	29.25	29.25	28.65	28.7103	2770.0
2022-06-16	ACTX	ETF	0.95	0.95	0.95	0.95	1501.0
2022-06-16	ACVF	ETF	28.06	28.06	27.718	27.718	6200.0
2022-06-16	ACWF	ETF	31.13	31.13	30.5399	30.619	18432.0
2022-06-16	ACWI	ETF	82.38	82.61	81.46	81.97	3653500.0
2022-06-16	ACWV	ETF	90.66	91.38	90.64	91.04	296100.0
2022-06-16	ACWX	ETF	44.39	44.76	44.2	44.47	5228809.0
2022-06-16	ADFI	ETF	8.405	8.435	8.4	8.435	17700.0
2022-06-16	ADIV	ETF	13.871	13.944	13.871	13.944	200.0
2022-06-16	ADME	ETF	33.96	34.05	33.89	33.974	15100.0
2022-06-16	ADRE	ETF	39.21	39.21	38.68	38.89	6768.0
2022-06-16	AEMB	ETF	38.41	38.42	38.358	38.358	8400.0
2022-06-16	AESR	ETF	10.93	10.93	10.67	10.83	83600.0
2022-06-16	AFIF	ETF	8.89	8.9	8.85	8.89	140731.0
2022-06-16	AFK	ETF	17.65	17.65	17.29	17.46	15195.0
2022-06-16	AFLG	ETF	21.987	21.987	21.987	21.987	100.0
2022-06-16	AFMC	ETF	20.369	20.369	20.369	20.369	200.0
2022-06-16	AFSM	ETF	21.328	21.328	21.328	21.328	100.0
2022-06-16	AFTY	ETF	17.773	17.773	17.773	17.773	2100.0
2022-06-16	AGG	ETF	99.24	100.36	99.14	100.35	9329900.0
2022-06-16	AGGH	ETF	23.32	23.4738	23.32	23.4738	299.0
2022-06-16	AGGY	ETF	43.71	44.25	43.7	44.2	175400.0
2022-06-16	AGNG	ETF	23.389	23.577	23.389	23.54	800.0
2022-06-16	AGOV	ETF	78.7878	78.7878	78.22	78.22	190.0
2022-06-16	AGOX	ETF	20.175	20.259	20.1	20.174	12900.0
2022-06-16	AGQ	ETF	28.15	29.19	27.91	29.13	778100.0
2022-06-16	AGZ	ETF	108.08	108.92	107.97	108.92	71675.0
2022-06-16	AGZD	ETF	22.985	23.05	22.94	23.005	78600.0
2022-06-16	AHHX	ETF	8.49	8.49	8.32	8.3737	5099.0
2022-06-16	AHYB	ETF	42.608	42.786	42.55	42.786	3200.0
2022-06-16	AIA	ETF	62.05	62.19	61.57	61.87	47754.0
2022-06-16	AIEQ	ETF	30.32	30.38	29.744	29.846	11300.0
2022-06-16	AIQ	ETF	20.56	20.64	20.3	20.33	14961.0
2022-06-16	AIRR	ETF	37.72	37.72	36.11	36.26	11100.0
2022-06-16	AIVI	ETF	36.38	36.64	36.29	36.44	2800.0

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

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