PREVIEW / etf_daily / 2023-01-30

all etf daily files

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

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-30	SPY	ETF	402.8	405.13	400.28	400.59	74202000.0
2023-01-30	QQQ	ETF	292.93	294.38	289.89	290.27	49405833.0
2023-01-30	IWM	ETF	187.84	189.61	186.83	186.94	18395100.0
2023-01-30	DIA	ETF	338.46	340.43	336.85	337.06	3032700.0
2023-01-30	GLD	ETF	179.29	179.43	178.65	178.76	4210700.0
2023-01-30	TLT	ETF	106.46	107.16	106.19	106.32	11459700.0
2023-01-30	AAA	ETF	24.6	24.6	24.6	24.6	149.0
2023-01-30	AAAU	ETF	19.13	19.14	19.06	19.07	691200.0
2023-01-30	AADR	ETF	49.59	49.59	49.37	49.54	900.0
2023-01-30	AAPB	ETF	18.49	18.49	18.07	18.07	2038.0
2023-01-30	AAPD	ETF	27.13	27.48	27.023	27.47	119836.0
2023-01-30	AAPU	ETF	19.46	19.61	19.08	19.1	90510.0
2023-01-30	AAXJ	ETF	71.73	71.84	71.28	71.32	867300.0
2023-01-30	ABEQ	ETF	28.84	28.84	28.67	28.7	13400.0
2023-01-30	ACES	ETF	52.3	52.68	51.21	51.22	66500.0
2023-01-30	ACIO	ETF	29.73	29.73	29.49	29.51	41300.0
2023-01-30	ACSI	ETF	44.5954	44.5954	44.5954	44.5954	141.0
2023-01-30	ACT	ETF	24.74	24.83	24.56	24.81	71863.0
2023-01-30	ACTV	ETF	31.9288	31.9288	31.5	31.53	7276.0
2023-01-30	ACVF	ETF	31.15	31.22	30.89	30.89	2600.0
2023-01-30	ACWF	ETF	33.75	33.83	33.575	33.59	9952.0
2023-01-30	ACWI	ETF	90.78	91.18	90.23	90.27	7535100.0
2023-01-30	ACWV	ETF	96.33	97.0	96.33	96.44	327100.0
2023-01-30	ACWX	ETF	49.58	49.74	49.35	49.35	3035971.0
2023-01-30	ADFI	ETF	8.57	8.58	8.55	8.58	8900.0
2023-01-30	ADIV	ETF	14.66	14.66	14.55	14.555	3600.0
2023-01-30	ADME	ETF	34.41	34.41	34.13	34.13	42100.0
2023-01-30	ADPV	ETF	25.16	25.18	25.145	25.175	22370.0
2023-01-30	ADRE	ETF	42.635	42.87	42.52	42.53	28734.0
2023-01-30	AEMB	ETF	39.03	39.03	39.03	39.03	900.0
2023-01-30	AESR	ETF	11.89	11.89	11.67	11.67	16600.0
2023-01-30	AFIF	ETF	8.8759	8.88	8.86	8.86	3146.0
2023-01-30	AFK	ETF	17.3	17.4	17.15	17.15	8484.0
2023-01-30	AFLG	ETF	24.05	24.05	23.994	23.994	100.0
2023-01-30	AFMC	ETF	23.63	23.63	23.582	23.582	100.0
2023-01-30	AFSM	ETF	23.96	23.97	23.81	23.81	1600.0
2023-01-30	AFTY	ETF	17.71	17.72	17.66	17.668	1900.0
2023-01-30	AGG	ETF	99.9	100.09	99.8	99.81	6822000.0
2023-01-30	AGGH	ETF	22.605	22.64	22.53	22.5967	3002.0
2023-01-30	AGGY	ETF	43.94	44.02	43.91	43.92	107300.0
2023-01-30	AGNG	ETF	26.77	26.814	26.59	26.7	154200.0
2023-01-30	AGOV	ETF	79.66	80.33	77.88	79.3379	773.0
2023-01-30	AGOX	ETF	21.76	21.94	21.76	21.76	30800.0
2023-01-30	AGQ	ETF	31.05	31.15	30.61	30.72	257600.0
2023-01-30	AGRH	ETF	25.8	25.8	25.64	25.64	800.0
2023-01-30	AGZ	ETF	108.07	108.1231	108.03	108.03	22036.0
2023-01-30	AGZD	ETF	21.895	21.915	21.84	21.85	346200.0
2023-01-30	AHHX	ETF	8.58	8.66	8.58	8.645	5192.0
2023-01-30	AHYB	ETF	44.16	44.16	44.103	44.103	200.0
2023-01-30	AIA	ETF	65.72	65.93	65.38	65.56	123819.0

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

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