PREVIEW / etf_daily / 2023-05-11

all etf daily files

  file:    by_date/etf_daily/2023/2023-05-11.parquet
  size:    109 KB
  rows:    2,958

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-05-11	SPY	ETF	411.95	412.43	409.97	412.13	70157100.0
2023-05-11	QQQ	ETF	325.7	326.75	324.12	326.2	44278548.0
2023-05-11	IWM	ETF	173.22	173.78	172.11	173.07	25884600.0
2023-05-11	DIA	ETF	333.74	333.87	331.47	333.33	2744700.0
2023-05-11	GLD	ETF	188.44	188.81	186.86	187.13	8245500.0
2023-05-11	TLT	ETF	105.3	105.52	104.72	105.15	19147200.0
2023-05-11	AAA	ETF	24.545	24.545	24.545	24.545	87.0
2023-05-11	AAAU	ETF	20.11	20.14	19.95	19.97	960100.0
2023-05-11	AADR	ETF	47.18	47.47	47.18	47.47	800.0
2023-05-11	AAPB	ETF	24.411	24.56	24.411	24.56	4061.0
2023-05-11	AAPD	ETF	22.45	22.6799	22.39	22.46	102733.0
2023-05-11	AAPU	ETF	25.06	25.18	24.7182	25.0	104394.0
2023-05-11	AAXJ	ETF	66.15	66.19	65.7	66.16	514700.0
2023-05-11	ABEQ	ETF	28.46	28.52	28.46	28.51	8700.0
2023-05-11	ACES	ETF	42.08	42.317	41.82	41.96	29600.0
2023-05-11	ACIO	ETF	30.04	30.12	30.004	30.094	68300.0
2023-05-11	ACSI	ETF	43.8889	43.8889	43.8889	43.8889	80.0
2023-05-11	ACT	ETF	23.84	24.0	23.36	23.72	463216.0
2023-05-11	ACTV	ETF	28.431	28.5811	28.431	28.5811	3554.0
2023-05-11	ACTX	ETF	0.3	0.3	0.3	0.3	343.0
2023-05-11	ACVF	ETF	31.0	31.1	31.0	31.09	3100.0
2023-05-11	ACWF	ETF	33.82	33.9572	33.82	33.9572	1141.0
2023-05-11	ACWI	ETF	91.84	91.99	91.43	91.96	3497500.0
2023-05-11	ACWV	ETF	99.93	99.93	99.39	99.75	77700.0
2023-05-11	ACWX	ETF	49.34	49.48	49.13	49.48	2081165.0
2023-05-11	ADFI	ETF	8.55	8.56	8.53	8.545	15300.0
2023-05-11	ADIV	ETF	13.591	13.591	13.591	13.591	100.0
2023-05-11	ADME	ETF	34.65	34.75	34.57	34.75	12900.0
2023-05-11	ADPV	ETF	23.02	23.0424	23.02	23.0424	966.0
2023-05-11	AEMB	ETF	37.71	37.79	37.71	37.75	1200.0
2023-05-11	AESR	ETF	12.02	12.028	11.985	12.02	13200.0
2023-05-11	AFIF	ETF	8.8734	8.88	8.85	8.8645	5892.0
2023-05-11	AFK	ETF	15.22	15.22	15.0	15.0	24638.0
2023-05-11	AFMC	ETF	22.59	22.648	22.59	22.648	200.0
2023-05-11	AFSM	ETF	22.52	22.582	22.52	22.582	100.0
2023-05-11	AFTY	ETF	16.053	16.053	16.053	16.053	200.0
2023-05-11	AGG	ETF	100.11	100.19	99.88	99.95	7703800.0
2023-05-11	AGGH	ETF	23.21	23.21	23.1758	23.1758	1088.0
2023-05-11	AGGY	ETF	43.97	43.99	43.88	43.9	53800.0
2023-05-11	AGNG	ETF	28.36	28.36	28.25	28.336	3500.0
2023-05-11	AGOV	ETF	77.135	77.135	77.135	77.135	43.0
2023-05-11	AGOX	ETF	21.66	21.66	21.44	21.536	16000.0
2023-05-11	AGQ	ETF	32.18	32.45	30.85	30.93	2284200.0
2023-05-11	AGZ	ETF	108.89	108.98	108.8	108.82	29223.0
2023-05-11	AGZD	ETF	21.625	21.74	21.625	21.705	40800.0
2023-05-11	AHYB	ETF	43.75	43.77	43.75	43.77	200.0
2023-05-11	AIA	ETF	57.76	58.22	57.6	58.22	154874.0
2023-05-11	AIEQ	ETF	27.89	28.06	27.7	27.79	9100.0
2023-05-11	AIQ	ETF	24.03	24.11	23.8	23.97	50031.0
2023-05-11	AIRR	ETF	46.26	46.488	46.06	46.39	23400.0

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

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