PREVIEW / etf_daily / 2022-02-09

all etf daily files

  file:    by_date/etf_daily/2022/2022-02-09.parquet
  size:    99 KB
  rows:    2,653

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-02-09	SPY	ETF	455.22	457.88	455.01	457.54	92589900.0
2022-02-09	QQQ	ETF	363.76	366.81	362.12	366.73	55766422.0
2022-02-09	IWM	ETF	204.57	206.65	204.3	206.61	27329300.0
2022-02-09	DIA	ETF	357.35	358.1	356.66	357.67	4781700.0
2022-02-09	GLD	ETF	170.68	171.42	170.55	171.21	8002800.0
2022-02-09	TLT	ETF	138.72	139.37	138.19	138.43	14349100.0
2022-02-09	AAA	ETF	25.0	25.0	24.985	25.0	1600.0
2022-02-09	AAAU	ETF	18.17	18.25	18.15	18.21	244900.0
2022-02-09	AADR	ETF	64.35	64.6	64.08	64.6	6500.0
2022-02-09	AAXJ	ETF	82.67	83.33	82.64	83.32	917900.0
2022-02-09	ABEQ	ETF	28.705	28.705	28.705	28.705	100.0
2022-02-09	ACES	ETF	53.8	54.25	53.12	54.25	41100.0
2022-02-09	ACIO	ETF	31.84	31.95	31.82	31.95	527500.0
2022-02-09	ACSI	ETF	51.41	51.41	51.0	51.0613	464.0
2022-02-09	ACT	ETF	22.52	22.7	22.2	22.33	162765.0
2022-02-09	ACTV	ETF	35.1911	35.33	35.17	35.2445	3832.0
2022-02-09	ACTX	ETF	0.99	0.99	0.99	0.99	442.0
2022-02-09	ACVF	ETF	34.19	34.335	34.19	34.314	2900.0
2022-02-09	ACWF	ETF	37.73	38.0248	37.73	38.0248	2841.0
2022-02-09	ACWI	ETF	102.52	103.07	102.5	103.07	5696300.0
2022-02-09	ACWV	ETF	104.18	104.52	104.18	104.48	83800.0
2022-02-09	ACWX	ETF	55.27	55.54	55.24	55.54	2165880.0
2022-02-09	ADFI	ETF	9.29	9.305	9.29	9.291	1700.0
2022-02-09	ADIV	ETF	16.64	16.72	16.64	16.699	3700.0
2022-02-09	ADME	ETF	41.61	41.95	41.61	41.88	431500.0
2022-02-09	ADRE	ETF	47.34	48.0	47.34	48.0	5130.0
2022-02-09	AEMB	ETF	46.45	46.45	46.45	46.45	100.0
2022-02-09	AESR	ETF	13.48	13.5	13.44	13.5	16100.0
2022-02-09	AFIF	ETF	9.45	9.45	9.438	9.44	44483.0
2022-02-09	AFK	ETF	21.19	21.2868	21.19	21.22	10959.0
2022-02-09	AFLG	ETF	26.85	26.912	26.85	26.912	1200.0
2022-02-09	AFMC	ETF	25.313	25.313	25.313	25.313	100.0
2022-02-09	AFSM	ETF	25.7	25.75	25.7	25.747	400.0
2022-02-09	AFTY	ETF	20.13	20.157	20.121	20.157	7000.0
2022-02-09	AGG	ETF	110.51	110.68	110.39	110.4	9194400.0
2022-02-09	AGGY	ETF	49.66	49.72	49.59	49.62	152500.0
2022-02-09	AGNG	ETF	27.0	27.35	26.99	27.278	37700.0
2022-02-09	AGOV	ETF	96.576	96.576	96.576	96.576	1.0
2022-02-09	AGOX	ETF	24.36	24.72	24.36	24.688	44600.0
2022-02-09	AGQ	ETF	34.03	34.45	33.76	34.26	699700.0
2022-02-09	AGZ	ETF	115.13	115.22	115.0601	115.1	36462.0
2022-02-09	AGZD	ETF	23.24	23.27	23.235	23.25	50000.0
2022-02-09	AHHX	ETF	9.809	9.81	9.7501	9.7801	4454.0
2022-02-09	AHYB	ETF	48.72	48.72	48.673	48.673	400.0
2022-02-09	AIA	ETF	78.13	78.93	78.13	78.89	47003.0
2022-02-09	AIEQ	ETF	37.39	38.26	37.39	38.26	23600.0
2022-02-09	AIQ	ETF	28.8	29.13	28.71	29.13	14526.0
2022-02-09	AIRR	ETF	41.8	42.67	41.8	42.55	53000.0
2022-02-09	AIVI	ETF	43.3	43.43	43.27	43.39	14900.0
2022-02-09	AIVL	ETF	99.98	100.81	99.98	100.5	5000.0

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

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