PREVIEW / etf_daily / 2023-02-03

all etf daily files

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

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-03	SPY	ETF	411.59	416.97	411.09	412.35	94736800.0
2023-02-03	QQQ	ETF	304.94	312.39	304.54	306.18	76170804.0
2023-02-03	IWM	ETF	196.11	199.13	195.7	196.99	24981500.0
2023-02-03	DIA	ETF	338.77	341.67	337.96	338.98	6504300.0
2023-02-03	GLD	ETF	174.92	175.43	173.12	173.46	13674400.0
2023-02-03	TLT	ETF	106.77	107.11	106.08	106.7	20619500.0
2023-02-03	AAA	ETF	24.54	24.54	24.5132	24.5132	265.0
2023-02-03	AAAU	ETF	18.66	18.7	18.47	18.5	1324900.0
2023-02-03	AADR	ETF	48.78	48.78	48.74	48.74	1000.0
2023-02-03	AAPB	ETF	19.08	21.23	19.08	20.57	22250.0
2023-02-03	AAPD	ETF	26.53	26.53	24.9	25.37	808344.0
2023-02-03	AAPU	ETF	20.04	22.0015	20.04	21.4	337829.0
2023-02-03	AAXJ	ETF	71.07	71.12	70.16	70.24	720800.0
2023-02-03	ABEQ	ETF	28.52	28.52	28.403	28.403	1500.0
2023-02-03	ACES	ETF	53.11	54.4	52.765	53.02	58600.0
2023-02-03	ACIO	ETF	30.078	30.22	29.97	30.07	89600.0
2023-02-03	ACSI	ETF	46.4458	46.4458	46.4458	46.4458	41.0
2023-02-03	ACT	ETF	24.8	25.27	24.8	25.1	176462.0
2023-02-03	ACTV	ETF	33.36	33.7442	33.36	33.46	18758.0
2023-02-03	ACTX	ETF	0.38	0.38	0.38	0.38	500.0
2023-02-03	ACVF	ETF	31.81	31.927	31.624	31.736	6700.0
2023-02-03	ACWF	ETF	33.91	34.16	33.91	33.9127	2383.0
2023-02-03	ACWI	ETF	91.8	92.79	91.63	91.86	2997800.0
2023-02-03	ACWV	ETF	96.22	96.45	95.7	96.01	388600.0
2023-02-03	ACWX	ETF	49.41	49.74	49.215	49.29	1356170.0
2023-02-03	ADFI	ETF	8.6	8.61	8.6	8.61	2200.0
2023-02-03	ADIV	ETF	14.335	14.335	14.335	14.335	100.0
2023-02-03	ADME	ETF	34.67	35.046	34.67	34.8	22800.0
2023-02-03	ADPV	ETF	25.1	25.43	25.1	25.38	29843.0
2023-02-03	ADRE	ETF	42.62	42.7857	42.05	42.1862	19207.0
2023-02-03	AEMB	ETF	39.255	39.255	39.255	39.255	200.0
2023-02-03	AESR	ETF	11.85	11.98	11.85	11.89	53300.0
2023-02-03	AFIF	ETF	8.91	8.91	8.87	8.885	126562.0
2023-02-03	AFK	ETF	17.27	17.28	17.0	17.0	5666.0
2023-02-03	AFLG	ETF	24.658	24.658	24.658	24.658	100.0
2023-02-03	AFMC	ETF	24.69	24.69	24.583	24.583	200.0
2023-02-03	AFSM	ETF	24.96	25.02	24.96	25.02	600.0
2023-02-03	AFTY	ETF	17.1	17.12	16.957	16.957	4300.0
2023-02-03	AGG	ETF	99.95	100.13	99.52	99.82	9083000.0
2023-02-03	AGGY	ETF	44.22	44.22	44.05	44.105	272900.0
2023-02-03	AGNG	ETF	27.23	27.249	27.19	27.249	900.0
2023-02-03	AGOV	ETF	78.67	78.67	78.67	78.67	1.0
2023-02-03	AGOX	ETF	22.45	22.59	22.27	22.29	14000.0
2023-02-03	AGQ	ETF	28.37	28.88	27.26	27.45	1282400.0
2023-02-03	AGZ	ETF	108.02	108.1134	107.9	108.04	61080.0
2023-02-03	AGZD	ETF	21.96	21.97	21.865	21.93	157400.0
2023-02-03	AHHX	ETF	8.79	8.8027	8.7501	8.7695	5263.0
2023-02-03	AHYB	ETF	44.68	44.68	44.437	44.437	600.0
2023-02-03	AIA	ETF	65.25	65.45	64.46	64.48	109937.0
2023-02-03	AIEQ	ETF	32.89	33.29	32.58	32.6	140100.0

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

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