PREVIEW / etf_daily / 2023-10-25

all etf daily files

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

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-25	SPY	ETF	421.89	421.92	417.02	417.55	94223200.0
2023-10-25	QQQ	ETF	356.7	356.88	349.75	350.34	71190536.0
2023-10-25	IWM	ETF	165.01	165.66	163.4	163.72	36832900.0
2023-10-25	DIA	ETF	332.22	332.69	329.83	330.35	3836300.0
2023-10-25	GLD	ETF	183.42	184.3	182.04	183.72	10087000.0
2023-10-25	TLT	ETF	84.02	84.13	83.13	83.45	60737200.0
2023-10-25	AAA	ETF	24.85	24.9	24.85	24.88	2400.0
2023-10-25	AAAU	ETF	19.6	19.68	19.45	19.62	1700300.0
2023-10-25	AADR	ETF	47.86	47.86	47.6	47.6	300.0
2023-10-25	AAPB	ETF	22.92	23.04	22.57	22.68	8148.0
2023-10-25	AAPD	ETF	22.71	22.84	22.5602	22.81	261444.0
2023-10-25	AAPU	ETF	23.6	23.779	23.3605	23.4	77486.0
2023-10-25	AAXJ	ETF	61.89	62.08	61.58	61.67	729100.0
2023-10-25	ABEQ	ETF	27.2	27.3	27.14	27.146	7300.0
2023-10-25	ACES	ETF	30.7	30.77	30.28	30.44	142800.0
2023-10-25	ACIO	ETF	30.07	30.167	29.98	30.02	105700.0
2023-10-25	ACSI	ETF	43.535	43.535	43.535	43.535	100.0
2023-10-25	ACT	ETF	26.93	27.115	26.64	27.0	275879.0
2023-10-25	ACTV	ETF	27.93	27.95	27.71	27.711	8300.0
2023-10-25	ACVF	ETF	32.48	32.48	32.163	32.21	2800.0
2023-10-25	ACWF	ETF	33.63	33.63	33.3816	33.3816	2151.0
2023-10-25	ACWI	ETF	90.61	90.61	89.72	89.83	2571200.0
2023-10-25	ACWV	ETF	94.1	94.47	93.79	94.06	160100.0
2023-10-25	ACWX	ETF	45.59	45.75	45.36	45.39	1427600.0
2023-10-25	ADFI	ETF	8.06	8.09	8.04	8.055	14500.0
2023-10-25	ADIV	ETF	12.85	12.85	12.85	12.85	100.0
2023-10-25	ADME	ETF	34.6	34.65	34.39	34.39	64700.0
2023-10-25	ADPV	ETF	22.405	22.4141	22.405	22.4141	349.0
2023-10-25	AEMB	ETF	35.05	35.09	34.935	34.935	300.0
2023-10-25	AESR	ETF	12.06	12.06	11.83	11.85	20900.0
2023-10-25	AETH	ETF	27.0	27.2875	26.92	26.9648	2676.0
2023-10-25	AFIF	ETF	8.88	8.9	8.88	8.88	3100.0
2023-10-25	AFK	ETF	13.96	13.96	13.45	13.71	8000.0
2023-10-25	AFMC	ETF	22.364	22.45	22.31	22.329	67600.0
2023-10-25	AFSM	ETF	22.52	22.52	22.52	22.52	100.0
2023-10-25	AFTY	ETF	13.79	13.79	13.79	13.79	100.0
2023-10-25	AGG	ETF	92.33	92.35	91.92	92.0	8904400.0
2023-10-25	AGGH	ETF	20.95	20.95	20.82	20.8653	109724.0
2023-10-25	AGGY	ETF	40.82	40.83	40.63	40.67	337200.0
2023-10-25	AGNG	ETF	25.18	25.27	25.01	25.04	1000.0
2023-10-25	AGOV	ETF	72.4	72.4	72.2349	72.2349	306.0
2023-10-25	AGOX	ETF	22.09	22.17	21.95	21.95	151800.0
2023-10-25	AGQ	ETF	25.82	26.19	25.18	25.85	910900.0
2023-10-25	AGZ	ETF	105.17	105.27	105.0	105.19	22200.0
2023-10-25	AGZD	ETF	22.11	22.17	22.06	22.13	22200.0
2023-10-25	AHLT	ETF	26.8	27.19	26.8	27.0786	41418.0
2023-10-25	AHYB	ETF	42.7	42.7	42.56	42.56	300.0
2023-10-25	AIA	ETF	54.69	54.69	54.11	54.23	24900.0
2023-10-25	AIEQ	ETF	29.01	29.01	28.58	28.65	26700.0
2023-10-25	AIQ	ETF	26.38	26.38	25.78	25.85	577200.0

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

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