PREVIEW / etf_daily / 2021-09-13

all etf daily files

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

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-09-13	SPY	ETF	448.64	448.92	444.11	446.58	83738600.0
2021-09-13	QQQ	ETF	378.99	379.43	374.22	376.33	48741781.0
2021-09-13	IWM	ETF	223.21	223.38	220.25	222.88	34693100.0
2021-09-13	DIA	ETF	348.91	349.94	347.47	349.3	5439700.0
2021-09-13	GLD	ETF	167.45	168.22	167.4	167.74	5474300.0
2021-09-13	TLT	ETF	149.04	149.49	148.95	149.3	15036100.0
2021-09-13	AAA	ETF	25.0	25.005	25.0	25.005	1672.0
2021-09-13	AAAU	ETF	17.82	17.88	17.81	17.84	84300.0
2021-09-13	AADR	ETF	67.37	67.62	67.17	67.42	1300.0
2021-09-13	AAXJ	ETF	89.21	89.45	88.77	89.28	563000.0
2021-09-13	ABEQ	ETF	27.381	27.441	27.381	27.441	700.0
2021-09-13	ACES	ETF	68.98	69.45	67.34	69.25	111500.0
2021-09-13	ACIO	ETF	31.02	31.02	30.694	30.85	64300.0
2021-09-13	ACSI	ETF	50.76	50.9075	50.76	50.9075	551.0
2021-09-13	ACTV	ETF	37.95	38.05	37.93	37.98	4327.0
2021-09-13	ACTX	ETF	1.48	1.48	1.25	1.27	1075.0
2021-09-13	ACVF	ETF	33.33	33.33	32.92	33.16	32800.0
2021-09-13	ACWF	ETF	39.16	39.16	38.88	39.04	11088.0
2021-09-13	ACWI	ETF	104.42	104.45	103.59	104.06	2490400.0
2021-09-13	ACWV	ETF	106.96	107.09	106.31	106.56	204300.0
2021-09-13	ACWX	ETF	58.06	58.06	57.8	57.96	1166099.0
2021-09-13	ADFI	ETF	9.789	9.8	9.77	9.785	3700.0
2021-09-13	ADIV	ETF	17.985	17.985	17.985	17.985	100.0
2021-09-13	ADME	ETF	41.28	41.28	40.77	40.99	39400.0
2021-09-13	ADRE	ETF	52.13	52.37	51.7835	52.3099	8399.0
2021-09-13	AEMB	ETF	50.234	50.234	50.234	50.234	100.0
2021-09-13	AESR	ETF	14.17	14.22	14.04	14.12	20200.0
2021-09-13	AFIF	ETF	9.7	9.73	9.7	9.72	9807.0
2021-09-13	AFK	ETF	21.37	21.58	21.37	21.58	7720.0
2021-09-13	AFLG	ETF	26.346	26.346	26.346	26.346	100.0
2021-09-13	AFMC	ETF	25.635	25.635	25.635	25.635	100.0
2021-09-13	AFSM	ETF	26.19	26.19	26.19	26.19	600.0
2021-09-13	AFTY	ETF	20.86	20.96	20.82	20.902	6100.0
2021-09-13	AGG	ETF	116.0	116.08	115.96	116.02	3954100.0
2021-09-13	AGGY	ETF	52.6	52.71	52.6	52.66	64800.0
2021-09-13	AGNG	ETF	30.157	30.342	30.05	30.092	3500.0
2021-09-13	AGOX	ETF	26.55	26.55	26.3	26.48	37700.0
2021-09-13	AGQ	ETF	36.41	37.47	36.34	37.11	752800.0
2021-09-13	AGZ	ETF	119.05	119.17	119.05	119.1	23921.0
2021-09-13	AGZD	ETF	23.45	23.45	23.415	23.425	24400.0
2021-09-13	AIA	ETF	82.83	83.185	82.5	82.82	66090.0
2021-09-13	AIEQ	ETF	43.04	43.04	42.42	42.63	13000.0
2021-09-13	AIQ	ETF	31.72	31.74	31.285	31.47	25701.0
2021-09-13	AIRR	ETF	41.46	41.46	41.07	41.24	19600.0
2021-09-13	AIVI	ETF	43.71	43.74	43.6	43.74	4100.0
2021-09-13	ALTL	ETF	43.38	43.38	42.819	42.95	18112.0
2021-09-13	ALTY	ETF	13.62	13.69	13.61	13.63	7800.0
2021-09-13	AMJ	ETF	17.8	18.13	17.78	17.94	2747547.0
2021-09-13	AMLP	ETF	32.75	33.37	32.71	33.0	2144400.0
2021-09-13	AMNA	ETF	32.3978	32.3978	32.3978	32.3978	0.0

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

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