PREVIEW / etf_daily / 2023-03-10

all etf daily files

  file:    by_date/etf_daily/2023/2023-03-10.parquet
  size:    110 KB
  rows:    2,968

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-03-10	SPY	ETF	390.99	393.16	384.32	385.91	189253000.0
2023-03-10	QQQ	ETF	292.83	294.35	287.38	288.55	98593561.0
2023-03-10	IWM	ETF	180.39	180.39	174.26	176.18	69274200.0
2023-03-10	DIA	ETF	322.54	324.87	318.43	319.73	7741600.0
2023-03-10	GLD	ETF	171.93	173.88	171.92	173.87	13803400.0
2023-03-10	TLT	ETF	104.03	105.69	104.0	105.59	43921500.0
2023-03-10	AAA	ETF	24.5601	24.5801	24.54	24.58	1478.0
2023-03-10	AAAU	ETF	18.35	18.55	18.35	18.55	2207600.0
2023-03-10	AADR	ETF	47.32	47.38	47.08	47.08	1300.0
2023-03-10	AAPB	ETF	19.33	19.4503	18.8399	18.97	4759.0
2023-03-10	AAPD	ETF	26.1	26.545	25.98	26.38	156579.0
2023-03-10	AAPU	ETF	20.41	20.54	19.91	20.06	93424.0
2023-03-10	AAXJ	ETF	64.77	65.22	64.55	64.61	737800.0
2023-03-10	ABEQ	ETF	26.99	27.24	26.99	27.114	3700.0
2023-03-10	ACES	ETF	46.62	46.62	44.5	45.02	37200.0
2023-03-10	ACIO	ETF	29.3	29.39	29.195	29.23	34400.0
2023-03-10	ACSI	ETF	42.0395	42.0395	42.0395	42.0395	5.0
2023-03-10	ACT	ETF	23.23	23.23	22.345	22.66	210064.0
2023-03-10	ACTV	ETF	30.18	30.18	29.22	29.49	18757.0
2023-03-10	ACTX	ETF	0.323	0.35	0.321	0.35	4534.0
2023-03-10	ACVF	ETF	30.0	30.02	29.66	29.728	4600.0
2023-03-10	ACWF	ETF	32.37	32.52	31.9815	32.0408	25145.0
2023-03-10	ACWI	ETF	87.39	87.8	86.12	86.36	5485100.0
2023-03-10	ACWV	ETF	92.81	93.25	92.26	92.42	157400.0
2023-03-10	ACWX	ETF	47.22	47.38	46.75	46.79	3023422.0
2023-03-10	ADFI	ETF	8.425	8.425	8.41	8.415	4600.0
2023-03-10	ADIV	ETF	13.475	13.475	13.475	13.475	100.0
2023-03-10	ADME	ETF	33.645	33.727	33.51	33.52	17800.0
2023-03-10	ADPV	ETF	24.37	24.37	23.74	23.8	45098.0
2023-03-10	ADRE	ETF	38.2	38.39	37.84	37.94	5635.0
2023-03-10	AEMB	ETF	37.587	37.587	37.587	37.587	100.0
2023-03-10	AESR	ETF	11.38	11.4	11.25	11.3	27500.0
2023-03-10	AFIF	ETF	8.89	8.89	8.86	8.875	20383.0
2023-03-10	AFK	ETF	15.82	15.95	15.64	15.64	8451.0
2023-03-10	AFLG	ETF	23.044	23.044	23.044	23.044	400.0
2023-03-10	AFMC	ETF	22.52	22.638	22.52	22.638	300.0
2023-03-10	AFSM	ETF	23.17	23.17	23.06	23.06	300.0
2023-03-10	AFTY	ETF	15.842	15.842	15.842	15.842	100.0
2023-03-10	AGG	ETF	97.79	98.32	97.76	98.09	7515700.0
2023-03-10	AGGY	ETF	43.06	43.229	42.99	43.19	1386400.0
2023-03-10	AGNG	ETF	25.578	25.578	25.325	25.325	200.0
2023-03-10	AGOV	ETF	76.145	76.145	76.145	76.145	15.0
2023-03-10	AGOX	ETF	21.07	21.2	20.78	20.8	9600.0
2023-03-10	AGQ	ETF	22.77	23.33	22.45	22.74	1144700.0
2023-03-10	AGRH	ETF	25.4	25.4206	25.4	25.4206	269.0
2023-03-10	AGZ	ETF	106.85	107.23	106.76	107.17	58807.0
2023-03-10	AGZD	ETF	21.825	21.855	21.775	21.775	28800.0
2023-03-10	AHHX	ETF	8.4494	8.45	8.3701	8.4039	2477.0
2023-03-10	AHYB	ETF	43.08	43.08	42.91	42.936	2100.0
2023-03-10	AIA	ETF	57.48	57.92	57.205	57.23	21362.0

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

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