PREVIEW / etf_daily / 2022-01-27

all etf daily files

  file:    by_date/etf_daily/2022/2022-01-27.parquet
  size:    99 KB
  rows:    2,644

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-01-27	SPY	ETF	438.26	441.59	429.45	431.24	149878300.0
2022-01-27	QQQ	ETF	349.4	351.27	340.05	341.1	95255656.0
2022-01-27	IWM	ETF	197.63	199.61	190.6	191.52	59829000.0
2022-01-27	DIA	ETF	344.4	347.63	339.89	341.55	12854100.0
2022-01-27	GLD	ETF	168.02	169.09	167.33	167.6	15867300.0
2022-01-27	TLT	ETF	142.41	143.37	142.33	143.08	21501800.0
2022-01-27	AAA	ETF	25.0	25.01	25.0	25.01	4145.0
2022-01-27	AAAU	ETF	17.89	17.99	17.81	17.84	1406600.0
2022-01-27	AADR	ETF	61.03	61.29	60.21	60.44	26500.0
2022-01-27	AAXJ	ETF	79.77	79.82	78.76	78.76	785300.0
2022-01-27	ABEQ	ETF	27.8	27.816	27.8	27.816	300.0
2022-01-27	ACES	ETF	51.23	51.23	48.45	48.6	54000.0
2022-01-27	ACIO	ETF	30.999	31.4	30.839	30.94	42000.0
2022-01-27	ACSI	ETF	48.0752	48.0752	48.0752	48.0752	50.0
2022-01-27	ACT	ETF	21.22	21.76	20.73	20.86	132331.0
2022-01-27	ACTV	ETF	34.76	34.76	33.65	33.84	3338.0
2022-01-27	ACVF	ETF	32.88	33.01	32.191	32.339	6700.0
2022-01-27	ACWF	ETF	36.53	36.64	35.8	35.9611	16043.0
2022-01-27	ACWI	ETF	98.61	99.23	97.03	97.37	6188700.0
2022-01-27	ACWV	ETF	101.12	101.78	100.35	100.75	174400.0
2022-01-27	ACWX	ETF	53.36	53.52	52.73	52.87	5245168.0
2022-01-27	ADFI	ETF	9.37	9.38	9.335	9.335	11100.0
2022-01-27	ADIV	ETF	15.775	15.775	15.775	15.775	100.0
2022-01-27	ADME	ETF	41.105	41.105	40.25	40.34	37200.0
2022-01-27	ADRE	ETF	45.36	45.4151	44.0	44.1	15566.0
2022-01-27	AEMB	ETF	46.775	46.775	46.775	46.775	100.0
2022-01-27	AESR	ETF	12.92	12.95	12.67	12.707	50600.0
2022-01-27	AFIF	ETF	9.505	9.51	9.495	9.4952	34603.0
2022-01-27	AFK	ETF	20.18	20.18	19.89	19.89	3318.0
2022-01-27	AFLG	ETF	25.82	25.92	25.36	25.441	1600.0
2022-01-27	AFMC	ETF	23.728	23.728	23.728	23.728	100.0
2022-01-27	AFSM	ETF	23.932	23.932	23.932	23.932	100.0
2022-01-27	AFTY	ETF	19.96	19.96	19.925	19.925	1600.0
2022-01-27	AGG	ETF	111.62	111.88	111.62	111.73	6146800.0
2022-01-27	AGGY	ETF	50.22	50.29	50.18	50.24	591100.0
2022-01-27	AGNG	ETF	26.145	26.145	25.79	25.82	2300.0
2022-01-27	AGOV	ETF	96.07	96.09	95.8841	95.8841	485.0
2022-01-27	AGOX	ETF	23.5	23.68	23.122	23.28	187400.0
2022-01-27	AGQ	ETF	32.9	33.66	32.28	32.73	1860300.0
2022-01-27	AGZ	ETF	115.76	116.0149	115.76	115.92	66626.0
2022-01-27	AGZD	ETF	23.315	23.315	23.245	23.26	103400.0
2022-01-27	AHHX	ETF	10.04	10.045	9.93	9.93	16422.0
2022-01-27	AHYB	ETF	49.16	49.165	48.855	48.855	600.0
2022-01-27	AIA	ETF	74.88	75.1482	74.04	74.13	59701.0
2022-01-27	AIEQ	ETF	35.62	35.7	34.58	34.77	10300.0
2022-01-27	AIQ	ETF	27.46	27.61	26.77	26.81	63614.0
2022-01-27	AIRR	ETF	40.61	40.977	39.382	39.39	13100.0
2022-01-27	AIVI	ETF	42.2	42.2	41.56	41.67	31700.0
2022-01-27	AIVL	ETF	97.16	98.12	95.88	96.31	10000.0
2022-01-27	ALTL	ETF	43.96	44.3177	43.4751	43.7	105861.0

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

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