PREVIEW / etf_daily / 2023-11-17

all etf daily files

  file:    by_date/etf_daily/2023/2023-11-17.parquet
  size:    113 KB
  rows:    3,159

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-17	SPY	ETF	450.24	451.42	449.29	450.79	83133200.0
2023-11-17	QQQ	ETF	385.21	387.07	384.29	386.04	46622745.0
2023-11-17	IWM	ETF	177.45	178.64	177.11	178.29	43418700.0
2023-11-17	DIA	ETF	349.78	350.22	348.73	349.43	2059200.0
2023-11-17	GLD	ETF	183.96	184.13	183.45	183.67	4871100.0
2023-11-17	TLT	ETF	90.16	90.43	89.64	90.04	44091400.0
2023-11-17	AAA	ETF	24.98	25.0	24.98	24.98	2700.0
2023-11-17	AAAU	ETF	19.66	19.67	19.6	19.62	1102700.0
2023-11-17	AADR	ETF	51.04	51.04	51.04	51.04	100.0
2023-11-17	AAPB	ETF	26.921	26.98	26.7371	26.97	18563.0
2023-11-17	AAPD	ETF	20.52	20.7	20.52	20.59	106281.0
2023-11-17	AAPU	ETF	27.33	27.36	27.0697	27.27	81303.0
2023-11-17	AAPY	ETF	26.83	26.83	26.7814	26.8093	493.0
2023-11-17	AAXJ	ETF	65.51	65.63	65.3	65.5	288200.0
2023-11-17	ABEQ	ETF	27.54	27.54	27.51	27.512	2500.0
2023-11-17	ACES	ETF	30.84	30.84	30.26	30.81	20700.0
2023-11-17	ACIO	ETF	32.02	32.14	31.94	31.96	30300.0
2023-11-17	ACSI	ETF	47.304	47.304	47.304	47.304	100.0
2023-11-17	ACT	ETF	27.52	27.64	27.33	27.54	227823.0
2023-11-17	ACTV	ETF	29.48	29.71	29.48	29.61	15400.0
2023-11-17	ACVF	ETF	34.54	34.54	34.4	34.479	5300.0
2023-11-17	ACWF	ETF	36.09	36.1581	36.0601	36.1581	1331.0
2023-11-17	ACWI	ETF	96.81	97.04	96.61	96.95	4134900.0
2023-11-17	ACWV	ETF	97.45	97.64	97.29	97.41	133400.0
2023-11-17	ACWX	ETF	48.8	48.98	48.73	48.96	1330800.0
2023-11-17	ADFI	ETF	8.3	8.305	8.3	8.3	9600.0
2023-11-17	ADIV	ETF	13.764	13.764	13.764	13.764	100.0
2023-11-17	ADME	ETF	37.0	37.0	36.76	36.83	6900.0
2023-11-17	ADPV	ETF	23.49	23.4981	23.49	23.4981	1135.0
2023-11-17	AEMB	ETF	36.335	36.335	36.335	36.335	100.0
2023-11-17	AESR	ETF	12.93	12.98	12.913	12.98	15600.0
2023-11-17	AETH	ETF	28.8	29.2399	28.79	29.1529	5383.0
2023-11-17	AFIF	ETF	8.94	8.96	8.91	8.93	52200.0
2023-11-17	AFK	ETF	13.66	13.81	13.62	13.65	5200.0
2023-11-17	AFLG	ETF	26.042	26.042	26.042	26.042	100.0
2023-11-17	AFMC	ETF	24.448	24.448	24.448	24.448	200.0
2023-11-17	AFSM	ETF	24.55	24.55	24.46	24.543	500.0
2023-11-17	AFTY	ETF	14.24	14.24	14.24	14.24	100.0
2023-11-17	AGG	ETF	95.21	95.36	95.03	95.25	9244000.0
2023-11-17	AGGH	ETF	21.4389	21.46	21.36	21.4247	20833.0
2023-11-17	AGGY	ETF	42.21	42.31	42.145	42.249	123600.0
2023-11-17	AGNG	ETF	26.23	26.28	26.16	26.28	28100.0
2023-11-17	AGOX	ETF	23.54	23.57	23.48	23.48	21300.0
2023-11-17	AGQ	ETF	27.75	27.86	27.42	27.58	612400.0
2023-11-17	AGZ	ETF	106.41	106.46	106.38	106.42	14900.0
2023-11-17	AGZD	ETF	22.27	22.28	22.15	22.28	32200.0
2023-11-17	AHLT	ETF	24.58	24.6	24.568	24.568	867.0
2023-11-17	AHYB	ETF	43.979	44.03	43.979	44.016	1800.0
2023-11-17	AIA	ETF	58.17	58.39	58.07	58.26	16900.0
2023-11-17	AIEQ	ETF	30.64	30.77	30.64	30.769	5300.0

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

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