PREVIEW / etf_daily / 2023-11-08

all etf daily files

  file:    by_date/etf_daily/2023/2023-11-08.parquet
  size:    112 KB
  rows:    3,137

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-11-08	SPY	ETF	437.55	438.09	434.87	437.25	61746000.0
2023-11-08	QQQ	ETF	373.08	373.79	370.62	372.94	35663373.0
2023-11-08	IWM	ETF	171.7	172.13	169.3	169.87	44938600.0
2023-11-08	DIA	ETF	342.1	342.59	339.94	341.12	2787900.0
2023-11-08	GLD	ETF	182.01	182.07	180.57	180.77	6738300.0
2023-11-08	TLT	ETF	88.48	89.62	88.45	89.56	53893400.0
2023-11-08	AAA	ETF	24.85	24.89	24.85	24.85	3200.0
2023-11-08	AAAU	ETF	19.45	19.45	19.29	19.32	1429800.0
2023-11-08	AADR	ETF	49.26	49.47	49.26	49.47	1400.0
2023-11-08	AAPB	ETF	25.22	25.37	24.98	25.32	5912.0
2023-11-08	AAPD	ETF	21.39	21.4901	21.29	21.35	136554.0
2023-11-08	AAPU	ETF	25.65	25.9195	25.5303	25.79	108651.0
2023-11-08	AAPY	ETF	26.53	26.53	26.4842	26.4842	218.0
2023-11-08	AAXJ	ETF	64.2	64.4	64.01	64.11	282900.0
2023-11-08	ABEQ	ETF	27.2	27.21	27.143	27.171	3100.0
2023-11-08	ACES	ETF	30.92	30.92	29.81	30.06	355400.0
2023-11-08	ACIO	ETF	31.25	31.44	31.072	31.21	142000.0
2023-11-08	ACSI	ETF	45.956	45.956	45.956	45.956	100.0
2023-11-08	ACT	ETF	27.79	28.14	27.63	27.89	1031511.0
2023-11-08	ACTV	ETF	28.97	28.97	28.66	28.68	10000.0
2023-11-08	ACVF	ETF	33.651	33.67	33.51	33.63	3700.0
2023-11-08	ACWF	ETF	34.9	34.99	34.8203	34.89	14083.0
2023-11-08	ACWI	ETF	93.86	94.06	93.37	93.8	2046600.0
2023-11-08	ACWV	ETF	96.42	96.42	95.86	96.12	101100.0
2023-11-08	ACWX	ETF	47.24	47.37	47.05	47.19	1614000.0
2023-11-08	ADFI	ETF	8.27	8.28	8.25	8.27	23900.0
2023-11-08	ADIV	ETF	13.42	13.43	13.39	13.39	400.0
2023-11-08	ADME	ETF	35.816	35.85	35.55	35.76	58400.0
2023-11-08	ADPV	ETF	22.57	22.5832	22.54	22.5832	3816.0
2023-11-08	AEMB	ETF	35.84	35.989	35.84	35.933	800.0
2023-11-08	AESR	ETF	12.43	12.46	12.43	12.43	54600.0
2023-11-08	AETH	ETF	28.56	28.72	28.42	28.5483	1292.0
2023-11-08	AFIF	ETF	8.94	8.94	8.93	8.93	2700.0
2023-11-08	AFK	ETF	13.61	13.68	13.36	13.36	5600.0
2023-11-08	AFLG	ETF	25.273	25.273	25.273	25.273	100.0
2023-11-08	AFMC	ETF	23.364	23.364	23.364	23.364	100.0
2023-11-08	AFSM	ETF	23.3	23.3	23.271	23.271	700.0
2023-11-08	AFTY	ETF	14.28	14.28	14.28	14.28	100.0
2023-11-08	AGG	ETF	94.27	94.62	94.25	94.53	6932200.0
2023-11-08	AGGH	ETF	21.31	21.4	21.25	21.3	49647.0
2023-11-08	AGGY	ETF	41.74	41.87	41.74	41.83	63200.0
2023-11-08	AGNG	ETF	25.96	25.96	25.701	25.75	900.0
2023-11-08	AGOV	ETF	72.56	73.375	72.56	73.375	632.0
2023-11-08	AGOX	ETF	22.822	22.92	22.78	22.87	38600.0
2023-11-08	AGQ	ETF	25.35	25.65	24.9	25.0	872500.0
2023-11-08	AGZ	ETF	105.97	106.17	105.97	106.08	16800.0
2023-11-08	AGZD	ETF	22.2	22.26	22.09	22.26	65500.0
2023-11-08	AHLT	ETF	25.17	25.19	25.1256	25.1256	2617.0
2023-11-08	AHYB	ETF	43.7	43.7	43.63	43.695	1200.0
2023-11-08	AIA	ETF	56.84	57.13	56.76	56.81	17900.0

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

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