PREVIEW / etf_daily / 2024-01-02

all etf daily files

  file:    by_date/etf_daily/2024/2024-01-02.parquet
  size:    117 KB
  rows:    3,244

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-01-02	SPY	ETF	472.16	473.67	470.49	472.65	123623700.0
2024-01-02	QQQ	ETF	405.84	406.09	400.24	402.59	58026946.0
2024-01-02	IWM	ETF	199.4	201.62	198.44	199.52	44341500.0
2024-01-02	DIA	ETF	374.8	377.82	374.8	377.09	5776300.0
2024-01-02	GLD	ETF	191.44	191.89	190.5	190.72	6025600.0
2024-01-02	TLT	ETF	98.23	98.65	98.0	98.31	47797400.0
2024-01-02	AAA	ETF	25.08	25.08	25.0	25.02	6300.0
2024-01-02	AAAU	ETF	20.45	20.51	20.36	20.39	1361500.0
2024-01-02	AADR	ETF	54.84	55.02	54.84	55.02	600.0
2024-01-02	AAPB	ETF	21.87	22.05	21.15	21.52	111014.0
2024-01-02	AAPD	ETF	20.77	21.0999	20.64	20.94	531159.0
2024-01-02	AAPU	ETF	26.24	26.47	25.52	25.86	337508.0
2024-01-02	AAXJ	ETF	65.47	65.76	65.31	65.44	642000.0
2024-01-02	ABCS	ETF	25.38	25.38	25.2943	25.2943	10019.0
2024-01-02	ABEQ	ETF	28.54	28.6	28.475	28.554	20000.0
2024-01-02	ACES	ETF	35.44	36.27	35.25	35.491	18900.0
2024-01-02	ACIO	ETF	33.03	33.37	32.895	33.04	155700.0
2024-01-02	ACSI	ETF	49.803	49.803	49.803	49.803	200.0
2024-01-02	ACT	ETF	28.84	28.89	28.57	28.66	153434.0
2024-01-02	ACTV	ETF	33.381	33.63	33.381	33.41	3000.0
2024-01-02	ACVF	ETF	36.4	36.41	36.214	36.315	9100.0
2024-01-02	ACWF	ETF	37.69	37.69	37.44	37.5609	43877.0
2024-01-02	ACWI	ETF	101.01	101.23	100.59	100.9	4067100.0
2024-01-02	ACWV	ETF	99.93	100.57	99.78	100.48	307300.0
2024-01-02	ACWX	ETF	50.29	50.66	50.29	50.42	1855600.0
2024-01-02	ADFI	ETF	8.58	8.58	8.55	8.565	5300.0
2024-01-02	ADIV	ETF	13.741	13.741	13.711	13.711	200.0
2024-01-02	ADME	ETF	38.225	38.31	38.07	38.27	43200.0
2024-01-02	ADPV	ETF	24.14	24.2146	24.14	24.2146	262.0
2024-01-02	ADVE	ETF	31.4	31.4	31.3452	31.3452	1331.0
2024-01-02	AEMB	ETF	37.9	37.9	37.82	37.82	300.0
2024-01-02	AESR	ETF	13.71	13.71	13.56	13.62	18900.0
2024-01-02	AETH	ETF	33.51	33.51	32.99	33.0824	3688.0
2024-01-02	AFIF	ETF	9.06	9.06	9.02	9.02	83400.0
2024-01-02	AFK	ETF	14.09	14.25	13.8	14.05	16000.0
2024-01-02	AFLG	ETF	27.05	27.152	27.05	27.148	800.0
2024-01-02	AFMC	ETF	26.54	26.611	26.54	26.611	100.0
2024-01-02	AFSM	ETF	27.225	27.32	27.225	27.274	1000.0
2024-01-02	AFTY	ETF	13.3	13.3	13.215	13.225	2400.0
2024-01-02	AGG	ETF	98.84	98.97	98.73	98.78	9754400.0
2024-01-02	AGGH	ETF	22.08	22.08	22.0	22.05	168529.0
2024-01-02	AGGY	ETF	43.81	43.886	43.78	43.82	144600.0
2024-01-02	AGIH	ETF	24.59	24.59	24.545	24.545	808.0
2024-01-02	AGNG	ETF	28.36	28.58	28.36	28.58	1500.0
2024-01-02	AGOX	ETF	24.1	24.33	24.1	24.21	225900.0
2024-01-02	AGQ	ETF	27.42	27.69	26.8	26.83	1166400.0
2024-01-02	AGQI	ETF	13.15	13.245	13.14	13.2	43944.0
2024-01-02	AGZ	ETF	108.29	108.33	107.52	108.17	62600.0
2024-01-02	AGZD	ETF	21.91	21.91	21.8	21.89	168900.0
2024-01-02	AHLT	ETF	22.09	22.09	21.96	21.9725	6914.0

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

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