PREVIEW / etf_daily / 2023-03-07

all etf daily files

  file:    by_date/etf_daily/2023/2023-03-07.parquet
  size:    109 KB
  rows:    2,941

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-03-07	SPY	ETF	404.42	404.67	397.63	398.27	108310600.0
2023-03-07	QQQ	ETF	300.07	301.01	295.72	296.34	65955756.0
2023-03-07	IWM	ETF	188.65	189.07	186.22	186.51	25865700.0
2023-03-07	DIA	ETF	334.67	334.92	328.72	328.87	5009200.0
2023-03-07	GLD	ETF	170.42	170.47	168.52	168.62	8713300.0
2023-03-07	TLT	ETF	101.46	102.37	100.88	101.72	23096500.0
2023-03-07	AAA	ETF	24.59	24.59	24.54	24.54	314.0
2023-03-07	AAAU	ETF	18.18	18.18	17.98	17.99	1637000.0
2023-03-07	AAPB	ETF	20.2598	20.2598	19.69	19.7419	5561.0
2023-03-07	AAPD	ETF	25.5	25.92	25.455	25.8538	119012.0
2023-03-07	AAPU	ETF	21.19	21.19	20.6431	20.72	89093.0
2023-03-07	AAXJ	ETF	67.35	67.35	66.41	66.42	387900.0
2023-03-07	ABEQ	ETF	27.757	27.757	27.64	27.645	15400.0
2023-03-07	ACES	ETF	48.68	48.68	47.88	48.09	88500.0
2023-03-07	ACIO	ETF	29.72	29.72	29.53	29.57	53300.0
2023-03-07	ACSI	ETF	43.9754	43.9754	43.9754	43.9754	67.0
2023-03-07	ACT	ETF	24.37	24.5	24.06	24.25	87938.0
2023-03-07	ACTV	ETF	31.365	31.45	31.1097	31.1097	5489.0
2023-03-07	ACTX	ETF	0.3755	0.3755	0.3755	0.3755	257.0
2023-03-07	ACVF	ETF	31.11	31.11	30.67	30.67	1100.0
2023-03-07	ACWF	ETF	33.18	33.18	32.9001	32.965	5206.0
2023-03-07	ACWI	ETF	90.03	90.11	88.6	88.75	1492600.0
2023-03-07	ACWV	ETF	94.41	94.69	93.47	93.55	200200.0
2023-03-07	ACWX	ETF	48.34	48.34	47.55	47.61	876857.0
2023-03-07	ADFI	ETF	8.38	8.43	8.38	8.43	13900.0
2023-03-07	ADIV	ETF	13.975	13.975	13.82	13.82	800.0
2023-03-07	ADME	ETF	34.19	34.19	33.791	33.86	27400.0
2023-03-07	ADPV	ETF	25.69	25.69	25.18	25.19	21387.0
2023-03-07	ADRE	ETF	39.77	39.855	39.25	39.4	4777.0
2023-03-07	AEMB	ETF	37.39	37.39	37.39	37.39	100.0
2023-03-07	AESR	ETF	11.78	11.78	11.55	11.6	18500.0
2023-03-07	AFIF	ETF	8.8301	8.84	8.82	8.83	13647.0
2023-03-07	AFK	ETF	16.17	16.17	15.85	15.85	5896.0
2023-03-07	AFLG	ETF	23.95	23.95	23.78	23.789	300.0
2023-03-07	AFMC	ETF	23.67	23.676	23.67	23.676	200.0
2023-03-07	AFSM	ETF	24.151	24.151	24.151	24.151	100.0
2023-03-07	AFTY	ETF	16.09	16.09	15.991	15.991	2300.0
2023-03-07	AGG	ETF	96.98	97.03	96.57	96.71	6013200.0
2023-03-07	AGGY	ETF	42.75	42.76	42.58	42.63	116300.0
2023-03-07	AGNG	ETF	26.09	26.09	26.025	26.025	1600.0
2023-03-07	AGOV	ETF	75.4748	75.4748	75.4748	75.4748	28.0
2023-03-07	AGOX	ETF	21.85	21.85	21.6	21.6	8000.0
2023-03-07	AGQ	ETF	23.07	23.1	21.68	21.79	1816000.0
2023-03-07	AGRH	ETF	25.57	25.59	25.5179	25.5179	577.0
2023-03-07	AGZ	ETF	106.22	106.22	105.989	105.99	18929.0
2023-03-07	AGZD	ETF	21.955	21.975	21.915	21.97	219800.0
2023-03-07	AHHX	ETF	8.56	8.56	8.5373	8.5391	536.0
2023-03-07	AHYB	ETF	43.325	43.325	43.325	43.325	300.0
2023-03-07	AIA	ETF	60.29	60.3	59.4	59.4	22010.0
2023-03-07	AIEQ	ETF	30.441	30.441	30.03	30.098	24800.0

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

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