PREVIEW / etf_daily / 2023-01-13

all etf daily files

  file:    by_date/etf_daily/2023/2023-01-13.parquet
  size:    108 KB
  rows:    2,920

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-01-13	SPY	ETF	393.62	399.1	393.34	398.5	63903900.0
2023-01-13	QQQ	ETF	276.5	281.219	276.16	280.97	44802936.0
2023-01-13	IWM	ETF	184.5	187.34	184.33	187.05	22120000.0
2023-01-13	DIA	ETF	339.16	343.49	339.11	343.04	3473400.0
2023-01-13	GLD	ETF	176.96	178.83	176.89	178.76	7468800.0
2023-01-13	TLT	ETF	107.1	107.8	106.38	106.75	17750800.0
2023-01-13	AAA	ETF	24.49	24.49	24.49	24.49	220.0
2023-01-13	AAAU	ETF	18.88	19.07	18.87	19.06	892700.0
2023-01-13	AADR	ETF	49.45	50.03	49.45	50.03	1600.0
2023-01-13	AAPB	ETF	16.07	16.34	16.07	16.34	434.0
2023-01-13	AAPD	ETF	29.77	29.805	29.08	29.11	112136.0
2023-01-13	AAPU	ETF	17.01	17.54	16.9541	17.5	45909.0
2023-01-13	AAXJ	ETF	70.16	70.8	70.16	70.75	942800.0
2023-01-13	ABEQ	ETF	28.99	28.995	28.86	28.995	8200.0
2023-01-13	ACES	ETF	49.93	50.96	49.59	50.95	272100.0
2023-01-13	ACIO	ETF	29.32	29.44	29.2	29.413	50300.0
2023-01-13	ACSI	ETF	43.79	43.8607	43.79	43.8607	122.0
2023-01-13	ACT	ETF	24.2	24.49	23.99	24.29	70976.0
2023-01-13	ACTV	ETF	31.2	31.3502	31.2	31.3502	2686.0
2023-01-13	ACTX	ETF	0.365	0.365	0.35	0.35	1851.0
2023-01-13	ACVF	ETF	30.66	30.9	30.66	30.895	2200.0
2023-01-13	ACWF	ETF	33.01	33.3	33.01	33.3	5901.0
2023-01-13	ACWI	ETF	88.73	89.78	88.72	89.69	8269400.0
2023-01-13	ACWV	ETF	96.46	97.37	96.46	97.34	779300.0
2023-01-13	ACWX	ETF	48.55	49.07	48.55	49.035	3858905.0
2023-01-13	ADFI	ETF	8.585	8.6	8.56	8.57	5100.0
2023-01-13	ADIV	ETF	14.228	14.228	14.228	14.228	100.0
2023-01-13	ADME	ETF	33.87	34.11	33.87	34.05	47300.0
2023-01-13	ADPV	ETF	25.14	25.15	25.12	25.14	29142.0
2023-01-13	ADRE	ETF	42.208	42.53	42.035	42.53	10868.0
2023-01-13	AEMB	ETF	38.95	38.95	38.95	38.95	100.0
2023-01-13	AESR	ETF	11.69	11.77	11.69	11.77	10700.0
2023-01-13	AFIF	ETF	8.81	8.84	8.81	8.8199	10205.0
2023-01-13	AFK	ETF	17.3	17.42	17.3	17.42	4459.0
2023-01-13	AFLG	ETF	23.91	23.949	23.91	23.949	300.0
2023-01-13	AFMC	ETF	23.377	23.377	23.377	23.377	100.0
2023-01-13	AFSM	ETF	23.805	23.89	23.805	23.873	1500.0
2023-01-13	AFTY	ETF	17.421	17.454	17.421	17.454	300.0
2023-01-13	AGG	ETF	100.02	100.26	99.83	99.92	6719000.0
2023-01-13	AGGH	ETF	22.71	22.7648	22.71	22.7648	481.0
2023-01-13	AGGY	ETF	44.04	44.15	44.0	44.05	92600.0
2023-01-13	AGNG	ETF	27.01	27.16	26.965	27.16	2600.0
2023-01-13	AGOV	ETF	80.21	81.33	80.21	81.2	4005.0
2023-01-13	AGOX	ETF	21.26	21.61	21.15	21.47	20900.0
2023-01-13	AGQ	ETF	31.4	32.78	31.37	32.74	691500.0
2023-01-13	AGZ	ETF	108.23	108.23	107.9201	107.97	31963.0
2023-01-13	AGZD	ETF	21.825	22.045	21.81	22.045	159000.0
2023-01-13	AHHX	ETF	8.6373	8.7397	8.6373	8.7122	3952.0
2023-01-13	AHYB	ETF	44.59	44.6	44.59	44.6	300.0
2023-01-13	AIA	ETF	63.66	64.35	63.61	64.31	59660.0

> showing 50 of 2,920 rows — these rows as CSV

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