PREVIEW / etf_daily / 2023-10-06

all etf daily files

  file:    by_date/etf_daily/2023/2023-10-06.parquet
  size:    110 KB
  rows:    3,065

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-10-06	SPY	ETF	421.97	431.13	420.6	429.54	113202700.0
2023-10-06	QQQ	ETF	355.65	365.91	354.85	364.7	75049119.0
2023-10-06	IWM	ETF	170.37	173.89	169.51	173.0	42144700.0
2023-10-06	DIA	ETF	330.35	335.64	328.48	334.1	4488200.0
2023-10-06	GLD	ETF	169.17	170.23	168.5	169.7	9942200.0
2023-10-06	TLT	ETF	84.2	85.69	84.06	84.79	62772200.0
2023-10-06	AAA	ETF	24.82	24.83	24.8	24.8	1800.0
2023-10-06	AAAU	ETF	18.07	18.18	18.0	18.13	1887000.0
2023-10-06	AADR	ETF	48.16	48.58	48.16	48.58	1200.0
2023-10-06	AAPB	ETF	23.53	24.38	23.3301	24.32	11933.0
2023-10-06	AAPD	ETF	22.37	22.41	21.84	21.92	164615.0
2023-10-06	AAPU	ETF	24.09	24.9158	23.98	24.83	115830.0
2023-10-06	AAXJ	ETF	62.87	63.88	62.83	63.75	297800.0
2023-10-06	ABEQ	ETF	26.83	27.15	26.83	27.04	8100.0
2023-10-06	ACES	ETF	32.32	33.645	32.2	33.37	128600.0
2023-10-06	ACIO	ETF	30.04	30.59	29.975	30.475	90000.0
2023-10-06	ACSI	ETF	44.35	44.363	44.34	44.34	800.0
2023-10-06	ACT	ETF	28.01	28.4	27.94	27.97	178893.0
2023-10-06	ACTV	ETF	29.25	29.41	29.075	29.269	4100.0
2023-10-06	ACVF	ETF	32.47	33.19	32.46	33.074	8800.0
2023-10-06	ACWF	ETF	33.85	34.55	33.79	34.4506	5807.0
2023-10-06	ACWI	ETF	90.99	92.76	90.64	92.48	5040300.0
2023-10-06	ACWV	ETF	94.47	95.28	93.84	95.07	138100.0
2023-10-06	ACWX	ETF	46.09	46.83	45.89	46.72	2067700.0
2023-10-06	ADFI	ETF	8.125	8.16	8.125	8.14	11800.0
2023-10-06	ADIV	ETF	13.318	13.318	13.318	13.318	100.0
2023-10-06	ADME	ETF	34.56	35.28	34.54	35.187	24800.0
2023-10-06	ADPV	ETF	24.15	24.15	24.06	24.06	6663.0
2023-10-06	AEMB	ETF	35.12	35.12	35.12	35.12	100.0
2023-10-06	AESR	ETF	12.1	12.37	12.05	12.31	29100.0
2023-10-06	AETH	ETF	24.34	24.641	24.34	24.641	363.0
2023-10-06	AFIF	ETF	8.9	8.92	8.89	8.9	58800.0
2023-10-06	AFK	ETF	13.57	13.57	13.42	13.45	6900.0
2023-10-06	AFMC	ETF	23.55	23.55	23.529	23.529	400.0
2023-10-06	AFTY	ETF	14.629	14.629	14.58	14.584	700.0
2023-10-06	AGG	ETF	92.46	92.98	92.37	92.75	9569500.0
2023-10-06	AGGH	ETF	20.95	21.0917	20.92	21.05	82950.0
2023-10-06	AGGY	ETF	40.95	41.13	40.89	41.09	154900.0
2023-10-06	AGNG	ETF	25.84	25.85	25.8	25.84	2300.0
2023-10-06	AGOV	ETF	72.325	72.325	72.325	72.325	2.0
2023-10-06	AGOX	ETF	22.36	22.82	22.36	22.67	31800.0
2023-10-06	AGQ	ETF	22.84	23.22	21.95	23.05	1629600.0
2023-10-06	AGRH	ETF	25.58	25.58	25.58	25.58	143.0
2023-10-06	AGZ	ETF	105.09	105.29	105.09	105.17	14200.0
2023-10-06	AGZD	ETF	22.14	22.21	22.04	22.14	66000.0
2023-10-06	AHLT	ETF	27.116	27.15	26.4801	26.626	4196.0
2023-10-06	AHYB	ETF	42.865	42.865	42.865	42.865	200.0
2023-10-06	AIA	ETF	54.96	55.96	54.94	55.86	40100.0
2023-10-06	AIEQ	ETF	28.99	29.596	28.84	29.494	7200.0
2023-10-06	AIQ	ETF	26.71	27.46	26.62	27.39	549800.0

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

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