PREVIEW / etf_daily / 2022-03-01

all etf daily files

  file:    by_date/etf_daily/2022/2022-03-01.parquet
  size:    99 KB
  rows:    2,649

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-03-01	SPY	ETF	435.04	437.17	427.11	429.98	137785900.0
2022-03-01	QQQ	ETF	345.75	348.078	338.9	341.49	67407000.0
2022-03-01	IWM	ETF	202.66	203.79	197.8	199.49	40638900.0
2022-03-01	DIA	ETF	337.27	339.02	331.33	333.16	8532900.0
2022-03-01	GLD	ETF	179.05	181.76	179.03	181.62	21942100.0
2022-03-01	TLT	ETF	140.36	142.33	140.0	141.3	35664400.0
2022-03-01	AAA	ETF	24.9771	24.9771	24.975	24.975	484.0
2022-03-01	AAAU	ETF	19.07	19.35	19.06	19.34	1413700.0
2022-03-01	AADR	ETF	58.81	58.81	56.9	57.07	4600.0
2022-03-01	AAXJ	ETF	78.42	78.88	77.56	77.91	3037300.0
2022-03-01	ABEQ	ETF	28.501	28.54	28.41	28.459	7800.0
2022-03-01	ACES	ETF	56.68	57.38	55.77	56.84	174300.0
2022-03-01	ACIO	ETF	30.95	30.95	30.653	30.76	30200.0
2022-03-01	ACSI	ETF	48.1961	48.1961	48.1961	48.1961	6.0
2022-03-01	ACT	ETF	20.59	20.78	19.97	20.09	97153.0
2022-03-01	ACTV	ETF	34.87	34.87	33.94	34.0235	7253.0
2022-03-01	ACTX	ETF	0.9	0.9	0.9	0.9	1501.0
2022-03-01	ACVF	ETF	32.6	32.6	32.1	32.201	2700.0
2022-03-01	ACWF	ETF	36.45	36.59	35.87	36.0	11938.0
2022-03-01	ACWI	ETF	97.6	97.9	95.7	96.22	4681800.0
2022-03-01	ACWV	ETF	101.19	102.13	100.68	101.09	506500.0
2022-03-01	ACWX	ETF	52.19	52.325	51.13	51.38	3901606.0
2022-03-01	ADFI	ETF	9.24	9.27	9.24	9.245	2800.0
2022-03-01	ADIV	ETF	15.89	15.89	15.67	15.706	4500.0
2022-03-01	ADME	ETF	40.21	40.21	39.71	39.85	23300.0
2022-03-01	ADRE	ETF	45.08	45.08	44.1833	44.1833	1719.0
2022-03-01	AEMB	ETF	44.03	44.03	43.748	43.748	600.0
2022-03-01	AESR	ETF	12.867	12.87	12.66	12.711	15200.0
2022-03-01	AFIF	ETF	9.42	9.45	9.41	9.44	23105.0
2022-03-01	AFK	ETF	21.45	21.45	21.09	21.17	12086.0
2022-03-01	AFLG	ETF	25.448	25.448	25.448	25.448	100.0
2022-03-01	AFTY	ETF	19.82	19.841	19.82	19.841	100.0
2022-03-01	AGG	ETF	110.6	111.17	110.57	110.82	14355100.0
2022-03-01	AGGH	ETF	25.41	25.5599	25.41	25.4199	1263.0
2022-03-01	AGGY	ETF	49.59	49.83	49.59	49.63	360200.0
2022-03-01	AGNG	ETF	27.15	27.15	26.87	26.88	1700.0
2022-03-01	AGOV	ETF	87.64	87.89	86.07	87.141	4512.0
2022-03-01	AGOX	ETF	23.89	23.97	23.291	23.52	101500.0
2022-03-01	AGQ	ETF	38.57	41.14	38.56	40.95	1786000.0
2022-03-01	AGZ	ETF	115.3	115.74	115.3	115.35	28928.0
2022-03-01	AGZD	ETF	23.11	23.11	23.045	23.06	64000.0
2022-03-01	AHHX	ETF	9.73	9.75	9.64	9.656	22802.0
2022-03-01	AHYB	ETF	48.06	48.06	47.971	47.971	600.0
2022-03-01	AIA	ETF	72.1	72.57	71.42	71.72	38217.0
2022-03-01	AIEQ	ETF	36.213	36.308	35.49	35.622	10600.0
2022-03-01	AIQ	ETF	26.68	26.903	26.27	26.34	17456.0
2022-03-01	AIRR	ETF	41.84	41.88	40.6	40.96	13700.0
2022-03-01	AIVI	ETF	40.23	40.23	39.38	39.59	59600.0
2022-03-01	AIVL	ETF	97.3	97.3	95.94	96.36	50600.0
2022-03-01	ALTL	ETF	43.71	43.9345	43.135	43.35	70595.0

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

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