PREVIEW / etf_daily / 2023-02-07

all etf daily files

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

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-07	SPY	ETF	408.87	416.49	407.57	415.19	90990700.0
2023-02-07	QQQ	ETF	303.46	311.03	302.32	309.88	67583981.0
2023-02-07	IWM	ETF	193.41	196.1	191.65	195.58	27074100.0
2023-02-07	DIA	ETF	336.95	342.31	336.19	341.52	4969600.0
2023-02-07	GLD	ETF	173.72	175.27	173.47	173.98	6794200.0
2023-02-07	TLT	ETF	105.33	106.23	105.0	105.06	18290300.0
2023-02-07	AAA	ETF	24.57	24.57	24.57	24.57	93.0
2023-02-07	AAAU	ETF	18.52	18.68	18.51	18.56	789600.0
2023-02-07	AADR	ETF	48.84	48.84	48.78	48.78	200.0
2023-02-07	AAPB	ETF	19.76	20.64	19.74	20.57	13364.0
2023-02-07	AAPD	ETF	26.0	26.0	25.28	25.37	211714.0
2023-02-07	AAPU	ETF	20.63	21.54	20.63	21.42	136534.0
2023-02-07	AAXJ	ETF	69.38	69.78	68.88	69.6	951000.0
2023-02-07	ABEQ	ETF	28.429	28.651	28.366	28.651	16300.0
2023-02-07	ACES	ETF	52.33	52.39	50.93	52.25	40700.0
2023-02-07	ACIO	ETF	29.78	30.24	29.78	30.24	28600.0
2023-02-07	ACSI	ETF	46.5157	46.5157	46.5157	46.5157	35.0
2023-02-07	ACT	ETF	25.06	25.06	22.311	23.02	392234.0
2023-02-07	ACTV	ETF	32.85	33.2652	32.73	33.2652	4243.0
2023-02-07	ACVF	ETF	31.405	31.92	31.405	31.892	4800.0
2023-02-07	ACWF	ETF	33.4101	33.9	33.4101	33.8856	5101.0
2023-02-07	ACWI	ETF	90.91	92.27	90.61	92.07	3044800.0
2023-02-07	ACWV	ETF	95.39	96.21	95.06	96.02	253600.0
2023-02-07	ACWX	ETF	48.61	49.19	48.475	49.13	1801819.0
2023-02-07	ADFI	ETF	8.54	8.58	8.531	8.565	22100.0
2023-02-07	ADIV	ETF	14.246	14.246	14.246	14.246	100.0
2023-02-07	ADME	ETF	34.639	34.94	34.62	34.93	10400.0
2023-02-07	ADPV	ETF	25.24	26.42	25.24	25.51	39158.0
2023-02-07	ADRE	ETF	41.62	42.0	41.535	42.0	5699.0
2023-02-07	AEMB	ETF	38.67	38.67	38.67	38.67	100.0
2023-02-07	AESR	ETF	11.77	12.0	11.77	11.98	52800.0
2023-02-07	AFIF	ETF	8.93	8.93	8.9	8.93	201272.0
2023-02-07	AFK	ETF	17.07	17.08	16.775	17.08	4629.0
2023-02-07	AFLG	ETF	24.725	24.725	24.725	24.725	100.0
2023-02-07	AFMC	ETF	24.23	24.447	24.23	24.447	200.0
2023-02-07	AFSM	ETF	24.64	24.91	24.64	24.91	1600.0
2023-02-07	AFTY	ETF	16.86	16.92	16.86	16.92	1700.0
2023-02-07	AGG	ETF	99.15	99.57	99.06	99.1	6224800.0
2023-02-07	AGGY	ETF	43.7	43.91	43.67	43.73	122000.0
2023-02-07	AGIH	ETF	24.57	24.57	24.57	24.57	100.0
2023-02-07	AGNG	ETF	26.8	27.13	26.8	27.13	1300.0
2023-02-07	AGOV	ETF	78.395	78.395	78.395	78.395	1.0
2023-02-07	AGOX	ETF	22.16	22.51	22.1	22.4	26700.0
2023-02-07	AGQ	ETF	27.04	27.62	26.66	26.94	534700.0
2023-02-07	AGZ	ETF	107.48	107.65	107.39	107.4139	18111.0
2023-02-07	AGZD	ETF	21.945	21.985	21.855	21.92	245200.0
2023-02-07	AHHX	ETF	8.69	8.69	8.51	8.68	12448.0
2023-02-07	AHYB	ETF	44.181	44.388	44.181	44.388	900.0
2023-02-07	AIA	ETF	63.71	63.92	63.1	63.92	168005.0
2023-02-07	AIEQ	ETF	32.53	32.795	31.99	32.728	76000.0

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

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