PREVIEW / etf_daily / 2022-08-08

all etf daily files

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

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-08	SPY	ETF	415.25	417.62	411.83	412.99	53886100.0
2022-08-08	QQQ	ETF	322.69	326.47	319.21	320.71	44066297.0
2022-08-08	IWM	ETF	192.15	194.63	191.89	192.82	22188700.0
2022-08-08	DIA	ETF	329.81	331.12	327.71	328.42	2528800.0
2022-08-08	GLD	ETF	166.03	166.81	165.93	166.69	3456300.0
2022-08-08	TLT	ETF	117.64	118.53	117.56	118.35	17476300.0
2022-08-08	AAA	ETF	24.345	24.345	24.345	24.345	102.0
2022-08-08	AAAU	ETF	17.68	17.77	17.68	17.75	686600.0
2022-08-08	AADR	ETF	51.23	51.25	51.23	51.25	2100.0
2022-08-08	AAXJ	ETF	68.13	68.44	67.85	67.94	582800.0
2022-08-08	ABEQ	ETF	27.225	27.231	27.135	27.135	7300.0
2022-08-08	ACES	ETF	63.87	65.33	63.52	63.52	73900.0
2022-08-08	ACIO	ETF	30.71	30.772	30.5	30.59	159100.0
2022-08-08	ACSI	ETF	46.7614	46.7614	46.7614	46.7614	40.0
2022-08-08	ACT	ETF	26.3	26.6	25.76	25.94	156535.0
2022-08-08	ACTV	ETF	31.64	32.21	31.64	31.984	8383.0
2022-08-08	ACTX	ETF	0.56	0.56	0.56	0.56	401.0
2022-08-08	ACVF	ETF	31.31	31.31	31.065	31.065	1200.0
2022-08-08	ACWF	ETF	33.3088	33.3088	33.05	33.1145	11678.0
2022-08-08	ACWI	ETF	90.23	90.8	89.69	89.87	2580300.0
2022-08-08	ACWV	ETF	98.11	98.26	97.62	97.82	173200.0
2022-08-08	ACWX	ETF	46.39	46.58	46.145	46.2	2541602.0
2022-08-08	ADFI	ETF	8.73	8.73	8.7	8.71	2700.0
2022-08-08	ADIV	ETF	13.76	13.765	13.73	13.765	1700.0
2022-08-08	ADME	ETF	36.876	37.02	36.57	36.66	10900.0
2022-08-08	ADRE	ETF	39.79	39.855	39.52	39.65	4942.0
2022-08-08	AEMB	ETF	39.2	39.51	39.2	39.51	1100.0
2022-08-08	AESR	ETF	12.02	12.04	11.925	11.96	10400.0
2022-08-08	AFIF	ETF	8.94	8.96	8.94	8.95	4923.0
2022-08-08	AFK	ETF	17.47	17.7023	17.34	17.4575	11053.0
2022-08-08	AFLG	ETF	24.305	24.305	24.305	24.305	100.0
2022-08-08	AFMC	ETF	22.822	22.882	22.822	22.882	100.0
2022-08-08	AFSM	ETF	24.05	24.05	24.05	24.05	100.0
2022-08-08	AFTY	ETF	17.228	17.228	17.228	17.228	100.0
2022-08-08	AGG	ETF	103.1	103.29	103.04	103.18	3425000.0
2022-08-08	AGGY	ETF	45.64	45.725	45.61	45.67	55900.0
2022-08-08	AGNG	ETF	26.47	26.47	26.47	26.47	500.0
2022-08-08	AGOV	ETF	82.96	82.96	81.61	82.4654	5509.0
2022-08-08	AGOX	ETF	22.02	22.104	21.88	21.94	647900.0
2022-08-08	AGQ	ETF	24.49	25.41	24.42	25.18	796500.0
2022-08-08	AGZ	ETF	110.2	110.44	110.2	110.29	34410.0
2022-08-08	AGZD	ETF	23.035	23.035	22.95	22.96	147000.0
2022-08-08	AHHX	ETF	8.75	8.83	8.75	8.7799	31323.0
2022-08-08	AHYB	ETF	45.139	45.139	45.139	45.139	100.0
2022-08-08	AIA	ETF	60.12	60.34	59.8	59.86	58388.0
2022-08-08	AIEQ	ETF	34.77	35.339	34.77	34.88	9800.0
2022-08-08	AIQ	ETF	23.07	23.34	22.92	23.0	23413.0
2022-08-08	AIRR	ETF	43.1	43.226	42.78	43.0	12900.0
2022-08-08	AIVI	ETF	36.51	36.59	36.33	36.33	3700.0
2022-08-08	AIVL	ETF	94.5	95.31	94.5	94.58	3300.0

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

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