PREVIEW / etf_daily / 2023-09-14

all etf daily files

  file:    by_date/etf_daily/2023/2023-09-14.parquet
  size:    108 KB
  rows:    3,016

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-09-14	SPY	ETF	449.07	451.08	447.72	450.36	83430800.0
2023-09-14	QQQ	ETF	375.99	378.27	373.89	377.27	48039388.0
2023-09-14	IWM	ETF	184.53	186.07	184.24	185.55	27952500.0
2023-09-14	DIA	ETF	348.66	350.63	347.73	349.94	3489400.0
2023-09-14	GLD	ETF	176.5	177.39	176.36	177.17	6184400.0
2023-09-14	TLT	ETF	93.94	94.21	93.4	93.53	27800600.0
2023-09-14	AAA	ETF	24.778	24.805	24.778	24.805	300.0
2023-09-14	AAAU	ETF	18.85	18.95	18.83	18.92	1076400.0
2023-09-14	AADR	ETF	50.65	50.78	50.65	50.78	200.0
2023-09-14	AAPB	ETF	23.76	24.14	23.5859	24.08	28150.0
2023-09-14	AAPD	ETF	22.49	22.5289	22.21	22.26	179692.0
2023-09-14	AAPU	ETF	24.36	24.7699	24.29	24.73	188660.0
2023-09-14	AAXJ	ETF	65.83	65.92	65.55	65.78	211600.0
2023-09-14	ABEQ	ETF	28.28	28.4	28.28	28.38	14400.0
2023-09-14	ACES	ETF	40.78	41.78	40.78	41.76	159600.0
2023-09-14	ACIO	ETF	31.46	31.645	31.46	31.63	52800.0
2023-09-14	ACSI	ETF	46.45	46.45	46.409	46.409	200.0
2023-09-14	ACT	ETF	28.03	28.34	27.69	27.73	111239.0
2023-09-14	ACTV	ETF	31.43	31.55	31.25	31.518	4200.0
2023-09-14	ACVF	ETF	34.76	34.8	34.67	34.755	5000.0
2023-09-14	ACWF	ETF	35.68	35.8	35.68	35.7508	2885.0
2023-09-14	ACWI	ETF	96.35	96.73	96.08	96.6	1336300.0
2023-09-14	ACWV	ETF	98.24	98.51	98.08	98.46	197500.0
2023-09-14	ACWX	ETF	48.63	48.88	48.57	48.83	594300.0
2023-09-14	ADFI	ETF	8.375	8.39	8.37	8.38	18000.0
2023-09-14	ADIV	ETF	13.695	13.695	13.695	13.695	100.0
2023-09-14	ADME	ETF	36.65	36.937	36.65	36.892	18600.0
2023-09-14	ADPV	ETF	24.97	25.0284	24.96	25.0284	3660.0
2023-09-14	AEMB	ETF	36.86	36.86	36.86	36.86	100.0
2023-09-14	AESR	ETF	12.85	12.86	12.8	12.821	35000.0
2023-09-14	AFIF	ETF	8.86	8.9	8.84	8.87	44400.0
2023-09-14	AFK	ETF	14.7	14.79	14.67	14.7	1300.0
2023-09-14	AFMC	ETF	24.67	24.7	24.67	24.7	400.0
2023-09-14	AFSM	ETF	24.69	24.8	24.69	24.8	1700.0
2023-09-14	AFTY	ETF	14.93	14.93	14.927	14.927	100.0
2023-09-14	AGG	ETF	95.96	95.98	95.68	95.71	5952800.0
2023-09-14	AGGH	ETF	22.02	22.02	21.975	21.9767	5048.0
2023-09-14	AGGY	ETF	42.38	42.38	42.27	42.29	68600.0
2023-09-14	AGNG	ETF	27.155	27.155	27.155	27.155	300.0
2023-09-14	AGOV	ETF	73.83	75.48	73.7501	73.827	6753.0
2023-09-14	AGOX	ETF	23.461	23.59	23.461	23.54	55500.0
2023-09-14	AGQ	ETF	25.36	26.07	25.0	25.76	1712100.0
2023-09-14	AGZ	ETF	106.25	106.48	106.25	106.35	32200.0
2023-09-14	AGZD	ETF	22.25	22.32	22.23	22.3	10700.0
2023-09-14	AHOY	ETF	20.39	20.5082	20.39	20.5082	1244.0
2023-09-14	AHYB	ETF	44.052	44.052	44.045	44.045	200.0
2023-09-14	AIA	ETF	58.02	58.14	57.91	57.92	42200.0
2023-09-14	AIEQ	ETF	30.96	31.13	30.96	31.104	7100.0
2023-09-14	AIQ	ETF	28.45	28.49	28.21	28.42	349500.0
2023-09-14	AIRR	ETF	53.3	53.92	53.3	53.92	38300.0

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

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