PREVIEW / etf_daily / 2023-06-15

all etf daily files

  file:    by_date/etf_daily/2023/2023-06-15.parquet
  size:    110 KB
  rows:    2,950

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-06-15	SPY	ETF	436.33	443.9	436.23	442.6	110303100.0
2023-06-15	QQQ	ETF	364.61	371.77	363.98	370.26	71138823.0
2023-06-15	IWM	ETF	185.08	187.57	184.91	187.44	36488400.0
2023-06-15	DIA	ETF	340.35	345.58	340.18	344.77	4722500.0
2023-06-15	GLD	ETF	180.28	182.05	180.18	181.91	6739000.0
2023-06-15	TLT	ETF	103.03	103.63	102.6	103.0	25732000.0
2023-06-15	AAA	ETF	24.6	24.6	24.56	24.6	589.0
2023-06-15	AAAU	ETF	19.25	19.44	19.24	19.42	1253000.0
2023-06-15	AADR	ETF	49.99	50.43	49.98	50.42	7700.0
2023-06-15	AAPB	ETF	26.915	27.46	26.915	27.41	15771.0
2023-06-15	AAPD	ETF	21.35	21.35	21.055	21.08	117807.0
2023-06-15	AAPU	ETF	27.18	27.66	27.13	27.6	88302.0
2023-06-15	AAXJ	ETF	68.9	69.17	68.73	69.13	460600.0
2023-06-15	ABEQ	ETF	28.49	28.49	28.318	28.378	10600.0
2023-06-15	ACES	ETF	45.39	46.342	45.28	46.2	46800.0
2023-06-15	ACIO	ETF	31.01	31.103	30.83	31.04	39500.0
2023-06-15	ACSI	ETF	46.6155	46.6155	46.6155	46.6155	54.0
2023-06-15	ACT	ETF	25.25	25.48	25.12	25.45	221323.0
2023-06-15	ACTV	ETF	31.27	31.67	31.27	31.6355	5273.0
2023-06-15	ACTX	ETF	0.08	0.23	0.08	0.23	679.0
2023-06-15	ACVF	ETF	33.35	33.85	33.33	33.751	7300.0
2023-06-15	ACWF	ETF	35.0963	35.5094	35.0963	35.4808	2278.0
2023-06-15	ACWI	ETF	95.24	96.56	95.16	96.36	2295700.0
2023-06-15	ACWV	ETF	97.63	98.5	97.46	98.43	249800.0
2023-06-15	ACWX	ETF	49.77	50.21	49.73	50.2	1341436.0
2023-06-15	ADFI	ETF	8.45	8.46	8.45	8.455	10300.0
2023-06-15	ADIV	ETF	14.03	14.06	14.03	14.06	500.0
2023-06-15	ADME	ETF	35.66	36.32	35.66	36.23	13500.0
2023-06-15	ADPV	ETF	24.2101	24.31	24.2101	24.2158	5234.0
2023-06-15	AEMB	ETF	37.66	37.68	37.66	37.68	4100.0
2023-06-15	AESR	ETF	12.58	12.84	12.58	12.8	53800.0
2023-06-15	AFIF	ETF	8.79	8.7901	8.76	8.77	179631.0
2023-06-15	AFK	ETF	15.98	15.98	15.71	15.75	9134.0
2023-06-15	AFMC	ETF	24.325	24.325	24.325	24.325	100.0
2023-06-15	AFSM	ETF	24.47	24.47	24.47	24.47	100.0
2023-06-15	AFTY	ETF	15.47	15.526	15.47	15.526	700.0
2023-06-15	AGG	ETF	98.29	98.46	98.13	98.45	7472000.0
2023-06-15	AGGH	ETF	22.77	22.81	22.67	22.6834	18427.0
2023-06-15	AGGY	ETF	43.2	43.32	43.158	43.29	278000.0
2023-06-15	AGNG	ETF	28.09	28.34	28.09	28.31	2600.0
2023-06-15	AGOV	ETF	75.975	75.975	75.975	75.975	3.0
2023-06-15	AGOX	ETF	23.45	23.53	23.197	23.43	7400.0
2023-06-15	AGQ	ETF	29.14	29.91	29.14	29.91	615600.0
2023-06-15	AGZ	ETF	107.26	107.3295	107.21	107.305	13871.0
2023-06-15	AGZD	ETF	21.95	22.075	21.95	22.035	37200.0
2023-06-15	AHYB	ETF	43.95	43.968	43.95	43.968	200.0
2023-06-15	AIA	ETF	62.8	63.06	62.423	63.02	45475.0
2023-06-15	AIEQ	ETF	31.14	31.65	31.14	31.642	10500.0
2023-06-15	AIQ	ETF	28.0	28.58	27.94	28.5	662791.0
2023-06-15	AIRR	ETF	51.85	52.34	51.658	52.11	85000.0

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

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