PREVIEW / etf_daily / 2023-06-14

all etf daily files

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

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-14	SPY	ETF	437.01	439.06	433.59	437.18	100612100.0
2023-06-14	QQQ	ETF	363.27	366.19	360.42	365.9	69525642.0
2023-06-14	IWM	ETF	188.32	189.24	184.55	185.91	37114100.0
2023-06-14	DIA	ETF	341.39	342.04	338.34	340.42	3766000.0
2023-06-14	GLD	ETF	181.69	181.96	180.14	180.64	6807000.0
2023-06-14	TLT	ETF	101.63	102.29	101.46	102.02	29094200.0
2023-06-14	AAA	ETF	24.5999	24.6	24.575	24.595	2502.0
2023-06-14	AAAU	ETF	19.39	19.42	19.23	19.27	3838000.0
2023-06-14	AADR	ETF	50.06	50.06	50.0	50.0	600.0
2023-06-14	AAPB	ETF	26.8	26.989	26.46	26.87	5095.0
2023-06-14	AAPD	ETF	21.4243	21.5499	21.2801	21.3478	137244.0
2023-06-14	AAPU	ETF	27.0	27.2182	26.71	27.11	89181.0
2023-06-14	AAXJ	ETF	68.04	68.76	68.04	68.61	548500.0
2023-06-14	ABEQ	ETF	28.35	28.373	28.19	28.23	5200.0
2023-06-14	ACES	ETF	46.84	46.84	45.38	45.74	24300.0
2023-06-14	ACIO	ETF	30.79	30.86	30.7	30.79	63500.0
2023-06-14	ACSI	ETF	46.1115	46.1115	46.1115	46.1115	49.0
2023-06-14	ACT	ETF	25.85	25.96	25.31	25.35	286860.0
2023-06-14	ACTV	ETF	31.6	31.65	31.12	31.388	17596.0
2023-06-14	ACTX	ETF	0.285	0.285	0.285	0.285	650.0
2023-06-14	ACVF	ETF	33.34	33.48	33.2	33.302	12100.0
2023-06-14	ACWF	ETF	35.06	35.1517	34.99	35.0406	4984.0
2023-06-14	ACWI	ETF	95.29	95.66	94.57	95.28	1349400.0
2023-06-14	ACWV	ETF	97.38	97.78	97.11	97.43	200100.0
2023-06-14	ACWX	ETF	49.69	49.88	49.41	49.68	1301846.0
2023-06-14	ADFI	ETF	8.45	8.45	8.43	8.445	11300.0
2023-06-14	ADIV	ETF	13.921	13.921	13.921	13.921	100.0
2023-06-14	ADME	ETF	35.926	35.96	35.63	35.89	14000.0
2023-06-14	ADPV	ETF	24.24	24.24	23.99	24.0534	652.0
2023-06-14	AEMB	ETF	37.522	37.522	37.522	37.522	100.0
2023-06-14	AESR	ETF	12.63	12.709	12.56	12.709	17500.0
2023-06-14	AFIF	ETF	8.98	8.98	8.81	8.81	10297.0
2023-06-14	AFK	ETF	15.79	15.9	15.79	15.9	4040.0
2023-06-14	AFLG	ETF	24.87	24.87	24.87	24.87	100.0
2023-06-14	AFMC	ETF	24.262	24.262	24.101	24.101	600.0
2023-06-14	AFSM	ETF	24.262	24.262	24.262	24.262	100.0
2023-06-14	AFTY	ETF	15.18	15.18	15.18	15.18	100.0
2023-06-14	AGG	ETF	97.88	97.99	97.45	97.77	8360100.0
2023-06-14	AGGH	ETF	22.7	22.7	22.6157	22.6157	10781.0
2023-06-14	AGGY	ETF	43.06	43.12	42.92	43.04	51300.0
2023-06-14	AGNG	ETF	28.13	28.25	28.01	28.12	4300.0
2023-06-14	AGOV	ETF	75.7	77.1436	75.7	77.1436	4302.0
2023-06-14	AGOX	ETF	23.09	23.325	23.09	23.25	44900.0
2023-06-14	AGQ	ETF	30.01	30.39	29.5	29.94	497600.0
2023-06-14	AGZ	ETF	107.11	107.13	106.7863	107.0	23832.0
2023-06-14	AGZD	ETF	22.065	22.1	21.99	22.035	40600.0
2023-06-14	AHOY	ETF	20.3	20.3	20.2334	20.2334	133.0
2023-06-14	AHYB	ETF	43.89	43.89	43.796	43.796	300.0
2023-06-14	AIA	ETF	61.94	62.72	61.93	62.62	113496.0
2023-06-14	AIEQ	ETF	31.66	31.758	31.15	31.269	16000.0

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

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