PREVIEW / etf_daily / 2021-07-29

all etf daily files

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

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-29	SPY	ETF	439.82	441.8	439.81	440.65	47435300.0
2021-07-29	QQQ	ETF	365.25	367.6794	365.25	366.48	25672533.0
2021-07-29	IWM	ETF	222.79	224.44	222.14	222.52	22634800.0
2021-07-29	DIA	ETF	350.95	351.71	350.38	350.82	2425700.0
2021-07-29	GLD	ETF	170.7	171.52	170.67	171.17	8119600.0
2021-07-29	TLT	ETF	148.78	149.22	148.53	148.82	11532000.0
2021-07-29	AAA	ETF	25.02	25.025	25.02	25.025	588.0
2021-07-29	AAAU	ETF	18.15	18.23	18.14	18.19	240400.0
2021-07-29	AADR	ETF	67.86	68.0	67.72	67.83	1800.0
2021-07-29	AAXJ	ETF	88.63	88.66	87.96	88.27	1891500.0
2021-07-29	ABEQ	ETF	27.71	27.72	27.686	27.686	1200.0
2021-07-29	ACES	ETF	71.58	72.36	71.37	71.78	61800.0
2021-07-29	ACIO	ETF	30.981	31.06	30.981	31.002	13800.0
2021-07-29	ACSI	ETF	51.1752	51.1752	51.1752	51.1752	247.0
2021-07-29	ACTV	ETF	38.26	38.66	38.21	38.4451	3047.0
2021-07-29	ACTX	ETF	1.76	1.76	1.65	1.65	2585.0
2021-07-29	ACVF	ETF	32.64	32.64	32.59	32.62	1000.0
2021-07-29	ACWF	ETF	38.13	38.39	38.13	38.3542	32110.0
2021-07-29	ACWI	ETF	102.65	102.9	102.61	102.69	3545800.0
2021-07-29	ACWV	ETF	104.84	105.07	104.84	104.88	77600.0
2021-07-29	ACWX	ETF	57.07	57.095	56.925	57.02	4505832.0
2021-07-29	ADFI	ETF	9.75	9.78	9.75	9.77	800.0
2021-07-29	ADIV	ETF	18.154	18.154	18.14	18.14	300.0
2021-07-29	ADME	ETF	40.8	40.9	40.8	40.837	24000.0
2021-07-29	ADRE	ETF	53.72	53.72	53.2	53.54	8872.0
2021-07-29	AEMB	ETF	50.03	50.03	50.03	50.03	100.0
2021-07-29	AESR	ETF	13.89	14.0	13.89	13.965	12500.0
2021-07-29	AFIF	ETF	9.66	9.69	9.65	9.67	19546.0
2021-07-29	AFK	ETF	21.47	21.89	21.47	21.82	7888.0
2021-07-29	AFLG	ETF	26.11	26.17	26.09	26.115	2800.0
2021-07-29	AFMC	ETF	25.543	25.543	25.506	25.506	500.0
2021-07-29	AFSM	ETF	26.063	26.063	26.063	26.063	100.0
2021-07-29	AFTY	ETF	20.58	20.58	20.34	20.392	2300.0
2021-07-29	AGG	ETF	116.29	116.36	116.23	116.3	6629500.0
2021-07-29	AGGY	ETF	52.76	52.788	52.72	52.77	53300.0
2021-07-29	AGNG	ETF	30.64	30.64	30.6	30.6	1700.0
2021-07-29	AGOX	ETF	26.35	26.43	26.332	26.332	19500.0
2021-07-29	AGQ	ETF	43.62	44.61	43.62	43.84	899700.0
2021-07-29	AGZ	ETF	119.2	119.2	119.11	119.18	11782.0
2021-07-29	AGZD	ETF	23.47	23.48	23.425	23.48	11000.0
2021-07-29	AIA	ETF	85.12	85.18	84.27	84.76	142289.0
2021-07-29	AIEQ	ETF	41.3	41.76	41.3	41.51	8900.0
2021-07-29	AIQ	ETF	30.77	30.9	30.73	30.73	23174.0
2021-07-29	AIRR	ETF	41.49	41.72	41.181	41.48	65400.0
2021-07-29	AIVI	ETF	44.0	44.03	43.95	43.95	2800.0
2021-07-29	ALTL	ETF	42.74	42.8826	42.67	42.76	140878.0
2021-07-29	ALTY	ETF	13.69	13.73	13.66	13.7	17000.0
2021-07-29	AMJ	ETF	18.73	18.73	18.39	18.64	439457.0
2021-07-29	AMLP	ETF	34.53	34.65	33.98	34.62	2509700.0
2021-07-29	AMNA	ETF	32.7875	32.7875	32.7875	32.7875	0.0

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

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