PREVIEW / etf_daily / 2023-07-24

all etf daily files

  file:    by_date/etf_daily/2023/2023-07-24.parquet
  size:    107 KB
  rows:    2,995

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-07-24	SPY	ETF	453.37	455.04	452.3	454.2	54023400.0
2023-07-24	QQQ	ETF	376.62	377.58	374.34	376.23	40380056.0
2023-07-24	IWM	ETF	194.56	196.26	193.99	194.94	16929800.0
2023-07-24	DIA	ETF	352.71	354.57	352.53	354.07	3073700.0
2023-07-24	GLD	ETF	182.22	182.54	181.34	181.4	4370000.0
2023-07-24	TLT	ETF	101.99	102.15	101.3	101.36	17546700.0
2023-07-24	AAA	ETF	24.71	24.73	24.71	24.73	100.0
2023-07-24	AAAU	ETF	19.45	19.48	19.36	19.36	921500.0
2023-07-24	AADR	ETF	50.89	51.81	50.89	51.49	800.0
2023-07-24	AAPB	ETF	29.2	29.229	28.77	28.77	5472.0
2023-07-24	AAPD	ETF	20.1547	20.3066	20.0475	20.26	60528.0
2023-07-24	AAPU	ETF	28.91	29.19	28.63	28.76	130809.0
2023-07-24	AAXJ	ETF	67.49	68.62	67.47	68.34	717000.0
2023-07-24	ABEQ	ETF	28.73	28.73	28.51	28.58	15300.0
2023-07-24	ACES	ETF	48.33	48.63	47.88	48.44	20300.0
2023-07-24	ACIO	ETF	31.47	31.664	31.47	31.624	98800.0
2023-07-24	ACSI	ETF	48.011	48.011	48.011	48.011	100.0
2023-07-24	ACT	ETF	26.52	27.04	26.51	26.95	191304.0
2023-07-24	ACTV	ETF	32.93	33.0	32.87	32.918	9200.0
2023-07-24	ACVF	ETF	34.74	34.82	34.68	34.817	17900.0
2023-07-24	ACWF	ETF	36.19	36.35	36.19	36.2747	1738.0
2023-07-24	ACWI	ETF	98.1	98.5	97.96	98.34	3472400.0
2023-07-24	ACWV	ETF	99.94	100.07	99.85	99.97	107500.0
2023-07-24	ACWX	ETF	50.3	50.61	50.25	50.49	700700.0
2023-07-24	ADFI	ETF	8.48	8.5	8.46	8.47	32300.0
2023-07-24	ADIV	ETF	13.83	13.83	13.83	13.83	100.0
2023-07-24	ADME	ETF	36.92	37.117	36.87	37.07	62400.0
2023-07-24	ADPV	ETF	25.34	25.3903	25.32	25.3903	903.0
2023-07-24	AEMB	ETF	37.92	37.925	37.92	37.925	100.0
2023-07-24	AESR	ETF	13.03	13.063	13.02	13.049	51300.0
2023-07-24	AFIF	ETF	8.86	8.86	8.84	8.84	14300.0
2023-07-24	AFK	ETF	15.69	15.69	15.5	15.57	8700.0
2023-07-24	AFMC	ETF	25.543	25.543	25.538	25.538	300.0
2023-07-24	AFSM	ETF	25.75	25.75	25.682	25.682	400.0
2023-07-24	AFTY	ETF	15.05	15.26	15.05	15.22	1600.0
2023-07-24	AGG	ETF	98.1	98.16	97.79	97.81	6656600.0
2023-07-24	AGGH	ETF	22.65	22.66	22.6	22.62	452433.0
2023-07-24	AGGY	ETF	43.27	43.285	43.144	43.22	62800.0
2023-07-24	AGNG	ETF	28.15	28.15	27.93	27.967	800.0
2023-07-24	AGOV	ETF	76.0	77.5085	75.8	77.5085	4903.0
2023-07-24	AGOX	ETF	23.975	24.07	23.94	23.94	17800.0
2023-07-24	AGQ	ETF	30.76	30.94	30.38	30.55	493400.0
2023-07-24	AGZ	ETF	107.15	107.15	106.92	106.92	15300.0
2023-07-24	AGZD	ETF	22.19	22.235	22.125	22.19	30000.0
2023-07-24	AHOY	ETF	21.0899	21.0899	21.0496	21.0496	101.0
2023-07-24	AHYB	ETF	44.27	44.27	44.215	44.215	2600.0
2023-07-24	AIA	ETF	60.07	61.36	59.99	61.1	72600.0
2023-07-24	AIEQ	ETF	32.5	32.79	32.5	32.72	13900.0
2023-07-24	AIQ	ETF	28.67	28.78	28.44	28.7	272500.0
2023-07-24	AIRR	ETF	54.39	54.87	54.21	54.53	51700.0

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

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