PREVIEW / etf_daily / 2022-05-09

all etf daily files

  file:    by_date/etf_daily/2022/2022-05-09.parquet
  size:    102 KB
  rows:    2,740

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-05-09	SPY	ETF	405.1	406.41	396.5	398.17	155586100.0
2022-05-09	QQQ	ETF	303.48	309.3487	295.72	297.15	113387342.0
2022-05-09	IWM	ETF	179.86	182.65	174.1	174.9	53682200.0
2022-05-09	DIA	ETF	324.98	326.37	321.37	322.6	7817200.0
2022-05-09	GLD	ETF	174.27	174.27	172.79	172.88	10742400.0
2022-05-09	TLT	ETF	112.86	114.71	112.62	114.67	26773000.0
2022-05-09	AAA	ETF	24.68	24.68	24.68	24.68	236.0
2022-05-09	AAAU	ETF	18.57	18.57	18.4	18.41	915400.0
2022-05-09	AADR	ETF	51.51	51.52	51.26	51.33	9600.0
2022-05-09	AAXJ	ETF	67.32	67.67	66.43	66.52	1994900.0
2022-05-09	ABEQ	ETF	30.15	31.0	28.01	28.16	16100.0
2022-05-09	ACES	ETF	49.85	49.85	46.94	47.23	136300.0
2022-05-09	ACIO	ETF	29.27	29.551	29.27	29.33	76400.0
2022-05-09	ACSI	ETF	44.87	44.87	44.3866	44.3866	179.0
2022-05-09	ACT	ETF	23.12	23.32	22.52	22.65	131150.0
2022-05-09	ACTV	ETF	32.055	32.24	31.7673	31.7673	8697.0
2022-05-09	ACTX	ETF	1.0	1.0	0.8	0.82	4401.0
2022-05-09	ACVF	ETF	30.61	30.61	29.93	29.93	13700.0
2022-05-09	ACWF	ETF	33.7	33.79	33.21	33.2756	8504.0
2022-05-09	ACWI	ETF	89.25	89.45	87.46	87.76	5784400.0
2022-05-09	ACWV	ETF	97.38	97.65	96.65	96.98	187600.0
2022-05-09	ACWX	ETF	46.81	46.91	46.125	46.21	4774376.0
2022-05-09	ADFI	ETF	8.6	8.635	8.6	8.635	18800.0
2022-05-09	ADIV	ETF	14.056	14.056	14.056	14.056	100.0
2022-05-09	ADME	ETF	37.06	37.224	36.75	36.84	54500.0
2022-05-09	ADRE	ETF	37.921	37.921	36.905	36.93	7291.0
2022-05-09	AEMB	ETF	39.74	39.74	39.74	39.74	100.0
2022-05-09	AESR	ETF	12.0	12.0	11.72	11.72	35500.0
2022-05-09	AFIF	ETF	9.1464	9.17	9.145	9.16	93735.0
2022-05-09	AFK	ETF	18.84	18.84	18.42	18.43	8595.0
2022-05-09	AFLG	ETF	24.153	24.153	24.153	24.153	100.0
2022-05-09	AFMC	ETF	22.817	22.817	22.653	22.653	800.0
2022-05-09	AFSM	ETF	23.14	23.14	22.963	22.963	1200.0
2022-05-09	AFTY	ETF	16.17	16.22	16.07	16.07	12700.0
2022-05-09	AGG	ETF	101.54	102.1	101.48	102.07	8640900.0
2022-05-09	AGGY	ETF	44.81	45.11	44.81	45.06	852800.0
2022-05-09	AGNG	ETF	25.3	25.3	24.65	24.66	7400.0
2022-05-09	AGOV	ETF	77.04	78.5	77.04	78.265	535.0
2022-05-09	AGOX	ETF	21.52	21.52	20.923	21.01	51200.0
2022-05-09	AGQ	ETF	29.76	29.79	28.64	28.73	1035200.0
2022-05-09	AGZ	ETF	109.83	110.265	109.83	110.22	34840.0
2022-05-09	AGZD	ETF	23.04	23.04	22.915	22.99	386800.0
2022-05-09	AHHX	ETF	9.035	9.035	8.89	8.8969	38859.0
2022-05-09	AHYB	ETF	44.6	44.6	44.475	44.475	300.0
2022-05-09	AIA	ETF	60.66	60.92	59.462	59.58	149616.0
2022-05-09	AIEQ	ETF	33.16	33.215	32.14	32.14	31200.0
2022-05-09	AIQ	ETF	22.21	22.28	21.62	21.63	24560.0
2022-05-09	AIRR	ETF	38.24	38.38	37.61	37.761	16600.0
2022-05-09	AIVI	ETF	37.62	37.71	37.29	37.37	38100.0
2022-05-09	AIVL	ETF	94.15	94.45	93.07	93.44	9600.0

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

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