PREVIEW / etf_daily / 2023-12-13

all etf daily files

  file:    by_date/etf_daily/2023/2023-12-13.parquet
  size:    116 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
2023-12-13	SPY	ETF	464.49	470.76	464.12	470.5	93278000.0
2023-12-13	QQQ	ETF	399.62	404.36	398.8399	403.74	55408129.0
2023-12-13	IWM	ETF	187.1	193.64	185.67	193.33	69484800.0
2023-12-13	DIA	ETF	366.6	371.74	366.0	371.74	4304800.0
2023-12-13	GLD	ETF	183.82	187.66	183.38	187.63	10635500.0
2023-12-13	TLT	ETF	95.17	96.98	95.02	96.84	70828500.0
2023-12-13	AAA	ETF	25.03	25.043	24.95	25.0	3300.0
2023-12-13	AAAU	ETF	19.65	20.05	19.6	20.05	3117700.0
2023-12-13	AADR	ETF	54.31	55.39	54.31	55.39	900.0
2023-12-13	AAPB	ETF	28.1	28.72	28.05	28.72	9362.0
2023-12-13	AAPD	ETF	20.1	20.1	19.79	19.81	142354.0
2023-12-13	AAPU	ETF	28.3	28.92	28.3	28.89	122224.0
2023-12-13	AAPY	ETF	27.16	27.2182	27.16	27.2182	445.0
2023-12-13	AAXJ	ETF	64.47	65.42	64.13	65.4	790600.0
2023-12-13	ABEQ	ETF	27.91	28.341	27.84	28.341	7700.0
2023-12-13	ACES	ETF	31.34	33.8	31.315	33.72	93600.0
2023-12-13	ACIO	ETF	32.7	32.96	32.65	32.93	66600.0
2023-12-13	ACSI	ETF	49.871	49.871	49.871	49.871	100.0
2023-12-13	ACT	ETF	27.67	28.45	27.67	28.32	452026.0
2023-12-13	ACTV	ETF	31.64	32.597	31.586	32.597	5200.0
2023-12-13	ACVF	ETF	35.63	36.07	35.61	36.04	8600.0
2023-12-13	ACWF	ETF	37.14	37.697	37.14	37.6624	6286.0
2023-12-13	ACWI	ETF	99.47	100.8	99.18	100.75	6968900.0
2023-12-13	ACWV	ETF	99.86	101.2	99.86	101.11	297300.0
2023-12-13	ACWX	ETF	49.63	50.38	49.4	50.37	2154800.0
2023-12-13	ADFI	ETF	8.49	8.56	8.49	8.56	22800.0
2023-12-13	ADIV	ETF	13.573	13.573	13.573	13.573	200.0
2023-12-13	ADME	ETF	37.69	38.108	37.675	38.085	10700.0
2023-12-13	ADPV	ETF	24.12	24.1473	24.12	24.1473	2904.0
2023-12-13	ADVE	ETF	30.62	30.759	30.6198	30.759	1739.0
2023-12-13	AEMB	ETF	37.38	37.849	37.38	37.849	300.0
2023-12-13	AESR	ETF	13.41	13.56	13.35	13.53	24800.0
2023-12-13	AETH	ETF	32.64	33.6619	32.605	33.6619	4143.0
2023-12-13	AFIF	ETF	9.04	9.05	9.01	9.03	12300.0
2023-12-13	AFK	ETF	13.51	13.62	13.16	13.62	24200.0
2023-12-13	AFMC	ETF	25.7	26.112	25.7	26.112	200.0
2023-12-13	AFSM	ETF	26.274	26.274	26.274	26.274	100.0
2023-12-13	AFTY	ETF	13.4	13.543	13.37	13.543	1300.0
2023-12-13	AGG	ETF	97.39	98.45	97.33	98.41	11194400.0
2023-12-13	AGGH	ETF	21.81	21.93	21.64	21.93	21965.0
2023-12-13	AGGY	ETF	43.2	43.655	43.17	43.61	425100.0
2023-12-13	AGNG	ETF	27.44	28.0	27.06	28.0	1800.0
2023-12-13	AGOX	ETF	24.14	24.22	23.97	24.184	38700.0
2023-12-13	AGQ	ETF	24.86	27.29	24.51	27.24	2377700.0
2023-12-13	AGQI	ETF	12.9	13.06	12.87	13.04	33585.0
2023-12-13	AGZ	ETF	107.29	107.98	107.29	107.92	20700.0
2023-12-13	AGZD	ETF	22.01	22.13	21.94	21.98	76100.0
2023-12-13	AHLT	ETF	23.96	23.9732	23.96	23.9732	434.0
2023-12-13	AHYB	ETF	45.175	45.175	45.175	45.175	300.0
2023-12-13	AIA	ETF	55.88	56.76	55.39	56.76	136200.0

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

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