PREVIEW / etf_daily / 2021-10-15

all etf daily files

  file:    by_date/etf_daily/2021/2021-10-15.parquet
  size:    94 KB
  rows:    2,526

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-15	SPY	ETF	444.75	446.26	444.09	445.87	66260200.0
2021-10-15	QQQ	ETF	367.88	369.06	366.82	368.94	40419878.0
2021-10-15	IWM	ETF	227.98	228.41	225.06	225.16	27555300.0
2021-10-15	DIA	ETF	351.65	353.08	350.92	352.85	4206800.0
2021-10-15	GLD	ETF	165.39	166.09	165.1	165.33	8699200.0
2021-10-15	TLT	ETF	145.0	145.14	144.47	145.03	11811500.0
2021-10-15	AAA	ETF	25.0099	25.0099	25.0	25.0	602.0
2021-10-15	AAAU	ETF	17.6	17.66	17.56	17.58	131800.0
2021-10-15	AADR	ETF	65.93	65.93	65.64	65.74	2100.0
2021-10-15	AAXJ	ETF	87.09	87.55	86.79	87.35	682000.0
2021-10-15	ABEQ	ETF	27.702	27.75	27.7	27.7	3900.0
2021-10-15	ACES	ETF	71.18	71.44	70.09	70.24	309000.0
2021-10-15	ACIO	ETF	30.84	30.92	30.79	30.88	31300.0
2021-10-15	ACSI	ETF	50.922	50.922	50.922	50.922	191.0
2021-10-15	ACT	ETF	21.5	21.69	20.89	21.56	149185.0
2021-10-15	ACTV	ETF	39.4	39.4	39.065	39.0663	5092.0
2021-10-15	ACTX	ETF	0.925	0.925	0.925	0.925	501.0
2021-10-15	ACVF	ETF	33.15	33.3	33.15	33.21	10100.0
2021-10-15	ACWF	ETF	37.71	37.85	37.71	37.71	4918.0
2021-10-15	ACWI	ETF	103.35	103.68	103.21	103.63	2024600.0
2021-10-15	ACWV	ETF	104.59	104.93	104.56	104.64	97900.0
2021-10-15	ACWX	ETF	56.92	57.155	56.8899	57.11	670931.0
2021-10-15	ADFI	ETF	9.65	9.665	9.65	9.665	300.0
2021-10-15	ADIV	ETF	17.334	17.334	17.334	17.334	100.0
2021-10-15	ADME	ETF	40.52	40.79	40.52	40.79	48200.0
2021-10-15	ADRE	ETF	50.64	51.018	50.64	50.83	5716.0
2021-10-15	AESR	ETF	14.045	14.14	14.045	14.122	11800.0
2021-10-15	AFIF	ETF	9.61	9.61	9.59	9.6	11135.0
2021-10-15	AFK	ETF	21.86	22.0	21.8296	22.0	8067.0
2021-10-15	AFLG	ETF	26.25	26.25	26.192	26.192	500.0
2021-10-15	AFSM	ETF	26.641	26.641	26.641	26.641	100.0
2021-10-15	AFTY	ETF	21.48	21.48	21.43	21.43	200.0
2021-10-15	AGG	ETF	114.61	114.63	114.51	114.57	4644800.0
2021-10-15	AGGY	ETF	51.98	51.98	51.89	51.91	53100.0
2021-10-15	AGNG	ETF	29.319	29.349	29.25	29.25	1300.0
2021-10-15	AGOV	ETF	99.2918	99.45	99.2918	99.335	784.0
2021-10-15	AGOX	ETF	26.62	26.74	26.62	26.666	34300.0
2021-10-15	AGQ	ETF	35.46	35.85	35.12	35.5	767900.0
2021-10-15	AGZ	ETF	118.12	118.21	118.09	118.15	22507.0
2021-10-15	AGZD	ETF	23.44	23.46	23.43	23.46	38200.0
2021-10-15	AIA	ETF	80.52	81.08	80.37	81.03	34181.0
2021-10-15	AIEQ	ETF	42.9	42.99	42.651	42.651	10300.0
2021-10-15	AIQ	ETF	31.49	31.6699	31.405	31.54	248356.0
2021-10-15	AIRR	ETF	42.77	42.78	42.15	42.15	31700.0
2021-10-15	AIVI	ETF	41.68	41.73	41.68	41.73	800.0
2021-10-15	ALTL	ETF	42.72	42.72	42.38	42.38	108262.0
2021-10-15	ALTY	ETF	13.59	13.61	13.53	13.58	18500.0
2021-10-15	AMJ	ETF	19.79	20.1	19.79	19.86	460907.0
2021-10-15	AMLP	ETF	36.54	36.72	36.41	36.45	2128300.0
2021-10-15	AMNA	ETF	35.99	35.99	35.8787	35.8787	195.0

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

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