PREVIEW / etf_daily / 2023-09-27

all etf daily files

  file:    by_date/etf_daily/2023/2023-09-27.parquet
  size:    110 KB
  rows:    3,052

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-27	SPY	ETF	427.09	427.67	422.29	426.05	104705800.0
2023-09-27	QQQ	ETF	355.38	356.98	351.36	355.04	56065972.0
2023-09-27	IWM	ETF	175.45	176.93	174.46	175.99	37293000.0
2023-09-27	DIA	ETF	336.88	337.15	332.93	335.43	4442200.0
2023-09-27	GLD	ETF	175.27	175.32	173.7	174.1	10919600.0
2023-09-27	TLT	ETF	89.54	89.62	88.09	88.41	47111200.0
2023-09-27	AAA	ETF	24.87	24.92	24.87	24.9	1700.0
2023-09-27	AAAU	ETF	18.72	18.72	18.55	18.6	972100.0
2023-09-27	AADR	ETF	48.54	48.62	48.53	48.62	600.0
2023-09-27	AAPB	ETF	23.11	23.11	22.45	22.73	13343.0
2023-09-27	AAPD	ETF	22.5	22.945	22.49	22.78	461163.0
2023-09-27	AAPU	ETF	23.85	23.89	23.15	23.39	247085.0
2023-09-27	AAXJ	ETF	63.5	63.56	63.05	63.35	376700.0
2023-09-27	ABEQ	ETF	27.52	27.54	27.423	27.423	12500.0
2023-09-27	ACES	ETF	37.79	37.79	36.66	36.94	59100.0
2023-09-27	ACIO	ETF	30.45	30.49	30.29	30.39	62700.0
2023-09-27	ACT	ETF	27.5	27.76	27.42	27.61	212231.0
2023-09-27	ACTV	ETF	30.33	30.43	30.07	30.24	34600.0
2023-09-27	ACVF	ETF	33.06	33.06	32.7	32.908	2400.0
2023-09-27	ACWF	ETF	34.28	34.32	33.985	34.1836	7988.0
2023-09-27	ACWI	ETF	92.38	92.46	91.32	92.06	2563100.0
2023-09-27	ACWV	ETF	96.38	96.38	95.35	95.69	643700.0
2023-09-27	ACWX	ETF	47.08	47.09	46.52	46.8	1780200.0
2023-09-27	ADFI	ETF	8.25	8.25	8.235	8.235	4900.0
2023-09-27	ADME	ETF	35.12	35.12	35.02	35.02	13500.0
2023-09-27	ADPV	ETF	24.0501	24.16	23.97	24.1131	6088.0
2023-09-27	AEMB	ETF	35.835	35.835	35.835	35.835	100.0
2023-09-27	AESR	ETF	12.15	12.18	12.05	12.14	23000.0
2023-09-27	AFIF	ETF	8.94	8.94	8.9	8.92	29200.0
2023-09-27	AFK	ETF	13.87	14.08	13.79	13.79	4600.0
2023-09-27	AFLG	ETF	24.645	24.645	24.61	24.612	1800.0
2023-09-27	AFMC	ETF	23.793	23.793	23.763	23.763	100.0
2023-09-27	AFSM	ETF	24.083	24.083	24.004	24.004	200.0
2023-09-27	AFTY	ETF	14.699	14.699	14.699	14.699	100.0
2023-09-27	AGG	ETF	94.47	94.51	93.66	93.85	14560500.0
2023-09-27	AGGH	ETF	21.5	21.5	21.22	21.22	122911.0
2023-09-27	AGGY	ETF	41.69	41.69	41.36	41.45	94300.0
2023-09-27	AGNG	ETF	26.23	26.23	25.97	26.044	41100.0
2023-09-27	AGOV	ETF	72.6842	72.6842	72.6842	72.6842	64.0
2023-09-27	AGOX	ETF	22.605	22.69	22.5	22.57	18700.0
2023-09-27	AGQ	ETF	25.65	25.83	25.19	25.59	1245300.0
2023-09-27	AGZ	ETF	105.9	105.99	105.63	105.72	10700.0
2023-09-27	AGZD	ETF	22.19	22.27	22.15	22.21	38400.0
2023-09-27	AHYB	ETF	43.45	43.45	43.29	43.29	300.0
2023-09-27	AIA	ETF	55.18	55.23	54.73	55.07	17800.0
2023-09-27	AIEQ	ETF	29.8	29.8	29.43	29.662	17200.0
2023-09-27	AIQ	ETF	26.67	26.77	26.36	26.66	310300.0
2023-09-27	AIRR	ETF	51.48	52.1	51.48	51.865	85000.0
2023-09-27	AIVI	ETF	37.56	37.56	37.25	37.39	5100.0
2023-09-27	AIVL	ETF	88.83	88.95	88.11	88.57	6800.0

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

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