PREVIEW / etf_daily / 2023-06-05

all etf daily files

  file:    by_date/etf_daily/2023/2023-06-05.parquet
  size:    110 KB
  rows:    3,000

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-05	SPY	ETF	428.28	429.62	426.37	427.1	65460200.0
2023-06-05	QQQ	ETF	354.43	357.495	353.85	354.9	47266228.0
2023-06-05	IWM	ETF	181.26	181.26	178.44	179.58	34465800.0
2023-06-05	DIA	ETF	338.21	338.48	335.96	336.13	3415600.0
2023-06-05	GLD	ETF	180.79	182.44	180.6	182.14	5748800.0
2023-06-05	TLT	ETF	101.35	102.44	101.21	101.8	14433200.0
2023-06-05	AAA	ETF	24.48	24.48	24.48	24.48	211.0
2023-06-05	AAAU	ETF	19.3	19.47	19.28	19.44	1139700.0
2023-06-05	AADR	ETF	47.5	47.92	45.76	47.8	4000.0
2023-06-05	AAPB	ETF	26.63	27.24	25.71	25.83	74010.0
2023-06-05	AAPD	ETF	21.47	21.9942	21.175	21.83	449908.0
2023-06-05	AAPU	ETF	26.88	27.399	25.9036	26.2	730194.0
2023-06-05	AAXJ	ETF	66.77	66.92	66.61	66.86	239500.0
2023-06-05	ABEQ	ETF	28.44	28.44	28.15	28.15	4900.0
2023-06-05	ACES	ETF	44.47	44.74	44.01	44.15	25300.0
2023-06-05	ACIO	ETF	30.495	30.58	30.45	30.5	49000.0
2023-06-05	ACSI	ETF	45.19	45.19	45.1187	45.1187	230.0
2023-06-05	ACT	ETF	25.29	25.4456	24.74	24.95	201030.0
2023-06-05	ACTV	ETF	30.19	30.239	30.0616	30.0616	19906.0
2023-06-05	ACVF	ETF	32.59	32.65	32.43	32.452	19700.0
2023-06-05	ACWF	ETF	34.72	34.7499	34.611	34.6177	4068.0
2023-06-05	ACWI	ETF	94.12	94.28	93.71	93.84	4295300.0
2023-06-05	ACWV	ETF	97.79	98.0	97.48	97.61	311000.0
2023-06-05	ACWX	ETF	49.26	49.295	49.08	49.1	1388794.0
2023-06-05	ADFI	ETF	8.46	8.46	8.44	8.455	34400.0
2023-06-05	ADIV	ETF	13.49	13.49	13.43	13.49	3200.0
2023-06-05	ADME	ETF	35.59	35.59	35.28	35.36	20100.0
2023-06-05	ADPV	ETF	23.37	23.45	23.28	23.4	6496.0
2023-06-05	AEMB	ETF	37.281	37.281	37.281	37.281	100.0
2023-06-05	AESR	ETF	12.41	12.5	12.36	12.37	46000.0
2023-06-05	AFIF	ETF	8.85	8.88	8.81	8.86	26873.0
2023-06-05	AFK	ETF	15.33	15.4	15.2501	15.3	4379.0
2023-06-05	AFLG	ETF	24.327	24.327	24.327	24.327	100.0
2023-06-05	AFMC	ETF	23.15	23.153	23.12	23.153	500.0
2023-06-05	AFSM	ETF	23.35	23.35	23.322	23.322	300.0
2023-06-05	AFTY	ETF	14.95	14.964	14.95	14.964	100.0
2023-06-05	AGG	ETF	97.85	98.32	97.77	98.08	7246200.0
2023-06-05	AGGH	ETF	22.68	22.7	22.67	22.7	640.0
2023-06-05	AGGY	ETF	43.05	43.24	43.03	43.165	489100.0
2023-06-05	AGNG	ETF	27.74	27.78	27.63	27.695	6400.0
2023-06-05	AGOV	ETF	77.91	77.91	76.76	77.31	659.0
2023-06-05	AGOX	ETF	22.51	22.625	22.46	22.55	20600.0
2023-06-05	AGQ	ETF	28.83	29.46	28.63	29.16	316200.0
2023-06-05	AGZ	ETF	107.1	107.39	107.1	107.3	26214.0
2023-06-05	AGZD	ETF	21.91	21.93	21.855	21.885	40000.0
2023-06-05	AHYB	ETF	43.625	43.625	43.625	43.625	100.0
2023-06-05	AIA	ETF	60.06	60.24	59.87	60.09	61438.0
2023-06-05	AIEQ	ETF	30.32	30.32	29.88	30.0	41000.0
2023-06-05	AIQ	ETF	26.71	26.84	26.5078	26.68	271329.0
2023-06-05	AIRR	ETF	50.28	50.28	49.321	49.8	54900.0

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

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