PREVIEW / etf_daily / 2021-12-13

all etf daily files

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

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-13	SPY	ETF	470.19	470.56	466.27	466.57	87724700.0
2021-12-13	QQQ	ETF	398.0	398.325	391.88	392.26	50166410.0
2021-12-13	IWM	ETF	218.39	219.05	214.75	216.04	33478400.0
2021-12-13	DIA	ETF	359.43	359.99	356.61	357.04	4563000.0
2021-12-13	GLD	ETF	166.9	167.26	166.67	167.0	6610700.0
2021-12-13	TLT	ETF	150.39	151.31	150.31	151.06	17860500.0
2021-12-13	AAA	ETF	24.99	24.99	24.99	24.99	63.0
2021-12-13	AAAU	ETF	17.75	17.79	17.74	17.77	161100.0
2021-12-13	AADR	ETF	62.73	62.73	62.12	62.22	1500.0
2021-12-13	AAXJ	ETF	83.32	83.32	82.32	82.58	1539200.0
2021-12-13	ABEQ	ETF	27.53	27.68	27.53	27.637	7000.0
2021-12-13	ACES	ETF	67.72	68.674	66.845	67.63	109200.0
2021-12-13	ACIO	ETF	32.08	32.215	32.08	32.15	33800.0
2021-12-13	ACSI	ETF	51.6661	51.6661	51.6661	51.6661	61.0
2021-12-13	ACT	ETF	20.84	20.84	20.5	20.7	105973.0
2021-12-13	ACTV	ETF	37.82	37.91	37.57	37.649	5512.0
2021-12-13	ACTX	ETF	1.0	1.24	0.7877	1.24	2615.0
2021-12-13	ACVF	ETF	35.11	35.11	34.77	34.802	2400.0
2021-12-13	ACWF	ETF	38.21	38.23	37.92	37.95	9284.0
2021-12-13	ACWI	ETF	104.43	104.43	103.57	103.57	3633400.0
2021-12-13	ACWV	ETF	105.68	106.22	105.48	106.03	114100.0
2021-12-13	ACWX	ETF	54.97	54.99	54.555	54.6	3038220.0
2021-12-13	ADFI	ETF	9.64	9.64	9.61	9.625	1200.0
2021-12-13	ADIV	ETF	16.09	16.09	16.02	16.048	3700.0
2021-12-13	ADME	ETF	42.64	42.64	42.36	42.36	33200.0
2021-12-13	ADRE	ETF	46.62	46.6522	46.03	46.2016	4269.0
2021-12-13	AEMB	ETF	48.71	48.71	48.71	48.71	100.0
2021-12-13	AESR	ETF	14.75	14.75	14.6	14.637	3400.0
2021-12-13	AFIF	ETF	9.6	9.619	9.6	9.61	18261.0
2021-12-13	AFK	ETF	20.43	20.49	20.25	20.25	6884.0
2021-12-13	AFLG	ETF	27.604	27.604	27.604	27.604	100.0
2021-12-13	AFMC	ETF	25.97	25.97	25.932	25.932	200.0
2021-12-13	AFSM	ETF	26.71	26.71	26.668	26.668	600.0
2021-12-13	AFTY	ETF	21.98	22.04	21.98	22.04	500.0
2021-12-13	AGG	ETF	114.51	114.71	114.46	114.63	8659300.0
2021-12-13	AGGY	ETF	51.8	51.97	51.8	51.91	94500.0
2021-12-13	AGNG	ETF	28.22	28.26	28.22	28.231	800.0
2021-12-13	AGOV	ETF	98.25	98.365	98.25	98.365	445.0
2021-12-13	AGOX	ETF	25.5	25.5	25.0	25.0	26200.0
2021-12-13	AGQ	ETF	32.0	32.23	31.83	31.95	447700.0
2021-12-13	AGZ	ETF	117.44	117.63	117.44	117.56	28337.0
2021-12-13	AGZD	ETF	23.345	23.4	23.325	23.325	30400.0
2021-12-13	AHHX	ETF	10.31	10.405	10.22	10.315	703.0
2021-12-13	AIA	ETF	77.36	77.36	76.55	76.76	78441.0
2021-12-13	AIEQ	ETF	42.0	42.0	41.28	41.29	13800.0
2021-12-13	AIQ	ETF	31.97	32.085	31.5	31.58	38199.0
2021-12-13	AIRR	ETF	44.63	44.79	44.442	44.54	18800.0
2021-12-13	AIVI	ETF	41.22	41.27	41.02	41.03	16200.0
2021-12-13	ALTL	ETF	45.57	45.57	44.3046	44.4	65031.0
2021-12-13	ALTY	ETF	13.28	13.34	13.24	13.31	17400.0

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

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