PREVIEW / etf_daily / 2022-07-27

all etf daily files

  file:    by_date/etf_daily/2022/2022-07-27.parquet
  size:    101 KB
  rows:    2,739

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-07-27	SPY	ETF	394.36	402.88	394.05	401.04	82342100.0
2022-07-27	QQQ	ETF	299.04	308.54	298.46	306.81	69304364.0
2022-07-27	IWM	ETF	180.48	184.25	180.0	183.41	21670700.0
2022-07-27	DIA	ETF	318.88	323.44	318.04	322.01	3338100.0
2022-07-27	GLD	ETF	160.02	162.21	159.51	161.67	5766100.0
2022-07-27	TLT	ETF	118.01	118.49	116.71	116.82	15725600.0
2022-07-27	AAA	ETF	24.24	24.24	24.24	24.24	101.0
2022-07-27	AAAU	ETF	17.04	17.28	17.0	17.22	960700.0
2022-07-27	AADR	ETF	49.06	49.95	49.05	49.95	500.0
2022-07-27	AAXJ	ETF	67.93	68.68	67.6	68.52	732000.0
2022-07-27	ABEQ	ETF	26.79	27.06	26.79	27.053	11000.0
2022-07-27	ACES	ETF	52.31	53.35	51.84	53.28	22400.0
2022-07-27	ACIO	ETF	29.5	29.99	29.5	29.89	37500.0
2022-07-27	ACSI	ETF	44.7078	44.7078	44.7078	44.7078	15.0
2022-07-27	ACT	ETF	22.67	23.32	22.405	22.73	168541.0
2022-07-27	ACTV	ETF	31.12	31.61	31.09	31.58	8042.0
2022-07-27	ACTX	ETF	0.7	0.7	0.7	0.7	289.0
2022-07-27	ACVF	ETF	29.89	30.308	29.89	30.308	900.0
2022-07-27	ACWF	ETF	32.1499	32.5969	32.08	32.5969	5426.0
2022-07-27	ACWI	ETF	86.52	88.13	86.46	87.85	2584100.0
2022-07-27	ACWV	ETF	95.67	96.56	95.37	96.3	197700.0
2022-07-27	ACWX	ETF	45.32	45.945	45.18	45.87	2436221.0
2022-07-27	ADFI	ETF	8.63	8.69	8.63	8.66	5100.0
2022-07-27	ADIV	ETF	13.955	13.955	13.955	13.955	100.0
2022-07-27	ADME	ETF	35.34	35.8	35.32	35.8	20700.0
2022-07-27	ADRE	ETF	38.82	39.38	38.65	39.38	7943.0
2022-07-27	AEMB	ETF	38.04	38.04	38.04	38.04	100.0
2022-07-27	AESR	ETF	11.48	11.72	11.48	11.65	40700.0
2022-07-27	AFIF	ETF	8.87	8.91	8.86	8.895	106938.0
2022-07-27	AFK	ETF	16.95	17.1	16.92	17.1	12899.0
2022-07-27	AFLG	ETF	23.44	23.76	23.44	23.754	200.0
2022-07-27	AFMC	ETF	22.15	22.434	22.15	22.434	800.0
2022-07-27	AFSM	ETF	23.29	23.65	23.29	23.65	200.0
2022-07-27	AFTY	ETF	17.78	17.807	17.78	17.807	500.0
2022-07-27	AGG	ETF	103.19	103.64	103.18	103.32	5431400.0
2022-07-27	AGGY	ETF	45.51	45.72	45.51	45.58	95600.0
2022-07-27	AGNG	ETF	26.23	26.5	26.23	26.5	1100.0
2022-07-27	AGOV	ETF	80.94	80.94	80.91	80.91	343.0
2022-07-27	AGOX	ETF	20.95	21.33	20.95	21.25	69900.0
2022-07-27	AGQ	ETF	20.47	21.67	20.06	21.51	844300.0
2022-07-27	AGZ	ETF	110.62	110.8124	110.51	110.67	17620.0
2022-07-27	AGZD	ETF	22.855	22.915	22.855	22.9	38200.0
2022-07-27	AHHX	ETF	8.64	8.7401	8.64	8.7401	12741.0
2022-07-27	AHYB	ETF	44.541	44.541	44.541	44.541	100.0
2022-07-27	AIA	ETF	61.25	61.9443	60.99	61.83	7416.0
2022-07-27	AIEQ	ETF	32.61	33.35	32.385	33.25	7600.0
2022-07-27	AIQ	ETF	21.77	22.29	21.71	22.24	9577.0
2022-07-27	AIRR	ETF	40.49	41.379	40.49	41.29	18700.0
2022-07-27	AIVI	ETF	35.47	35.99	35.42	35.96	4400.0
2022-07-27	AIVL	ETF	92.58	94.03	92.53	93.74	9000.0

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

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