PREVIEW / etf_daily / 2023-07-10

all etf daily files

  file:    by_date/etf_daily/2023/2023-07-10.parquet
  size:    107 KB
  rows:    2,976

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-07-10	SPY	ETF	438.18	439.84	437.59	439.66	62443500.0
2023-07-10	QQQ	ETF	365.96	367.05	363.41	366.36	48498800.0
2023-07-10	IWM	ETF	184.58	188.05	184.16	187.87	29725100.0
2023-07-10	DIA	ETF	337.4	339.65	337.17	339.58	2560200.0
2023-07-10	GLD	ETF	178.37	178.92	178.26	178.78	3320500.0
2023-07-10	TLT	ETF	98.86	99.53	98.85	99.21	24665200.0
2023-07-10	AAA	ETF	24.82	24.82	24.62	24.62	1400.0
2023-07-10	AAAU	ETF	19.05	19.1	19.04	19.09	706600.0
2023-07-10	AADR	ETF	48.74	48.77	48.67	48.67	4700.0
2023-07-10	AAPB	ETF	28.05	28.12	27.5	27.9	88876.0
2023-07-10	AAPD	ETF	20.55	20.815	20.51	20.66	130952.0
2023-07-10	AAPU	ETF	28.05	28.16	27.54	27.9	258804.0
2023-07-10	AAXJ	ETF	65.7	66.23	65.69	66.16	2026000.0
2023-07-10	ABEQ	ETF	27.87	27.93	27.8	27.81	10300.0
2023-07-10	ACES	ETF	46.23	47.0	45.58	47.0	330200.0
2023-07-10	ACIO	ETF	30.79	30.87	30.77	30.844	27200.0
2023-07-10	ACSI	ETF	46.62	46.62	46.617	46.617	200.0
2023-07-10	ACT	ETF	25.45	25.8	25.45	25.8	180570.0
2023-07-10	ACTV	ETF	31.919	31.92	31.73	31.836	12500.0
2023-07-10	ACTX	ETF	0.21	0.21	0.21	0.21	363.0
2023-07-10	ACVF	ETF	33.59	33.64	33.54	33.629	11500.0
2023-07-10	ACWF	ETF	34.96	35.0215	34.95	35.0215	2988.0
2023-07-10	ACWI	ETF	94.57	94.97	94.57	94.95	1066400.0
2023-07-10	ACWV	ETF	96.37	97.1	96.37	96.84	122000.0
2023-07-10	ACWX	ETF	48.32	48.57	48.28	48.56	1441900.0
2023-07-10	ADFI	ETF	8.38	8.41	8.38	8.395	13700.0
2023-07-10	ADIV	ETF	13.431	13.431	13.431	13.431	100.0
2023-07-10	ADME	ETF	35.94	36.01	35.851	36.01	12800.0
2023-07-10	ADPV	ETF	24.96	25.15	24.95	25.1384	6124.0
2023-07-10	AEMB	ETF	37.03	37.03	37.03	37.03	100.0
2023-07-10	AESR	ETF	12.7	12.72	12.65	12.72	28000.0
2023-07-10	AFIF	ETF	8.81	8.83	8.8	8.82	20200.0
2023-07-10	AFK	ETF	14.79	14.8	14.45	14.8	12000.0
2023-07-10	AFLG	ETF	25.309	25.309	25.309	25.309	300.0
2023-07-10	AFMC	ETF	24.87	24.9	24.85	24.9	800.0
2023-07-10	AFSM	ETF	24.699	24.7	24.665	24.68	1400.0
2023-07-10	AFTY	ETF	14.74	14.88	14.74	14.875	9200.0
2023-07-10	AGG	ETF	96.57	96.94	96.55	96.8	8827400.0
2023-07-10	AGGH	ETF	22.24	22.4	22.24	22.2862	6139.0
2023-07-10	AGGY	ETF	42.55	42.77	42.55	42.692	838700.0
2023-07-10	AGNG	ETF	27.09	27.3	27.09	27.22	2600.0
2023-07-10	AGOV	ETF	72.36	72.36	72.36	72.36	105.0
2023-07-10	AGOX	ETF	24.99	24.99	23.24	23.31	25400.0
2023-07-10	AGQ	ETF	27.31	27.84	27.3	27.8	668300.0
2023-07-10	AGRH	ETF	25.6299	25.6299	25.59	25.59	1025.0
2023-07-10	AGZ	ETF	106.22	106.45	106.22	106.22	15000.0
2023-07-10	AGZD	ETF	22.09	22.12	22.085	22.095	27400.0
2023-07-10	AHYB	ETF	43.54	43.63	43.54	43.584	2200.0
2023-07-10	AIA	ETF	58.64	59.18	58.64	59.12	24300.0
2023-07-10	AIEQ	ETF	31.41	31.72	31.41	31.66	12800.0

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

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