PREVIEW / etf_daily / 2021-10-29

all etf daily files

  file:    by_date/etf_daily/2021/2021-10-29.parquet
  size:    95 KB
  rows:    2,550

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-10-29	SPY	ETF	455.87	459.56	455.56	459.25	70162400.0
2021-10-29	QQQ	ETF	381.06	386.28	380.7	386.11	37310116.0
2021-10-29	IWM	ETF	227.8	228.83	226.96	228.05	20777700.0
2021-10-29	DIA	ETF	356.65	358.52	356.39	358.23	2979600.0
2021-10-29	GLD	ETF	166.29	166.73	165.64	166.65	7531900.0
2021-10-29	TLT	ETF	146.47	148.0	146.32	147.69	19087300.0
2021-10-29	AAA	ETF	24.99	25.0	24.99	25.0	423.0
2021-10-29	AAAU	ETF	17.69	17.74	17.63	17.73	213700.0
2021-10-29	AADR	ETF	64.8	65.09	64.75	65.09	2700.0
2021-10-29	AAXJ	ETF	86.44	86.54	85.87	86.31	419500.0
2021-10-29	ABEQ	ETF	27.529	27.529	27.529	27.529	100.0
2021-10-29	ACES	ETF	77.64	79.241	77.64	79.21	50800.0
2021-10-29	ACIO	ETF	31.479	31.67	31.479	31.67	34900.0
2021-10-29	ACSI	ETF	51.54	51.9481	51.54	51.9481	240.0
2021-10-29	ACT	ETF	22.49	23.26	22.49	22.98	93391.0
2021-10-29	ACTV	ETF	38.72	38.72	38.43	38.4939	4290.0
2021-10-29	ACVF	ETF	34.02	34.39	34.02	34.388	3800.0
2021-10-29	ACWF	ETF	37.88	38.025	37.88	37.9778	25902.0
2021-10-29	ACWI	ETF	104.81	105.4	104.77	105.31	2908600.0
2021-10-29	ACWV	ETF	105.24	105.76	105.24	105.73	118900.0
2021-10-29	ACWX	ETF	57.01	57.1	56.91	57.07	1525215.0
2021-10-29	ADFI	ETF	9.65	9.67	9.65	9.67	400.0
2021-10-29	ADIV	ETF	17.577	17.577	17.577	17.577	100.0
2021-10-29	ADME	ETF	41.63	41.95	41.63	41.87	44100.0
2021-10-29	ADRE	ETF	50.01	50.1399	49.35	49.49	8058.0
2021-10-29	AESR	ETF	14.49	14.575	14.49	14.57	2400.0
2021-10-29	AFIF	ETF	9.62	9.6295	9.62	9.6295	1630.0
2021-10-29	AFK	ETF	21.4	21.5689	21.38	21.38	3946.0
2021-10-29	AFLG	ETF	26.871	26.871	26.871	26.871	100.0
2021-10-29	AFMC	ETF	25.952	25.952	25.952	25.952	100.0
2021-10-29	AFTY	ETF	21.3	21.36	21.29	21.339	4300.0
2021-10-29	AGG	ETF	114.35	114.78	114.35	114.64	10047900.0
2021-10-29	AGGY	ETF	51.8	51.93	51.73	51.88	82900.0
2021-10-29	AGNG	ETF	29.59	29.76	29.589	29.76	2500.0
2021-10-29	AGOV	ETF	98.97	98.97	98.97	98.97	30.0
2021-10-29	AGOX	ETF	27.25	27.25	27.025	27.14	73800.0
2021-10-29	AGQ	ETF	37.09	37.39	36.47	37.21	805800.0
2021-10-29	AGZ	ETF	117.75	118.1	117.75	117.96	29644.0
2021-10-29	AGZD	ETF	23.435	23.445	23.41	23.435	58600.0
2021-10-29	AIA	ETF	80.38	80.38	79.71	80.01	28135.0
2021-10-29	AIEQ	ETF	43.06	43.357	43.004	43.281	7400.0
2021-10-29	AIQ	ETF	31.46	31.72	31.46	31.71	20367.0
2021-10-29	AIRR	ETF	43.66	44.13	43.66	43.88	22200.0
2021-10-29	AIVI	ETF	41.29	41.3	41.18	41.29	3300.0
2021-10-29	ALTL	ETF	43.32	43.4369	43.12	43.4314	19298.0
2021-10-29	ALTY	ETF	13.7	13.7	13.6	13.64	49300.0
2021-10-29	AMJ	ETF	19.29	19.3	18.81	18.96	801045.0
2021-10-29	AMLP	ETF	35.6	35.62	34.65	35.06	2579100.0
2021-10-29	AMNA	ETF	34.5826	34.5826	34.5826	34.5826	0.0
2021-10-29	AMND	ETF	35.706	35.706	35.706	35.706	2.0

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

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