PREVIEW / etf_daily / 2022-12-20

all etf daily files

  file:    by_date/etf_daily/2022/2022-12-20.parquet
  size:    106 KB
  rows:    2,886

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-20	SPY	ETF	379.23	382.23	377.85	380.54	74427200.0
2022-12-20	QQQ	ETF	268.56	271.32	266.95	269.54	51064199.0
2022-12-20	IWM	ETF	171.67	174.02	171.18	172.92	18050800.0
2022-12-20	DIA	ETF	327.59	329.87	326.41	328.38	4721700.0
2022-12-20	GLD	ETF	168.1	169.53	168.03	169.08	7803100.0
2022-12-20	TLT	ETF	103.38	103.81	103.1	103.44	28869000.0
2022-12-20	AAA	ETF	24.42	24.42	24.42	24.42	2.0
2022-12-20	AAAU	ETF	17.93	18.08	17.92	18.04	609900.0
2022-12-20	AADR	ETF	48.13	48.22	48.13	48.14	300.0
2022-12-20	AAPB	ETF	15.59	16.03	15.59	16.03	2189.0
2022-12-20	AAPD	ETF	29.91	30.26	29.54	29.7248	167593.0
2022-12-20	AAPU	ETF	17.01	17.33	16.71	17.16	171435.0
2022-12-20	AAXJ	ETF	64.43	64.92	64.38	64.6	553600.0
2022-12-20	ABEQ	ETF	27.615	27.83	27.615	27.7	21300.0
2022-12-20	ACES	ETF	48.11	49.105	47.62	47.96	140500.0
2022-12-20	ACIO	ETF	28.84	29.0	28.84	28.92	62900.0
2022-12-20	ACSI	ETF	41.6901	41.8018	41.6901	41.8018	1001.0
2022-12-20	ACT	ETF	23.91	24.53	23.8	24.44	198149.0
2022-12-20	ACTV	ETF	28.73	29.01	28.62	28.9	16945.0
2022-12-20	ACVF	ETF	29.51	29.77	29.51	29.648	3300.0
2022-12-20	ACWF	ETF	31.6	31.759	31.59	31.5931	38727.0
2022-12-20	ACWI	ETF	84.4	84.96	84.1	84.59	9583300.0
2022-12-20	ACWV	ETF	94.23	94.87	94.23	94.58	260900.0
2022-12-20	ACWX	ETF	45.34	45.59	45.235	45.4	1986861.0
2022-12-20	ADFI	ETF	8.37	8.41	8.37	8.385	12600.0
2022-12-20	ADIV	ETF	12.9	12.913	12.9	12.913	700.0
2022-12-20	ADME	ETF	33.88	33.91	33.82	33.828	54600.0
2022-12-20	ADPV	ETF	25.13	25.16	25.1	25.1	21242.0
2022-12-20	ADRE	ETF	37.36	37.6	37.36	37.485	6001.0
2022-12-20	AEMB	ETF	37.7	37.7	37.41	37.65	2900.0
2022-12-20	AESR	ETF	11.4	11.46	11.32	11.39	59600.0
2022-12-20	AFIF	ETF	8.79	8.79	8.77	8.79	32503.0
2022-12-20	AFK	ETF	16.09	16.12	15.94	15.96	10078.0
2022-12-20	AFLG	ETF	23.26	23.26	23.213	23.213	300.0
2022-12-20	AFMC	ETF	22.18	22.18	22.1	22.1	100.0
2022-12-20	AFSM	ETF	22.636	22.636	22.636	22.636	300.0
2022-12-20	AFTY	ETF	15.82	15.83	15.771	15.793	900.0
2022-12-20	AGG	ETF	98.1	98.26	97.98	98.07	10282200.0
2022-12-20	AGGY	ETF	43.26	43.32	43.2	43.23	252400.0
2022-12-20	AGNG	ETF	26.0	26.06	25.959	25.97	2800.0
2022-12-20	AGOV	ETF	81.0	81.6213	81.0	81.6213	2884.0
2022-12-20	AGOX	ETF	20.43	20.59	20.43	20.503	13900.0
2022-12-20	AGQ	ETF	31.93	32.98	31.68	32.75	1333900.0
2022-12-20	AGZ	ETF	106.85	106.9299	106.77	106.84	21636.0
2022-12-20	AGZD	ETF	21.75	21.805	21.725	21.76	117600.0
2022-12-20	AHHX	ETF	8.4546	8.4546	8.4546	8.4546	286.0
2022-12-20	AHYB	ETF	43.142	43.142	43.116	43.116	1700.0
2022-12-20	AIA	ETF	56.25	56.69	56.22	56.47	70201.0
2022-12-20	AIEQ	ETF	28.26	28.75	28.26	28.68	3200.0
2022-12-20	AIQ	ETF	20.06	20.3	20.06	20.16	11418.0

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

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