PREVIEW / etf_daily / 2021-11-10

all etf daily files

  file:    by_date/etf_daily/2021/2021-11-10.parquet
  size:    96 KB
  rows:    2,567

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-10	SPY	ETF	465.58	467.38	462.04	463.62	69429700.0
2021-11-10	QQQ	ETF	392.47	395.36	387.53	389.51	54937385.0
2021-11-10	IWM	ETF	240.08	241.56	236.31	237.35	32471600.0
2021-11-10	DIA	ETF	362.52	363.73	360.28	361.07	3529000.0
2021-11-10	GLD	ETF	173.67	174.65	172.11	173.15	11461800.0
2021-11-10	TLT	ETF	150.83	150.93	147.03	148.2	28170600.0
2021-11-10	AAA	ETF	25.0499	25.05	25.038	25.038	2905.0
2021-11-10	AAAU	ETF	18.46	18.56	18.31	18.41	399800.0
2021-11-10	AADR	ETF	65.95	65.95	64.83	64.91	2100.0
2021-11-10	AAXJ	ETF	86.42	86.81	85.77	86.06	4416900.0
2021-11-10	ABEQ	ETF	28.465	28.52	28.458	28.458	3600.0
2021-11-10	ACES	ETF	77.9	78.7	76.49	77.3	105000.0
2021-11-10	ACIO	ETF	31.84	32.05	31.79	31.82	41500.0
2021-11-10	ACSI	ETF	52.9123	52.9123	52.9123	52.9123	103.0
2021-11-10	ACT	ETF	22.43	22.545	22.12	22.31	91477.0
2021-11-10	ACTV	ETF	39.16	39.4408	38.93	39.0075	7557.0
2021-11-10	ACTX	ETF	1.01	1.01	1.01	1.01	167.0
2021-11-10	ACVF	ETF	35.12	35.158	34.802	34.93	8800.0
2021-11-10	ACWF	ETF	38.73	38.7512	38.445	38.5045	4503.0
2021-11-10	ACWI	ETF	106.65	106.97	105.7	105.98	2624400.0
2021-11-10	ACWV	ETF	106.43	107.06	106.43	106.58	263700.0
2021-11-10	ACWX	ETF	57.66	57.79	57.1201	57.21	972572.0
2021-11-10	ADFI	ETF	9.68	9.68	9.66	9.665	3200.0
2021-11-10	ADIV	ETF	17.614	17.614	17.614	17.614	100.0
2021-11-10	ADME	ETF	42.29	42.592	42.1	42.19	29900.0
2021-11-10	ADRE	ETF	50.3	50.7	49.77	49.98	5337.0
2021-11-10	AEMB	ETF	48.65	48.65	48.63	48.632	2600.0
2021-11-10	AESR	ETF	14.8	14.81	14.67	14.719	16500.0
2021-11-10	AFIF	ETF	9.64	9.64	9.591	9.605	20531.0
2021-11-10	AFK	ETF	21.61	21.738	21.5	21.5	4500.0
2021-11-10	AFLG	ETF	27.149	27.149	27.149	27.149	100.0
2021-11-10	AFSM	ETF	28.71	28.71	28.456	28.456	300.0
2021-11-10	AFTY	ETF	20.71	20.82	20.705	20.705	2100.0
2021-11-10	AGG	ETF	115.11	115.14	114.4	114.55	11620300.0
2021-11-10	AGGY	ETF	52.25	52.25	51.921	51.94	127700.0
2021-11-10	AGNG	ETF	30.257	30.331	29.81	29.845	9400.0
2021-11-10	AGOV	ETF	99.67	99.67	99.01	99.12	6965.0
2021-11-10	AGOX	ETF	26.33	26.37	26.0	26.09	59900.0
2021-11-10	AGQ	ETF	40.73	41.13	39.16	39.7	1730500.0
2021-11-10	AGZ	ETF	118.17	118.24	117.92	117.94	27223.0
2021-11-10	AGZD	ETF	23.365	23.485	23.365	23.475	117800.0
2021-11-10	AIA	ETF	80.11	80.6284	79.62	79.95	62280.0
2021-11-10	AIEQ	ETF	44.39	44.51	43.62	43.811	16800.0
2021-11-10	AIQ	ETF	32.72	32.84	32.13	32.3	38022.0
2021-11-10	AIRR	ETF	46.97	47.38	46.81	47.11	50200.0
2021-11-10	AIVI	ETF	41.6	41.72	41.23	41.31	5900.0
2021-11-10	ALTL	ETF	44.68	44.77	44.5827	44.74	24452.0
2021-11-10	ALTY	ETF	13.62	13.65	13.52	13.52	39600.0
2021-11-10	AMJ	ETF	19.44	19.55	19.11	19.21	531181.0
2021-11-10	AMLP	ETF	34.89	35.37	34.47	34.71	1772100.0

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

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