PREVIEW / etf_daily / 2021-09-17

all etf daily files

  file:    by_date/etf_daily/2021/2021-09-17.parquet
  size:    93 KB
  rows:    2,472

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-17	SPY	ETF	444.92	445.37	441.02	441.4	118425000.0
2021-09-17	QQQ	ETF	377.82	377.87	372.76	373.83	60912267.0
2021-09-17	IWM	ETF	221.62	223.03	220.64	222.48	39957600.0
2021-09-17	DIA	ETF	346.85	347.7	345.06	345.64	5380900.0
2021-09-17	GLD	ETF	163.86	164.32	163.4	163.77	8369700.0
2021-09-17	TLT	ETF	149.18	149.36	148.7	149.17	13782900.0
2021-09-17	AAA	ETF	25.0099	25.0099	25.005	25.005	125.0
2021-09-17	AAAU	ETF	17.43	17.47	17.39	17.42	246400.0
2021-09-17	AADR	ETF	65.78	65.94	65.78	65.94	400.0
2021-09-17	AAXJ	ETF	87.27	87.33	86.73	86.94	576700.0
2021-09-17	ABEQ	ETF	27.03	27.08	27.03	27.08	800.0
2021-09-17	ACES	ETF	68.53	69.96	68.45	69.85	535300.0
2021-09-17	ACIO	ETF	30.67	30.68	30.54	30.59	46500.0
2021-09-17	ACSI	ETF	50.5984	50.5984	50.5984	50.5984	68.0
2021-09-17	ACT	ETF	20.29	20.94	20.0	20.0	664033.0
2021-09-17	ACTV	ETF	37.6	37.64	37.35	37.5766	3368.0
2021-09-17	ACTX	ETF	1.05	1.1	1.05	1.05	2000.0
2021-09-17	ACVF	ETF	33.19	33.19	32.85	32.91	14900.0
2021-09-17	ACWF	ETF	38.66	38.66	38.31	38.39	7344.0
2021-09-17	ACWI	ETF	103.53	103.69	102.66	102.76	3500400.0
2021-09-17	ACWV	ETF	105.95	106.03	105.46	105.54	72100.0
2021-09-17	ACWX	ETF	57.27	57.35	56.74	56.88	2565827.0
2021-09-17	ADFI	ETF	9.75	9.755	9.75	9.755	500.0
2021-09-17	ADIV	ETF	17.529	17.529	17.529	17.529	100.0
2021-09-17	ADME	ETF	40.89	40.89	40.598	40.64	17000.0
2021-09-17	ADRE	ETF	51.01	51.01	50.31	50.395	8443.0
2021-09-17	AEMB	ETF	49.995	49.995	49.995	49.995	100.0
2021-09-17	AESR	ETF	14.15	14.15	14.0	14.024	11600.0
2021-09-17	AFIF	ETF	9.68	9.69	9.675	9.68	16599.0
2021-09-17	AFK	ETF	21.22	21.22	20.75	20.94	7417.0
2021-09-17	AFLG	ETF	26.166	26.166	26.151	26.151	1400.0
2021-09-17	AFMC	ETF	25.509	25.509	25.509	25.509	100.0
2021-09-17	AFTY	ETF	20.3	20.3	20.188	20.188	400.0
2021-09-17	AGG	ETF	115.8	115.88	115.74	115.87	5742500.0
2021-09-17	AGGY	ETF	52.56	52.62	52.56	52.59	45200.0
2021-09-17	AGNG	ETF	30.2	30.44	30.19	30.19	1700.0
2021-09-17	AGOV	ETF	100.44	100.465	100.44	100.465	549.0
2021-09-17	AGOX	ETF	26.35	26.43	26.22	26.31	39700.0
2021-09-17	AGQ	ETF	33.6	33.69	32.61	32.78	1419500.0
2021-09-17	AGZ	ETF	118.79	118.92	118.79	118.84	19803.0
2021-09-17	AGZD	ETF	23.375	23.455	23.375	23.455	39400.0
2021-09-17	AIA	ETF	80.8	80.8	80.205	80.36	67837.0
2021-09-17	AIEQ	ETF	42.95	42.95	42.552	42.771	8300.0
2021-09-17	AIQ	ETF	31.52	31.52	31.2	31.3399	35263.0
2021-09-17	AIRR	ETF	40.92	41.04	40.54	40.988	73500.0
2021-09-17	AIVI	ETF	42.74	42.74	42.58	42.64	2300.0
2021-09-17	ALTL	ETF	42.69	42.95	42.3938	42.43	38809.0
2021-09-17	ALTY	ETF	13.6	13.63	13.52	13.52	6700.0
2021-09-17	AMJ	ETF	17.94	18.0	17.625	17.74	559970.0
2021-09-17	AMLP	ETF	32.91	33.1	32.33	32.47	3204500.0

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

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