PREVIEW / etf_daily / 2022-12-30

all etf daily files

  file:    by_date/etf_daily/2022/2022-12-30.parquet
  size:    107 KB
  rows:    2,875

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
2022-12-30	SPY	ETF	380.64	382.58	378.43	382.43	84022200.0
2022-12-30	QQQ	ETF	263.62	266.41	262.29	266.28	37858277.0
2022-12-30	IWM	ETF	173.34	174.72	172.61	174.36	21275600.0
2022-12-30	DIA	ETF	330.62	331.4	328.35	331.33	3881800.0
2022-12-30	GLD	ETF	169.26	169.9	168.8	169.64	2864500.0
2022-12-30	TLT	ETF	99.87	100.55	99.37	99.56	20810200.0
2022-12-30	AAA	ETF	24.38	24.38	24.37	24.37	307.0
2022-12-30	AAAU	ETF	18.06	18.11	18.0	18.09	138400.0
2022-12-30	AADR	ETF	47.29	47.76	47.29	47.76	1200.0
2022-12-30	AAPB	ETF	15.08	15.38	15.0451	15.38	900.0
2022-12-30	AAPD	ETF	30.65	30.825	30.23	30.23	180574.0
2022-12-30	AAPU	ETF	16.28	16.65	16.1899	16.65	64151.0
2022-12-30	AAXJ	ETF	65.29	65.48	64.62	64.79	572600.0
2022-12-30	ABEQ	ETF	27.84	27.84	27.735	27.827	3500.0
2022-12-30	ACES	ETF	44.94	45.59	44.84	45.49	139000.0
2022-12-30	ACIO	ETF	28.784	28.83	28.64	28.83	60100.0
2022-12-30	ACSI	ETF	41.692	41.692	41.692	41.692	126.0
2022-12-30	ACT	ETF	23.99	24.34	23.85	24.12	77089.0
2022-12-30	ACTV	ETF	29.0	29.32	28.77	29.32	35034.0
2022-12-30	ACTX	ETF	0.331	0.331	0.331	0.331	202.0
2022-12-30	ACVF	ETF	29.67	29.732	29.629	29.732	2300.0
2022-12-30	ACWF	ETF	31.75	31.7589	31.58	31.7589	3548.0
2022-12-30	ACWI	ETF	84.82	85.06	84.33	84.88	4201900.0
2022-12-30	ACWV	ETF	95.06	95.47	94.6	95.02	154200.0
2022-12-30	ACWX	ETF	45.74	45.9	45.43	45.5	2262931.0
2022-12-30	ADFI	ETF	8.32	8.33	8.302	8.315	26600.0
2022-12-30	ADIV	ETF	13.08	13.13	13.07	13.103	2700.0
2022-12-30	ADME	ETF	33.57	33.586	33.43	33.586	29700.0
2022-12-30	ADPV	ETF	25.11	25.11	25.089	25.105	10352.0
2022-12-30	ADRE	ETF	37.33	37.4833	37.155	37.4	9207.0
2022-12-30	AESR	ETF	11.4	11.46	11.35	11.45	37400.0
2022-12-30	AFIF	ETF	8.7363	8.76	8.72	8.76	22987.0
2022-12-30	AFK	ETF	16.14	16.27	15.96	16.06	13899.0
2022-12-30	AFLG	ETF	23.028	23.124	23.01	23.124	6800.0
2022-12-30	AFTY	ETF	15.925	15.925	15.83	15.854	2900.0
2022-12-30	AGG	ETF	97.25	97.36	96.97	96.99	8469000.0
2022-12-30	AGGH	ETF	22.36	22.38	22.36	22.38	710.0
2022-12-30	AGGY	ETF	42.78	42.78	42.63	42.65	550300.0
2022-12-30	AGNG	ETF	25.99	26.193	25.98	26.193	700.0
2022-12-30	AGOV	ETF	78.97	78.97	78.97	78.97	39.0
2022-12-30	AGOX	ETF	20.36	20.56	20.3	20.494	11300.0
2022-12-30	AGQ	ETF	31.75	32.03	30.87	32.0	500800.0
2022-12-30	AGZ	ETF	106.57	106.83	106.43	106.43	35616.0
2022-12-30	AGZD	ETF	21.65	21.785	21.65	21.73	210600.0
2022-12-30	AHHX	ETF	8.311	8.36	8.311	8.34	2447.0
2022-12-30	AIA	ETF	57.19	57.43	56.64	56.74	50563.0
2022-12-30	AIEQ	ETF	28.22	28.481	28.145	28.481	10000.0
2022-12-30	AIQ	ETF	20.0738	20.14	19.85	20.1	64460.0
2022-12-30	AIRR	ETF	43.97	44.12	43.64	44.12	26700.0
2022-12-30	AIVI	ETF	36.24	36.24	36.08	36.12	8200.0

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

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