PREVIEW / etf_daily / 2023-07-14

all etf daily files

  file:    by_date/etf_daily/2023/2023-07-14.parquet
  size:    107 KB
  rows:    2,974

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-07-14	SPY	ETF	450.48	451.36	448.49	449.28	69761800.0
2023-07-14	QQQ	ETF	379.585	382.86	378.18	379.07	55148500.0
2023-07-14	IWM	ETF	193.34	193.49	190.29	191.53	32165700.0
2023-07-14	DIA	ETF	345.71	345.92	344.51	345.17	3292300.0
2023-07-14	GLD	ETF	181.59	182.17	181.11	181.43	5389300.0
2023-07-14	TLT	ETF	101.72	101.94	101.24	101.29	18566200.0
2023-07-14	AAA	ETF	24.605	24.65	24.605	24.62	800.0
2023-07-14	AAAU	ETF	19.39	19.45	19.34	19.37	1375900.0
2023-07-14	AADR	ETF	50.76	50.76	50.39	50.73	9800.0
2023-07-14	AAPB	ETF	28.26	28.37	28.15	28.36	8298.0
2023-07-14	AAPD	ETF	20.51	20.5491	20.4	20.4661	45995.0
2023-07-14	AAPU	ETF	28.24	28.4234	28.0895	28.31	93626.0
2023-07-14	AAXJ	ETF	69.17	69.17	68.82	68.88	476300.0
2023-07-14	ABEQ	ETF	28.062	28.141	28.03	28.09	24800.0
2023-07-14	ACES	ETF	48.99	48.99	47.56	47.71	40500.0
2023-07-14	ACIO	ETF	31.35	31.429	31.282	31.32	39500.0
2023-07-14	ACSI	ETF	47.431	47.46	47.295	47.295	1200.0
2023-07-14	ACT	ETF	26.6	26.6	26.33	26.49	318832.0
2023-07-14	ACTV	ETF	32.53	32.53	32.23	32.43	10200.0
2023-07-14	ACTX	ETF	0.21	0.21	0.21	0.21	1134.0
2023-07-14	ACVF	ETF	34.32	34.45	34.287	34.287	9700.0
2023-07-14	ACWF	ETF	36.13	36.215	36.03	36.0401	14102.0
2023-07-14	ACWI	ETF	98.04	98.1	97.57	97.68	2875800.0
2023-07-14	ACWV	ETF	98.44	98.75	98.41	98.67	253500.0
2023-07-14	ACWX	ETF	50.7	50.7	50.39	50.41	1910600.0
2023-07-14	ADFI	ETF	8.495	8.5	8.48	8.495	8200.0
2023-07-14	ADME	ETF	36.64	36.76	36.61	36.663	8600.0
2023-07-14	ADPV	ETF	25.71	25.71	25.42	25.4608	34200.0
2023-07-14	AEMB	ETF	37.915	37.96	37.905	37.905	1000.0
2023-07-14	AESR	ETF	12.96	13.04	12.95	12.95	16100.0
2023-07-14	AFIF	ETF	8.87	8.91	8.87	8.89	16200.0
2023-07-14	AFK	ETF	15.3	15.68	15.14	15.35	7300.0
2023-07-14	AFMC	ETF	25.66	25.66	25.29	25.346	800.0
2023-07-14	AFSM	ETF	25.13	25.133	25.13	25.133	400.0
2023-07-14	AFTY	ETF	15.337	15.38	15.32	15.32	1600.0
2023-07-14	AGG	ETF	98.23	98.31	97.92	97.94	7208400.0
2023-07-14	AGGH	ETF	23.53	23.53	22.56	22.59	13194.0
2023-07-14	AGGY	ETF	43.33	43.36	43.17	43.185	183000.0
2023-07-14	AGIH	ETF	24.43	24.4301	24.395	24.395	250.0
2023-07-14	AGNG	ETF	27.85	27.95	27.8	27.82	3500.0
2023-07-14	AGOV	ETF	76.0	77.0	76.0	77.0	1083.0
2023-07-14	AGOX	ETF	23.88	23.93	23.75	23.77	7300.0
2023-07-14	AGQ	ETF	31.96	32.43	31.79	32.11	799100.0
2023-07-14	AGZ	ETF	107.21	107.3	107.01	107.01	18700.0
2023-07-14	AGZD	ETF	22.15	22.15	22.085	22.115	35400.0
2023-07-14	AHYB	ETF	44.098	44.098	44.098	44.098	200.0
2023-07-14	AIA	ETF	62.49	62.49	62.13	62.13	20100.0
2023-07-14	AIEQ	ETF	32.32	32.32	31.9	31.974	20700.0
2023-07-14	AIQ	ETF	29.19	29.329	28.94	29.01	478500.0
2023-07-14	AIRR	ETF	54.52	54.52	53.4	53.54	142900.0

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

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