PREVIEW / etf_daily / 2023-12-29

all etf daily files

  file:    by_date/etf_daily/2023/2023-12-29.parquet
  size:    116 KB
  rows:    3,230

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-12-29	SPY	ETF	476.49	477.03	473.3	475.31	122234100.0
2023-12-29	QQQ	ETF	411.28	411.64	407.58	409.52	42662120.0
2023-12-29	IWM	ETF	203.48	204.03	200.71	200.71	41475800.0
2023-12-29	DIA	ETF	376.95	377.46	375.27	376.87	3364400.0
2023-12-29	GLD	ETF	190.99	191.64	190.74	191.17	4610300.0
2023-12-29	TLT	ETF	99.13	99.82	98.8	98.88	41601700.0
2023-12-29	AAA	ETF	25.02	25.034	24.96	24.96	6300.0
2023-12-29	AAAU	ETF	20.42	20.49	20.4	20.43	1690000.0
2023-12-29	AADR	ETF	55.96	56.22	55.93	56.22	500.0
2023-12-29	AAPB	ETF	23.2204	23.2204	22.8	22.97	21822.0
2023-12-29	AAPD	ETF	20.04	20.2599	20.0	20.19	231744.0
2023-12-29	AAPU	ETF	27.67	27.77	27.23	27.41	83075.0
2023-12-29	AAXJ	ETF	66.23	66.77	66.23	66.57	481200.0
2023-12-29	ABCS	ETF	25.39	25.39	25.3282	25.3282	297.0
2023-12-29	ABEQ	ETF	28.34	28.4	28.31	28.365	5100.0
2023-12-29	ACES	ETF	36.35	36.37	35.82	35.9	32700.0
2023-12-29	ACIO	ETF	33.253	33.29	33.08	33.16	88600.0
2023-12-29	ACSI	ETF	50.09	50.1	49.968	49.968	2100.0
2023-12-29	ACT	ETF	29.24	29.24	28.89	28.89	105213.0
2023-12-29	ACTV	ETF	33.62	33.62	33.385	33.385	4900.0
2023-12-29	ACVF	ETF	36.58	36.62	36.393	36.484	5300.0
2023-12-29	ACWF	ETF	37.89	37.97	37.785	37.8704	4625.0
2023-12-29	ACWI	ETF	101.97	102.15	101.48	101.77	3341500.0
2023-12-29	ACWV	ETF	99.89	100.38	99.89	100.35	232100.0
2023-12-29	ACWX	ETF	51.04	51.19	50.9	51.04	1309600.0
2023-12-29	ADFI	ETF	8.63	8.63	8.61	8.613	11900.0
2023-12-29	ADIV	ETF	14.01	14.049	13.985	14.03	1200.0
2023-12-29	ADME	ETF	38.545	38.545	38.29	38.444	8800.0
2023-12-29	ADPV	ETF	25.12	25.12	24.8935	24.8935	1730.0
2023-12-29	AEMB	ETF	38.28	38.28	38.19	38.19	500.0
2023-12-29	AESR	ETF	13.88	13.89	13.79	13.81	16800.0
2023-12-29	AETH	ETF	32.97	32.97	32.19	32.2748	5452.0
2023-12-29	AFIF	ETF	9.03	9.06	9.01	9.04	9600.0
2023-12-29	AFK	ETF	13.82	14.14	13.8	13.8	16400.0
2023-12-29	AFLG	ETF	27.41	27.41	27.22	27.33	9200.0
2023-12-29	AFMC	ETF	26.75	26.75	26.698	26.698	300.0
2023-12-29	AFSM	ETF	27.7	27.7	27.368	27.368	700.0
2023-12-29	AFTY	ETF	13.49	13.52	13.49	13.514	2900.0
2023-12-29	AGG	ETF	99.2	99.43	99.13	99.25	7327600.0
2023-12-29	AGGH	ETF	22.07	22.1199	22.06	22.08	96005.0
2023-12-29	AGGY	ETF	44.01	44.065	43.963	44.02	78100.0
2023-12-29	AGNG	ETF	28.467	28.49	28.42	28.44	2000.0
2023-12-29	AGOX	ETF	24.44	24.44	24.25	24.337	86900.0
2023-12-29	AGQ	ETF	26.74	27.59	26.59	27.17	1498000.0
2023-12-29	AGQI	ETF	13.3	13.3	13.2345	13.2646	11116.0
2023-12-29	AGZ	ETF	108.4	108.5	108.12	108.43	25900.0
2023-12-29	AGZD	ETF	21.83	21.96	21.76	21.92	63100.0
2023-12-29	AHLT	ETF	22.39	22.39	22.2	22.2041	2278.0
2023-12-29	AHYB	ETF	45.506	45.526	45.37	45.37	1800.0
2023-12-29	AIA	ETF	57.86	58.19	57.78	57.97	15400.0

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

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