PREVIEW / etf_daily / 2023-01-25

all etf daily files

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

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-25	SPY	ETF	395.95	400.7	393.56	400.35	84800300.0
2023-01-25	QQQ	ETF	283.77	288.36	281.18	287.73	50872022.0
2023-01-25	IWM	ETF	185.41	187.51	183.87	187.45	18174600.0
2023-01-25	DIA	ETF	334.24	337.64	332.55	337.32	4318600.0
2023-01-25	GLD	ETF	179.35	181.22	179.29	181.11	6925300.0
2023-01-25	TLT	ETF	107.37	107.91	106.64	107.48	11906500.0
2023-01-25	AAA	ETF	24.5399	24.54	24.53	24.53	311.0
2023-01-25	AAAU	ETF	19.13	19.32	19.13	19.32	731500.0
2023-01-25	AADR	ETF	49.75	50.2	49.75	50.2	400.0
2023-01-25	AAPB	ETF	17.56	17.83	17.2072	17.8034	3170.0
2023-01-25	AAPD	ETF	27.92	28.26	27.6	27.73	128439.0
2023-01-25	AAPU	ETF	18.67	18.99	18.3	18.86	71564.0
2023-01-25	AAXJ	ETF	71.99	72.29	71.44	72.29	710500.0
2023-01-25	ABEQ	ETF	28.84	28.867	28.828	28.867	700.0
2023-01-25	ACES	ETF	49.99	50.79	49.19	50.6	45400.0
2023-01-25	ACIO	ETF	29.21	29.55	29.21	29.496	24300.0
2023-01-25	ACSI	ETF	43.655	44.59	43.655	44.59	427.0
2023-01-25	ACT	ETF	24.5	24.55	24.34	24.45	109133.0
2023-01-25	ACTV	ETF	31.0606	31.6	31.0606	31.53	15063.0
2023-01-25	ACTX	ETF	0.44	0.44	0.44	0.44	116.0
2023-01-25	ACVF	ETF	30.53	30.98	30.53	30.941	3400.0
2023-01-25	ACWF	ETF	33.46	33.76	33.35	33.7434	15840.0
2023-01-25	ACWI	ETF	89.63	90.63	89.24	90.55	6457200.0
2023-01-25	ACWV	ETF	96.39	97.27	96.39	97.26	160700.0
2023-01-25	ACWX	ETF	49.46	49.85	49.31	49.82	1773306.0
2023-01-25	ADFI	ETF	8.59	8.595	8.58	8.595	7600.0
2023-01-25	ADIV	ETF	14.696	14.696	14.696	14.696	100.0
2023-01-25	ADME	ETF	33.77	34.09	33.7	34.041	12300.0
2023-01-25	ADPV	ETF	25.11	25.29	25.11	25.17	31065.0
2023-01-25	ADRE	ETF	43.24	43.47	42.85	43.3	14961.0
2023-01-25	AEMB	ETF	39.39	39.39	39.38	39.38	100.0
2023-01-25	AESR	ETF	11.61	11.72	11.61	11.72	15700.0
2023-01-25	AFIF	ETF	8.86	8.8699	8.84	8.86	21267.0
2023-01-25	AFK	ETF	17.4	17.4649	17.29	17.4649	2916.0
2023-01-25	AFLG	ETF	23.98	24.006	23.98	24.006	300.0
2023-01-25	AFMC	ETF	23.46	23.499	23.46	23.499	100.0
2023-01-25	AFSM	ETF	23.95	23.95	23.95	23.95	200.0
2023-01-25	AFTY	ETF	17.71	17.735	17.71	17.735	600.0
2023-01-25	AGG	ETF	100.26	100.47	100.1	100.4	5431000.0
2023-01-25	AGGH	ETF	22.84	22.84	22.84	22.84	103.0
2023-01-25	AGGY	ETF	44.14	44.21	44.045	44.15	82200.0
2023-01-25	AGIH	ETF	24.86	24.86	24.86	24.86	102.0
2023-01-25	AGNG	ETF	26.72	26.874	26.72	26.874	1000.0
2023-01-25	AGOV	ETF	79.655	80.7501	79.655	80.7501	506.0
2023-01-25	AGOX	ETF	21.51	21.82	21.44	21.82	12300.0
2023-01-25	AGQ	ETF	30.6	31.73	30.49	31.65	523300.0
2023-01-25	AGZ	ETF	108.4601	108.61	108.12	108.61	60454.0
2023-01-25	AGZD	ETF	21.825	21.915	21.81	21.84	215000.0
2023-01-25	AHHX	ETF	8.6381	8.69	8.63	8.6706	12641.0
2023-01-25	AHYB	ETF	44.201	44.362	44.2	44.362	700.0

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

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