PREVIEW / etf_daily / 2024-01-09

all etf daily files

  file:    by_date/etf_daily/2024/2024-01-09.parquet
  size:    115 KB
  rows:    3,205

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
2024-01-09	SPY	ETF	471.87	474.93	471.35	473.88	65931400.0
2024-01-09	QQQ	ETF	401.91	406.69	401.71	405.75	39132860.0
2024-01-09	IWM	ETF	194.35	195.77	193.32	194.97	28998700.0
2024-01-09	DIA	ETF	374.8	375.6	373.75	375.18	3230900.0
2024-01-09	GLD	ETF	188.68	188.78	187.73	187.93	4437300.0
2024-01-09	TLT	ETF	96.64	97.17	96.59	96.62	34374000.0
2024-01-09	AAA	ETF	25.11	25.11	25.05	25.06	4400.0
2024-01-09	AAAU	ETF	20.17	20.17	20.07	20.08	2333800.0
2024-01-09	AADR	ETF	54.71	54.71	54.64	54.64	200.0
2024-01-09	AAPB	ETF	21.09	21.33	20.91	21.33	19254.0
2024-01-09	AAPD	ETF	21.11	21.23	20.98	20.99	173427.0
2024-01-09	AAPU	ETF	25.53	25.74	25.26	25.74	99753.0
2024-01-09	AAPY	ETF	25.73	25.7871	25.73	25.7871	296.0
2024-01-09	AAXJ	ETF	64.02	64.11	63.83	64.0	515300.0
2024-01-09	ABCS	ETF	24.97	25.01	24.97	25.0014	12100.0
2024-01-09	ABEQ	ETF	28.53	28.57	28.48	28.561	16300.0
2024-01-09	ACES	ETF	33.27	33.27	32.8	33.03	17000.0
2024-01-09	ACIO	ETF	32.947	33.135	32.947	33.12	80700.0
2024-01-09	ACSI	ETF	49.22	49.69	49.22	49.635	1300.0
2024-01-09	ACT	ETF	28.49	28.6395	28.02	28.17	208687.0
2024-01-09	ACTV	ETF	33.07	33.115	32.96	33.03	5000.0
2024-01-09	ACVF	ETF	36.31	36.43	36.31	36.428	2000.0
2024-01-09	ACWF	ETF	37.53	37.6349	37.5018	37.6349	1487.0
2024-01-09	ACWI	ETF	100.48	101.03	100.41	100.82	4043600.0
2024-01-09	ACWV	ETF	100.56	100.6	100.33	100.52	83000.0
2024-01-09	ACWX	ETF	50.12	50.16	49.97	50.04	945400.0
2024-01-09	ADFI	ETF	8.55	8.55	8.54	8.545	5600.0
2024-01-09	ADIV	ETF	13.53	13.53	13.505	13.51	1200.0
2024-01-09	ADME	ETF	38.28	38.37	38.276	38.37	7900.0
2024-01-09	ADPV	ETF	24.2	24.2499	24.2	24.2499	1040.0
2024-01-09	AEMB	ETF	37.322	37.36	37.322	37.36	700.0
2024-01-09	AESR	ETF	13.67	13.79	13.67	13.72	22200.0
2024-01-09	AETH	ETF	31.54	31.54	30.911	31.0347	3219.0
2024-01-09	AFIF	ETF	9.07	9.07	9.03	9.03	22500.0
2024-01-09	AFK	ETF	13.99	14.03	13.81	13.98	9800.0
2024-01-09	AFLG	ETF	27.237	27.237	27.237	27.237	100.0
2024-01-09	AFMC	ETF	26.44	26.45	26.394	26.394	1000.0
2024-01-09	AFSM	ETF	26.652	26.8	26.652	26.73	700.0
2024-01-09	AFTY	ETF	12.855	12.855	12.855	12.855	100.0
2024-01-09	AGG	ETF	98.39	98.66	98.39	98.55	7157400.0
2024-01-09	AGGH	ETF	21.88	21.97	21.82	21.97	82277.0
2024-01-09	AGGY	ETF	43.64	43.726	43.64	43.72	60800.0
2024-01-09	AGNG	ETF	28.67	28.73	28.65	28.69	2800.0
2024-01-09	AGOX	ETF	24.04	24.054	23.93	23.96	32000.0
2024-01-09	AGQ	ETF	25.71	25.74	25.05	25.15	806000.0
2024-01-09	AGQI	ETF	13.1	13.19	13.1	13.17	33145.0
2024-01-09	AGZ	ETF	108.09	108.15	108.02	108.09	29400.0
2024-01-09	AGZD	ETF	21.97	21.97	21.9	21.95	13900.0
2024-01-09	AHLT	ETF	21.82	21.8856	21.82	21.8856	1269.0
2024-01-09	AHYB	ETF	45.149	45.274	45.149	45.274	1400.0

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

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