PREVIEW / etf_daily / 2021-08-12

all etf daily files

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

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-08-12	SPY	ETF	443.62	445.26	442.66	445.11	38909400.0
2021-08-12	QQQ	ETF	365.69	367.9	364.295	367.53	26003877.0
2021-08-12	IWM	ETF	223.76	223.84	221.71	223.16	23269500.0
2021-08-12	DIA	ETF	355.19	355.25	353.74	355.23	3118600.0
2021-08-12	GLD	ETF	163.65	164.1	162.93	164.04	5211700.0
2021-08-12	TLT	ETF	146.09	146.44	145.43	146.24	14709400.0
2021-08-12	AAA	ETF	25.01	25.0113	25.01	25.01	331.0
2021-08-12	AAAU	ETF	17.41	17.45	17.33	17.45	336400.0
2021-08-12	AADR	ETF	68.71	69.01	68.69	69.01	1600.0
2021-08-12	AAXJ	ETF	88.07	88.15	87.58	87.93	1144100.0
2021-08-12	ABEQ	ETF	27.83	27.97	27.81	27.97	11200.0
2021-08-12	ACES	ETF	71.11	71.38	70.376	71.38	61900.0
2021-08-12	ACIO	ETF	30.88	30.89	30.77	30.88	95600.0
2021-08-12	ACSI	ETF	51.648	51.648	51.648	51.648	56.0
2021-08-12	ACTV	ETF	38.65	38.8	38.565	38.7975	7926.0
2021-08-12	ACTX	ETF	1.44	1.44	1.4	1.4	10529.0
2021-08-12	ACVF	ETF	33.0	33.0	32.895	32.988	3200.0
2021-08-12	ACWF	ETF	38.585	38.7009	38.585	38.7009	1269.0
2021-08-12	ACWI	ETF	103.3	103.52	103.04	103.5	2602800.0
2021-08-12	ACWV	ETF	105.48	105.6	105.31	105.56	42900.0
2021-08-12	ACWX	ETF	57.38	57.38	57.16	57.35	522426.0
2021-08-12	ADFI	ETF	9.72	9.72	9.705	9.705	1700.0
2021-08-12	ADIV	ETF	18.26	18.26	18.251	18.251	100.0
2021-08-12	ADME	ETF	40.76	40.76	40.59	40.71	112200.0
2021-08-12	ADRE	ETF	52.77	52.79	52.2327	52.4775	10202.0
2021-08-12	AEMB	ETF	49.8	49.8	49.8	49.8	100.0
2021-08-12	AESR	ETF	14.059	14.12	14.04	14.12	3900.0
2021-08-12	AFIF	ETF	9.67	9.688	9.67	9.675	12191.0
2021-08-12	AFK	ETF	21.89	21.89	21.74	21.78	4136.0
2021-08-12	AFLG	ETF	26.41	26.46	26.41	26.46	600.0
2021-08-12	AFMC	ETF	25.93	25.994	25.925	25.994	3900.0
2021-08-12	AFSM	ETF	26.53	26.569	26.505	26.569	2700.0
2021-08-12	AFTY	ETF	20.83	20.85	20.81	20.81	1500.0
2021-08-12	AGG	ETF	115.49	115.58	115.4	115.55	5017300.0
2021-08-12	AGGY	ETF	52.41	52.45	52.37	52.42	172300.0
2021-08-12	AGNG	ETF	30.01	30.199	30.01	30.19	2000.0
2021-08-12	AGOV	ETF	100.0	100.0	99.855	99.855	301.0
2021-08-12	AGOX	ETF	26.4	26.52	26.344	26.48	139100.0
2021-08-12	AGQ	ETF	36.04	36.04	35.02	35.62	718300.0
2021-08-12	AGZ	ETF	118.76	118.8395	118.74	118.79	17025.0
2021-08-12	AGZD	ETF	23.5	23.505	23.435	23.46	12800.0
2021-08-12	AIA	ETF	83.78	83.78	83.33	83.72	83297.0
2021-08-12	AIEQ	ETF	41.51	41.898	41.51	41.858	5800.0
2021-08-12	AIQ	ETF	30.71	30.84	30.68	30.8	15335.0
2021-08-12	AIRR	ETF	42.83	43.147	42.622	42.76	12900.0
2021-08-12	AIVI	ETF	43.94	44.0	43.94	43.99	800.0
2021-08-12	ALTL	ETF	42.91	43.1988	42.91	43.07	74571.0
2021-08-12	ALTY	ETF	13.73	13.77	13.67	13.77	11700.0
2021-08-12	AMJ	ETF	18.18	18.45	17.965	18.45	375557.0
2021-08-12	AMLP	ETF	32.85	33.35	32.47	33.31	1821000.0

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

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