PREVIEW / etf_daily / 2022-03-28

all etf daily files

  file:    by_date/etf_daily/2022/2022-03-28.parquet
  size:    101 KB
  rows:    2,684

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-28	SPY	ETF	452.06	455.91	450.06	455.91	68529800.0
2022-03-28	QQQ	ETF	359.34	365.01	358.07	364.91	56833866.0
2022-03-28	IWM	ETF	205.6	206.21	203.03	206.19	18999100.0
2022-03-28	DIA	ETF	347.75	349.49	345.38	349.49	2962400.0
2022-03-28	GLD	ETF	180.38	181.33	178.85	179.06	9489700.0
2022-03-28	TLT	ETF	129.39	130.56	129.04	129.76	17657800.0
2022-03-28	AAA	ETF	24.82	24.82	24.81	24.81	1112.0
2022-03-28	AAAU	ETF	19.21	19.31	19.05	19.07	508900.0
2022-03-28	AADR	ETF	59.79	59.86	59.11	59.86	2400.0
2022-03-28	AAXJ	ETF	75.13	75.45	74.71	75.42	761000.0
2022-03-28	ABEQ	ETF	29.9	29.956	29.864	29.956	14300.0
2022-03-28	ACES	ETF	62.08	63.177	61.46	62.39	37700.0
2022-03-28	ACIO	ETF	31.341	31.54	31.248	31.54	42800.0
2022-03-28	ACSI	ETF	50.79	51.047	50.79	51.047	839.0
2022-03-28	ACT	ETF	22.92	22.99	22.25	22.59	74321.0
2022-03-28	ACTV	ETF	35.8	35.8	35.47	35.68	18880.0
2022-03-28	ACTX	ETF	0.77	1.0	0.77	1.0	748.0
2022-03-28	ACVF	ETF	33.82	33.979	33.785	33.979	1500.0
2022-03-28	ACWF	ETF	37.19	37.32	36.8901	37.32	6568.0
2022-03-28	ACWI	ETF	99.84	100.42	99.29	100.37	3846100.0
2022-03-28	ACWV	ETF	103.75	104.48	103.75	104.42	156100.0
2022-03-28	ACWX	ETF	52.11	52.28	51.86	52.28	4495609.0
2022-03-28	ADFI	ETF	8.98	8.99	8.96	8.99	14500.0
2022-03-28	ADIV	ETF	15.565	15.565	15.565	15.565	200.0
2022-03-28	ADME	ETF	40.89	41.145	40.71	41.145	18000.0
2022-03-28	ADRE	ETF	44.27	44.7031	44.1845	44.57	7673.0
2022-03-28	AEMB	ETF	43.085	43.085	43.085	43.085	100.0
2022-03-28	AESR	ETF	13.45	13.52	13.44	13.52	18600.0
2022-03-28	AFIF	ETF	9.22	9.22	9.2	9.205	10041.0
2022-03-28	AFK	ETF	21.5	21.5	21.08	21.23	10657.0
2022-03-28	AFLG	ETF	26.83	26.95	26.77	26.95	500.0
2022-03-28	AFMC	ETF	25.017	25.017	25.017	25.017	100.0
2022-03-28	AFSM	ETF	25.969	25.969	25.969	25.969	100.0
2022-03-28	AFTY	ETF	17.728	17.728	17.728	17.728	100.0
2022-03-28	AGG	ETF	106.25	106.53	106.16	106.36	8540500.0
2022-03-28	AGGY	ETF	47.33	47.447	47.29	47.38	261200.0
2022-03-28	AGNG	ETF	28.14	28.275	28.067	28.275	7200.0
2022-03-28	AGOV	ETF	82.8	85.45	82.69	82.69	6677.0
2022-03-28	AGOX	ETF	24.3	24.3	23.75	23.99	68600.0
2022-03-28	AGQ	ETF	39.31	39.6	38.51	38.62	701200.0
2022-03-28	AGZ	ETF	112.31	112.31	111.72	112.17	142162.0
2022-03-28	AGZD	ETF	23.15	23.315	23.145	23.245	90800.0
2022-03-28	AHHX	ETF	8.66	9.56	7.8	9.4091	10999.0
2022-03-28	AHYB	ETF	47.095	47.3	47.095	47.3	400.0
2022-03-28	AIA	ETF	68.97	69.45	68.7338	69.45	39316.0
2022-03-28	AIEQ	ETF	37.18	37.24	36.755	37.154	11100.0
2022-03-28	AIQ	ETF	26.99	27.3	26.9	27.26	19029.0
2022-03-28	AIRR	ETF	42.99	43.01	42.52	42.85	35600.0
2022-03-28	AIVI	ETF	40.12	40.25	40.04	40.25	4800.0
2022-03-28	AIVL	ETF	98.95	99.26	98.71	99.26	6200.0

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

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