PREVIEW / etf_daily / 2021-07-13

all etf daily files

  file:    by_date/etf_daily/2021/2021-07-13.parquet
  size:    91 KB
  rows:    2,417

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-07-13	SPY	ETF	436.24	437.84	435.31	435.59	52911300.0
2021-07-13	QQQ	ETF	362.03	365.465	361.54	362.42	39723015.0
2021-07-13	IWM	ETF	225.23	225.74	222.22	222.3	25357500.0
2021-07-13	DIA	ETF	349.53	350.25	348.85	349.0	3310200.0
2021-07-13	GLD	ETF	169.51	169.9	168.93	169.22	7040300.0
2021-07-13	TLT	ETF	146.82	147.46	144.64	145.22	23340200.0
2021-07-13	AAA	ETF	25.01	25.01	25.0	25.0	2306.0
2021-07-13	AAAU	ETF	18.01	18.06	17.97	18.0	259100.0
2021-07-13	AADR	ETF	65.76	65.84	65.47	65.47	14300.0
2021-07-13	AAXJ	ETF	92.13	92.63	92.06	92.14	460200.0
2021-07-13	ABEQ	ETF	27.57	27.59	27.47	27.48	6100.0
2021-07-13	ACES	ETF	73.03	73.49	71.93	71.94	48900.0
2021-07-13	ACIO	ETF	30.8	30.9	30.74	30.74	74500.0
2021-07-13	ACSI	ETF	50.8412	50.8412	50.8412	50.8412	214.0
2021-07-13	ACTV	ETF	38.67	38.72	38.2479	38.2479	30436.0
2021-07-13	ACVF	ETF	32.39	32.39	32.186	32.205	1800.0
2021-07-13	ACWF	ETF	38.24	38.27	38.08	38.08	7925.0
2021-07-13	ACWI	ETF	102.22	102.53	101.97	102.03	3193800.0
2021-07-13	ACWV	ETF	103.95	104.48	103.94	104.01	82600.0
2021-07-13	ACWX	ETF	57.34	57.49	57.235	57.28	2830283.0
2021-07-13	ADFI	ETF	9.76	9.78	9.75	9.751	1600.0
2021-07-13	ADIV	ETF	18.31	18.31	18.3	18.305	400.0
2021-07-13	ADME	ETF	40.55	40.73	40.51	40.57	83000.0
2021-07-13	ADRE	ETF	55.64	56.54	55.64	56.18	10491.0
2021-07-13	AEMB	ETF	49.92	49.92	49.92	49.92	100.0
2021-07-13	AESR	ETF	13.9	13.9	13.809	13.809	22300.0
2021-07-13	AFIF	ETF	9.75	9.75	9.7	9.71	14849.0
2021-07-13	AFK	ETF	21.7	21.7198	21.3701	21.48	15817.0
2021-07-13	AFLG	ETF	25.78	25.78	25.653	25.653	400.0
2021-07-13	AFMC	ETF	25.125	25.125	25.125	25.125	100.0
2021-07-13	AFSM	ETF	25.918	25.918	25.918	25.918	300.0
2021-07-13	AFTY	ETF	22.44	22.49	22.38	22.402	10500.0
2021-07-13	AGG	ETF	115.65	115.76	115.3	115.36	5145200.0
2021-07-13	AGGY	ETF	52.51	52.56	52.34	52.35	80700.0
2021-07-13	AGNG	ETF	30.72	30.74	30.6	30.615	4300.0
2021-07-13	AGOX	ETF	25.92	26.26	25.92	26.08	9300.0
2021-07-13	AGQ	ETF	45.64	46.25	45.36	45.48	824000.0
2021-07-13	AGZ	ETF	118.63	118.74	118.48	118.5	32982.0
2021-07-13	AGZD	ETF	23.51	23.51	23.485	23.5	84200.0
2021-07-13	AIA	ETF	89.23	89.86	89.12	89.15	107103.0
2021-07-13	AIEQ	ETF	41.34	41.37	40.9	40.97	12900.0
2021-07-13	AIQ	ETF	30.64	30.97	30.6	30.78	23680.0
2021-07-13	AIRR	ETF	40.71	40.71	40.1	40.12	108800.0
2021-07-13	AIVI	ETF	43.75	43.82	43.64	43.65	3500.0
2021-07-13	ALTL	ETF	42.15	42.24	41.82	41.94	21087.0
2021-07-13	ALTY	ETF	13.54	13.62	13.531	13.59	8700.0
2021-07-13	AMJ	ETF	19.46	19.46	19.04	19.11	272074.0
2021-07-13	AMLP	ETF	35.91	36.06	35.23	35.23	1924300.0
2021-07-13	AMNA	ETF	33.308	33.308	33.308	33.308	2.0
2021-07-13	AMND	ETF	35.1603	35.1603	35.1603	35.1603	6.0

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

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