PREVIEW / etf_daily / 2021-11-11

all etf daily files

  file:    by_date/etf_daily/2021/2021-11-11.parquet
  size:    95 KB
  rows:    2,554

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-11-11	SPY	ETF	465.21	465.29	463.75	463.77	34848500.0
2021-11-11	QQQ	ETF	392.57	392.75	390.24	390.59	32242983.0
2021-11-11	IWM	ETF	238.31	240.38	237.66	239.26	17987500.0
2021-11-11	DIA	ETF	361.19	361.26	359.38	359.46	2461200.0
2021-11-11	GLD	ETF	173.98	174.27	173.74	174.12	5959600.0
2021-11-11	TLT	ETF	148.51	148.66	147.89	147.98	5552500.0
2021-11-11	AAA	ETF	25.05	25.05	25.05	25.05	148.0
2021-11-11	AAAU	ETF	18.5	18.53	18.48	18.52	232100.0
2021-11-11	AADR	ETF	65.56	65.63	65.35	65.49	2200.0
2021-11-11	AAXJ	ETF	87.1	87.61	87.05	87.44	1093700.0
2021-11-11	ABEQ	ETF	28.38	28.43	28.37	28.37	1500.0
2021-11-11	ACES	ETF	77.95	80.506	77.39	79.98	76600.0
2021-11-11	ACIO	ETF	31.99	31.99	31.79	31.82	36100.0
2021-11-11	ACSI	ETF	52.8807	52.8807	52.8807	52.8807	8.0
2021-11-11	ACT	ETF	22.37	23.0982	21.875	21.96	332718.0
2021-11-11	ACTV	ETF	38.91	38.99	38.8871	38.8871	4668.0
2021-11-11	ACVF	ETF	35.32	35.32	34.959	34.96	7700.0
2021-11-11	ACWF	ETF	38.73	38.8467	38.73	38.8393	23585.0
2021-11-11	ACWI	ETF	106.45	106.59	106.31	106.33	3283100.0
2021-11-11	ACWV	ETF	106.82	106.82	106.58	106.71	176700.0
2021-11-11	ACWX	ETF	57.61	57.75	57.5499	57.63	921565.0
2021-11-11	ADFI	ETF	9.65	9.666	9.64	9.655	1900.0
2021-11-11	ADIV	ETF	17.792	17.792	17.792	17.792	100.0
2021-11-11	ADME	ETF	42.468	42.468	42.23	42.25	26400.0
2021-11-11	ADRE	ETF	50.91	51.23	50.91	51.1	6043.0
2021-11-11	AEMB	ETF	48.82	48.83	48.7	48.7	300.0
2021-11-11	AESR	ETF	14.75	14.76	14.7	14.7	5800.0
2021-11-11	AFIF	ETF	9.63	9.63	9.6199	9.6199	6023.0
2021-11-11	AFK	ETF	21.53	21.829	21.53	21.66	4450.0
2021-11-11	AFLG	ETF	27.241	27.241	27.241	27.241	100.0
2021-11-11	AFMC	ETF	27.02	27.04	27.02	27.04	600.0
2021-11-11	AFSM	ETF	28.84	28.84	28.769	28.769	500.0
2021-11-11	AFTY	ETF	21.189	21.35	21.189	21.308	2600.0
2021-11-11	AGG	ETF	114.51	114.57	114.3	114.34	3937100.0
2021-11-11	AGGY	ETF	51.98	51.98	51.83	51.87	54500.0
2021-11-11	AGNG	ETF	29.86	29.86	29.7	29.785	5800.0
2021-11-11	AGOV	ETF	99.36	99.4	99.235	99.235	9200.0
2021-11-11	AGOX	ETF	26.3	26.3	26.19	26.25	34000.0
2021-11-11	AGQ	ETF	41.04	41.62	40.87	41.48	810200.0
2021-11-11	AGZ	ETF	117.896	117.9147	117.76	117.76	18412.0
2021-11-11	AGZD	ETF	23.57	23.57	23.435	23.465	20000.0
2021-11-11	AIA	ETF	80.71	81.46	80.71	81.36	40775.0
2021-11-11	AIEQ	ETF	44.0	44.2	44.0	44.13	24000.0
2021-11-11	AIQ	ETF	32.61	32.795	32.61	32.66	32497.0
2021-11-11	AIRR	ETF	47.16	47.48	46.837	47.23	19200.0
2021-11-11	AIVI	ETF	41.53	41.62	41.53	41.55	2700.0
2021-11-11	ALTL	ETF	44.88	44.88	44.47	44.57	30546.0
2021-11-11	ALTY	ETF	13.6	13.6	13.533	13.58	19100.0
2021-11-11	AMJ	ETF	19.33	19.4699	19.265	19.43	397064.0
2021-11-11	AMLP	ETF	34.69	35.17	34.69	35.02	1164500.0

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

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