PREVIEW / etf_daily / 2022-11-28

all etf daily files

  file:    by_date/etf_daily/2022/2022-11-28.parquet
  size:    107 KB
  rows:    2,882

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
2022-11-28	SPY	ETF	399.09	400.81	395.11	395.91	67881600.0
2022-11-28	QQQ	ETF	284.9	286.96	281.76	282.71	38877045.0
2022-11-28	IWM	ETF	184.13	184.92	181.29	181.84	17465600.0
2022-11-28	DIA	ETF	341.69	342.98	337.95	338.49	3089800.0
2022-11-28	GLD	ETF	162.93	163.06	161.91	161.93	4052900.0
2022-11-28	TLT	ETF	103.61	103.81	102.69	103.19	14563200.0
2022-11-28	AAA	ETF	24.36	24.36	24.36	24.36	4.0
2022-11-28	AAAU	ETF	17.36	17.39	17.26	17.26	3018300.0
2022-11-28	AADR	ETF	48.97	48.97	48.51	48.51	1200.0
2022-11-28	AAPB	ETF	18.94	19.02	18.77	18.77	1077.0
2022-11-28	AAPD	ETF	27.31	27.66	27.09	27.52	472609.0
2022-11-28	AAPU	ETF	20.0	20.28	19.6233	19.85	100320.0
2022-11-28	AAXJ	ETF	62.79	63.58	62.79	62.88	530700.0
2022-11-28	ABEQ	ETF	28.61	28.61	27.96	27.978	32600.0
2022-11-28	ACES	ETF	54.58	55.14	53.59	53.77	71900.0
2022-11-28	ACIO	ETF	30.16	30.16	29.76	29.77	35800.0
2022-11-28	ACSI	ETF	44.3821	44.3821	44.3821	44.3821	65.0
2022-11-28	ACT	ETF	24.59	24.7	24.18	24.36	144699.0
2022-11-28	ACTV	ETF	30.34	30.34	29.84	29.84	2013.0
2022-11-28	ACVF	ETF	31.4	31.4	30.535	30.573	5500.0
2022-11-28	ACWF	ETF	33.365	33.365	33.0328	33.0328	2065.0
2022-11-28	ACWI	ETF	87.7	88.05	86.87	87.01	10513600.0
2022-11-28	ACWV	ETF	97.21	97.74	96.79	96.91	243900.0
2022-11-28	ACWX	ETF	45.92	46.2	45.605	45.66	3000793.0
2022-11-28	ADFI	ETF	8.38	8.43	8.38	8.405	4900.0
2022-11-28	ADIV	ETF	12.69	12.69	12.69	12.69	100.0
2022-11-28	ADME	ETF	35.15	35.188	34.82	34.915	26000.0
2022-11-28	ADPV	ETF	25.09	25.09	25.075	25.075	19518.0
2022-11-28	ADRE	ETF	37.1251	37.135	36.91	36.91	3532.0
2022-11-28	AEMB	ETF	37.755	37.755	37.755	37.755	100.0
2022-11-28	AESR	ETF	11.91	11.91	11.8	11.83	17600.0
2022-11-28	AFIF	ETF	8.7573	8.77	8.74	8.7699	11548.0
2022-11-28	AFK	ETF	16.99	17.2	16.6	17.02	19618.0
2022-11-28	AFLG	ETF	24.1	24.1	24.1	24.1	200.0
2022-11-28	AFMC	ETF	23.24	23.24	23.077	23.077	100.0
2022-11-28	AFSM	ETF	23.869	23.869	23.616	23.616	400.0
2022-11-28	AFTY	ETF	14.47	14.47	14.429	14.429	1200.0
2022-11-28	AGG	ETF	98.14	98.19	97.84	97.88	7920700.0
2022-11-28	AGGH	ETF	22.49	22.49	22.45	22.45	2107.0
2022-11-28	AGGY	ETF	43.03	43.07	42.895	43.0	83900.0
2022-11-28	AGNG	ETF	26.08	26.11	25.87	25.98	1400.0
2022-11-28	AGOV	ETF	79.945	79.945	79.945	79.945	32.0
2022-11-28	AGOX	ETF	21.24	21.25	21.017	21.044	30100.0
2022-11-28	AGQ	ETF	25.74	25.86	24.57	24.7	2316300.0
2022-11-28	AGZ	ETF	106.9	106.96	106.37	106.73	367051.0
2022-11-28	AGZD	ETF	23.065	23.065	22.985	23.045	189000.0
2022-11-28	AHHX	ETF	8.55	8.57	8.4919	8.5087	3247.0
2022-11-28	AHYB	ETF	43.28	43.28	43.275	43.275	300.0
2022-11-28	AIA	ETF	53.87	54.693	53.87	54.03	56437.0
2022-11-28	AIEQ	ETF	30.96	31.098	30.59	30.59	4400.0

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

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