PREVIEW / etf_daily / 2023-07-19

all etf daily files

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

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-19	SPY	ETF	455.01	456.43	454.11	455.2	65891700.0
2023-07-19	QQQ	ETF	386.82	387.98	384.3	385.65	54092958.0
2023-07-19	IWM	ETF	196.7	197.66	195.93	196.8	23679000.0
2023-07-19	DIA	ETF	350.4	352.45	350.4	350.69	5864300.0
2023-07-19	GLD	ETF	183.45	183.84	182.87	183.67	3911600.0
2023-07-19	TLT	ETF	102.0	102.98	101.73	102.95	27192500.0
2023-07-19	AAA	ETF	24.645	24.645	24.645	24.645	200.0
2023-07-19	AAAU	ETF	19.58	19.63	19.52	19.61	810200.0
2023-07-19	AADR	ETF	51.14	51.32	51.06	51.29	900.0
2023-07-19	AAPB	ETF	28.861	30.16	28.86	29.43	23300.0
2023-07-19	AAPD	ETF	20.17	20.24	19.69	20.0	144379.0
2023-07-19	AAPU	ETF	28.85	29.96	28.75	29.29	342603.0
2023-07-19	AAXJ	ETF	68.48	68.67	68.06	68.11	481700.0
2023-07-19	ABEQ	ETF	28.407	28.42	28.32	28.38	3000.0
2023-07-19	ACES	ETF	49.82	50.68	49.575	49.84	304500.0
2023-07-19	ACIO	ETF	31.645	31.718	31.48	31.64	28900.0
2023-07-19	ACSI	ETF	48.31	48.328	48.31	48.328	400.0
2023-07-19	ACT	ETF	26.91	27.02	26.79	26.91	218618.0
2023-07-19	ACTV	ETF	33.07	33.16	32.96	33.051	11000.0
2023-07-19	ACVF	ETF	34.99	34.99	34.799	34.805	14400.0
2023-07-19	ACWF	ETF	36.39	36.47	36.35	36.405	14821.0
2023-07-19	ACWI	ETF	98.6	98.85	98.44	98.6	6198500.0
2023-07-19	ACWV	ETF	98.89	99.21	98.8	99.01	432800.0
2023-07-19	ACWX	ETF	50.61	50.72	50.47	50.58	4063100.0
2023-07-19	ADFI	ETF	8.49	8.51	8.49	8.505	6700.0
2023-07-19	ADIV	ETF	13.794	13.825	13.794	13.825	400.0
2023-07-19	ADME	ETF	37.19	37.19	37.08	37.09	17300.0
2023-07-19	ADPV	ETF	25.96	25.96	25.86	25.935	1300.0
2023-07-19	AEMB	ETF	38.025	38.025	38.025	38.025	100.0
2023-07-19	AESR	ETF	13.185	13.2	13.15	13.2	25800.0
2023-07-19	AFIF	ETF	8.83	8.86	8.82	8.84	94600.0
2023-07-19	AFK	ETF	15.76	15.84	15.7	15.7	14800.0
2023-07-19	AFLG	ETF	26.078	26.078	26.078	26.078	100.0
2023-07-19	AFMC	ETF	25.81	25.85	25.762	25.835	26900.0
2023-07-19	AFSM	ETF	25.823	25.823	25.823	25.823	200.0
2023-07-19	AFTY	ETF	14.97	14.995	14.97	14.995	200.0
2023-07-19	AGG	ETF	98.35	98.48	98.19	98.43	7467900.0
2023-07-19	AGGH	ETF	22.63	22.7	22.62	22.7	173710.0
2023-07-19	AGGY	ETF	43.35	43.43	43.305	43.41	167500.0
2023-07-19	AGNG	ETF	27.895	27.917	27.79	27.868	5700.0
2023-07-19	AGOV	ETF	77.09	78.66	77.0	77.0	5892.0
2023-07-19	AGOX	ETF	24.24	24.24	24.07	24.12	37600.0
2023-07-19	AGQ	ETF	32.51	32.97	32.3	32.75	431200.0
2023-07-19	AGZ	ETF	107.28	107.28	107.11	107.24	13800.0
2023-07-19	AGZD	ETF	22.09	22.14	22.08	22.125	431400.0
2023-07-19	AHOY	ETF	21.09	21.09	21.03	21.0385	462.0
2023-07-19	AHYB	ETF	44.384	44.384	44.359	44.359	400.0
2023-07-19	AIA	ETF	61.3	61.59	61.02	61.05	16300.0
2023-07-19	AIEQ	ETF	32.15	32.6	32.15	32.6	19700.0
2023-07-19	AIQ	ETF	29.63	29.74	29.376	29.49	542800.0

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

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