PREVIEW / etf_daily / 2023-06-09

all etf daily files

  file:    by_date/etf_daily/2023/2023-06-09.parquet
  size:    109 KB
  rows:    2,947

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-06-09	SPY	ETF	429.96	431.99	428.87	429.9	85742800.0
2023-06-09	QQQ	ETF	354.63	357.66	353.03	354.5	53196927.0
2023-06-09	IWM	ETF	186.32	186.61	184.45	185.03	30216600.0
2023-06-09	DIA	ETF	338.57	340.26	338.32	339.27	3162300.0
2023-06-09	GLD	ETF	182.36	182.79	181.72	182.04	4379200.0
2023-06-09	TLT	ETF	101.6	102.27	101.34	101.92	22147400.0
2023-06-09	AAA	ETF	24.53	24.53	24.53	24.53	45.0
2023-06-09	AAAU	ETF	19.46	19.51	19.4	19.43	1002800.0
2023-06-09	AADR	ETF	49.0	49.22	49.0	49.05	1200.0
2023-06-09	AAPB	ETF	26.29	26.44	26.15	26.15	6431.0
2023-06-09	AAPD	ETF	21.62	21.7	21.53	21.6723	78460.0
2023-06-09	AAPU	ETF	26.61	26.7526	26.435	26.51	131710.0
2023-06-09	AAXJ	ETF	67.24	67.56	67.2	67.23	334200.0
2023-06-09	ABEQ	ETF	28.28	28.28	28.179	28.21	3200.0
2023-06-09	ACES	ETF	45.33	45.452	44.56	44.57	15500.0
2023-06-09	ACIO	ETF	30.42	30.573	30.42	30.52	18000.0
2023-06-09	ACSI	ETF	45.7	45.7	45.6341	45.6341	218.0
2023-06-09	ACT	ETF	25.78	26.16	25.37	25.99	264329.0
2023-06-09	ACTV	ETF	31.053	31.07	30.9183	30.9183	16889.0
2023-06-09	ACTX	ETF	0.285	0.285	0.285	0.285	500.0
2023-06-09	ACVF	ETF	32.79	32.87	32.64	32.714	8800.0
2023-06-09	ACWF	ETF	34.54	34.595	34.4629	34.4921	5807.0
2023-06-09	ACWI	ETF	93.69	94.03	93.45	93.64	3250700.0
2023-06-09	ACWV	ETF	97.07	97.22	96.84	96.98	247100.0
2023-06-09	ACWX	ETF	48.87	48.975	48.76	48.84	717376.0
2023-06-09	ADFI	ETF	8.445	8.45	8.431	8.445	7300.0
2023-06-09	ADIV	ETF	13.74	13.75	13.72	13.72	300.0
2023-06-09	ADME	ETF	35.47	35.539	35.4	35.4	14700.0
2023-06-09	ADPV	ETF	23.92	23.92	23.8	23.8166	21314.0
2023-06-09	AESR	ETF	12.45	12.45	12.385	12.4	17000.0
2023-06-09	AFIF	ETF	8.8351	8.8351	8.81	8.8202	7134.0
2023-06-09	AFK	ETF	15.66	15.8199	15.585	15.6	11136.0
2023-06-09	AFLG	ETF	24.58	24.58	24.542	24.542	500.0
2023-06-09	AFMC	ETF	24.03	24.03	23.936	23.936	900.0
2023-06-09	AFSM	ETF	24.226	24.226	24.226	24.226	100.0
2023-06-09	AFTY	ETF	14.91	14.91	14.91	14.91	1200.0
2023-06-09	AGG	ETF	97.91	98.05	97.79	97.97	7140700.0
2023-06-09	AGGH	ETF	22.6999	22.73	22.69	22.69	4604.0
2023-06-09	AGGY	ETF	43.08	43.124	43.03	43.065	90200.0
2023-06-09	AGNG	ETF	27.82	27.82	27.71	27.71	3500.0
2023-06-09	AGOV	ETF	77.0	77.192	77.0	77.192	525.0
2023-06-09	AGOX	ETF	22.83	22.945	22.771	22.822	25200.0
2023-06-09	AGQ	ETF	30.81	31.52	30.68	30.9	522800.0
2023-06-09	AGZ	ETF	107.14	107.2	107.1	107.13	16003.0
2023-06-09	AGZD	ETF	21.88	21.98	21.865	21.925	21400.0
2023-06-09	AHOY	ETF	19.83	19.83	19.7982	19.7982	239.0
2023-06-09	AHYB	ETF	43.81	43.81	43.772	43.772	200.0
2023-06-09	AIA	ETF	61.09	61.24	60.82	60.93	81720.0
2023-06-09	AIEQ	ETF	30.98	31.06	30.766	30.79	16900.0
2023-06-09	AIQ	ETF	27.01	27.27	26.92	27.01	248262.0

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

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