PREVIEW / etf_daily / 2023-01-03

all etf daily files

  file:    by_date/etf_daily/2023/2023-01-03.parquet
  size:    108 KB
  rows:    2,926

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-01-03	SPY	ETF	384.37	386.43	377.83	380.82	74850700.0
2023-01-03	QQQ	ETF	268.65	270.155	262.13	264.48	42335325.0
2023-01-03	IWM	ETF	175.93	177.32	171.9	173.4	22503800.0
2023-01-03	DIA	ETF	332.42	333.83	328.35	331.22	3910700.0
2023-01-03	GLD	ETF	171.32	172.09	170.02	171.06	7992900.0
2023-01-03	TLT	ETF	102.2	102.34	100.84	101.46	25313200.0
2023-01-03	AAA	ETF	24.365	24.365	24.365	24.365	12.0
2023-01-03	AAAU	ETF	18.27	18.35	18.14	18.24	319800.0
2023-01-03	AADR	ETF	47.84	47.84	47.14	47.19	3200.0
2023-01-03	AAPB	ETF	14.94	14.94	14.25	14.44	32653.0
2023-01-03	AAPD	ETF	30.11	31.59	30.0783	31.4	473496.0
2023-01-03	AAPU	ETF	16.76	16.7996	15.55	15.73	194511.0
2023-01-03	AAXJ	ETF	65.78	66.26	65.42	65.67	654300.0
2023-01-03	ABEQ	ETF	28.12	28.12	27.85	28.02	8000.0
2023-01-03	ACES	ETF	46.04	46.44	44.13	44.4	19300.0
2023-01-03	ACIO	ETF	28.79	28.956	28.64	28.77	27600.0
2023-01-03	ACSI	ETF	41.3573	41.3573	41.3573	41.3573	75.0
2023-01-03	ACT	ETF	24.24	24.45	23.765	24.19	251482.0
2023-01-03	ACTV	ETF	29.61	29.62	28.935	29.13	5650.0
2023-01-03	ACVF	ETF	29.99	29.99	29.408	29.625	10200.0
2023-01-03	ACWF	ETF	31.91	31.9722	31.57	31.7025	9004.0
2023-01-03	ACWI	ETF	85.51	86.02	84.4	84.9	13272000.0
2023-01-03	ACWV	ETF	95.49	95.71	94.89	95.45	137100.0
2023-01-03	ACWX	ETF	45.95	46.3	45.67	45.8	3331263.0
2023-01-03	ADFI	ETF	8.355	8.355	8.34	8.355	2400.0
2023-01-03	ADIV	ETF	13.206	13.206	13.206	13.206	100.0
2023-01-03	ADME	ETF	33.59	33.73	33.34	33.5	27800.0
2023-01-03	ADPV	ETF	25.12	25.14	25.06	25.1281	50804.0
2023-01-03	ADRE	ETF	37.79	37.82	37.373	37.373	5514.0
2023-01-03	AEMB	ETF	37.59	37.59	37.59	37.59	100.0
2023-01-03	AESR	ETF	11.45	11.45	11.3	11.36	24700.0
2023-01-03	AFIF	ETF	8.78	8.78	8.75	8.78	20945.0
2023-01-03	AFK	ETF	16.37	16.38	15.976	16.21	12609.0
2023-01-03	AFLG	ETF	22.93	23.016	22.93	23.016	200.0
2023-01-03	AFMC	ETF	21.97	22.118	21.97	22.118	100.0
2023-01-03	AFSM	ETF	22.497	22.497	22.497	22.497	200.0
2023-01-03	AFTY	ETF	15.876	15.876	15.876	15.876	100.0
2023-01-03	AGG	ETF	97.97	97.97	97.37	97.56	19930800.0
2023-01-03	AGGH	ETF	22.49	22.49	22.49	22.49	214.0
2023-01-03	AGGY	ETF	43.0	43.0	42.805	42.865	166300.0
2023-01-03	AGNG	ETF	26.3	26.3	26.29	26.3	2500.0
2023-01-03	AGOV	ETF	79.625	79.625	79.625	79.625	70.0
2023-01-03	AGOX	ETF	20.63	20.63	20.29	20.461	31100.0
2023-01-03	AGQ	ETF	33.25	33.53	31.99	32.02	1027300.0
2023-01-03	AGZ	ETF	107.04	107.04	106.6	106.62	21662.0
2023-01-03	AGZD	ETF	21.58	21.725	21.58	21.685	415000.0
2023-01-03	AHHX	ETF	8.45	8.45	8.33	8.36	172439.0
2023-01-03	AHYB	ETF	43.108	43.108	42.981	42.981	500.0
2023-01-03	AIA	ETF	57.82	58.5	57.64	57.94	21063.0
2023-01-03	AIEQ	ETF	28.64	28.85	28.288	28.328	9900.0

> showing 50 of 2,926 rows — these rows as CSV

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