PREVIEW / etf_daily / 2022-08-05

all etf daily files

  file:    by_date/etf_daily/2022/2022-08-05.parquet
  size:    103 KB
  rows:    2,772

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-05	SPY	ETF	409.66	414.15	409.6	413.47	56814900.0
2022-08-05	QQQ	ETF	319.19	323.83	318.39	321.75	53893972.0
2022-08-05	IWM	ETF	187.47	191.02	187.17	190.8	18540300.0
2022-08-05	DIA	ETF	325.07	328.19	324.93	327.97	2672400.0
2022-08-05	GLD	ETF	164.99	165.84	164.87	165.29	6023300.0
2022-08-05	TLT	ETF	117.07	117.11	115.89	116.47	19492300.0
2022-08-05	AAA	ETF	24.28	24.28	24.28	24.28	206.0
2022-08-05	AAAU	ETF	17.53	17.66	17.53	17.6	1608500.0
2022-08-05	AADR	ETF	50.65	51.13	50.58	51.13	3900.0
2022-08-05	AAXJ	ETF	67.87	68.26	67.76	68.16	521300.0
2022-08-05	ABEQ	ETF	27.15	27.15	26.73	26.936	56600.0
2022-08-05	ACES	ETF	61.52	63.0	61.01	62.07	28100.0
2022-08-05	ACIO	ETF	30.13	30.59	30.13	30.59	25800.0
2022-08-05	ACSI	ETF	46.92	46.92	46.7599	46.7599	172.0
2022-08-05	ACT	ETF	25.29	26.44	25.29	26.21	257323.0
2022-08-05	ACTV	ETF	31.1	31.55	31.1	31.5254	7241.0
2022-08-05	ACTX	ETF	0.63	0.7	0.56	0.56	555.0
2022-08-05	ACVF	ETF	31.01	31.116	30.98	31.116	1600.0
2022-08-05	ACWF	ETF	32.78	33.002	32.78	33.002	4387.0
2022-08-05	ACWI	ETF	89.1	89.99	89.03	89.83	1493400.0
2022-08-05	ACWV	ETF	96.73	97.59	96.73	97.52	100200.0
2022-08-05	ACWX	ETF	45.83	46.145	45.82	46.09	1074596.0
2022-08-05	ADFI	ETF	8.66	8.67	8.65	8.665	2700.0
2022-08-05	ADIV	ETF	13.779	13.779	13.779	13.779	100.0
2022-08-05	ADME	ETF	36.662	36.68	36.46	36.651	15200.0
2022-08-05	ADRE	ETF	39.6599	39.6599	39.61	39.65	832.0
2022-08-05	AEMB	ETF	38.97	38.97	38.918	38.918	200.0
2022-08-05	AESR	ETF	11.9	11.98	11.86	11.93	87100.0
2022-08-05	AFIF	ETF	8.881	8.9039	8.88	8.9	72106.0
2022-08-05	AFK	ETF	17.22	17.33	17.05	17.33	6361.0
2022-08-05	AFLG	ETF	24.23	24.257	24.13	24.257	300.0
2022-08-05	AFMC	ETF	22.66	22.73	22.66	22.73	100.0
2022-08-05	AFSM	ETF	23.81	23.905	23.81	23.905	100.0
2022-08-05	AFTY	ETF	17.309	17.309	17.309	17.309	100.0
2022-08-05	AGG	ETF	102.81	102.83	102.52	102.71	4847100.0
2022-08-05	AGGH	ETF	23.74	23.74	23.7226	23.7226	19322.0
2022-08-05	AGGY	ETF	45.54	45.54	45.44	45.53	77500.0
2022-08-05	AGNG	ETF	26.0	26.249	26.0	26.21	1800.0
2022-08-05	AGOV	ETF	83.21	83.21	82.4226	82.4226	245.0
2022-08-05	AGOX	ETF	21.47	21.94	21.47	21.897	6500.0
2022-08-05	AGQ	ETF	22.75	23.56	22.63	23.29	816800.0
2022-08-05	AGZ	ETF	110.15	110.1933	110.03	110.14	11959.0
2022-08-05	AGZD	ETF	22.975	23.04	22.94	23.03	409400.0
2022-08-05	AHHX	ETF	8.84	8.84	8.68	8.76	1625.0
2022-08-05	AHYB	ETF	45.03	45.107	44.938	45.107	900.0
2022-08-05	AIA	ETF	60.4	60.57	60.1485	60.43	87829.0
2022-08-05	AIEQ	ETF	34.2	34.764	34.17	34.764	3200.0
2022-08-05	AIQ	ETF	22.83	23.14	22.8	23.07	31782.0
2022-08-05	AIRR	ETF	42.17	42.89	42.17	42.89	69200.0
2022-08-05	AIVI	ETF	36.09	36.31	36.09	36.31	300.0

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

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