PREVIEW / etf_daily / 2021-08-13

all etf daily files

  file:    by_date/etf_daily/2021/2021-08-13.parquet
  size:    92 KB
  rows:    2,425

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-13	SPY	ETF	445.59	445.94	445.07	445.92	39470300.0
2021-08-13	QQQ	ETF	367.89	369.16	367.38	368.82	19336190.0
2021-08-13	IWM	ETF	222.98	223.3	220.7	221.13	20813700.0
2021-08-13	DIA	ETF	355.85	356.37	355.0	355.39	2414900.0
2021-08-13	GLD	ETF	165.02	166.46	164.89	166.39	7466900.0
2021-08-13	TLT	ETF	146.83	148.56	146.81	148.55	18653800.0
2021-08-13	AAA	ETF	25.01	25.01	25.01	25.01	133.0
2021-08-13	AAAU	ETF	17.54	17.7	17.53	17.69	211900.0
2021-08-13	AADR	ETF	68.96	69.0	68.88	69.0	2500.0
2021-08-13	AAXJ	ETF	87.61	87.8	87.16	87.56	373600.0
2021-08-13	ABEQ	ETF	28.01	28.03	28.01	28.016	1500.0
2021-08-13	ACES	ETF	71.44	71.44	69.73	69.85	38900.0
2021-08-13	ACIO	ETF	31.02	31.02	30.844	30.89	53500.0
2021-08-13	ACSI	ETF	51.56	51.56	51.5434	51.5434	649.0
2021-08-13	ACTV	ETF	38.67	38.74	38.5843	38.5843	4726.0
2021-08-13	ACTX	ETF	1.41	1.41	1.4	1.4	2080.0
2021-08-13	ACVF	ETF	33.03	33.069	33.029	33.029	900.0
2021-08-13	ACWF	ETF	38.77	38.7884	38.77	38.7782	1201.0
2021-08-13	ACWI	ETF	103.64	103.77	103.47	103.76	1848500.0
2021-08-13	ACWV	ETF	105.88	106.18	105.76	106.16	162500.0
2021-08-13	ACWX	ETF	57.42	57.52	57.29	57.51	987399.0
2021-08-13	ADFI	ETF	9.73	9.74	9.73	9.733	900.0
2021-08-13	ADIV	ETF	18.268	18.268	18.268	18.268	100.0
2021-08-13	ADME	ETF	40.94	40.94	40.66	40.71	38700.0
2021-08-13	ADRE	ETF	52.0132	52.235	52.01	52.0875	5429.0
2021-08-13	AESR	ETF	14.12	14.13	14.09	14.12	52600.0
2021-08-13	AFIF	ETF	9.6912	9.7	9.6901	9.695	6337.0
2021-08-13	AFK	ETF	21.87	21.9293	21.795	21.82	5404.0
2021-08-13	AFLG	ETF	26.46	26.46	26.44	26.443	1600.0
2021-08-13	AFMC	ETF	25.862	25.862	25.862	25.862	100.0
2021-08-13	AFSM	ETF	26.44	26.44	26.293	26.293	300.0
2021-08-13	AFTY	ETF	20.984	20.984	20.984	20.984	100.0
2021-08-13	AGG	ETF	115.65	115.97	115.64	115.97	4599800.0
2021-08-13	AGGY	ETF	52.5	52.64	52.47	52.64	78000.0
2021-08-13	AGNG	ETF	30.65	30.65	30.37	30.48	15200.0
2021-08-13	AGOV	ETF	99.87	100.12	99.865	100.12	451.0
2021-08-13	AGOX	ETF	26.43	27.0	26.36	26.45	36600.0
2021-08-13	AGQ	ETF	36.56	37.65	36.35	37.26	824300.0
2021-08-13	AGZ	ETF	118.81	119.06	118.81	119.06	41601.0
2021-08-13	AGZD	ETF	23.45	23.49	23.405	23.41	37200.0
2021-08-13	AIA	ETF	83.02	83.11	82.56	83.07	68275.0
2021-08-13	AIEQ	ETF	41.95	41.95	41.592	41.691	59300.0
2021-08-13	AIQ	ETF	30.81	30.88	30.72	30.84	14399.0
2021-08-13	AIRR	ETF	42.89	42.89	42.23	42.33	35000.0
2021-08-13	AIVI	ETF	44.11	44.22	44.11	44.16	3400.0
2021-08-13	ALTL	ETF	43.16	43.4483	43.16	43.4	70193.0
2021-08-13	ALTY	ETF	13.79	13.79	13.7	13.72	14100.0
2021-08-13	AMJ	ETF	18.43	18.5	18.15	18.15	327992.0
2021-08-13	AMLP	ETF	33.31	33.52	32.9	33.0	1151800.0
2021-08-13	AMNA	ETF	32.2232	32.2232	32.2232	32.2232	0.0

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

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