PREVIEW / etf_daily / 2022-09-23

all etf daily files

  file:    by_date/etf_daily/2022/2022-09-23.parquet
  size:    105 KB
  rows:    2,835

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-09-23	SPY	ETF	370.58	370.62	363.29	367.95	122346900.0
2022-09-23	QQQ	ETF	277.55	277.85	272.02	275.51	74815189.0
2022-09-23	IWM	ETF	169.0	169.19	165.0	167.31	40336900.0
2022-09-23	DIA	ETF	297.82	298.0	292.4	295.86	4949300.0
2022-09-23	GLD	ETF	153.9	154.0	152.64	153.01	9598000.0
2022-09-23	TLT	ETF	105.34	106.43	104.56	105.7	23042200.0
2022-09-23	AAA	ETF	24.2743	24.2743	24.26	24.26	340.0
2022-09-23	AAAU	ETF	16.4	16.41	16.27	16.31	1895200.0
2022-09-23	AADR	ETF	45.53	45.53	44.99	45.5	1800.0
2022-09-23	AAPB	ETF	21.0	21.1	20.5401	20.91	3557.0
2022-09-23	AAPD	ETF	27.04	27.43	26.97	27.18	99160.0
2022-09-23	AAPU	ETF	21.66	21.66	21.18	21.55	36257.0
2022-09-23	AAXJ	ETF	61.03	61.12	60.41	60.7	961300.0
2022-09-23	ABEQ	ETF	25.45	25.45	25.102	25.34	11700.0
2022-09-23	ACES	ETF	58.34	58.34	56.553	57.48	76300.0
2022-09-23	ACIO	ETF	28.22	28.58	28.22	28.56	102100.0
2022-09-23	ACSI	ETF	42.3217	42.3217	42.3217	42.3217	9.0
2022-09-23	ACT	ETF	22.69	22.975	22.16	22.53	215251.0
2022-09-23	ACTV	ETF	27.13	27.49	27.03	27.343	24864.0
2022-09-23	ACTX	ETF	0.5255	0.5255	0.5255	0.5255	345.0
2022-09-23	ACVF	ETF	27.92	27.92	27.4	27.597	7800.0
2022-09-23	ACWF	ETF	30.08	30.08	29.5211	29.7134	11263.0
2022-09-23	ACWI	ETF	80.4	80.41	78.92	79.81	9135300.0
2022-09-23	ACWV	ETF	91.08	91.28	90.03	90.73	138900.0
2022-09-23	ACWX	ETF	41.05	41.08	40.43	40.71	4412592.0
2022-09-23	ADFI	ETF	8.24	8.26	8.24	8.245	10800.0
2022-09-23	ADIV	ETF	12.49	12.49	12.38	12.38	2100.0
2022-09-23	ADME	ETF	33.32	33.45	33.32	33.44	74400.0
2022-09-23	ADRE	ETF	35.72	35.72	35.14	35.46	7069.0
2022-09-23	AEMB	ETF	36.46	36.645	36.4	36.645	900.0
2022-09-23	AESR	ETF	10.98	10.98	10.77	10.86	25600.0
2022-09-23	AFIF	ETF	8.76	8.77	8.74	8.7499	26184.0
2022-09-23	AFK	ETF	15.61	15.61	15.27	15.36	10509.0
2022-09-23	AFLG	ETF	21.8	21.909	21.8	21.909	800.0
2022-09-23	AFMC	ETF	20.302	20.302	20.302	20.302	100.0
2022-09-23	AFSM	ETF	20.74	20.796	20.74	20.796	100.0
2022-09-23	AFTY	ETF	15.5	15.5	15.484	15.484	200.0
2022-09-23	AGG	ETF	97.4	97.45	96.89	97.2	11059300.0
2022-09-23	AGGH	ETF	22.92	22.9489	22.92	22.9489	250.0
2022-09-23	AGGY	ETF	42.9	42.91	42.68	42.815	381100.0
2022-09-23	AGNG	ETF	23.52	23.52	23.247	23.356	800.0
2022-09-23	AGOV	ETF	79.9	80.255	79.9	80.255	225.0
2022-09-23	AGOX	ETF	19.94	19.94	19.38	19.563	16500.0
2022-09-23	AGQ	ETF	21.12	21.14	20.26	20.44	2140600.0
2022-09-23	AGRH	ETF	25.26	25.26	25.18	25.18	510.0
2022-09-23	AGZ	ETF	106.9	106.9034	106.73	106.8	42006.0
2022-09-23	AGZD	ETF	22.965	22.995	22.905	22.945	842800.0
2022-09-23	AHHX	ETF	8.21	8.21	8.15	8.18	7376.0
2022-09-23	AHYB	ETF	42.06	42.107	42.06	42.107	600.0
2022-09-23	AIA	ETF	52.18	52.18	51.67	51.89	169098.0

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

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