PREVIEW / etf_daily / 2023-07-05

all etf daily files

  file:    by_date/etf_daily/2023/2023-07-05.parquet
  size:    107 KB
  rows:    3,010

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-05	SPY	ETF	441.91	443.89	441.9	443.13	58418400.0
2023-07-05	QQQ	ETF	368.695	372.01	368.66	370.28	34460883.0
2023-07-05	IWM	ETF	187.13	187.21	185.44	185.78	24092100.0
2023-07-05	DIA	ETF	342.38	343.74	342.25	342.81	2717000.0
2023-07-05	GLD	ETF	179.41	179.42	177.83	177.84	5650600.0
2023-07-05	TLT	ETF	101.89	102.0	100.74	101.11	28170300.0
2023-07-05	AAA	ETF	24.599	24.599	24.56	24.56	400.0
2023-07-05	AAAU	ETF	19.15	19.15	18.98	18.99	758000.0
2023-07-05	AADR	ETF	49.09	49.2	49.0	49.2	1900.0
2023-07-05	AAPB	ETF	28.76	28.991	28.5	28.68	13826.0
2023-07-05	AAPD	ETF	20.29	20.405	20.1701	20.35	142298.0
2023-07-05	AAPU	ETF	28.62	28.88	28.36	28.53	127506.0
2023-07-05	AAXJ	ETF	66.83	66.91	66.64	66.7	847800.0
2023-07-05	ABEQ	ETF	28.02	28.08	28.02	28.05	10500.0
2023-07-05	ACES	ETF	45.97	46.35	45.46	45.93	65700.0
2023-07-05	ACIO	ETF	31.09	31.17	31.09	31.14	12000.0
2023-07-05	ACSI	ETF	47.124	47.124	47.124	47.124	100.0
2023-07-05	ACT	ETF	25.51	25.665	25.39	25.48	231793.0
2023-07-05	ACTV	ETF	31.51	31.51	31.304	31.331	12800.0
2023-07-05	ACTX	ETF	0.0401	0.0401	0.0401	0.0401	215.0
2023-07-05	ACVF	ETF	33.79	33.88	33.79	33.802	4300.0
2023-07-05	ACWF	ETF	35.24	35.33	35.24	35.2783	7113.0
2023-07-05	ACWI	ETF	95.68	95.85	95.53	95.7	3163500.0
2023-07-05	ACWV	ETF	97.84	97.86	97.59	97.77	337600.0
2023-07-05	ACWX	ETF	49.1	49.1	48.86	48.92	917600.0
2023-07-05	ADFI	ETF	8.43	8.43	8.41	8.425	17000.0
2023-07-05	ADIV	ETF	13.58	13.59	13.561	13.561	600.0
2023-07-05	ADME	ETF	36.23	36.42	36.23	36.39	5200.0
2023-07-05	ADPV	ETF	24.6106	24.71	24.6106	24.6625	13077.0
2023-07-05	AEMB	ETF	37.55	37.55	37.47	37.51	600.0
2023-07-05	AESR	ETF	12.82	12.86	12.79	12.84	40500.0
2023-07-05	AFIF	ETF	8.69	8.87	8.69	8.82	451900.0
2023-07-05	AFK	ETF	15.0	15.0	14.63	14.85	5100.0
2023-07-05	AFLG	ETF	25.364	25.364	25.364	25.364	100.0
2023-07-05	AFMC	ETF	24.75	24.75	24.721	24.721	200.0
2023-07-05	AFSM	ETF	24.629	24.643	24.54	24.571	7700.0
2023-07-05	AFTY	ETF	14.82	14.83	14.811	14.811	3100.0
2023-07-05	AGG	ETF	97.51	97.53	97.05	97.14	6046200.0
2023-07-05	AGGH	ETF	22.83	22.83	22.3	22.3909	21792.0
2023-07-05	AGGY	ETF	42.96	42.98	42.77	42.825	145800.0
2023-07-05	AGNG	ETF	27.51	27.53	27.47	27.47	1800.0
2023-07-05	AGOV	ETF	75.13	75.13	75.13	75.13	3.0
2023-07-05	AGOX	ETF	23.33	23.43	23.3	23.335	24300.0
2023-07-05	AGQ	ETF	28.1	28.14	27.51	27.84	712500.0
2023-07-05	AGZ	ETF	106.52	106.58	106.35	106.39	18300.0
2023-07-05	AGZD	ETF	22.085	22.145	22.085	22.105	18200.0
2023-07-05	AHYB	ETF	43.7	43.7	43.54	43.645	700.0
2023-07-05	AIA	ETF	59.92	60.05	59.76	59.88	22400.0
2023-07-05	AIEQ	ETF	31.59	31.733	31.517	31.64	12400.0
2023-07-05	AIQ	ETF	27.91	28.085	27.88	28.01	425900.0

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

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