PREVIEW / etf_daily / 2023-01-24

all etf daily files

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

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-24	SPY	ETF	398.88	401.15	397.64	400.2	59524900.0
2023-01-24	QQQ	ETF	287.31	289.55	286.78	288.37	44875146.0
2023-01-24	IWM	ETF	186.59	187.83	185.88	186.93	19263500.0
2023-01-24	DIA	ETF	334.96	337.72	333.7	337.1	3360900.0
2023-01-24	GLD	ETF	179.56	180.32	178.35	180.28	4604600.0
2023-01-24	TLT	ETF	106.12	107.45	105.39	107.22	16417200.0
2023-01-24	AAA	ETF	24.51	24.51	24.51	24.51	100.0
2023-01-24	AAAU	ETF	19.15	19.23	19.04	19.23	483600.0
2023-01-24	AADR	ETF	50.1	50.36	50.02	50.36	2000.0
2023-01-24	AAPB	ETF	17.76	18.05	17.76	17.98	2846.0
2023-01-24	AAPD	ETF	27.99	27.99	27.45	27.52	129295.0
2023-01-24	AAPU	ETF	18.61	19.12	18.61	19.06	54059.0
2023-01-24	AAXJ	ETF	72.23	72.32	71.9	72.23	1487800.0
2023-01-24	ABEQ	ETF	28.79	28.869	28.775	28.869	2000.0
2023-01-24	ACES	ETF	51.08	51.651	50.9	51.235	28300.0
2023-01-24	ACIO	ETF	29.366	29.558	29.366	29.54	37800.0
2023-01-24	ACSI	ETF	44.2201	44.3558	44.22	44.3558	629.0
2023-01-24	ACT	ETF	24.55	24.735	24.22	24.5	86498.0
2023-01-24	ACTV	ETF	31.59	31.65	31.46	31.5	5646.0
2023-01-24	ACVF	ETF	30.92	31.02	30.843	30.94	13000.0
2023-01-24	ACWF	ETF	33.58	33.7	33.58	33.6702	3113.0
2023-01-24	ACWI	ETF	90.06	90.52	89.78	90.34	5137400.0
2023-01-24	ACWV	ETF	96.43	97.06	96.27	96.86	167100.0
2023-01-24	ACWX	ETF	49.4	49.695	49.28	49.62	1419900.0
2023-01-24	ADFI	ETF	8.58	8.605	8.568	8.605	8800.0
2023-01-24	ADIV	ETF	14.61	14.634	14.61	14.634	300.0
2023-01-24	ADME	ETF	34.2	34.2	33.95	34.105	112700.0
2023-01-24	ADPV	ETF	25.1	25.16	25.1	25.11	22009.0
2023-01-24	ADRE	ETF	43.46	43.7	43.46	43.4618	4956.0
2023-01-24	AEMB	ETF	39.28	39.4	39.28	39.4	200.0
2023-01-24	AESR	ETF	11.67	11.74	11.67	11.724	6700.0
2023-01-24	AFIF	ETF	8.8788	8.88	8.86	8.88	27796.0
2023-01-24	AFK	ETF	17.46	17.67	17.2592	17.36	4722.0
2023-01-24	AFMC	ETF	23.402	23.402	23.402	23.402	100.0
2023-01-24	AFSM	ETF	23.87	23.87	23.87	23.87	100.0
2023-01-24	AFTY	ETF	17.67	17.67	17.638	17.638	300.0
2023-01-24	AGG	ETF	99.84	100.32	99.68	100.28	6538600.0
2023-01-24	AGGH	ETF	22.84	22.84	22.84	22.84	100.0
2023-01-24	AGGY	ETF	44.13	44.31	44.02	44.31	337000.0
2023-01-24	AGIH	ETF	24.74	24.805	24.67	24.805	781.0
2023-01-24	AGNG	ETF	26.92	26.97	26.867	26.867	1400.0
2023-01-24	AGOV	ETF	81.2489	81.2489	81.2489	81.2489	24.0
2023-01-24	AGOX	ETF	21.765	21.83	21.73	21.77	39900.0
2023-01-24	AGQ	ETF	30.18	31.19	29.82	31.0	530400.0
2023-01-24	AGZ	ETF	108.16	108.49	108.16	108.49	80272.0
2023-01-24	AGZD	ETF	21.87	21.965	21.865	21.895	188400.0
2023-01-24	AHHX	ETF	8.6401	8.6788	8.6401	8.6788	476.0
2023-01-24	AHYB	ETF	44.25	44.358	44.25	44.358	700.0
2023-01-24	AIA	ETF	65.9	66.31	65.74	66.22	101508.0
2023-01-24	AIEQ	ETF	31.38	31.66	31.32	31.32	6300.0

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

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