PREVIEW / etf_daily / 2021-12-08

all etf daily files

  file:    by_date/etf_daily/2021/2021-12-08.parquet
  size:    97 KB
  rows:    2,597

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
2021-12-08	SPY	ETF	468.7	470.0	466.83	469.52	72238800.0
2021-12-08	QQQ	ETF	398.17	399.82	396.22	399.61	39204041.0
2021-12-08	IWM	ETF	224.6	226.54	223.06	225.63	36546400.0
2021-12-08	DIA	ETF	358.17	358.87	356.42	357.99	3355600.0
2021-12-08	GLD	ETF	166.51	166.96	166.28	166.9	4288900.0
2021-12-08	TLT	ETF	150.47	150.48	148.36	148.39	33633900.0
2021-12-08	AAA	ETF	25.01	25.02	25.0	25.0	2962.0
2021-12-08	AAAU	ETF	17.72	17.76	17.7	17.74	132700.0
2021-12-08	AADR	ETF	63.59	63.88	63.59	63.84	3900.0
2021-12-08	AAXJ	ETF	85.2	85.85	85.01	85.67	1500700.0
2021-12-08	ABEQ	ETF	27.6	27.669	27.6	27.669	3200.0
2021-12-08	ACES	ETF	70.83	71.2	70.3	70.91	46400.0
2021-12-08	ACIO	ETF	32.08	32.19	32.045	32.17	180500.0
2021-12-08	ACSI	ETF	52.17	52.3416	52.17	52.3416	102.0
2021-12-08	ACT	ETF	21.35	21.355	20.79	20.97	107406.0
2021-12-08	ACTV	ETF	38.621	38.73	38.621	38.6274	3477.0
2021-12-08	ACTX	ETF	1.1	1.24	1.05	1.24	631.0
2021-12-08	ACVF	ETF	35.1	35.1	34.82	35.04	13600.0
2021-12-08	ACWF	ETF	38.75	38.77	38.62	38.76	8914.0
2021-12-08	ACWI	ETF	105.7	105.98	105.37	105.9	4336700.0
2021-12-08	ACWV	ETF	106.18	106.67	106.02	106.53	2535300.0
2021-12-08	ACWX	ETF	56.31	56.47	56.21	56.42	2195050.0
2021-12-08	ADFI	ETF	9.63	9.63	9.62	9.62	400.0
2021-12-08	ADIV	ETF	16.17	16.18	16.17	16.179	2700.0
2021-12-08	ADME	ETF	42.55	42.73	42.496	42.706	81800.0
2021-12-08	ADRE	ETF	47.35	47.7346	47.16	47.7137	5889.0
2021-12-08	AEMB	ETF	48.51	48.51	48.51	48.51	100.0
2021-12-08	AESR	ETF	14.7	14.786	14.7	14.786	9500.0
2021-12-08	AFIF	ETF	9.5799	9.5799	9.56	9.56	3061.0
2021-12-08	AFK	ETF	20.48	20.64	20.46	20.64	12455.0
2021-12-08	AFLG	ETF	27.54	27.64	27.523	27.63	1800.0
2021-12-08	AFMC	ETF	26.38	26.411	26.38	26.411	200.0
2021-12-08	AFSM	ETF	27.584	27.584	27.509	27.532	300.0
2021-12-08	AFTY	ETF	21.9	21.9	21.85	21.85	3500.0
2021-12-08	AGG	ETF	114.37	114.37	114.05	114.19	8050100.0
2021-12-08	AGGY	ETF	51.81	51.841	51.692	51.77	122100.0
2021-12-08	AGNG	ETF	28.45	28.45	28.444	28.444	1300.0
2021-12-08	AGOV	ETF	98.14	98.26	98.13	98.26	4095.0
2021-12-08	AGOX	ETF	25.31	25.68	25.31	25.58	171800.0
2021-12-08	AGQ	ETF	32.12	32.48	31.92	32.39	441300.0
2021-12-08	AGZ	ETF	117.28	117.36	117.21	117.35	35745.0
2021-12-08	AGZD	ETF	23.385	23.4	23.355	23.385	22800.0
2021-12-08	AHHX	ETF	10.44	10.45	10.32	10.325	1359.0
2021-12-08	AIA	ETF	78.77	79.5	78.75	79.3	57138.0
2021-12-08	AIEQ	ETF	42.6	42.72	42.32	42.72	22500.0
2021-12-08	AIQ	ETF	32.09	32.25	31.99	32.22	29526.0
2021-12-08	AIRR	ETF	45.78	45.81	45.475	45.59	62900.0
2021-12-08	AIVI	ETF	41.36	41.52	41.35	41.51	7900.0
2021-12-08	ALTL	ETF	46.08	46.31	45.77	46.14	84332.0
2021-12-08	ALTY	ETF	13.41	13.41	13.33	13.385	32000.0

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

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