PREVIEW / etf_daily / 2022-06-22

all etf daily files

  file:    by_date/etf_daily/2022/2022-06-22.parquet
  size:    102 KB
  rows:    2,745

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-22	SPY	ETF	370.62	378.72	370.18	374.39	90059400.0
2022-06-22	QQQ	ETF	278.52	285.18	277.91	280.67	67472924.0
2022-06-22	IWM	ETF	165.96	169.26	165.37	167.82	29303500.0
2022-06-22	DIA	ETF	301.53	307.68	301.33	304.61	6361200.0
2022-06-22	GLD	ETF	171.61	172.3	171.1	171.31	6558700.0
2022-06-22	TLT	ETF	112.69	113.31	112.38	113.21	23703800.0
2022-06-22	AAA	ETF	24.415	24.415	24.28	24.415	636.0
2022-06-22	AAAU	ETF	18.27	18.35	18.24	18.25	1310300.0
2022-06-22	AADR	ETF	49.05	49.12	48.68	48.82	2600.0
2022-06-22	AAXJ	ETF	67.93	68.4	67.69	67.94	788800.0
2022-06-22	ABEQ	ETF	26.6	27.12	26.6	26.983	22800.0
2022-06-22	ACES	ETF	48.81	50.39	48.69	49.69	159400.0
2022-06-22	ACIO	ETF	28.36	28.72	28.36	28.56	43800.0
2022-06-22	ACSI	ETF	41.9844	41.9844	41.9844	41.9844	89.0
2022-06-22	ACT	ETF	20.77	22.0	20.73	20.92	1070266.0
2022-06-22	ACTV	ETF	29.24	29.95	29.24	29.7691	20103.0
2022-06-22	ACTX	ETF	0.8999	0.8999	0.8999	0.8999	505.0
2022-06-22	ACVF	ETF	28.29	28.62	28.25	28.47	2900.0
2022-06-22	ACWF	ETF	30.65	31.07	30.65	30.86	18402.0
2022-06-22	ACWI	ETF	82.77	84.14	82.56	83.28	3650800.0
2022-06-22	ACWV	ETF	91.72	93.28	91.72	92.66	182400.0
2022-06-22	ACWX	ETF	44.45	44.95	44.3689	44.6	3506945.0
2022-06-22	ADFI	ETF	8.49	8.49	8.45	8.479	15400.0
2022-06-22	ADIV	ETF	13.9	14.05	13.9	14.03	4100.0
2022-06-22	ADME	ETF	34.28	34.62	34.27	34.27	63700.0
2022-06-22	ADRE	ETF	38.795	39.19	38.66	38.86	2265.0
2022-06-22	AESR	ETF	10.95	11.1	10.82	11.0	44700.0
2022-06-22	AFIF	ETF	8.89	8.905	8.88	8.8995	34448.0
2022-06-22	AFK	ETF	17.33	17.33	17.0	17.11	5857.0
2022-06-22	AFLG	ETF	22.497	22.497	22.497	22.497	100.0
2022-06-22	AFMC	ETF	20.76	20.76	20.744	20.744	100.0
2022-06-22	AFSM	ETF	21.68	21.68	21.623	21.623	100.0
2022-06-22	AFTY	ETF	18.022	18.022	18.022	18.022	100.0
2022-06-22	AGG	ETF	100.67	100.93	100.67	100.79	9437000.0
2022-06-22	AGGY	ETF	44.38	44.48	44.35	44.35	119500.0
2022-06-22	AGNG	ETF	24.66	24.73	24.6	24.644	900.0
2022-06-22	AGOV	ETF	78.75	80.67	76.8	78.735	4693.0
2022-06-22	AGOX	ETF	20.43	20.52	20.29	20.38	164100.0
2022-06-22	AGQ	ETF	27.86	28.14	27.53	27.64	608700.0
2022-06-22	AGZ	ETF	109.03	109.56	109.03	109.45	68344.0
2022-06-22	AGZD	ETF	23.005	23.005	22.85	22.97	125800.0
2022-06-22	AHHX	ETF	8.49	8.49	8.468	8.4738	1060.0
2022-06-22	AHYB	ETF	42.88	42.951	42.872	42.872	1100.0
2022-06-22	AIA	ETF	61.97	62.46	61.967	62.18	25457.0
2022-06-22	AIEQ	ETF	30.27	30.91	30.27	30.838	15100.0
2022-06-22	AIQ	ETF	20.75	21.26	20.75	20.92	19437.0
2022-06-22	AIRR	ETF	36.6	37.09	36.6	37.001	10200.0
2022-06-22	AIVI	ETF	36.3	36.56	36.3	36.42	2800.0
2022-06-22	AIVL	ETF	86.98	88.45	86.98	87.95	4400.0
2022-06-22	ALTL	ETF	39.27	39.9852	39.2437	39.66	105024.0

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

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