PREVIEW / etf_daily / 2022-08-04

all etf daily files

  file:    by_date/etf_daily/2022/2022-08-04.parquet
  size:    102 KB
  rows:    2,749

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-08-04	SPY	ETF	414.37	415.09	412.44	414.17	45656600.0
2022-08-04	QQQ	ETF	322.97	324.72	320.77	324.4	38973659.0
2022-08-04	IWM	ETF	189.84	190.04	188.44	189.35	14838900.0
2022-08-04	DIA	ETF	327.69	328.36	326.55	327.36	2426400.0
2022-08-04	GLD	ETF	165.53	167.31	165.34	167.17	5502000.0
2022-08-04	TLT	ETF	118.98	119.55	118.54	119.31	11003000.0
2022-08-04	AAA	ETF	24.27	24.27	24.27	24.27	24.0
2022-08-04	AAAU	ETF	17.65	17.82	17.62	17.81	1009700.0
2022-08-04	AADR	ETF	50.56	50.67	50.56	50.67	500.0
2022-08-04	AAXJ	ETF	68.18	68.37	67.91	68.25	1250400.0
2022-08-04	ABEQ	ETF	26.96	26.966	26.875	26.875	6400.0
2022-08-04	ACES	ETF	60.78	61.605	60.6	61.45	14700.0
2022-08-04	ACIO	ETF	30.6	30.69	30.5	30.62	28600.0
2022-08-04	ACSI	ETF	46.93	46.93	46.883	46.883	1270.0
2022-08-04	ACT	ETF	25.02	25.6875	25.02	25.52	232056.0
2022-08-04	ACTV	ETF	31.67	31.67	31.27	31.3057	1536.0
2022-08-04	ACVF	ETF	31.26	31.26	31.13	31.176	1600.0
2022-08-04	ACWF	ETF	33.12	33.12	32.97	32.97	46531.0
2022-08-04	ACWI	ETF	89.98	90.29	89.74	90.11	2889600.0
2022-08-04	ACWV	ETF	97.2	97.69	97.2	97.42	418200.0
2022-08-04	ACWX	ETF	46.22	46.425	46.15	46.36	1423443.0
2022-08-04	ADFI	ETF	8.74	8.74	8.71	8.725	28500.0
2022-08-04	ADIV	ETF	13.697	13.697	13.697	13.697	100.0
2022-08-04	ADME	ETF	36.58	36.88	36.58	36.773	93800.0
2022-08-04	ADRE	ETF	39.63	39.65	39.575	39.595	3438.0
2022-08-04	AEMB	ETF	39.15	39.155	39.13	39.155	1200.0
2022-08-04	AESR	ETF	11.96	12.0	11.95	11.97	29100.0
2022-08-04	AFIF	ETF	8.94	8.96	8.94	8.9534	24817.0
2022-08-04	AFK	ETF	17.22	17.2684	17.18	17.2355	1619.0
2022-08-04	AFLG	ETF	24.212	24.212	24.212	24.212	100.0
2022-08-04	AFMC	ETF	22.708	22.708	22.708	22.708	100.0
2022-08-04	AFSM	ETF	23.782	23.782	23.782	23.782	100.0
2022-08-04	AFTY	ETF	17.237	17.237	17.237	17.237	100.0
2022-08-04	AGG	ETF	103.67	103.89	103.57	103.87	5199700.0
2022-08-04	AGGY	ETF	45.917	45.991	45.875	45.98	79700.0
2022-08-04	AGNG	ETF	26.26	26.3	26.26	26.3	500.0
2022-08-04	AGOV	ETF	81.5	82.89	81.45	82.0776	1666.0
2022-08-04	AGOX	ETF	21.95	21.95	21.731	21.82	67700.0
2022-08-04	AGQ	ETF	23.65	24.23	23.53	24.08	624500.0
2022-08-04	AGZ	ETF	110.56	111.02	110.56	111.02	14915.0
2022-08-04	AGZD	ETF	23.055	23.055	22.915	22.965	345600.0
2022-08-04	AHHX	ETF	8.795	8.81	8.73	8.78	12603.0
2022-08-04	AHYB	ETF	45.243	45.243	45.243	45.243	100.0
2022-08-04	AIA	ETF	60.77	61.04	60.525	60.74	35474.0
2022-08-04	AIEQ	ETF	34.511	34.614	34.362	34.512	23600.0
2022-08-04	AIQ	ETF	23.11	23.24	22.935	23.24	11519.0
2022-08-04	AIRR	ETF	42.85	42.869	42.55	42.81	15600.0
2022-08-04	AIVI	ETF	36.26	36.47	36.26	36.4	4600.0
2022-08-04	AIVL	ETF	94.78	94.78	94.44	94.44	3500.0
2022-08-04	ALTL	ETF	43.26	43.49	43.0	43.45	445466.0

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

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