PREVIEW / etf_daily / 2022-01-18

all etf daily files

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

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-01-18	SPY	ETF	459.74	459.96	455.31	456.49	109709100.0
2022-01-18	QQQ	ETF	374.04	376.22	369.7704	370.55	75812296.0
2022-01-18	IWM	ETF	212.2	212.44	207.53	207.83	49434400.0
2022-01-18	DIA	ETF	355.33	355.36	352.62	353.85	8166100.0
2022-01-18	GLD	ETF	169.64	170.01	169.09	169.39	9322800.0
2022-01-18	TLT	ETF	140.96	141.31	140.02	140.1	21171700.0
2022-01-18	AAA	ETF	24.9899	24.9899	24.97	24.98	1525.0
2022-01-18	AAAU	ETF	18.05	18.08	18.0	18.02	129900.0
2022-01-18	AADR	ETF	63.19	63.47	62.87	62.87	2400.0
2022-01-18	AAXJ	ETF	82.86	83.48	82.86	83.03	1062900.0
2022-01-18	ABEQ	ETF	28.64	28.65	28.55	28.55	9400.0
2022-01-18	ACES	ETF	56.53	57.21	55.6	55.69	97800.0
2022-01-18	ACIO	ETF	31.585	31.67	31.51	31.56	99700.0
2022-01-18	ACSI	ETF	50.72	50.7201	50.6659	50.6659	306.0
2022-01-18	ACT	ETF	22.28	22.38	21.64	21.76	93467.0
2022-01-18	ACTV	ETF	36.82	36.82	36.0806	36.1054	5490.0
2022-01-18	ACVF	ETF	34.5	34.5	34.04	34.08	20600.0
2022-01-18	ACWF	ETF	38.48	38.48	38.2	38.2166	34649.0
2022-01-18	ACWI	ETF	103.26	103.37	102.45	102.66	8446000.0
2022-01-18	ACWV	ETF	104.49	104.66	104.2	104.48	244800.0
2022-01-18	ACWX	ETF	55.41	55.58	55.06	55.28	4349500.0
2022-01-18	ADFI	ETF	9.36	9.4	9.36	9.373	1000.0
2022-01-18	ADIV	ETF	16.53	16.57	16.503	16.503	7900.0
2022-01-18	ADME	ETF	41.671	41.77	41.52	41.572	64100.0
2022-01-18	ADRE	ETF	48.36	48.8	48.2	48.31	26612.0
2022-01-18	AEMB	ETF	46.545	46.545	46.545	46.545	100.0
2022-01-18	AESR	ETF	13.59	13.59	13.42	13.44	11200.0
2022-01-18	AFIF	ETF	9.48	9.48	9.45	9.45	31857.0
2022-01-18	AFK	ETF	20.68	20.68	20.44	20.5	9709.0
2022-01-18	AFLG	ETF	26.835	26.835	26.789	26.789	100.0
2022-01-18	AFMC	ETF	25.398	25.398	25.398	25.398	100.0
2022-01-18	AFSM	ETF	25.869	25.869	25.869	25.869	100.0
2022-01-18	AFTY	ETF	20.36	20.36	20.297	20.297	300.0
2022-01-18	AGG	ETF	111.81	111.86	111.47	111.49	7943800.0
2022-01-18	AGGY	ETF	50.45	50.453	50.27	50.28	96000.0
2022-01-18	AGNG	ETF	27.34	27.38	27.18	27.212	8700.0
2022-01-18	AGOV	ETF	96.6	96.8299	96.5	96.58	5070.0
2022-01-18	AGOX	ETF	24.44	24.69	24.42	24.449	21700.0
2022-01-18	AGQ	ETF	34.94	35.64	34.58	35.18	972400.0
2022-01-18	AGZ	ETF	115.96	115.98	115.75	115.75	36288.0
2022-01-18	AGZD	ETF	23.365	23.365	23.27	23.3	385400.0
2022-01-18	AHHX	ETF	10.17	10.17	10.08	10.105	401.0
2022-01-18	AHYB	ETF	49.6	49.6	49.515	49.515	800.0
2022-01-18	AIA	ETF	77.53	77.98	77.38	77.59	95466.0
2022-01-18	AIEQ	ETF	37.7	37.8	37.34	37.34	14200.0
2022-01-18	AIQ	ETF	29.5	29.69	29.19	29.24	72343.0
2022-01-18	AIRR	ETF	43.79	43.79	43.09	43.09	35400.0
2022-01-18	AIVI	ETF	42.95	43.11	42.84	42.92	7700.0
2022-01-18	AIVL	ETF	100.15	101.07	100.15	100.4528	21070.0
2022-01-18	ALTL	ETF	45.58	45.58	44.7818	45.21	166837.0

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

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