PREVIEW / etf_daily / 2022-12-29

all etf daily files

  file:    by_date/etf_daily/2022/2022-12-29.parquet
  size:    107 KB
  rows:    2,892

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-12-29	SPY	ETF	379.63	384.35	379.08	383.44	66970900.0
2022-12-29	QQQ	ETF	262.96	267.405	262.25	266.44	45893567.0
2022-12-29	IWM	ETF	171.72	175.25	171.4	174.85	22311300.0
2022-12-29	DIA	ETF	330.53	332.85	330.13	332.06	2458800.0
2022-12-29	GLD	ETF	168.54	169.35	168.52	168.85	3345900.0
2022-12-29	TLT	ETF	99.86	100.99	99.79	100.68	16593000.0
2022-12-29	AAA	ETF	24.37	24.37	24.365	24.365	105.0
2022-12-29	AAAU	ETF	17.97	18.06	17.97	18.01	270100.0
2022-12-29	AADR	ETF	47.83	47.85	47.65	47.76	900.0
2022-12-29	AAPB	ETF	15.2	15.4	15.19	15.39	3528.0
2022-12-29	AAPD	ETF	30.71	30.75	30.1	30.2932	273267.0
2022-12-29	AAPU	ETF	16.32	16.75	16.32	16.62	132204.0
2022-12-29	AAXJ	ETF	65.01	65.78	65.01	65.72	434700.0
2022-12-29	ABEQ	ETF	27.85	27.97	27.85	27.909	30500.0
2022-12-29	ACES	ETF	44.7	45.77	44.5	45.47	77700.0
2022-12-29	ACIO	ETF	28.8	28.94	28.8	28.88	247100.0
2022-12-29	ACSI	ETF	41.78	41.8143	41.78	41.8143	2682.0
2022-12-29	ACT	ETF	23.81	24.11	23.675	24.02	60236.0
2022-12-29	ACTV	ETF	29.165	29.17	29.1173	29.1173	2592.0
2022-12-29	ACTX	ETF	0.4	0.4	0.4	0.4	3482.0
2022-12-29	ACVF	ETF	29.53	29.91	29.53	29.85	4900.0
2022-12-29	ACWF	ETF	31.71	32.02	31.71	31.9572	5738.0
2022-12-29	ACWI	ETF	84.76	85.58	84.61	85.39	5039100.0
2022-12-29	ACWV	ETF	95.14	95.83	95.14	95.64	108200.0
2022-12-29	ACWX	ETF	45.8	46.1	45.755	46.01	2984774.0
2022-12-29	ADFI	ETF	8.34	8.37	8.34	8.355	10200.0
2022-12-29	ADIV	ETF	13.19	13.229	13.19	13.229	200.0
2022-12-29	ADME	ETF	33.69	33.73	33.64	33.64	18800.0
2022-12-29	ADPV	ETF	25.12	25.12	25.06	25.095	25967.0
2022-12-29	ADRE	ETF	37.57	37.78	37.57	37.71	5581.0
2022-12-29	AEMB	ETF	37.7	37.7	37.7	37.7	100.0
2022-12-29	AESR	ETF	11.52	11.52	11.498	11.498	3600.0
2022-12-29	AFIF	ETF	8.79	8.79	8.77	8.79	2711.0
2022-12-29	AFK	ETF	16.31	16.4199	16.255	16.3	11948.0
2022-12-29	AFMC	ETF	22.278	22.278	22.278	22.278	100.0
2022-12-29	AFSM	ETF	22.64	22.76	22.64	22.711	1000.0
2022-12-29	AFTY	ETF	15.71	15.775	15.71	15.764	800.0
2022-12-29	AGG	ETF	97.21	97.47	97.18	97.45	7763300.0
2022-12-29	AGGH	ETF	22.46	22.4807	22.46	22.4807	205.0
2022-12-29	AGGY	ETF	42.77	42.88	42.74	42.86	191200.0
2022-12-29	AGNG	ETF	26.15	26.34	25.98	26.31	9400.0
2022-12-29	AGOV	ETF	79.5	79.5001	79.0338	79.0338	993.0
2022-12-29	AGOX	ETF	20.28	20.62	20.28	20.584	13900.0
2022-12-29	AGQ	ETF	32.14	32.37	31.86	31.93	728800.0
2022-12-29	AGZ	ETF	106.72	106.8798	106.72	106.825	20819.0
2022-12-29	AGZD	ETF	21.64	21.795	21.625	21.73	436800.0
2022-12-29	AHHX	ETF	8.2109	8.3	8.2109	8.3	3965.0
2022-12-29	AHYB	ETF	42.89	42.89	42.89	42.89	100.0
2022-12-29	AIA	ETF	57.14	57.86	57.08	57.86	27133.0
2022-12-29	AIEQ	ETF	27.88	28.52	27.88	28.48	13700.0

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

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