PREVIEW / etf_daily / 2023-07-25

all etf daily files

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

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-25	SPY	ETF	453.92	456.74	453.87	455.44	55191200.0
2023-07-25	QQQ	ETF	376.95	380.47	376.93	378.78	38894384.0
2023-07-25	IWM	ETF	194.58	196.21	194.42	194.92	18961100.0
2023-07-25	DIA	ETF	353.8	355.18	353.55	354.32	2548700.0
2023-07-25	GLD	ETF	181.72	182.47	181.1	182.41	4090100.0
2023-07-25	TLT	ETF	100.83	101.5	100.8	101.17	17160600.0
2023-07-25	AAA	ETF	24.72	24.73	24.72	24.73	100.0
2023-07-25	AAAU	ETF	19.4	19.49	19.35	19.47	557300.0
2023-07-25	AADR	ETF	52.08	52.26	52.08	52.26	900.0
2023-07-25	AAPB	ETF	29.0	29.17	29.0	29.02	3878.0
2023-07-25	AAPD	ETF	20.1799	20.21	20.08	20.17	69556.0
2023-07-25	AAPU	ETF	28.89	29.0953	28.82	28.94	72102.0
2023-07-25	AAXJ	ETF	69.12	69.3	68.89	68.95	520000.0
2023-07-25	ABEQ	ETF	28.6	28.68	28.6	28.648	4300.0
2023-07-25	ACES	ETF	48.45	48.71	47.89	47.91	24100.0
2023-07-25	ACIO	ETF	31.7	31.82	31.66	31.78	51700.0
2023-07-25	ACSI	ETF	47.796	47.796	47.796	47.796	100.0
2023-07-25	ACT	ETF	26.94	27.325	26.92	27.15	279256.0
2023-07-25	ACTV	ETF	32.91	33.17	32.86	33.03	6100.0
2023-07-25	ACVF	ETF	34.68	34.98	34.68	34.923	9900.0
2023-07-25	ACWF	ETF	36.27	36.4483	36.27	36.4019	2233.0
2023-07-25	ACWI	ETF	98.39	98.87	98.38	98.66	4697300.0
2023-07-25	ACWV	ETF	100.03	100.16	99.86	100.04	61300.0
2023-07-25	ACWX	ETF	50.6	50.75	50.6	50.67	1191400.0
2023-07-25	ADFI	ETF	8.46	8.47	8.45	8.45	16600.0
2023-07-25	ADIV	ETF	14.0	14.0	14.0	14.0	100.0
2023-07-25	ADME	ETF	37.14	37.33	37.07	37.22	17700.0
2023-07-25	ADPV	ETF	25.67	25.74	25.67	25.73	7078.0
2023-07-25	AEMB	ETF	37.86	37.86	37.86	37.86	100.0
2023-07-25	AESR	ETF	13.06	13.13	13.06	13.1	38500.0
2023-07-25	AFIF	ETF	8.85	8.88	8.74	8.74	37500.0
2023-07-25	AFK	ETF	15.57	15.69	15.57	15.63	8900.0
2023-07-25	AFLG	ETF	26.16	26.16	26.126	26.126	200.0
2023-07-25	AFMC	ETF	25.65	25.65	25.627	25.627	200.0
2023-07-25	AFSM	ETF	25.712	25.712	25.712	25.712	100.0
2023-07-25	AFTY	ETF	15.68	15.77	15.626	15.636	2200.0
2023-07-25	AGG	ETF	97.58	97.79	97.57	97.7	5794800.0
2023-07-25	AGGH	ETF	22.6	22.64	22.53	22.64	268899.0
2023-07-25	AGGY	ETF	42.94	43.0	42.927	42.975	106700.0
2023-07-25	AGNG	ETF	28.0	28.0	27.87	27.957	2600.0
2023-07-25	AGOV	ETF	75.94	77.37	75.94	77.37	716.0
2023-07-25	AGOX	ETF	24.09	24.21	23.99	24.01	21700.0
2023-07-25	AGQ	ETF	31.23	31.55	30.95	31.39	380500.0
2023-07-25	AGZ	ETF	106.8	106.87	106.76	106.87	10700.0
2023-07-25	AGZD	ETF	22.14	22.155	22.12	22.15	24600.0
2023-07-25	AHYB	ETF	44.13	44.16	44.13	44.16	800.0
2023-07-25	AIA	ETF	62.0	62.0	61.48	61.48	43900.0
2023-07-25	AIEQ	ETF	32.63	32.78	32.57	32.57	15000.0
2023-07-25	AIQ	ETF	28.83	29.025	28.812	28.92	275700.0
2023-07-25	AIRR	ETF	54.52	54.77	54.29	54.45	235600.0

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

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