PREVIEW / etf_daily / 2023-06-22

all etf daily files

  file:    by_date/etf_daily/2023/2023-06-22.parquet
  size:    109 KB
  rows:    2,951

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
2023-06-22	SPY	ETF	433.95	436.62	433.6	436.51	70637200.0
2023-06-22	QQQ	ETF	360.63	366.33	360.22	366.17	47603043.0
2023-06-22	IWM	ETF	184.2	184.25	182.49	183.33	27063700.0
2023-06-22	DIA	ETF	338.94	339.93	338.24	339.34	2605500.0
2023-06-22	GLD	ETF	178.36	178.99	177.63	177.71	7945000.0
2023-06-22	TLT	ETF	102.8	103.25	102.2	102.31	23630700.0
2023-06-22	AAA	ETF	24.6699	24.6699	24.625	24.625	191.0
2023-06-22	AAAU	ETF	19.04	19.11	18.96	18.98	1368900.0
2023-06-22	AADR	ETF	49.28	49.42	49.19	49.38	2200.0
2023-06-22	AAPB	ETF	27.11	27.63	27.11	27.63	12260.0
2023-06-22	AAPD	ETF	21.16	21.16	20.765	20.79	72018.0
2023-06-22	AAPU	ETF	26.89	27.62	26.89	27.62	102288.0
2023-06-22	AAXJ	ETF	66.6	66.97	66.54	66.88	264000.0
2023-06-22	ABEQ	ETF	28.08	28.19	28.07	28.18	2100.0
2023-06-22	ACES	ETF	43.98	44.0	43.225	43.59	40200.0
2023-06-22	ACIO	ETF	30.85	30.9	30.78	30.86	46600.0
2023-06-22	ACSI	ETF	46.14	46.2476	46.14	46.2476	1036.0
2023-06-22	ACT	ETF	24.96	25.1	24.56	24.85	183366.0
2023-06-22	ACTV	ETF	30.72	30.84	30.72	30.7635	8917.0
2023-06-22	ACVF	ETF	33.26	33.35	33.2	33.346	5800.0
2023-06-22	ACWF	ETF	34.776	34.97	34.776	34.92	16905.0
2023-06-22	ACWI	ETF	94.52	94.9	94.4	94.89	1609700.0
2023-06-22	ACWV	ETF	97.73	97.77	97.45	97.75	95300.0
2023-06-22	ACWX	ETF	48.95	49.11	48.935	49.06	781817.0
2023-06-22	ADFI	ETF	8.45	8.45	8.421	8.43	17400.0
2023-06-22	ADIV	ETF	13.6	13.621	13.6	13.621	900.0
2023-06-22	ADME	ETF	35.919	36.0	35.86	35.993	3700.0
2023-06-22	ADPV	ETF	24.0	24.01	23.98	23.9855	16480.0
2023-06-22	AEMB	ETF	37.675	37.675	37.675	37.675	100.0
2023-06-22	AESR	ETF	12.6	12.69	12.53	12.69	48000.0
2023-06-22	AFIF	ETF	8.805	8.84	8.78	8.79	97306.0
2023-06-22	AFK	ETF	15.05	15.05	14.75	14.8	10501.0
2023-06-22	AFLG	ETF	24.927	24.927	24.927	24.927	100.0
2023-06-22	AFMC	ETF	24.087	24.087	24.087	24.087	100.0
2023-06-22	AFSM	ETF	24.36	24.36	24.281	24.281	200.0
2023-06-22	AFTY	ETF	14.99	14.99	14.92	14.92	9800.0
2023-06-22	AGG	ETF	98.17	98.33	97.92	97.97	7147600.0
2023-06-22	AGGH	ETF	22.71	22.71	22.6845	22.7002	1748.0
2023-06-22	AGGY	ETF	43.25	43.29	43.125	43.18	84000.0
2023-06-22	AGNG	ETF	28.1	28.12	28.05	28.12	700.0
2023-06-22	AGOV	ETF	75.245	75.245	75.245	75.245	107.0
2023-06-22	AGOX	ETF	23.01	23.12	22.98	23.05	71000.0
2023-06-22	AGQ	ETF	26.25	26.47	25.84	26.04	757200.0
2023-06-22	AGZ	ETF	107.16	107.185	107.025	107.05	10851.0
2023-06-22	AGZD	ETF	22.01	22.115	22.01	22.06	50600.0
2023-06-22	AHYB	ETF	43.575	43.575	43.575	43.575	100.0
2023-06-22	AIA	ETF	60.09	60.58	60.09	60.47	38735.0
2023-06-22	AIEQ	ETF	30.71	30.71	30.525	30.64	24800.0
2023-06-22	AIQ	ETF	27.37	27.74	27.34	27.74	474062.0
2023-06-22	AIRR	ETF	52.26	52.26	51.73	51.87	42700.0

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

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