PREVIEW / etf_daily / 2023-11-14

all etf daily files

  file:    by_date/etf_daily/2023/2023-11-14.parquet
  size:    112 KB
  rows:    3,132

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-11-14	SPY	ETF	446.32	450.06	446.09	448.73	97176900.0
2023-11-14	QQQ	ETF	383.71	386.26	383.18	385.33	67792634.0
2023-11-14	IWM	ETF	174.23	178.47	174.22	178.46	77611000.0
2023-11-14	DIA	ETF	347.52	349.52	346.67	348.42	4815500.0
2023-11-14	GLD	ETF	181.7	182.75	181.62	182.12	6831600.0
2023-11-14	TLT	ETF	90.0	90.15	89.29	89.78	65666800.0
2023-11-14	AAA	ETF	24.91	24.928	24.86	24.895	7800.0
2023-11-14	AAAU	ETF	19.42	19.52	19.41	19.45	2487600.0
2023-11-14	AADR	ETF	50.95	50.95	50.95	50.95	100.0
2023-11-14	AAPB	ETF	26.2	26.54	26.2	26.36	26739.0
2023-11-14	AAPD	ETF	20.77	20.925	20.73	20.82	106962.0
2023-11-14	AAPU	ETF	26.82	26.92	26.5505	26.77	152119.0
2023-11-14	AAXJ	ETF	64.84	65.62	64.84	65.51	820400.0
2023-11-14	ABEQ	ETF	27.28	27.52	27.28	27.431	27100.0
2023-11-14	ACES	ETF	29.38	30.91	29.38	30.91	112100.0
2023-11-14	ACIO	ETF	31.7	31.99	31.7	31.9	58100.0
2023-11-14	ACSI	ETF	46.994	46.994	46.994	46.994	100.0
2023-11-14	ACT	ETF	28.44	28.66	27.86	28.43	1192213.0
2023-11-14	ACTV	ETF	29.32	29.56	29.32	29.46	7200.0
2023-11-14	ACVF	ETF	34.21	34.555	34.21	34.5	3300.0
2023-11-14	ACWF	ETF	35.9899	36.01	35.9348	36.0001	8648.0
2023-11-14	ACWI	ETF	95.76	96.62	95.57	96.39	3893200.0
2023-11-14	ACWV	ETF	97.28	97.63	96.99	97.43	143500.0
2023-11-14	ACWX	ETF	48.13	48.66	48.13	48.62	2339300.0
2023-11-14	ADFI	ETF	8.33	8.33	8.291	8.315	15200.0
2023-11-14	ADIV	ETF	13.725	13.725	13.725	13.725	100.0
2023-11-14	ADME	ETF	36.72	36.78	36.62	36.659	9800.0
2023-11-14	ADPV	ETF	23.13	23.54	23.13	23.49	13246.0
2023-11-14	AEMB	ETF	36.19	36.19	36.19	36.19	100.0
2023-11-14	AESR	ETF	12.77	12.915	12.77	12.9	347700.0
2023-11-14	AETH	ETF	30.815	30.815	29.22	29.6595	3800.0
2023-11-14	AFIF	ETF	8.92	8.95	8.92	8.92	62900.0
2023-11-14	AFK	ETF	13.66	13.94	13.5	13.94	11000.0
2023-11-14	AFLG	ETF	25.995	25.995	25.995	25.995	100.0
2023-11-14	AFMC	ETF	24.436	24.436	24.436	24.436	100.0
2023-11-14	AFSM	ETF	24.518	24.518	24.518	24.518	100.0
2023-11-14	AFTY	ETF	14.391	14.391	14.391	14.391	100.0
2023-11-14	AGG	ETF	95.03	95.2	94.93	95.13	12149600.0
2023-11-14	AGGH	ETF	21.39	21.48	21.3	21.45	385686.0
2023-11-14	AGGY	ETF	42.02	42.11	42.02	42.09	129400.0
2023-11-14	AGNG	ETF	26.03	26.08	26.03	26.08	47800.0
2023-11-14	AGOV	ETF	72.57	73.1038	72.0	73.1038	604.0
2023-11-14	AGOX	ETF	23.45	23.49	23.4	23.44	18600.0
2023-11-14	AGQ	ETF	25.56	26.33	25.46	26.15	1158000.0
2023-11-14	AGRH	ETF	25.67	25.67	25.645	25.645	6739.0
2023-11-14	AGZ	ETF	106.44	106.5	106.29	106.49	323500.0
2023-11-14	AGZD	ETF	22.27	22.3	22.21	22.28	69500.0
2023-11-14	AHLT	ETF	24.99	25.04	24.57	24.6209	15870.0
2023-11-14	AHYB	ETF	44.044	44.044	44.044	44.044	200.0
2023-11-14	AIA	ETF	57.84	58.51	57.8	58.42	21100.0

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

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