PREVIEW / etf_daily / 2025-01-07

all etf daily files

  file:    by_date/etf_daily/2025/2025-01-07.parquet
  size:    146 KB
  rows:    3,889

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
2025-01-07	SPY	ETF	597.42	597.75	586.78	588.63	60304456.0
2025-01-07	QQQ	ETF	525.59	525.99	513.28	515.18	36690272.0
2025-01-07	IWM	ETF	225.58	226.515	221.38	222.72	28234305.0
2025-01-07	DIA	ETF	428.9	429.32	423.86	425.33	2031592.0
2025-01-07	GLD	ETF	245.52	245.77	243.81	244.56	5087572.0
2025-01-07	TLT	ETF	86.6	86.77	85.79	85.92	41653059.0
2025-01-07	AAA	ETF	25.14	25.15	25.08	25.1297	13095.0
2025-01-07	AAAU	ETF	26.29	26.3252	26.1199	26.195	3474517.0
2025-01-07	AADR	ETF	71.28	72.14	71.12	71.31	17403.0
2025-01-07	AAPB	ETF	31.74	32.41	31.34	31.52	60133.0
2025-01-07	AAPD	ETF	15.74	15.8467	15.58	15.8	1021087.0
2025-01-07	AAPR	ETF	26.39	26.4514	26.38	26.3952	2530.0
2025-01-07	AAPU	ETF	35.37	36.13	34.92	35.15	560663.0
2025-01-07	AAPX	ETF	30.28	30.8	29.91	30.07	28711.0
2025-01-07	AAPY	ETF	27.01	27.01	26.5	26.5	4468.0
2025-01-07	AAXJ	ETF	72.98	73.04	72.14	72.17	435022.0
2025-01-07	ABCS	ETF	28.86	28.86	28.63	28.7113	1315.0
2025-01-07	ABEQ	ETF	31.71	31.71	31.58	31.6263	786.0
2025-01-07	ABFL	ETF	67.0	67.06	66.7257	66.7257	163228.0
2025-01-07	ABHY	ETF	18.99	18.995	18.98	18.995	303.0
2025-01-07	ABLD	ETF	28.33	28.33	28.2539	28.2539	533.0
2025-01-07	ABLG	ETF	29.02	29.1342	28.93	28.9494	11744.0
2025-01-07	ABNY	ETF	76.75	76.775	74.25	74.7	2509.0
2025-01-07	ABOT	ETF	36.91	36.91	36.32	36.3884	1895.0
2025-01-07	ACES	ETF	28.19	28.6592	27.9	28.09	13735.0
2025-01-07	ACGR	ETF	58.6951	58.6951	58.237	58.237	918.0
2025-01-07	ACIO	ETF	40.66	40.7	40.19	40.27	168670.0
2025-01-07	ACLC	ETF	71.84	71.84	70.87	70.9708	4473.0
2025-01-07	ACSI	ETF	60.8525	60.8525	60.8525	60.8525	19.0
2025-01-07	ACT	ETF	31.76	31.99	31.67	31.94	173146.0
2025-01-07	ACTV	ETF	32.61	32.61	32.2992	32.4038	3373.0
2025-01-07	ACVF	ETF	44.61	44.61	43.9442	43.9523	5708.0
2025-01-07	ACWI	ETF	119.82	119.895	117.81	118.16	13461447.0
2025-01-07	ACWV	ETF	108.92	109.27	108.48	108.6	127295.0
2025-01-07	ACWX	ETF	53.08	53.1899	52.47	52.54	834981.0
2025-01-07	ADFI	ETF	8.3385	8.35	8.3247	8.3498	13320.0
2025-01-07	ADIV	ETF	15.3198	15.3198	15.3198	15.3198	9.0
2025-01-07	ADME	ETF	47.81	47.81	46.75	46.83	11010.0
2025-01-07	ADPV	ETF	36.46	36.46	35.71	35.9023	6402.0
2025-01-07	ADVE	ETF	32.05	32.05	31.8853	31.8853	289.0
2025-01-07	AESR	ETF	17.79	17.79	17.47	17.52	20432.0
2025-01-07	AETH	ETF	35.39	35.56	33.86	33.86	4441.0
2025-01-07	AFIF	ETF	9.18	9.19	9.15	9.165	24262.0
2025-01-07	AFIX	ETF	24.3836	24.3836	24.3836	24.3836	3.0
2025-01-07	AFK	ETF	16.22	16.22	15.94	15.94	5910.0
2025-01-07	AFLG	ETF	35.3	35.3	34.7	34.82	124635.0
2025-01-07	AFMC	ETF	32.03	32.03	31.63	31.77	5610.0
2025-01-07	AFSM	ETF	30.31	30.31	29.87	30.0218	9151.0
2025-01-07	AGG	ETF	96.61	96.675	96.24	96.37	9152696.0
2025-01-07	AGGH	ETF	20.49	20.55	20.3584	20.43	66537.0

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

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