PREVIEW / etf_daily / 2023-09-20

all etf daily files

  file:    by_date/etf_daily/2023/2023-09-20.parquet
  size:    109 KB
  rows:    3,020

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-09-20	SPY	ETF	444.01	444.44	438.43	438.64	82562600.0
2023-09-20	QQQ	ETF	370.95	371.31	364.46	364.54	45514189.0
2023-09-20	IWM	ETF	182.4	183.51	179.82	179.86	27642900.0
2023-09-20	DIA	ETF	346.04	347.66	344.2	344.32	3411400.0
2023-09-20	GLD	ETF	179.34	180.66	179.32	179.35	9328000.0
2023-09-20	TLT	ETF	93.29	93.6	93.04	93.09	29451200.0
2023-09-20	AAA	ETF	24.8	24.88	24.8	24.835	8300.0
2023-09-20	AAAU	ETF	19.16	19.3	19.15	19.16	1387400.0
2023-09-20	AADR	ETF	50.94	50.94	50.37	50.37	600.0
2023-09-20	AAPB	ETF	24.7529	24.76	23.94	23.94	18959.0
2023-09-20	AAPD	ETF	21.64	22.1	21.6	22.1	131605.0
2023-09-20	AAPU	ETF	25.26	25.38	24.49	24.52	108176.0
2023-09-20	AAXJ	ETF	64.98	65.29	64.62	64.62	480100.0
2023-09-20	ABEQ	ETF	28.36	28.48	28.22	28.244	7200.0
2023-09-20	ACES	ETF	40.2	40.459	39.56	39.6	58400.0
2023-09-20	ACIO	ETF	31.3	31.3	31.005	31.02	69200.0
2023-09-20	ACSI	ETF	45.91	45.91	45.479	45.479	400.0
2023-09-20	ACT	ETF	28.28	28.39	28.07	28.09	122153.0
2023-09-20	ACTV	ETF	31.5	31.58	31.15	31.166	20200.0
2023-09-20	ACVF	ETF	34.34	34.35	33.948	33.948	2700.0
2023-09-20	ACWF	ETF	35.525	35.56	35.1577	35.1577	4289.0
2023-09-20	ACWI	ETF	95.82	96.02	94.85	94.89	1121300.0
2023-09-20	ACWV	ETF	98.42	98.67	97.94	97.94	449800.0
2023-09-20	ACWX	ETF	48.71	48.91	48.36	48.38	853400.0
2023-09-20	ADFI	ETF	8.32	8.34	8.32	8.328	9600.0
2023-09-20	ADIV	ETF	13.544	13.544	13.544	13.544	100.0
2023-09-20	ADME	ETF	36.44	36.468	36.09	36.103	24200.0
2023-09-20	ADPV	ETF	24.92	24.92	24.3641	24.3641	1665.0
2023-09-20	AEMB	ETF	36.74	36.8	36.705	36.705	300.0
2023-09-20	AESR	ETF	12.59	12.65	12.46	12.46	21900.0
2023-09-20	AFIF	ETF	8.89	8.92	8.89	8.91	1200.0
2023-09-20	AFK	ETF	14.48	14.9	14.15	14.15	76100.0
2023-09-20	AFLG	ETF	25.51	25.53	25.191	25.191	400.0
2023-09-20	AFMC	ETF	24.23	24.23	24.161	24.161	700.0
2023-09-20	AFSM	ETF	24.239	24.239	24.071	24.071	200.0
2023-09-20	AFTY	ETF	14.86	14.86	14.81	14.81	200.0
2023-09-20	AGG	ETF	95.57	95.7	95.3	95.3	6282700.0
2023-09-20	AGGH	ETF	21.9799	21.9899	21.85	21.96	21402.0
2023-09-20	AGGY	ETF	42.23	42.28	42.145	42.15	88100.0
2023-09-20	AGNG	ETF	26.88	27.03	26.75	26.787	8200.0
2023-09-20	AGOV	ETF	72.75	72.75	72.75	72.75	50.0
2023-09-20	AGOX	ETF	23.35	23.35	23.05	23.07	43500.0
2023-09-20	AGQ	ETF	27.19	28.02	27.15	27.3	945200.0
2023-09-20	AGZ	ETF	106.26	106.28	105.98	106.01	22100.0
2023-09-20	AGZD	ETF	22.3	22.4	22.26	22.31	27100.0
2023-09-20	AHLT	ETF	25.78	26.29	25.73	25.9871	3035.0
2023-09-20	AHYB	ETF	43.936	43.97	43.8	43.809	1300.0
2023-09-20	AIA	ETF	57.1	57.28	56.51	56.51	16200.0
2023-09-20	AIEQ	ETF	30.75	30.85	30.53	30.564	7100.0
2023-09-20	AIQ	ETF	27.88	27.958	27.42	27.46	223500.0

> showing 50 of 3,020 rows — these rows as CSV

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