PREVIEW / etf_daily / 2021-07-30

all etf daily files

  file:    by_date/etf_daily/2021/2021-07-30.parquet
  size:    92 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-30	SPY	ETF	437.91	440.06	437.77	438.51	68951200.0
2021-07-30	QQQ	ETF	362.44	365.17	362.41	364.57	36484649.0
2021-07-30	IWM	ETF	221.65	224.05	220.28	221.05	28473000.0
2021-07-30	DIA	ETF	349.88	351.01	348.67	349.48	3576700.0
2021-07-30	GLD	ETF	170.72	170.99	169.38	169.82	7391700.0
2021-07-30	TLT	ETF	149.13	149.72	149.06	149.52	14342100.0
2021-07-30	AAA	ETF	25.025	25.025	25.025	25.025	175.0
2021-07-30	AAAU	ETF	18.16	18.18	18.01	18.06	161400.0
2021-07-30	AADR	ETF	66.94	66.94	66.94	66.94	400.0
2021-07-30	AAXJ	ETF	87.26	87.95	87.11	87.8	1570900.0
2021-07-30	ABEQ	ETF	27.626	27.626	27.626	27.626	100.0
2021-07-30	ACES	ETF	71.01	72.99	71.01	72.21	86900.0
2021-07-30	ACIO	ETF	30.92	30.93	30.82	30.86	88200.0
2021-07-30	ACSI	ETF	50.435	50.435	50.435	50.435	68.0
2021-07-30	ACTV	ETF	38.26	38.309	38.18	38.2441	3616.0
2021-07-30	ACTX	ETF	1.55	1.55	1.5	1.5	532.0
2021-07-30	ACVF	ETF	32.6	32.6	32.57	32.57	2300.0
2021-07-30	ACWF	ETF	38.3196	38.3196	38.1945	38.2666	3996.0
2021-07-30	ACWI	ETF	102.03	102.48	101.88	102.11	3702800.0
2021-07-30	ACWV	ETF	104.74	104.99	104.64	104.79	54000.0
2021-07-30	ACWX	ETF	56.64	56.86	56.47	56.56	2164175.0
2021-07-30	ADFI	ETF	9.8	9.8	9.76	9.77	600.0
2021-07-30	ADIV	ETF	18.081	18.081	18.081	18.081	100.0
2021-07-30	ADME	ETF	40.77	40.77	40.58	40.6	74000.0
2021-07-30	ADRE	ETF	52.54	53.3399	52.4834	52.79	9012.0
2021-07-30	AEMB	ETF	50.165	50.165	50.165	50.165	100.0
2021-07-30	AESR	ETF	13.91	13.925	13.86	13.881	7000.0
2021-07-30	AFIF	ETF	9.705	9.7235	9.68	9.7021	4870.0
2021-07-30	AFK	ETF	21.86	21.86	21.611	21.73	4766.0
2021-07-30	AFLG	ETF	26.1	26.1	25.962	25.962	300.0
2021-07-30	AFSM	ETF	26.12	26.12	25.946	25.946	400.0
2021-07-30	AFTY	ETF	20.14	20.14	20.08	20.12	1900.0
2021-07-30	AGG	ETF	116.36	116.49	116.35	116.46	5552100.0
2021-07-30	AGGY	ETF	52.8	52.85	52.785	52.81	50200.0
2021-07-30	AGNG	ETF	30.51	30.89	30.51	30.53	6300.0
2021-07-30	AGOV	ETF	100.265	100.265	100.265	100.265	13.0
2021-07-30	AGOX	ETF	26.57	26.57	26.135	26.161	19700.0
2021-07-30	AGQ	ETF	43.67	43.96	42.98	43.46	488800.0
2021-07-30	AGZ	ETF	119.19	119.29	119.19	119.29	71476.0
2021-07-30	AGZD	ETF	23.505	23.525	23.435	23.46	29200.0
2021-07-30	AIA	ETF	83.34	84.238	83.27	83.95	99740.0
2021-07-30	AIEQ	ETF	41.09	41.55	41.09	41.485	14000.0
2021-07-30	AIQ	ETF	30.43	30.555	30.407	30.43	25915.0
2021-07-30	AIRR	ETF	41.46	41.68	41.07	41.332	29900.0
2021-07-30	AIVI	ETF	43.68	43.68	43.54	43.55	1700.0
2021-07-30	ALTL	ETF	42.78	42.9628	42.69	42.69	25956.0
2021-07-30	ALTY	ETF	13.7	13.75	13.631	13.68	15400.0
2021-07-30	AMJ	ETF	18.69	18.72	18.31	18.31	544977.0
2021-07-30	AMLP	ETF	34.53	34.66	33.87	33.91	2299800.0
2021-07-30	AMNA	ETF	32.3407	32.3407	32.3407	32.3407	30.0

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

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