PREVIEW / etf_daily / 2023-11-01

all etf daily files

  file:    by_date/etf_daily/2023/2023-11-01.parquet
  size:    112 KB
  rows:    3,139

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-11-01	SPY	ETF	419.2	423.5	418.65	422.66	98068100.0
2023-11-01	QQQ	ETF	351.72	357.5298	351.62	356.96	58992666.0
2023-11-01	IWM	ETF	164.46	165.6	163.1	165.46	44367100.0
2023-11-01	DIA	ETF	330.92	333.36	330.1	332.68	4546200.0
2023-11-01	GLD	ETF	183.91	185.0	182.67	183.51	9048600.0
2023-11-01	TLT	ETF	84.04	85.12	84.02	85.1	72308500.0
2023-11-01	AAA	ETF	24.824	24.92	24.824	24.855	4900.0
2023-11-01	AAAU	ETF	19.65	19.75	19.52	19.61	2186800.0
2023-11-01	AADR	ETF	47.12	48.19	47.12	48.19	400.0
2023-11-01	AAPB	ETF	22.741	23.295	22.6348	23.2	5923.0
2023-11-01	AAPD	ETF	22.8	22.93	22.3898	22.41	248516.0
2023-11-01	AAPU	ETF	23.38	24.02	23.18	23.95	154879.0
2023-11-01	AAXJ	ETF	61.28	61.83	61.2	61.83	660100.0
2023-11-01	ABEQ	ETF	27.05	27.07	26.86	26.98	26000.0
2023-11-01	ACES	ETF	29.55	29.64	28.89	29.34	54500.0
2023-11-01	ACIO	ETF	30.24	30.435	30.168	30.4	71100.0
2023-11-01	ACSI	ETF	44.25	44.258	44.25	44.258	500.0
2023-11-01	ACT	ETF	27.67	27.8	27.45	27.65	234422.0
2023-11-01	ACTV	ETF	27.651	27.77	27.5	27.749	14700.0
2023-11-01	ACVF	ETF	32.27	32.48	32.22	32.425	7300.0
2023-11-01	ACWF	ETF	33.69	33.9	33.56	33.8452	5454.0
2023-11-01	ACWI	ETF	90.23	91.05	90.09	90.92	6827900.0
2023-11-01	ACWV	ETF	94.12	94.74	94.11	94.55	538100.0
2023-11-01	ACWX	ETF	45.6	46.01	45.56	45.99	2675100.0
2023-11-01	ADFI	ETF	8.08	8.13	8.08	8.13	22500.0
2023-11-01	ADIV	ETF	13.01	13.03	13.01	13.03	300.0
2023-11-01	ADME	ETF	34.57	34.85	34.54	34.812	20800.0
2023-11-01	ADPV	ETF	22.36	22.3799	22.36	22.37	1145.0
2023-11-01	AEMB	ETF	35.27	35.325	35.27	35.325	1500.0
2023-11-01	AESR	ETF	11.84	11.94	11.815	11.92	24400.0
2023-11-01	AETH	ETF	27.38	28.04	27.38	27.7493	773.0
2023-11-01	AFIF	ETF	8.9	8.9	8.87	8.87	10700.0
2023-11-01	AFK	ETF	13.43	13.43	13.29	13.43	2900.0
2023-11-01	AFLG	ETF	24.5	24.543	24.5	24.543	900.0
2023-11-01	AFMC	ETF	22.36	22.88	22.36	22.827	5900.0
2023-11-01	AFSM	ETF	22.78	22.964	22.78	22.964	800.0
2023-11-01	AFTY	ETF	14.21	14.21	14.21	14.21	300.0
2023-11-01	AGG	ETF	92.23	93.05	92.23	93.05	14404600.0
2023-11-01	AGGH	ETF	20.75	21.1	20.6301	20.92	16354.0
2023-11-01	AGGY	ETF	40.86	41.175	40.86	41.17	126000.0
2023-11-01	AGNG	ETF	25.055	25.17	24.97	25.17	600.0
2023-11-01	AGOV	ETF	74.2	74.2	69.47	72.0075	5041.0
2023-11-01	AGOX	ETF	22.226	22.39	22.19	22.32	61600.0
2023-11-01	AGQ	ETF	25.51	26.13	25.06	25.78	1094700.0
2023-11-01	AGZ	ETF	105.15	105.56	105.15	105.56	27600.0
2023-11-01	AGZD	ETF	22.07	22.12	22.02	22.1	199000.0
2023-11-01	AHLT	ETF	26.74	26.85	26.311	26.3464	2937.0
2023-11-01	AHOY	ETF	19.06	19.15	19.06	19.15	1032.0
2023-11-01	AHYB	ETF	42.83	42.966	42.74	42.966	800.0
2023-11-01	AIA	ETF	53.95	54.48	53.86	54.48	28100.0

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

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