PREVIEW / etf_daily / 2022-08-16

all etf daily files

  file:    by_date/etf_daily/2022/2022-08-16.parquet
  size:    104 KB
  rows:    2,793

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-16	SPY	ETF	427.73	431.73	426.88	429.7	59289000.0
2022-08-16	QQQ	ETF	332.055	334.4209	329.16	332.28	41186864.0
2022-08-16	IWM	ETF	200.5	201.99	199.03	200.99	18833100.0
2022-08-16	DIA	ETF	338.82	343.09	338.75	341.74	3897100.0
2022-08-16	GLD	ETF	165.31	165.72	165.18	165.42	4291500.0
2022-08-16	TLT	ETF	115.25	116.02	114.24	115.93	11066000.0
2022-08-16	AAA	ETF	24.3601	24.39	24.3601	24.39	165.0
2022-08-16	AAAU	ETF	17.61	17.66	17.61	17.63	729700.0
2022-08-16	AADR	ETF	52.25	52.38	52.25	52.26	1600.0
2022-08-16	AAPB	ETF	27.92	27.92	26.74	27.1406	6877.0
2022-08-16	AAPD	ETF	23.88	23.9901	23.73	23.84	44534.0
2022-08-16	AAPU	ETF	26.79	26.99	26.6386	26.87	38352.0
2022-08-16	AAXJ	ETF	68.71	68.99	68.62	68.83	548200.0
2022-08-16	ABEQ	ETF	27.82	27.95	27.82	27.93	31900.0
2022-08-16	ACES	ETF	67.04	67.04	65.85	66.47	28300.0
2022-08-16	ACIO	ETF	31.36	31.46	31.221	31.4	50900.0
2022-08-16	ACSI	ETF	49.07	49.07	49.0594	49.0594	195.0
2022-08-16	ACT	ETF	26.66	27.5	26.66	27.44	210733.0
2022-08-16	ACTV	ETF	33.34	33.34	32.91	33.0319	12600.0
2022-08-16	ACTX	ETF	0.4313	0.545	0.4313	0.545	380.0
2022-08-16	ACVF	ETF	32.17	32.38	32.1	32.289	2700.0
2022-08-16	ACWF	ETF	34.0288	34.2	34.0	34.1321	1132.0
2022-08-16	ACWI	ETF	92.27	93.06	92.22	92.7	7095000.0
2022-08-16	ACWV	ETF	99.44	100.41	99.31	100.05	247300.0
2022-08-16	ACWX	ETF	46.89	47.18	46.84	47.1	1002807.0
2022-08-16	ADFI	ETF	8.7	8.72	8.7	8.715	9200.0
2022-08-16	ADIV	ETF	13.96	13.96	13.96	13.96	100.0
2022-08-16	ADME	ETF	37.58	37.7	37.49	37.675	13600.0
2022-08-16	ADRE	ETF	40.83	40.83	40.63	40.65	1410.0
2022-08-16	AEMB	ETF	39.57	39.57	39.36	39.43	900.0
2022-08-16	AESR	ETF	12.34	12.4	12.31	12.384	23600.0
2022-08-16	AFIF	ETF	8.9943	8.9943	8.97	8.9799	21677.0
2022-08-16	AFK	ETF	17.9	18.0699	17.9	18.02	7672.0
2022-08-16	AFLG	ETF	25.317	25.317	25.317	25.317	100.0
2022-08-16	AFSM	ETF	24.762	24.873	24.762	24.873	1600.0
2022-08-16	AFTY	ETF	17.293	17.293	17.293	17.293	100.0
2022-08-16	AGG	ETF	103.13	103.13	102.79	103.1	4976100.0
2022-08-16	AGGH	ETF	23.7	23.7044	23.7	23.7044	131.0
2022-08-16	AGGY	ETF	45.73	45.77	45.56	45.72	78500.0
2022-08-16	AGIH	ETF	25.78	25.78	25.76	25.76	201.0
2022-08-16	AGNG	ETF	26.53	26.53	26.36	26.4	5000.0
2022-08-16	AGOV	ETF	82.84	82.84	82.84	82.84	42.0
2022-08-16	AGOX	ETF	22.88	22.88	22.52	22.66	14100.0
2022-08-16	AGQ	ETF	23.63	23.99	23.6	23.78	528600.0
2022-08-16	AGZ	ETF	110.14	110.18	110.02	110.18	16736.0
2022-08-16	AGZD	ETF	23.055	23.08	23.05	23.05	46600.0
2022-08-16	AHHX	ETF	8.99	8.99	8.89	8.9153	12375.0
2022-08-16	AHYB	ETF	45.39	45.39	45.33	45.364	800.0
2022-08-16	AIA	ETF	60.22	60.57	60.15	60.39	44285.0
2022-08-16	AIEQ	ETF	36.54	36.9	36.3	36.53	5000.0

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

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