PREVIEW / etf_daily / 2022-03-16

all etf daily files

  file:    by_date/etf_daily/2022/2022-03-16.parquet
  size:    100 KB
  rows:    2,672

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-03-16	SPY	ETF	429.89	435.68	424.8	435.62	144954800.0
2022-03-16	QQQ	ETF	332.17	340.44	328.401	340.32	105242954.0
2022-03-16	IWM	ETF	197.54	201.94	196.15	201.94	31869700.0
2022-03-16	DIA	ETF	339.19	341.42	334.54	341.36	9577100.0
2022-03-16	GLD	ETF	179.13	180.12	176.87	180.01	17548100.0
2022-03-16	TLT	ETF	131.83	133.13	130.32	132.82	25857700.0
2022-03-16	AAA	ETF	24.89	24.9	24.8751	24.8751	1735.0
2022-03-16	AAAU	ETF	19.08	19.18	18.84	19.17	1090300.0
2022-03-16	AADR	ETF	57.12	57.5	56.53	56.58	6100.0
2022-03-16	AAXJ	ETF	73.09	75.88	72.75	75.88	3979300.0
2022-03-16	ABEQ	ETF	28.965	29.24	28.965	29.24	11800.0
2022-03-16	ACES	ETF	57.91	59.18	57.31	59.12	143500.0
2022-03-16	ACIO	ETF	30.74	30.77	30.13	30.57	23600.0
2022-03-16	ACSI	ETF	48.14	48.6279	48.14	48.6279	170.0
2022-03-16	ACT	ETF	21.55	22.12	21.35	22.04	139855.0
2022-03-16	ACTV	ETF	34.8616	35.0521	34.47	35.0521	2232.0
2022-03-16	ACTX	ETF	0.885	0.885	0.885	0.885	101.0
2022-03-16	ACVF	ETF	32.28	32.73	32.18	32.73	3900.0
2022-03-16	ACWF	ETF	36.03	36.445	36.02	36.43	15331.0
2022-03-16	ACWI	ETF	95.12	96.86	94.36	96.86	2966000.0
2022-03-16	ACWV	ETF	101.72	102.68	100.87	102.52	130900.0
2022-03-16	ACWX	ETF	50.53	51.56	50.25	51.51	3336641.0
2022-03-16	ADFI	ETF	9.015	9.019	8.95	9.019	5300.0
2022-03-16	ADIV	ETF	15.11	15.44	15.075	15.44	2200.0
2022-03-16	ADME	ETF	39.54	39.79	39.06	39.79	14900.0
2022-03-16	ADRE	ETF	41.35	43.4369	41.35	43.2	7873.0
2022-03-16	AEMB	ETF	42.51	42.75	42.51	42.736	3000.0
2022-03-16	AESR	ETF	12.77	12.83	12.68	12.83	4700.0
2022-03-16	AFIF	ETF	9.24	9.24	9.201	9.22	7728.0
2022-03-16	AFK	ETF	20.36	20.87	20.36	20.83	6256.0
2022-03-16	AFLG	ETF	25.66	25.866	25.66	25.866	300.0
2022-03-16	AFMC	ETF	24.601	24.754	24.55	24.754	1000.0
2022-03-16	AFSM	ETF	25.748	25.748	25.748	25.748	100.0
2022-03-16	AFTY	ETF	18.225	18.64	18.09	18.428	7100.0
2022-03-16	AGG	ETF	107.63	107.73	107.0	107.68	16805400.0
2022-03-16	AGGY	ETF	47.99	48.23	47.825	48.07	118500.0
2022-03-16	AGNG	ETF	27.12	27.39	26.999	27.39	2300.0
2022-03-16	AGOV	ETF	83.8	84.0283	83.8	84.0283	201.0
2022-03-16	AGOX	ETF	23.39	23.456	23.11	23.397	168800.0
2022-03-16	AGQ	ETF	38.92	39.33	37.5	39.24	1053100.0
2022-03-16	AGZ	ETF	113.48	113.58	113.1233	113.38	15513.0
2022-03-16	AGZD	ETF	23.045	23.1	23.045	23.09	43800.0
2022-03-16	AHHX	ETF	9.4611	9.47	9.45	9.464	782.0
2022-03-16	AHYB	ETF	47.061	47.241	46.71	47.241	600.0
2022-03-16	AIA	ETF	66.34	69.7	65.88	69.63	96556.0
2022-03-16	AIEQ	ETF	35.02	35.915	35.0	35.878	8600.0
2022-03-16	AIQ	ETF	24.95	25.88	24.92	25.86	41865.0
2022-03-16	AIRR	ETF	42.89	43.53	42.644	43.53	11400.0
2022-03-16	AIVI	ETF	39.85	40.16	39.68	40.16	1900.0
2022-03-16	AIVL	ETF	95.56	96.82	95.56	96.82	15100.0

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

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