PREVIEW / etf_daily / 2022-01-19

all etf daily files

  file:    by_date/etf_daily/2022/2022-01-19.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-01-19	SPY	ETF	458.13	459.61	451.46	451.75	109357600.0
2022-01-19	QQQ	ETF	372.15	374.69	366.21	366.48	81791482.0
2022-01-19	IWM	ETF	208.81	209.46	204.38	204.45	46209100.0
2022-01-19	DIA	ETF	354.91	355.55	350.21	350.35	7386500.0
2022-01-19	GLD	ETF	170.39	172.19	170.2	172.08	15784500.0
2022-01-19	TLT	ETF	140.53	141.71	140.31	141.07	17930500.0
2022-01-19	AAA	ETF	25.0	25.0	24.985	24.985	130.0
2022-01-19	AAAU	ETF	18.14	18.32	18.13	18.31	128600.0
2022-01-19	AADR	ETF	63.1	63.1	63.06	63.06	600.0
2022-01-19	AAXJ	ETF	83.51	83.71	83.15	83.18	1106500.0
2022-01-19	ABEQ	ETF	28.88	28.88	28.643	28.643	6300.0
2022-01-19	ACES	ETF	56.24	56.24	54.72	54.96	268800.0
2022-01-19	ACIO	ETF	31.54	31.87	31.44	31.44	145300.0
2022-01-19	ACSI	ETF	50.79	50.79	50.2601	50.2601	428.0
2022-01-19	ACT	ETF	21.91	22.54	21.58	21.67	154312.0
2022-01-19	ACTV	ETF	36.18	36.18	35.4954	35.4954	8903.0
2022-01-19	ACTX	ETF	1.39	1.39	1.39	1.39	287.0
2022-01-19	ACVF	ETF	34.16	34.3	33.85	33.87	16400.0
2022-01-19	ACWF	ETF	38.43	38.44	37.96	37.96	18202.0
2022-01-19	ACWI	ETF	103.11	103.41	102.0	102.04	6159500.0
2022-01-19	ACWV	ETF	104.47	105.16	104.43	104.54	155300.0
2022-01-19	ACWX	ETF	55.59	55.7	55.29	55.34	2801935.0
2022-01-19	ADFI	ETF	9.41	9.42	9.38	9.397	6800.0
2022-01-19	ADIV	ETF	16.63	16.63	16.571	16.571	1100.0
2022-01-19	ADME	ETF	41.81	41.91	41.32	41.37	45800.0
2022-01-19	ADRE	ETF	48.83	48.8444	48.0956	48.0956	9898.0
2022-01-19	AEMB	ETF	46.79	46.79	46.749	46.749	200.0
2022-01-19	AESR	ETF	13.54	13.54	13.302	13.302	39000.0
2022-01-19	AFIF	ETF	9.51	9.53	9.51	9.52	12920.0
2022-01-19	AFK	ETF	20.72	20.88	20.72	20.84	11599.0
2022-01-19	AFLG	ETF	26.73	26.773	26.551	26.551	500.0
2022-01-19	AFMC	ETF	25.03	25.03	25.03	25.03	200.0
2022-01-19	AFSM	ETF	25.501	25.69	25.424	25.424	1500.0
2022-01-19	AFTY	ETF	20.283	20.283	20.283	20.283	100.0
2022-01-19	AGG	ETF	111.7	111.89	111.65	111.73	8321000.0
2022-01-19	AGGY	ETF	50.3	50.48	50.3	50.33	255500.0
2022-01-19	AGNG	ETF	27.25	27.44	27.161	27.161	10100.0
2022-01-19	AGOV	ETF	96.85	96.935	96.82	96.935	2230.0
2022-01-19	AGOX	ETF	24.63	24.63	24.21	24.21	40300.0
2022-01-19	AGQ	ETF	36.18	37.39	36.0	37.3	1917200.0
2022-01-19	AGZ	ETF	115.4	116.1	115.4	116.05	101992.0
2022-01-19	AGZD	ETF	23.29	23.34	23.28	23.285	91600.0
2022-01-19	AHHX	ETF	10.105	10.1399	10.02	10.08	14687.0
2022-01-19	AHYB	ETF	49.542	49.542	49.495	49.495	3000.0
2022-01-19	AIA	ETF	78.17	78.3879	77.7638	77.94	103332.0
2022-01-19	AIEQ	ETF	37.53	37.83	36.95	36.95	20400.0
2022-01-19	AIQ	ETF	29.4	29.56	28.92	28.97	40052.0
2022-01-19	AIRR	ETF	43.42	43.42	41.98	42.0	98500.0
2022-01-19	AIVI	ETF	42.88	43.04	42.76	42.78	7200.0
2022-01-19	AIVL	ETF	100.3	100.95	99.66	99.66	14100.0

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

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