PREVIEW / etf_daily / 2023-01-09

all etf daily files

  file:    by_date/etf_daily/2023/2023-01-09.parquet
  size:    108 KB
  rows:    2,910

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-01-09	SPY	ETF	390.37	393.7	387.67	387.86	73978100.0
2023-01-09	QQQ	ETF	270.83	275.29	269.92	270.54	45568676.0
2023-01-09	IWM	ETF	179.01	180.12	177.65	177.88	18366500.0
2023-01-09	DIA	ETF	337.69	339.41	334.92	335.29	3864000.0
2023-01-09	GLD	ETF	174.51	175.04	173.88	174.1	5134500.0
2023-01-09	TLT	ETF	104.41	105.93	104.27	105.74	21472200.0
2023-01-09	AAA	ETF	24.375	24.375	24.375	24.375	2.0
2023-01-09	AAAU	ETF	18.62	18.67	18.55	18.57	675100.0
2023-01-09	AADR	ETF	48.45	48.45	48.25	48.29	1200.0
2023-01-09	AAPB	ETF	15.62	16.06	15.34	15.43	8973.0
2023-01-09	AAPD	ETF	30.03	30.18	29.38	30.12	179786.0
2023-01-09	AAPU	ETF	16.76	17.28	16.63	16.67	120894.0
2023-01-09	AAXJ	ETF	69.67	69.87	69.29	69.29	2563800.0
2023-01-09	ABEQ	ETF	28.7	28.76	28.501	28.525	13900.0
2023-01-09	ACES	ETF	45.73	46.85	45.73	46.12	151600.0
2023-01-09	ACIO	ETF	29.11	29.21	28.92	28.96	56100.0
2023-01-09	ACSI	ETF	42.96	42.96	42.6407	42.6407	4169.0
2023-01-09	ACT	ETF	23.99	24.2	23.61	23.75	146807.0
2023-01-09	ACTV	ETF	30.48	30.79	30.33	30.37	27233.0
2023-01-09	ACVF	ETF	30.3	30.59	30.19	30.19	3600.0
2023-01-09	ACWF	ETF	32.71	32.895	32.53	32.5473	5157.0
2023-01-09	ACWI	ETF	87.66	88.33	87.22	87.26	6658500.0
2023-01-09	ACWV	ETF	97.18	97.43	96.38	96.45	77700.0
2023-01-09	ACWX	ETF	47.81	48.075	47.615	47.62	4157793.0
2023-01-09	ADFI	ETF	8.52	8.57	8.51	8.57	17600.0
2023-01-09	ADIV	ETF	13.961	13.961	13.961	13.961	100.0
2023-01-09	ADME	ETF	33.9	33.987	33.58	33.58	27500.0
2023-01-09	ADPV	ETF	25.07	25.22	25.07	25.14	52206.0
2023-01-09	ADRE	ETF	40.78	40.7945	40.52	40.73	2496.0
2023-01-09	AEMB	ETF	38.5	38.5	38.5	38.5	100.0
2023-01-09	AESR	ETF	11.61	11.68	11.5	11.512	15300.0
2023-01-09	AFIF	ETF	8.83	8.83	8.805	8.81	22154.0
2023-01-09	AFK	ETF	16.85	17.05	16.69	16.69	24971.0
2023-01-09	AFLG	ETF	23.65	23.65	23.403	23.403	600.0
2023-01-09	AFMC	ETF	22.69	22.69	22.653	22.653	100.0
2023-01-09	AFSM	ETF	23.12	23.2	22.92	22.939	1900.0
2023-01-09	AFTY	ETF	16.92	16.96	16.851	16.851	500.0
2023-01-09	AGG	ETF	99.06	99.5	99.0	99.34	7849600.0
2023-01-09	AGGH	ETF	22.69	22.695	22.69	22.695	584.0
2023-01-09	AGGY	ETF	43.56	43.755	43.54	43.7	170500.0
2023-01-09	AGNG	ETF	26.97	26.97	26.64	26.64	1900.0
2023-01-09	AGOV	ETF	80.3305	80.3305	80.3305	80.3305	155.0
2023-01-09	AGOX	ETF	21.01	21.21	20.91	20.91	89500.0
2023-01-09	AGQ	ETF	31.8	32.21	30.91	31.0	614100.0
2023-01-09	AGZ	ETF	107.46	107.695	107.42	107.62	19783.0
2023-01-09	AGZD	ETF	21.79	21.83	21.705	21.785	151600.0
2023-01-09	AHHX	ETF	8.58	8.63	8.55	8.5838	198461.0
2023-01-09	AHYB	ETF	44.118	44.118	44.081	44.096	600.0
2023-01-09	AIA	ETF	63.02	63.1	62.48	62.48	81098.0
2023-01-09	AIEQ	ETF	29.3	29.777	29.3	29.52	6000.0

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

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