PREVIEW / etf_daily / 2023-03-03

all etf daily files

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

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-03	SPY	ETF	399.71	404.45	399.03	404.19	90120000.0
2023-03-03	QQQ	ETF	295.39	299.92	294.87	299.68	60511540.0
2023-03-03	IWM	ETF	189.67	191.93	188.42	191.5	22774300.0
2023-03-03	DIA	ETF	331.52	334.43	330.42	334.21	3033500.0
2023-03-03	GLD	ETF	171.45	172.6	170.98	172.49	6894500.0
2023-03-03	TLT	ETF	100.93	101.9	100.57	101.89	30877300.0
2023-03-03	AAA	ETF	24.53	24.555	24.53	24.555	221.0
2023-03-03	AAAU	ETF	18.29	18.41	18.25	18.41	1554600.0
2023-03-03	AADR	ETF	49.53	49.75	49.53	49.75	500.0
2023-03-03	AAPB	ETF	18.9	19.66	18.9	19.6364	7490.0
2023-03-03	AAPD	ETF	26.47	26.6	25.92	25.92	170296.0
2023-03-03	AAPU	ETF	20.07	20.64	19.92	20.62	72274.0
2023-03-03	AAXJ	ETF	67.4	67.93	67.35	67.84	578300.0
2023-03-03	ABEQ	ETF	27.961	28.08	27.961	28.08	3300.0
2023-03-03	ACES	ETF	47.68	49.43	47.68	49.07	30200.0
2023-03-03	ACIO	ETF	29.39	29.77	29.39	29.77	76700.0
2023-03-03	ACSI	ETF	43.99	44.4364	43.99	44.4364	710.0
2023-03-03	ACT	ETF	24.38	24.56	24.255	24.45	58422.0
2023-03-03	ACTV	ETF	31.8201	32.07	31.77	31.9857	15864.0
2023-03-03	ACVF	ETF	30.94	31.15	30.9	31.15	1500.0
2023-03-03	ACWF	ETF	33.17	33.3944	33.16	33.3944	3784.0
2023-03-03	ACWI	ETF	89.42	90.31	89.17	90.23	3629400.0
2023-03-03	ACWV	ETF	93.94	94.56	93.68	94.43	232900.0
2023-03-03	ACWX	ETF	48.15	48.5996	48.079	48.54	843632.0
2023-03-03	ADFI	ETF	8.38	8.41	8.38	8.41	7100.0
2023-03-03	ADIV	ETF	14.04	14.11	14.04	14.11	1000.0
2023-03-03	ADME	ETF	33.71	34.05	33.71	34.041	47300.0
2023-03-03	ADPV	ETF	25.42	25.64	25.38	25.64	11629.0
2023-03-03	ADRE	ETF	39.8	40.11	39.711	40.11	6855.0
2023-03-03	AEMB	ETF	37.596	37.659	37.596	37.659	200.0
2023-03-03	AESR	ETF	11.58	11.75	11.58	11.73	85600.0
2023-03-03	AFIF	ETF	8.86	8.86	8.82	8.84	158569.0
2023-03-03	AFK	ETF	16.4	16.49	16.33	16.49	2885.0
2023-03-03	AFLG	ETF	24.1	24.15	24.1	24.15	600.0
2023-03-03	AFMC	ETF	24.15	24.189	24.15	24.189	100.0
2023-03-03	AFSM	ETF	24.642	24.808	24.642	24.808	200.0
2023-03-03	AFTY	ETF	16.69	16.725	16.69	16.725	100.0
2023-03-03	AGG	ETF	96.85	97.08	96.59	97.08	7267000.0
2023-03-03	AGGY	ETF	42.62	42.72	42.532	42.68	171100.0
2023-03-03	AGNG	ETF	26.34	26.612	26.34	26.612	2100.0
2023-03-03	AGOV	ETF	74.677	74.677	74.677	74.677	121.0
2023-03-03	AGOX	ETF	21.76	22.05	21.76	22.05	49800.0
2023-03-03	AGQ	ETF	23.89	24.54	23.52	24.5	890600.0
2023-03-03	AGZ	ETF	106.22	106.2895	106.02	106.21	13638.0
2023-03-03	AGZD	ETF	21.92	21.995	21.92	21.93	513200.0
2023-03-03	AHHX	ETF	8.52	8.585	8.52	8.585	65223.0
2023-03-03	AHYB	ETF	43.62	43.62	43.581	43.581	300.0
2023-03-03	AIA	ETF	60.66	60.8875	60.5	60.83	9629.0
2023-03-03	AIEQ	ETF	30.41	30.927	30.316	30.83	17600.0
2023-03-03	AIQ	ETF	22.92	23.182	22.7435	23.08	19385.0

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

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