PREVIEW / etf_daily / 2023-02-01

all etf daily files

  file:    by_date/etf_daily/2023/2023-02-01.parquet
  size:    110 KB
  rows:    2,954

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-02-01	SPY	ETF	405.21	413.67	402.35	410.8	101459200.0
2023-02-01	QQQ	ETF	294.41	303.43	292.3	300.92	67562173.0
2023-02-01	IWM	ETF	191.19	196.19	190.13	194.49	27007300.0
2023-02-01	DIA	ETF	339.12	343.27	335.58	340.87	6175400.0
2023-02-01	GLD	ETF	179.75	181.73	178.63	181.67	7996000.0
2023-02-01	TLT	ETF	107.55	108.59	106.42	108.18	25305800.0
2023-02-01	AAA	ETF	24.515	24.515	24.515	24.515	50.0
2023-02-01	AAAU	ETF	19.17	19.39	19.06	19.38	1235200.0
2023-02-01	AADR	ETF	49.85	50.43	49.81	50.43	900.0
2023-02-01	AAPB	ETF	18.07	18.5518	17.79	18.5518	20547.0
2023-02-01	AAPD	ETF	27.27	27.76	26.79	27.02	189195.0
2023-02-01	AAPU	ETF	19.3	19.81	18.8	19.57	138560.0
2023-02-01	AAXJ	ETF	71.37	72.25	71.03	72.03	603400.0
2023-02-01	ABEQ	ETF	28.73	29.0	28.68	28.917	21700.0
2023-02-01	ACES	ETF	52.69	54.092	51.905	53.82	67600.0
2023-02-01	ACIO	ETF	29.778	30.19	29.74	30.01	30300.0
2023-02-01	ACSI	ETF	45.9665	45.9665	45.9665	45.9665	388.0
2023-02-01	ACT	ETF	25.14	25.25	24.8	24.9	193764.0
2023-02-01	ACTV	ETF	32.08	33.17	32.08	32.89	15188.0
2023-02-01	ACTX	ETF	0.41	0.41	0.31	0.4	35342.0
2023-02-01	ACVF	ETF	31.41	31.93	31.237	31.728	5800.0
2023-02-01	ACWF	ETF	33.81	34.167	33.71	34.167	4751.0
2023-02-01	ACWI	ETF	91.02	92.71	90.43	92.18	3807600.0
2023-02-01	ACWV	ETF	96.57	97.76	96.17	97.38	359400.0
2023-02-01	ACWX	ETF	49.59	50.21	49.23	50.01	2347297.0
2023-02-01	ADFI	ETF	8.6	8.64	8.571	8.64	16300.0
2023-02-01	ADIV	ETF	14.65	14.697	14.59	14.697	3400.0
2023-02-01	ADME	ETF	34.52	34.97	34.38	34.76	16900.0
2023-02-01	ADPV	ETF	25.46	25.56	25.33	25.44	27460.0
2023-02-01	ADRE	ETF	42.98	43.3538	42.52	43.17	31764.0
2023-02-01	AEMB	ETF	39.64	39.64	39.64	39.64	100.0
2023-02-01	AESR	ETF	11.77	11.935	11.75	11.926	28700.0
2023-02-01	AFIF	ETF	8.89	8.905	8.8599	8.905	15820.0
2023-02-01	AFK	ETF	17.12	17.46	17.1199	17.43	9241.0
2023-02-01	AFLG	ETF	24.55	24.616	24.55	24.616	100.0
2023-02-01	AFMC	ETF	24.413	24.413	24.413	24.413	100.0
2023-02-01	AFSM	ETF	24.675	24.675	24.675	24.675	200.0
2023-02-01	AFTY	ETF	17.55	17.664	17.51	17.664	1000.0
2023-02-01	AGG	ETF	100.19	100.78	99.86	100.68	11593300.0
2023-02-01	AGGH	ETF	22.82	22.82	22.7699	22.7699	327.0
2023-02-01	AGGY	ETF	44.19	44.42	44.06	44.39	235500.0
2023-02-01	AGNG	ETF	26.83	27.161	26.78	27.161	1300.0
2023-02-01	AGOV	ETF	79.265	79.265	79.265	79.265	288.0
2023-02-01	AGOX	ETF	22.021	22.44	21.92	22.25	15700.0
2023-02-01	AGQ	ETF	31.03	31.98	30.15	31.83	762700.0
2023-02-01	AGZ	ETF	108.16	108.46	108.03	108.424	19966.0
2023-02-01	AGZD	ETF	21.875	21.935	21.82	21.935	272000.0
2023-02-01	AHHX	ETF	8.73	8.7914	8.73	8.7914	158.0
2023-02-01	AHYB	ETF	44.661	44.661	44.661	44.661	100.0
2023-02-01	AIA	ETF	65.54	66.62	65.26	66.36	273742.0

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

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