PREVIEW / etf_daily / 2021-09-14

all etf daily files

  file:    by_date/etf_daily/2021/2021-09-14.parquet
  size:    92 KB
  rows:    2,460

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-09-14	SPY	ETF	448.12	448.34	443.22	444.17	78197100.0
2021-09-14	QQQ	ETF	377.86	378.61	374.28	375.26	41826624.0
2021-09-14	IWM	ETF	223.75	223.77	219.07	220.04	30312600.0
2021-09-14	DIA	ETF	350.4	350.57	345.71	346.47	3902200.0
2021-09-14	GLD	ETF	168.22	169.16	167.48	168.82	7922900.0
2021-09-14	TLT	ETF	149.73	151.57	149.58	151.11	19918400.0
2021-09-14	AAA	ETF	25.001	25.01	25.001	25.01	278.0
2021-09-14	AAAU	ETF	17.88	17.99	17.81	17.95	108600.0
2021-09-14	AADR	ETF	67.0	67.37	66.87	67.24	3100.0
2021-09-14	AAXJ	ETF	88.75	88.88	88.18	88.4	470900.0
2021-09-14	ABEQ	ETF	27.35	27.35	27.21	27.26	1200.0
2021-09-14	ACES	ETF	69.56	70.06	68.55	68.9	24800.0
2021-09-14	ACIO	ETF	30.96	30.96	30.58	30.64	49100.0
2021-09-14	ACSI	ETF	50.3784	50.3784	50.3784	50.3784	335.0
2021-09-14	ACTV	ETF	37.71	37.84	37.5171	37.5171	6454.0
2021-09-14	ACTX	ETF	1.35	1.35	1.25	1.25	4031.0
2021-09-14	ACVF	ETF	33.36	33.36	32.8	32.86	12000.0
2021-09-14	ACWF	ETF	39.03	39.04	38.72	38.73	32748.0
2021-09-14	ACWI	ETF	104.29	104.35	103.31	103.44	1780800.0
2021-09-14	ACWV	ETF	106.62	106.81	106.1	106.29	90200.0
2021-09-14	ACWX	ETF	58.0	58.06	57.575	57.63	1105442.0
2021-09-14	ADFI	ETF	9.79	9.8	9.78	9.79	3300.0
2021-09-14	ADIV	ETF	17.824	17.824	17.824	17.824	100.0
2021-09-14	ADME	ETF	41.2	41.2	40.67	40.75	32400.0
2021-09-14	ADRE	ETF	52.0	52.0	51.35	51.42	11622.0
2021-09-14	AESR	ETF	14.14	14.14	14.01	14.05	26700.0
2021-09-14	AFIF	ETF	9.71	9.73	9.71	9.73	8022.0
2021-09-14	AFK	ETF	21.77	21.77	21.5101	21.535	4039.0
2021-09-14	AFLG	ETF	26.49	26.49	26.171	26.171	200.0
2021-09-14	AFTY	ETF	20.53	20.54	20.51	20.51	2900.0
2021-09-14	AGG	ETF	116.07	116.38	116.07	116.28	4183600.0
2021-09-14	AGGY	ETF	52.71	52.86	52.71	52.835	38500.0
2021-09-14	AGNG	ETF	30.18	30.3	30.18	30.29	4900.0
2021-09-14	AGOV	ETF	100.96	100.96	100.89	100.9	242.0
2021-09-14	AGOX	ETF	26.39	26.55	26.23	26.31	15400.0
2021-09-14	AGQ	ETF	37.29	37.76	36.69	37.46	778300.0
2021-09-14	AGZ	ETF	119.2115	119.325	119.2115	119.28	16433.0
2021-09-14	AGZD	ETF	23.43	23.43	23.41	23.42	37000.0
2021-09-14	AIA	ETF	82.44	82.44	81.681	81.79	90478.0
2021-09-14	AIEQ	ETF	42.71	42.837	42.37	42.39	30900.0
2021-09-14	AIQ	ETF	31.56	31.62	31.29	31.31	31436.0
2021-09-14	AIRR	ETF	41.49	41.6	40.62	40.74	80400.0
2021-09-14	AIVI	ETF	43.54	43.56	43.41	43.41	2000.0
2021-09-14	ALTL	ETF	42.88	43.1	42.735	42.8	43595.0
2021-09-14	ALTY	ETF	13.69	13.7	13.56	13.58	14200.0
2021-09-14	AMJ	ETF	18.01	18.06	17.71	17.76	717186.0
2021-09-14	AMLP	ETF	33.19	33.24	32.57	32.69	1842600.0
2021-09-14	AMNA	ETF	32.1554	32.1554	32.1554	32.1554	3.0
2021-09-14	AMND	ETF	33.6626	33.6626	33.6626	33.6626	6.0
2021-09-14	AMOM	ETF	36.7	36.7	36.57	36.58	4500.0

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

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