PREVIEW / etf_daily / 2022-06-07

all etf daily files

  file:    by_date/etf_daily/2022/2022-06-07.parquet
  size:    102 KB
  rows:    2,736

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-06-07	SPY	ETF	408.1	416.22	407.61	415.74	59272400.0
2022-06-07	QQQ	ETF	303.81	310.67	302.6886	309.87	44900292.0
2022-06-07	IWM	ETF	186.41	190.94	185.9	190.9	21661600.0
2022-06-07	DIA	ETF	326.82	332.47	326.82	332.17	2424000.0
2022-06-07	GLD	ETF	172.11	173.05	171.99	172.94	3860000.0
2022-06-07	TLT	ETF	114.61	115.78	114.58	115.12	14278700.0
2022-06-07	AAA	ETF	24.4301	24.46	24.4301	24.46	400.0
2022-06-07	AAAU	ETF	18.33	18.43	18.32	18.42	1246000.0
2022-06-07	AADR	ETF	56.39	56.68	56.23	56.68	1100.0
2022-06-07	AAXJ	ETF	71.49	72.28	71.35	72.21	2293500.0
2022-06-07	ABEQ	ETF	28.95	29.06	28.95	29.055	7700.0
2022-06-07	ACES	ETF	54.01	55.095	53.91	55.09	249300.0
2022-06-07	ACIO	ETF	29.95	30.32	29.95	30.32	27000.0
2022-06-07	ACSI	ETF	45.3852	45.3852	45.3852	45.3852	124.0
2022-06-07	ACT	ETF	24.55	25.42	23.97	24.46	405175.0
2022-06-07	ACTV	ETF	32.9988	33.3706	32.9988	33.3706	4558.0
2022-06-07	ACTX	ETF	1.0	1.0	1.0	1.0	233.0
2022-06-07	ACVF	ETF	30.85	31.43	30.85	31.388	3500.0
2022-06-07	ACWF	ETF	34.16	34.682	34.16	34.682	11157.0
2022-06-07	ACWI	ETF	91.33	92.86	91.2	92.78	3557800.0
2022-06-07	ACWV	ETF	97.8	98.86	97.8	98.86	122200.0
2022-06-07	ACWX	ETF	49.18	49.82	49.18	49.82	2360996.0
2022-06-07	ADFI	ETF	8.67	8.74	8.67	8.709	11600.0
2022-06-07	ADIV	ETF	14.91	14.91	14.91	14.91	100.0
2022-06-07	ADME	ETF	37.386	37.82	37.386	37.76	37500.0
2022-06-07	ADRE	ETF	41.479	42.41	41.479	42.41	2143.0
2022-06-07	AEMB	ETF	40.42	40.42	40.42	40.42	100.0
2022-06-07	AESR	ETF	12.16	12.37	12.16	12.355	17500.0
2022-06-07	AFIF	ETF	9.05	9.109	9.05	9.1	2360.0
2022-06-07	AFK	ETF	19.14	19.2951	19.14	19.27	2255.0
2022-06-07	AFLG	ETF	25.002	25.002	25.002	25.002	100.0
2022-06-07	AFTY	ETF	17.7	17.75	17.68	17.745	2900.0
2022-06-07	AGG	ETF	102.42	102.76	102.4	102.58	5620200.0
2022-06-07	AGGH	ETF	23.76	23.76	23.745	23.745	690.0
2022-06-07	AGGY	ETF	45.3	45.47	45.3	45.395	91600.0
2022-06-07	AGNG	ETF	25.86	26.01	25.54	26.01	3900.0
2022-06-07	AGOV	ETF	80.5	80.5	80.5	80.5	402.0
2022-06-07	AGOX	ETF	22.35	22.63	22.316	22.55	36000.0
2022-06-07	AGQ	ETF	29.31	30.18	29.18	30.12	464200.0
2022-06-07	AGZ	ETF	110.14	110.31	110.1	110.31	21162.0
2022-06-07	AGZD	ETF	23.06	23.095	23.04	23.04	115000.0
2022-06-07	AHHX	ETF	9.1661	9.2011	9.15	9.2011	458.0
2022-06-07	AHYB	ETF	45.069	45.29	45.069	45.29	400.0
2022-06-07	AIA	ETF	65.5	66.5	65.5	66.5	27349.0
2022-06-07	AIEQ	ETF	34.38	35.05	34.378	35.03	7100.0
2022-06-07	AIQ	ETF	22.71	23.31	22.71	23.23	26151.0
2022-06-07	AIRR	ETF	41.58	42.23	41.46	42.215	14900.0
2022-06-07	AIVI	ETF	39.53	39.85	39.52	39.85	3900.0
2022-06-07	AIVL	ETF	96.0	97.45	96.0	97.45	15200.0
2022-06-07	ALTL	ETF	42.31	42.9	42.2499	42.87	355532.0

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

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