PREVIEW / etf_daily / 2022-01-12

all etf daily files

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

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-12	SPY	ETF	471.59	473.2	468.94	471.02	67605400.0
2022-01-12	QQQ	ETF	388.46	390.2	385.01	387.35	54576366.0
2022-01-12	IWM	ETF	218.52	219.38	214.64	215.99	35284500.0
2022-01-12	DIA	ETF	363.73	364.56	361.67	362.95	4493200.0
2022-01-12	GLD	ETF	170.19	170.75	170.01	170.74	6280700.0
2022-01-12	TLT	ETF	143.9	144.01	143.0	143.01	14440600.0
2022-01-12	AAA	ETF	24.9899	24.995	24.9899	24.995	706.0
2022-01-12	AAAU	ETF	18.12	18.17	18.09	18.17	121800.0
2022-01-12	AADR	ETF	64.18	64.96	64.18	64.81	700.0
2022-01-12	AAXJ	ETF	85.39	85.72	85.04	85.6	4308700.0
2022-01-12	ABEQ	ETF	28.94	28.98	28.94	28.98	200.0
2022-01-12	ACES	ETF	60.45	60.98	59.31	59.78	63500.0
2022-01-12	ACIO	ETF	32.301	32.4	32.12	32.35	49800.0
2022-01-12	ACSI	ETF	52.1	52.3303	52.1	52.3303	122.0
2022-01-12	ACT	ETF	21.91	22.46	21.86	22.36	199940.0
2022-01-12	ACTV	ETF	37.11	37.22	36.97	36.9996	11343.0
2022-01-12	ACVF	ETF	35.13	35.32	35.13	35.2	3700.0
2022-01-12	ACWF	ETF	39.3119	39.35	39.1941	39.2335	4737.0
2022-01-12	ACWI	ETF	105.79	106.08	105.3	105.86	4580800.0
2022-01-12	ACWV	ETF	106.51	106.6	106.15	106.53	173000.0
2022-01-12	ACWX	ETF	56.48	56.745	56.39	56.7	1203253.0
2022-01-12	ADFI	ETF	9.47	9.475	9.46	9.475	4300.0
2022-01-12	ADIV	ETF	16.746	16.746	16.746	16.746	100.0
2022-01-12	ADME	ETF	42.56	42.86	42.56	42.67	46000.0
2022-01-12	ADRE	ETF	49.06	49.27	48.98	49.14	18479.0
2022-01-12	AESR	ETF	13.97	13.97	13.843	13.91	44900.0
2022-01-12	AFIF	ETF	9.525	9.54	9.525	9.53	66860.0
2022-01-12	AFK	ETF	20.69	21.0	20.69	21.0	10602.0
2022-01-12	AFLG	ETF	27.52	27.618	27.52	27.618	100.0
2022-01-12	AFMC	ETF	26.34	26.34	26.1	26.178	300.0
2022-01-12	AFSM	ETF	26.99	26.99	26.81	26.81	300.0
2022-01-12	AFTY	ETF	20.63	20.735	20.63	20.733	1500.0
2022-01-12	AGG	ETF	112.72	112.79	112.58	112.6	6713200.0
2022-01-12	AGGY	ETF	50.85	50.913	50.83	50.83	187100.0
2022-01-12	AGNG	ETF	27.9	28.03	27.83	27.93	2700.0
2022-01-12	AGOV	ETF	97.47	97.54	97.47	97.54	950.0
2022-01-12	AGOX	ETF	25.21	25.345	25.18	25.21	14300.0
2022-01-12	AGQ	ETF	33.57	34.43	33.48	34.32	763400.0
2022-01-12	AGZ	ETF	116.34	116.4312	116.23	116.25	83727.0
2022-01-12	AGZD	ETF	23.32	23.35	23.305	23.345	274000.0
2022-01-12	AHHX	ETF	10.15	10.1972	10.15	10.1753	8545.0
2022-01-12	AHYB	ETF	49.849	49.849	49.849	49.849	200.0
2022-01-12	AIA	ETF	80.1	80.53	79.91	80.41	254175.0
2022-01-12	AIEQ	ETF	39.53	39.718	39.32	39.32	57600.0
2022-01-12	AIQ	ETF	31.0	31.15	30.71	30.89	38681.0
2022-01-12	AIRR	ETF	44.62	44.82	43.99	44.26	66500.0
2022-01-12	AIVI	ETF	43.13	43.31	43.13	43.27	12500.0
2022-01-12	ALTL	ETF	46.03	46.03	45.78	46.0	177593.0
2022-01-12	ALTY	ETF	13.5	13.51	13.36	13.42	49300.0
2022-01-12	AMAX	ETF	9.645	9.645	9.62	9.64	2000.0

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

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