PREVIEW / etf_daily / 2022-03-07

all etf daily files

  file:    by_date/etf_daily/2022/2022-03-07.parquet
  size:    100 KB
  rows:    2,663

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-07	SPY	ETF	431.55	432.3	419.36	419.43	137896600.0
2022-03-07	QQQ	ETF	337.29	338.48	324.65	324.86	89933794.0
2022-03-07	IWM	ETF	199.22	199.59	193.68	193.72	39279800.0
2022-03-07	DIA	ETF	335.2	335.33	328.34	328.47	6590800.0
2022-03-07	GLD	ETF	184.45	186.64	184.22	186.41	27951800.0
2022-03-07	TLT	ETF	139.12	140.64	138.77	139.17	23710900.0
2022-03-07	AAA	ETF	24.88	24.894	24.88	24.894	1304.0
2022-03-07	AAAU	ETF	19.65	19.87	19.61	19.85	1644800.0
2022-03-07	AADR	ETF	55.38	55.38	52.82	53.09	3500.0
2022-03-07	AAXJ	ETF	73.72	74.04	72.2	72.26	2553100.0
2022-03-07	ABEQ	ETF	28.73	28.795	28.62	28.622	14400.0
2022-03-07	ACES	ETF	55.36	57.328	55.36	56.15	85000.0
2022-03-07	ACIO	ETF	30.715	30.728	30.195	30.22	30900.0
2022-03-07	ACSI	ETF	46.7897	46.7897	46.7897	46.7897	2.0
2022-03-07	ACT	ETF	20.19	20.19	19.46	19.5	99672.0
2022-03-07	ACTV	ETF	33.57	33.58	33.2363	33.2363	9432.0
2022-03-07	ACVF	ETF	32.05	32.165	31.573	31.573	5400.0
2022-03-07	ACWF	ETF	35.76	35.879	35.05	35.0929	18036.0
2022-03-07	ACWI	ETF	94.81	94.87	92.19	92.22	5164500.0
2022-03-07	ACWV	ETF	102.04	102.04	100.49	100.72	603300.0
2022-03-07	ACWX	ETF	49.54	49.54	48.13	48.26	3884134.0
2022-03-07	ADFI	ETF	9.14	9.16	9.1	9.101	5100.0
2022-03-07	ADIV	ETF	15.27	15.27	15.021	15.021	13700.0
2022-03-07	ADME	ETF	39.688	39.723	38.968	38.97	23700.0
2022-03-07	ADRE	ETF	42.57	42.58	41.128	41.225	11698.0
2022-03-07	AEMB	ETF	42.295	42.36	42.185	42.185	4600.0
2022-03-07	AESR	ETF	12.68	12.68	12.38	12.43	14300.0
2022-03-07	AFIF	ETF	9.39	9.39	9.345	9.345	9151.0
2022-03-07	AFK	ETF	20.84	20.84	20.12	20.22	20806.0
2022-03-07	AFLG	ETF	25.46	25.46	25.27	25.27	200.0
2022-03-07	AFMC	ETF	23.629	23.629	23.629	23.629	100.0
2022-03-07	AFSM	ETF	24.72	24.721	24.72	24.721	2800.0
2022-03-07	AFTY	ETF	18.4	18.41	18.4	18.401	1000.0
2022-03-07	AGG	ETF	109.87	110.14	109.64	109.66	12740600.0
2022-03-07	AGGY	ETF	49.21	49.28	49.051	49.095	114200.0
2022-03-07	AGNG	ETF	26.64	26.67	26.35	26.37	3200.0
2022-03-07	AGOV	ETF	84.48	84.83	83.92	84.5728	6958.0
2022-03-07	AGOX	ETF	23.23	23.585	22.86	22.86	20200.0
2022-03-07	AGQ	ETF	41.1	41.94	40.78	41.69	1609900.0
2022-03-07	AGZ	ETF	114.95	115.1618	114.95	115.07	20842.0
2022-03-07	AGZD	ETF	23.02	23.115	22.93	22.995	78600.0
2022-03-07	AHHX	ETF	8.92	9.78	8.92	9.69	18493.0
2022-03-07	AHYB	ETF	47.55	47.58	47.327	47.327	900.0
2022-03-07	AIA	ETF	67.44	67.79	66.0	66.0	30199.0
2022-03-07	AIEQ	ETF	35.43	35.43	34.03	34.15	12200.0
2022-03-07	AIQ	ETF	25.49	25.5	24.6507	24.69	27147.0
2022-03-07	AIRR	ETF	41.43	41.51	40.84	40.88	31700.0
2022-03-07	AIVI	ETF	37.66	37.69	36.7	36.97	9000.0
2022-03-07	AIVL	ETF	97.25	97.25	95.12	95.12	7300.0
2022-03-07	ALTL	ETF	42.63	42.63	40.43	40.47	722748.0

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

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