PREVIEW / etf_daily / 2024-02-07

all etf daily files

  file:    by_date/etf_daily/2024/2024-02-07.parquet
  size:    118 KB
  rows:    3,268

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
2024-02-07	SPY	ETF	496.29	498.53	495.36	498.1	70556500.0
2024-02-07	QQQ	ETF	430.41	432.83	429.09	431.99	37712661.0
2024-02-07	IWM	ETF	194.07	194.15	192.04	193.22	31713900.0
2024-02-07	DIA	ETF	386.39	387.45	385.65	386.67	2797600.0
2024-02-07	GLD	ETF	188.45	189.39	188.28	188.5	6276900.0
2024-02-07	TLT	ETF	94.57	95.23	94.52	94.59	40120200.0
2024-02-07	AAA	ETF	25.07	25.16	25.066	25.105	9800.0
2024-02-07	AAAU	ETF	20.15	20.24	20.13	20.15	1445000.0
2024-02-07	AADR	ETF	56.16	56.16	56.16	56.16	100.0
2024-02-07	AAPB	ETF	22.2	22.2	21.7004	21.89	22487.0
2024-02-07	AAPD	ETF	20.44	20.6699	20.44	20.57	96682.0
2024-02-07	AAPU	ETF	26.75	26.81	26.34	26.47	164566.0
2024-02-07	AAPX	ETF	25.9932	25.9932	25.4713	25.557	3357.0
2024-02-07	AAPY	ETF	26.03	26.0678	26.0299	26.0678	300.0
2024-02-07	AAXJ	ETF	65.08	65.31	64.96	65.14	370100.0
2024-02-07	ABCS	ETF	26.97	26.97	24.94	24.9544	23733.0
2024-02-07	ABEQ	ETF	28.672	28.69	28.61	28.61	7000.0
2024-02-07	ACES	ETF	30.46	30.57	29.86	30.34	57200.0
2024-02-07	ACIO	ETF	34.39	34.526	34.39	34.49	111400.0
2024-02-07	ACSI	ETF	50.071	50.071	50.071	50.071	100.0
2024-02-07	ACT	ETF	27.72	27.96	26.22	26.45	572043.0
2024-02-07	ACTV	ETF	32.71	32.72	32.53	32.562	6600.0
2024-02-07	ACVF	ETF	38.0	38.14	38.0	38.139	4500.0
2024-02-07	ACWF	ETF	39.12	39.285	39.12	39.2498	8811.0
2024-02-07	ACWI	ETF	104.12	104.56	104.06	104.47	2348400.0
2024-02-07	ACWV	ETF	102.33	102.44	102.2	102.26	86800.0
2024-02-07	ACWX	ETF	50.63	50.7	50.53	50.65	1317800.0
2024-02-07	ADFI	ETF	8.55	8.6	8.51	8.58	32000.0
2024-02-07	ADIV	ETF	13.83	13.87	13.83	13.844	2400.0
2024-02-07	ADME	ETF	39.87	40.176	39.87	40.142	12800.0
2024-02-07	ADPV	ETF	25.77	26.08	25.7101	25.9768	4767.0
2024-02-07	ADVE	ETF	31.52	31.57	31.52	31.57	2500.0
2024-02-07	AEMB	ETF	37.72	37.72	37.698	37.698	300.0
2024-02-07	AESR	ETF	14.6	14.69	14.6	14.69	35400.0
2024-02-07	AETH	ETF	33.35	33.5183	32.49	33.5183	1287.0
2024-02-07	AFIF	ETF	9.11	9.14	9.11	9.13	8100.0
2024-02-07	AFK	ETF	13.35	13.35	13.18	13.23	9900.0
2024-02-07	AFLG	ETF	28.637	28.657	28.637	28.657	400.0
2024-02-07	AFMC	ETF	26.99	26.99	26.922	26.922	600.0
2024-02-07	AFSM	ETF	26.812	26.812	26.812	26.812	100.0
2024-02-07	AFTY	ETF	13.44	13.44	13.38	13.413	1100.0
2024-02-07	AGG	ETF	97.99	98.28	97.94	97.96	8785200.0
2024-02-07	AGGH	ETF	21.75	21.75	21.65	21.66	66391.0
2024-02-07	AGGY	ETF	43.47	43.59	43.43	43.43	91500.0
2024-02-07	AGNG	ETF	28.74	28.75	28.64	28.647	4300.0
2024-02-07	AGOX	ETF	24.37	24.73	24.37	24.713	32700.0
2024-02-07	AGQ	ETF	23.58	23.82	23.33	23.34	1276700.0
2024-02-07	AGQI	ETF	13.39	13.43	13.39	13.4294	40779.0
2024-02-07	AGZ	ETF	108.05	108.16	107.84	107.91	271600.0
2024-02-07	AGZD	ETF	21.95	21.98	21.84	21.98	15400.0

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

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