PREVIEW / etf_daily / 2023-11-16

all etf daily files

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

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-16	SPY	ETF	449.22	450.56	448.12	450.23	66665800.0
2023-11-16	QQQ	ETF	384.84	386.19	383.56	385.95	45343544.0
2023-11-16	IWM	ETF	178.14	178.63	175.16	175.88	46616700.0
2023-11-16	DIA	ETF	349.58	350.8	348.75	350.02	3848000.0
2023-11-16	GLD	ETF	182.85	184.32	182.8	183.69	8253300.0
2023-11-16	TLT	ETF	89.3	89.96	89.25	89.62	49473900.0
2023-11-16	AAA	ETF	24.99	24.99	24.85	24.93	10400.0
2023-11-16	AAAU	ETF	19.53	19.69	19.53	19.63	1555000.0
2023-11-16	AADR	ETF	50.7	50.76	50.6	50.76	1800.0
2023-11-16	AAPB	ETF	26.97	27.09	26.79	26.98	22187.0
2023-11-16	AAPD	ETF	20.6	20.685	20.44	20.58	186671.0
2023-11-16	AAPU	ETF	27.22	27.51	27.09	27.29	105972.0
2023-11-16	AAXJ	ETF	65.26	65.74	65.16	65.39	551000.0
2023-11-16	ABEQ	ETF	27.43	27.481	27.37	27.481	13200.0
2023-11-16	ACES	ETF	31.33	31.41	30.467	30.68	155000.0
2023-11-16	ACIO	ETF	31.88	32.02	31.87	32.02	72900.0
2023-11-16	ACSI	ETF	47.151	47.151	47.151	47.151	100.0
2023-11-16	ACT	ETF	28.09	28.32	27.35	27.43	286850.0
2023-11-16	ACTV	ETF	29.4	29.45	29.25	29.31	9100.0
2023-11-16	ACVF	ETF	34.35	34.39	34.34	34.39	2400.0
2023-11-16	ACWF	ETF	36.02	36.02	35.8425	35.91	18789.0
2023-11-16	ACWI	ETF	96.37	96.67	96.11	96.52	2122600.0
2023-11-16	ACWV	ETF	96.95	97.34	96.95	97.18	163400.0
2023-11-16	ACWX	ETF	48.44	48.68	48.34	48.5	2542700.0
2023-11-16	ADFI	ETF	8.28	8.3	8.27	8.295	21000.0
2023-11-16	ADIV	ETF	13.651	13.665	13.651	13.665	500.0
2023-11-16	ADME	ETF	36.73	36.84	36.67	36.84	18300.0
2023-11-16	ADPV	ETF	23.16	23.29	23.16	23.21	15226.0
2023-11-16	ADVE	ETF	30.4215	30.4215	30.4163	30.4163	302.0
2023-11-16	AEMB	ETF	36.221	36.221	36.221	36.221	100.0
2023-11-16	AESR	ETF	12.88	12.95	12.88	12.95	29500.0
2023-11-16	AETH	ETF	30.35	30.46	29.23	29.397	3908.0
2023-11-16	AFIF	ETF	8.93	8.93	8.91	8.92	18600.0
2023-11-16	AFK	ETF	13.74	13.93	13.6	13.6	4500.0
2023-11-16	AFLG	ETF	25.968	25.968	25.968	25.968	100.0
2023-11-16	AFMC	ETF	24.314	24.335	24.214	24.214	1100.0
2023-11-16	AFSM	ETF	24.213	24.213	24.213	24.213	100.0
2023-11-16	AFTY	ETF	14.1	14.12	14.1	14.11	900.0
2023-11-16	AGG	ETF	94.85	95.2	94.85	95.06	10145400.0
2023-11-16	AGGH	ETF	21.4001	21.47	21.39	21.47	12779.0
2023-11-16	AGGY	ETF	42.05	42.18	42.05	42.17	122400.0
2023-11-16	AGNG	ETF	25.97	26.09	25.97	26.061	33300.0
2023-11-16	AGOX	ETF	23.4	23.44	23.35	23.38	13800.0
2023-11-16	AGQ	ETF	27.95	28.38	27.6	27.65	1269600.0
2023-11-16	AGZ	ETF	106.34	106.52	106.2	106.38	51800.0
2023-11-16	AGZD	ETF	22.31	22.31	22.18	22.27	51900.0
2023-11-16	AHLT	ETF	24.8	24.8	24.57	24.6973	3109.0
2023-11-16	AHYB	ETF	43.91	43.942	43.9	43.942	900.0
2023-11-16	AIA	ETF	58.27	58.61	58.12	58.21	124400.0
2023-11-16	AIEQ	ETF	30.62	30.826	30.527	30.62	9700.0

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

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