PREVIEW / etf_daily / 2023-09-11

all etf daily files

  file:    by_date/etf_daily/2023/2023-09-11.parquet
  size:    108 KB
  rows:    3,036

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-09-11	SPY	ETF	448.24	448.77	446.47	448.45	60180100.0
2023-09-11	QQQ	ETF	375.66	377.49	373.66	376.97	39936634.0
2023-09-11	IWM	ETF	185.26	185.72	184.2	184.36	17424700.0
2023-09-11	DIA	ETF	348.02	348.59	346.51	347.37	1722900.0
2023-09-11	GLD	ETF	178.97	179.07	178.26	178.41	3689100.0
2023-09-11	TLT	ETF	93.7	93.98	93.55	93.69	17061500.0
2023-09-11	AAA	ETF	24.75	24.75	24.75	24.75	500.0
2023-09-11	AAAU	ETF	19.11	19.13	19.04	19.06	867500.0
2023-09-11	AADR	ETF	50.91	50.91	50.83	50.83	18500.0
2023-09-11	AAPB	ETF	25.21	25.21	24.54	25.0	21279.0
2023-09-11	AAPD	ETF	21.65	22.03	21.65	21.8	129488.0
2023-09-11	AAPU	ETF	25.7	25.7	25.1	25.53	247197.0
2023-09-11	AAXJ	ETF	65.47	65.69	65.3	65.61	202500.0
2023-09-11	ABEQ	ETF	28.04	28.102	28.01	28.01	5900.0
2023-09-11	ACES	ETF	40.59	40.87	40.19	40.67	28000.0
2023-09-11	ACIO	ETF	31.34	31.477	31.34	31.43	60700.0
2023-09-11	ACSI	ETF	45.83	46.226	45.83	46.226	500.0
2023-09-11	ACT	ETF	28.3	28.51	27.87	27.94	232944.0
2023-09-11	ACTV	ETF	31.45	31.45	31.11	31.11	4400.0
2023-09-11	ACVF	ETF	34.67	34.67	34.5	34.621	12200.0
2023-09-11	ACWF	ETF	35.61	35.64	35.5383	35.64	4144.0
2023-09-11	ACWI	ETF	96.08	96.17	95.78	96.15	1015800.0
2023-09-11	ACWV	ETF	97.68	97.9	97.59	97.84	85300.0
2023-09-11	ACWX	ETF	48.43	48.56	48.3	48.53	664000.0
2023-09-11	ADFI	ETF	8.38	8.389	8.36	8.389	17000.0
2023-09-11	ADIV	ETF	13.585	13.585	13.585	13.585	100.0
2023-09-11	ADME	ETF	36.58	36.694	36.56	36.67	29500.0
2023-09-11	ADPV	ETF	25.27	25.34	25.2536	25.2536	1325.0
2023-09-11	AEMB	ETF	36.76	36.76	36.76	36.76	100.0
2023-09-11	AESR	ETF	12.78	12.85	12.78	12.84	45300.0
2023-09-11	AFIF	ETF	8.95	8.96	8.93	8.94	3200.0
2023-09-11	AFK	ETF	14.51	14.73	14.48	14.64	5200.0
2023-09-11	AFLG	ETF	25.58	25.58	25.58	25.58	100.0
2023-09-11	AFMC	ETF	24.601	24.601	24.569	24.569	900.0
2023-09-11	AFSM	ETF	24.538	24.538	24.538	24.538	100.0
2023-09-11	AFTY	ETF	14.967	14.967	14.967	14.967	100.0
2023-09-11	AGG	ETF	95.66	95.73	95.57	95.67	4077200.0
2023-09-11	AGGH	ETF	22.33	22.33	21.935	21.9617	97812.0
2023-09-11	AGGY	ETF	42.28	42.31	42.24	42.26	74800.0
2023-09-11	AGNG	ETF	27.0	27.33	27.0	27.27	9500.0
2023-09-11	AGOV	ETF	73.85	73.85	73.195	73.195	1349.0
2023-09-11	AGOX	ETF	23.37	23.63	22.62	23.53	32500.0
2023-09-11	AGQ	ETF	27.06	27.12	26.56	26.9	663900.0
2023-09-11	AGZ	ETF	106.32	106.36	106.28	106.34	18200.0
2023-09-11	AGZD	ETF	22.25	22.27	22.15	22.25	37300.0
2023-09-11	AHYB	ETF	43.898	43.942	43.898	43.942	500.0
2023-09-11	AIA	ETF	57.76	57.76	57.33	57.58	14300.0
2023-09-11	AIEQ	ETF	31.07	31.18	30.95	30.976	10400.0
2023-09-11	AIQ	ETF	28.62	28.74	28.45	28.7	381000.0
2023-09-11	AIRR	ETF	53.79	53.849	53.38	53.53	33800.0

> showing 50 of 3,036 rows — these rows as CSV

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