PREVIEW / etf_daily / 2023-06-08

all etf daily files

  file:    by_date/etf_daily/2023/2023-06-08.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-08	SPY	ETF	426.62	429.6	425.82	429.13	61952800.0
2023-06-08	QQQ	ETF	349.12	353.62	348.89	353.15	47153922.0
2023-06-08	IWM	ETF	186.75	187.38	184.91	186.54	34185000.0
2023-06-08	DIA	ETF	337.23	339.26	336.75	338.81	2700300.0
2023-06-08	GLD	ETF	182.0	183.04	181.96	182.53	6394100.0
2023-06-08	TLT	ETF	100.87	102.14	100.8	102.06	23845100.0
2023-06-08	AAA	ETF	24.5485	24.5485	24.505	24.505	1255.0
2023-06-08	AAAU	ETF	19.43	19.53	19.43	19.48	1418700.0
2023-06-08	AADR	ETF	48.87	48.88	48.76	48.88	800.0
2023-06-08	AAPB	ETF	25.545	26.12	25.499	26.1	14732.0
2023-06-08	AAPD	ETF	22.01	22.06	21.6899	21.705	72093.0
2023-06-08	AAPU	ETF	25.81	26.45	25.75	26.42	128628.0
2023-06-08	AAXJ	ETF	66.63	67.15	66.63	67.06	696100.0
2023-06-08	ABEQ	ETF	28.18	28.278	28.18	28.278	9100.0
2023-06-08	ACES	ETF	45.14	45.29	44.85	45.11	37000.0
2023-06-08	ACIO	ETF	30.26	30.51	30.26	30.51	44800.0
2023-06-08	ACSI	ETF	45.51	45.6461	45.51	45.6461	192.0
2023-06-08	ACT	ETF	26.27	26.27	25.85	25.88	148467.0
2023-06-08	ACTV	ETF	30.7893	31.03	30.7893	30.9816	12753.0
2023-06-08	ACTX	ETF	0.285	0.285	0.0501	0.285	2122.0
2023-06-08	ACVF	ETF	32.45	32.66	32.45	32.628	8700.0
2023-06-08	ACWF	ETF	34.22	34.445	34.22	34.4418	6490.0
2023-06-08	ACWI	ETF	92.95	93.61	92.84	93.51	3750500.0
2023-06-08	ACWV	ETF	96.18	97.05	96.06	97.05	410100.0
2023-06-08	ACWX	ETF	48.54	48.85	48.5	48.82	1087463.0
2023-06-08	ADFI	ETF	8.445	8.46	8.43	8.445	24400.0
2023-06-08	ADIV	ETF	13.72	13.72	13.72	13.72	100.0
2023-06-08	ADME	ETF	35.24	35.42	35.24	35.4	3600.0
2023-06-08	ADPV	ETF	23.83	23.8839	23.83	23.8839	152.0
2023-06-08	AEMB	ETF	37.305	37.305	37.305	37.305	100.0
2023-06-08	AESR	ETF	12.24	12.342	12.24	12.33	24400.0
2023-06-08	AFIF	ETF	8.79	8.85	8.79	8.835	3346.0
2023-06-08	AFK	ETF	15.48	15.59	15.48	15.4802	12753.0
2023-06-08	AFLG	ETF	24.482	24.544	24.48	24.544	1300.0
2023-06-08	AFMC	ETF	23.93	24.022	23.93	24.022	200.0
2023-06-08	AFSM	ETF	24.382	24.382	24.382	24.382	100.0
2023-06-08	AFTY	ETF	14.86	15.003	14.86	15.003	700.0
2023-06-08	AGG	ETF	97.8	98.21	97.77	98.2	5041900.0
2023-06-08	AGGH	ETF	22.72	22.72	22.715	22.715	1598.0
2023-06-08	AGGY	ETF	43.0	43.175	42.99	43.17	65300.0
2023-06-08	AGNG	ETF	27.58	27.745	27.58	27.745	3300.0
2023-06-08	AGOV	ETF	75.74	76.8644	75.04	76.8644	523.0
2023-06-08	AGOX	ETF	22.57	22.75	22.54	22.7	37800.0
2023-06-08	AGQ	ETF	30.18	31.12	30.18	30.94	940400.0
2023-06-08	AGZ	ETF	107.17	107.34	107.17	107.325	16505.0
2023-06-08	AGZD	ETF	21.94	21.945	21.915	21.93	22400.0
2023-06-08	AHOY	ETF	19.74	19.7931	19.74	19.7931	145.0
2023-06-08	AHYB	ETF	43.735	43.735	43.735	43.735	300.0
2023-06-08	AIA	ETF	59.96	60.72	59.96	60.67	479247.0
2023-06-08	AIEQ	ETF	30.94	31.05	30.714	30.96	34500.0

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

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