PREVIEW / etf_daily / 2021-07-12

all etf daily files

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

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-12	SPY	ETF	435.43	437.35	434.97	437.08	52889600.0
2021-07-12	QQQ	ETF	362.45	362.89	360.83	362.42	25717677.0
2021-07-12	IWM	ETF	225.56	226.89	224.55	226.57	16831000.0
2021-07-12	DIA	ETF	348.01	350.29	347.37	350.03	3999800.0
2021-07-12	GLD	ETF	168.7	169.16	167.64	169.0	7315400.0
2021-07-12	TLT	ETF	147.09	147.23	146.17	146.34	10610400.0
2021-07-12	AAA	ETF	25.005	25.005	25.005	25.005	38.0
2021-07-12	AAAU	ETF	17.94	17.98	17.83	17.97	477200.0
2021-07-12	AAXJ	ETF	91.56	91.79	91.29	91.79	447500.0
2021-07-12	ABEQ	ETF	27.63	27.64	27.58	27.58	6100.0
2021-07-12	ACES	ETF	73.23	73.84	72.74	73.76	25600.0
2021-07-12	ACIO	ETF	30.77	30.81	30.76	30.788	32200.0
2021-07-12	ACSI	ETF	51.1066	51.1066	51.1066	51.1066	178.0
2021-07-12	ACTV	ETF	38.71	38.88	38.6577	38.81	5984.0
2021-07-12	ACTX	ETF	2.6	2.6	2.6	2.6	250.0
2021-07-12	ACVF	ETF	32.27	32.331	32.27	32.331	2000.0
2021-07-12	ACWF	ETF	38.15	38.275	38.08	38.25	14435.0
2021-07-12	ACWI	ETF	102.06	102.45	101.98	102.38	3517100.0
2021-07-12	ACWV	ETF	104.12	104.41	104.12	104.24	267600.0
2021-07-12	ACWX	ETF	57.29	57.5	57.205	57.5	1602420.0
2021-07-12	ADFI	ETF	9.75	9.77	9.75	9.755	3200.0
2021-07-12	ADIV	ETF	18.27	18.305	18.27	18.305	500.0
2021-07-12	ADME	ETF	40.53	40.63	40.5	40.62	31300.0
2021-07-12	ADRE	ETF	55.21	55.6	54.9	55.6	12062.0
2021-07-12	AEMB	ETF	50.04	50.04	50.04	50.04	100.0
2021-07-12	AESR	ETF	13.82	13.88	13.82	13.872	5900.0
2021-07-12	AFIF	ETF	9.72	9.74	9.72	9.7299	11816.0
2021-07-12	AFK	ETF	22.0	22.0	21.77	21.85	11995.0
2021-07-12	AFLG	ETF	25.829	25.829	25.829	25.829	100.0
2021-07-12	AFMC	ETF	25.451	25.543	25.44	25.543	900.0
2021-07-12	AFSM	ETF	26.395	26.395	26.395	26.395	100.0
2021-07-12	AFTY	ETF	22.4	22.413	22.394	22.413	3700.0
2021-07-12	AGG	ETF	115.8	115.81	115.6	115.61	4266600.0
2021-07-12	AGGY	ETF	52.53	52.54	52.45	52.48	44200.0
2021-07-12	AGNG	ETF	30.81	30.85	30.795	30.797	11600.0
2021-07-12	AGOX	ETF	26.3	26.31	26.16	26.27	4800.0
2021-07-12	AGQ	ETF	45.9	46.46	45.32	46.3	446200.0
2021-07-12	AGZ	ETF	118.7	118.81	118.63	118.63	13426.0
2021-07-12	AGZD	ETF	23.49	23.495	23.485	23.495	49000.0
2021-07-12	AIA	ETF	87.95	88.53	87.88	88.36	143383.0
2021-07-12	AIEQ	ETF	41.29	41.5	41.21	41.25	14900.0
2021-07-12	AIQ	ETF	30.82	30.82	30.69	30.7	19915.0
2021-07-12	AIRR	ETF	40.18	40.9	40.13	40.9	14700.0
2021-07-12	AIVI	ETF	43.8	43.84	43.8	43.81	4200.0
2021-07-12	ALTL	ETF	42.03	42.13	41.96	42.05	16355.0
2021-07-12	ALTY	ETF	13.64	13.69	13.59	13.69	17100.0
2021-07-12	AMJ	ETF	19.43	19.515	19.25	19.47	444720.0
2021-07-12	AMLP	ETF	36.06	36.21	35.69	35.97	1911800.0
2021-07-12	AMNA	ETF	34.1977	34.1977	34.1977	34.1977	73.0
2021-07-12	AMND	ETF	36.2371	36.2371	36.2371	36.2371	8.0

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

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