PREVIEW / etf_daily / 2023-10-26

all etf daily files

  file:    by_date/etf_daily/2023/2023-10-26.parquet
  size:    111 KB
  rows:    3,092

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-10-26	SPY	ETF	416.45	417.33	411.6	412.55	115156800.0
2023-10-26	QQQ	ETF	349.12	350.07	342.35	343.66	78621425.0
2023-10-26	IWM	ETF	164.15	165.77	163.2	164.14	50525600.0
2023-10-26	DIA	ETF	330.16	331.02	327.36	327.82	4882600.0
2023-10-26	GLD	ETF	183.4	184.49	182.87	184.01	7671400.0
2023-10-26	TLT	ETF	83.48	84.82	83.4	84.73	49704100.0
2023-10-26	AAA	ETF	24.93	24.965	24.88	24.88	3100.0
2023-10-26	AAAU	ETF	19.59	19.7	19.53	19.66	1023900.0
2023-10-26	AADR	ETF	47.52	47.58	47.38	47.58	1700.0
2023-10-26	AAPB	ETF	22.5637	22.5637	21.39	21.68	15382.0
2023-10-26	AAPD	ETF	22.89	23.53	22.78	23.41	486446.0
2023-10-26	AAPU	ETF	23.26	23.4031	22.31	22.56	144856.0
2023-10-26	AAXJ	ETF	61.08	61.43	60.99	61.22	512400.0
2023-10-26	ABEQ	ETF	27.0	27.075	26.96	26.96	16300.0
2023-10-26	ACES	ETF	30.56	31.09	30.357	30.45	64700.0
2023-10-26	ACIO	ETF	29.93	30.01	29.77	29.79	39200.0
2023-10-26	ACSI	ETF	43.008	43.008	43.008	43.008	100.0
2023-10-26	ACT	ETF	26.97	27.77	26.97	27.03	200309.0
2023-10-26	ACTV	ETF	27.7	27.8	27.63	27.716	5200.0
2023-10-26	ACVF	ETF	32.04	32.14	31.84	31.84	6600.0
2023-10-26	ACWF	ETF	33.39	33.39	33.1096	33.1096	661.0
2023-10-26	ACWI	ETF	89.52	89.72	88.69	88.91	2376400.0
2023-10-26	ACWV	ETF	94.05	94.12	93.34	93.55	254700.0
2023-10-26	ACWX	ETF	45.19	45.32	44.94	45.09	1600700.0
2023-10-26	ADFI	ETF	8.08	8.1	8.06	8.095	13000.0
2023-10-26	ADIV	ETF	12.795	12.795	12.795	12.795	100.0
2023-10-26	ADME	ETF	34.19	34.35	34.03	34.067	17400.0
2023-10-26	ADPV	ETF	22.53	22.61	22.3837	22.3837	3561.0
2023-10-26	ADVE	ETF	28.7	28.7	28.5226	28.5226	203.0
2023-10-26	AEMB	ETF	35.065	35.065	35.065	35.065	100.0
2023-10-26	AESR	ETF	11.775	11.775	11.575	11.61	27200.0
2023-10-26	AETH	ETF	26.71	26.9927	26.68	26.9927	811.0
2023-10-26	AFIF	ETF	8.88	8.9	8.86	8.86	9800.0
2023-10-26	AFK	ETF	13.36	13.66	13.02	13.06	14700.0
2023-10-26	AFLG	ETF	24.0	24.015	23.973	23.973	3500.0
2023-10-26	AFMC	ETF	22.44	22.49	22.435	22.435	2600.0
2023-10-26	AFSM	ETF	22.588	22.588	22.588	22.588	100.0
2023-10-26	AFTY	ETF	13.903	13.903	13.903	13.903	100.0
2023-10-26	AGG	ETF	92.12	92.64	92.11	92.62	11574400.0
2023-10-26	AGGH	ETF	20.76	20.8799	20.7475	20.82	116461.0
2023-10-26	AGGY	ETF	40.75	40.92	40.74	40.91	146100.0
2023-10-26	AGNG	ETF	24.95	25.0	24.61	24.61	2400.0
2023-10-26	AGOV	ETF	70.38	74.26	69.9001	72.1625	548.0
2023-10-26	AGOX	ETF	22.025	22.13	21.873	21.98	60400.0
2023-10-26	AGQ	ETF	25.78	25.9	24.89	25.61	956800.0
2023-10-26	AGZ	ETF	105.16	105.49	105.16	105.42	18600.0
2023-10-26	AGZD	ETF	22.08	22.17	22.02	22.09	14400.0
2023-10-26	AHLT	ETF	26.87	26.99	26.7802	26.7802	10915.0
2023-10-26	AHYB	ETF	42.62	42.748	42.62	42.748	500.0
2023-10-26	AIA	ETF	53.88	54.25	53.72	53.93	46400.0

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

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