PREVIEW / etf_daily / 2023-11-15

all etf daily files

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

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-15	SPY	ETF	450.11	451.38	448.8	449.68	77327600.0
2023-11-15	QQQ	ETF	387.25	387.75	384.235	385.62	54141385.0
2023-11-15	IWM	ETF	178.35	181.76	178.11	178.77	59641400.0
2023-11-15	DIA	ETF	349.29	350.78	348.98	350.27	3149400.0
2023-11-15	GLD	ETF	182.03	182.18	181.31	181.64	4909400.0
2023-11-15	TLT	ETF	89.01	89.14	88.31	88.52	56205300.0
2023-11-15	AAA	ETF	24.818	24.98	24.818	24.915	12600.0
2023-11-15	AAAU	ETF	19.44	19.47	19.38	19.41	1717000.0
2023-11-15	AADR	ETF	51.03	51.15	50.54	50.7	6500.0
2023-11-15	AAPB	ETF	26.58	26.8801	26.49	26.58	18827.0
2023-11-15	AAPD	ETF	20.74	20.765	20.585	20.76	112740.0
2023-11-15	AAPU	ETF	26.88	27.2186	26.8647	26.91	119584.0
2023-11-15	AAPY	ETF	26.8	26.8	26.7641	26.7641	331.0
2023-11-15	AAXJ	ETF	65.86	66.51	65.86	66.13	754800.0
2023-11-15	ABEQ	ETF	27.51	27.57	27.49	27.49	1100.0
2023-11-15	ACES	ETF	31.04	32.37	31.04	31.57	119700.0
2023-11-15	ACIO	ETF	31.94	32.06	31.919	31.96	72200.0
2023-11-15	ACSI	ETF	47.347	47.347	47.347	47.347	100.0
2023-11-15	ACT	ETF	27.53	28.04	27.464	28.0	550872.0
2023-11-15	ACTV	ETF	29.64	30.06	29.64	29.784	26500.0
2023-11-15	ACVF	ETF	34.58	34.64	34.45	34.487	3700.0
2023-11-15	ACWF	ETF	36.1012	36.1012	36.0123	36.0123	1529.0
2023-11-15	ACWI	ETF	96.7	97.02	96.45	96.59	4183700.0
2023-11-15	ACWV	ETF	97.41	97.69	97.22	97.25	317000.0
2023-11-15	ACWX	ETF	48.73	48.92	48.64	48.67	1619600.0
2023-11-15	ADFI	ETF	8.26	8.26	8.24	8.26	7800.0
2023-11-15	ADIV	ETF	13.788	13.788	13.788	13.788	200.0
2023-11-15	ADME	ETF	36.88	36.88	36.71	36.75	33900.0
2023-11-15	ADPV	ETF	23.61	23.6101	23.4168	23.4168	754.0
2023-11-15	AEMB	ETF	36.09	36.09	35.995	35.995	500.0
2023-11-15	AESR	ETF	12.95	13.09	12.91	12.95	48100.0
2023-11-15	AETH	ETF	30.31	30.95	30.23	30.7513	885.0
2023-11-15	AFIF	ETF	8.89	8.91	8.89	8.9	23100.0
2023-11-15	AFK	ETF	14.0	14.3	13.98	13.98	12600.0
2023-11-15	AFLG	ETF	26.007	26.007	26.007	26.007	100.0
2023-11-15	AFMC	ETF	24.57	24.57	24.456	24.456	200.0
2023-11-15	AFSM	ETF	24.84	24.84	24.551	24.551	1100.0
2023-11-15	AFTY	ETF	14.361	14.38	14.361	14.362	500.0
2023-11-15	AGG	ETF	94.7	94.72	94.46	94.54	10956800.0
2023-11-15	AGGH	ETF	21.3758	21.3758	21.25	21.25	28175.0
2023-11-15	AGGY	ETF	41.97	41.99	41.865	41.94	342300.0
2023-11-15	AGNG	ETF	26.07	26.16	25.965	25.965	3000.0
2023-11-15	AGOX	ETF	23.57	23.63	23.46	23.51	17700.0
2023-11-15	AGQ	ETF	26.68	27.05	26.38	26.88	1024100.0
2023-11-15	AGRH	ETF	25.66	25.66	25.6451	25.6451	330.0
2023-11-15	AGZ	ETF	106.27	106.29	106.15	106.16	58700.0
2023-11-15	AGZD	ETF	22.24	22.32	22.06	22.28	35500.0
2023-11-15	AHLT	ETF	24.91	24.91	24.785	24.855	841.0
2023-11-15	AHOY	ETF	20.505	20.505	20.4634	20.4634	106.0
2023-11-15	AHYB	ETF	43.99	43.99	43.89	43.89	500.0

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

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