PREVIEW / etf_daily / 2023-01-17

all etf daily files

  file:    by_date/etf_daily/2023/2023-01-17.parquet
  size:    109 KB
  rows:    2,924

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-17	SPY	ETF	398.48	400.23	397.06	397.77	62677300.0
2023-01-17	QQQ	ETF	280.77	282.85	279.581	281.54	36269738.0
2023-01-17	IWM	ETF	187.0	187.84	186.24	186.82	22422600.0
2023-01-17	DIA	ETF	342.36	342.75	338.63	339.16	3929700.0
2023-01-17	GLD	ETF	178.21	178.24	177.09	177.59	6610800.0
2023-01-17	TLT	ETF	105.67	106.66	105.65	106.06	13911700.0
2023-01-17	AAA	ETF	24.46	24.46	24.46	24.46	0.0
2023-01-17	AAAU	ETF	19.01	19.01	18.9	18.94	448000.0
2023-01-17	AADR	ETF	49.79	50.03	49.79	50.03	5300.0
2023-01-17	AAPB	ETF	16.51	16.59	16.51	16.57	2757.0
2023-01-17	AAPD	ETF	29.05	29.24	28.59	28.89	125994.0
2023-01-17	AAPU	ETF	17.59	18.0025	17.42	17.76	70007.0
2023-01-17	AAXJ	ETF	70.39	70.44	70.1	70.32	834400.0
2023-01-17	ABEQ	ETF	29.24	29.24	28.72	28.732	13400.0
2023-01-17	ACES	ETF	51.3	51.73	50.95	51.31	544200.0
2023-01-17	ACIO	ETF	29.46	29.475	29.385	29.41	31900.0
2023-01-17	ACSI	ETF	43.86	43.8634	43.85	43.8634	216.0
2023-01-17	ACT	ETF	24.41	24.46	24.0	24.21	79787.0
2023-01-17	ACTV	ETF	31.39	31.47	31.38	31.43	11145.0
2023-01-17	ACTX	ETF	0.4499	0.4499	0.4454	0.4454	477.0
2023-01-17	ACVF	ETF	30.97	31.04	30.85	30.857	4300.0
2023-01-17	ACWF	ETF	33.37	33.37	33.27	33.28	4062.0
2023-01-17	ACWI	ETF	89.69	90.07	89.47	89.63	3795100.0
2023-01-17	ACWV	ETF	97.2	97.64	97.11	97.21	296800.0
2023-01-17	ACWX	ETF	48.99	49.1	48.99	49.05	1141078.0
2023-01-17	ADFI	ETF	8.561	8.57	8.56	8.57	11500.0
2023-01-17	ADIV	ETF	14.3	14.339	14.26	14.321	4600.0
2023-01-17	ADME	ETF	34.18	34.2	34.0	34.0	20500.0
2023-01-17	ADPV	ETF	25.09	25.16	25.09	25.159	30134.0
2023-01-17	ADRE	ETF	42.3347	42.4	42.2401	42.2401	1655.0
2023-01-17	AEMB	ETF	39.0	39.0	38.98	38.98	100.0
2023-01-17	AESR	ETF	11.72	11.81	11.72	11.74	19300.0
2023-01-17	AFIF	ETF	8.8352	8.84	8.83	8.835	3124.0
2023-01-17	AFK	ETF	17.09	17.09	17.0	17.0087	977.0
2023-01-17	AFLG	ETF	23.88	23.88	23.86	23.86	1400.0
2023-01-17	AFMC	ETF	23.31	23.33	23.31	23.315	1000.0
2023-01-17	AFSM	ETF	23.83	23.83	23.77	23.812	1200.0
2023-01-17	AFTY	ETF	17.38	17.445	17.38	17.445	300.0
2023-01-17	AGG	ETF	99.74	99.96	99.65	99.74	8174700.0
2023-01-17	AGGH	ETF	22.76	22.76	22.76	22.76	139.0
2023-01-17	AGGY	ETF	43.92	44.025	43.92	43.94	89700.0
2023-01-17	AGNG	ETF	27.25	27.25	27.064	27.066	1300.0
2023-01-17	AGOV	ETF	80.52	81.98	80.52	80.92	2657.0
2023-01-17	AGOX	ETF	21.58	21.66	21.494	21.51	36100.0
2023-01-17	AGQ	ETF	32.35	32.37	31.53	31.84	468700.0
2023-01-17	AGZ	ETF	108.0799	108.0832	107.9333	108.0	16612.0
2023-01-17	AGZD	ETF	21.87	21.875	21.8	21.84	236000.0
2023-01-17	AHHX	ETF	8.65	8.696	8.65	8.685	28561.0
2023-01-17	AHYB	ETF	44.53	44.53	44.487	44.487	1000.0
2023-01-17	AIA	ETF	63.73	63.84	63.42	63.695	88779.0

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

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