PREVIEW / etf_daily / 2021-09-16

all etf daily files

  file:    by_date/etf_daily/2021/2021-09-16.parquet
  size:    93 KB
  rows:    2,465

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-16	SPY	ETF	447.32	448.36	444.02	447.17	77786700.0
2021-09-16	QQQ	ETF	376.68	378.9	374.695	378.31	35193083.0
2021-09-16	IWM	ETF	222.26	223.34	220.26	222.19	22369000.0
2021-09-16	DIA	ETF	348.91	350.08	346.0	348.18	3646000.0
2021-09-16	GLD	ETF	164.38	164.44	163.23	164.03	11780400.0
2021-09-16	TLT	ETF	149.67	150.45	149.5	149.89	13328900.0
2021-09-16	AAA	ETF	25.005	25.005	25.005	25.005	100.0
2021-09-16	AAAU	ETF	17.49	17.49	17.38	17.45	342800.0
2021-09-16	AADR	ETF	67.03	67.34	67.03	67.34	1400.0
2021-09-16	AAXJ	ETF	86.77	87.18	86.55	87.02	427200.0
2021-09-16	ABEQ	ETF	27.142	27.34	27.13	27.255	9900.0
2021-09-16	ACES	ETF	68.35	68.65	67.991	68.48	96400.0
2021-09-16	ACIO	ETF	30.72	30.85	30.65	30.78	28900.0
2021-09-16	ACSI	ETF	50.8954	50.8954	50.8954	50.8954	11.0
2021-09-16	ACT	ETF	20.0	21.3494	19.51	20.49	3415154.0
2021-09-16	ACTV	ETF	38.39	38.39	37.7694	37.7694	2801.0
2021-09-16	ACTX	ETF	1.15	1.15	1.05	1.05	3796.0
2021-09-16	ACVF	ETF	33.02	33.28	32.94	33.17	14700.0
2021-09-16	ACWF	ETF	38.721	38.86	38.6199	38.83	14254.0
2021-09-16	ACWI	ETF	103.8	104.01	103.22	103.79	1936500.0
2021-09-16	ACWV	ETF	106.11	106.44	105.84	106.16	69000.0
2021-09-16	ACWX	ETF	57.37	57.535	57.22	57.47	1761770.0
2021-09-16	ADFI	ETF	9.76	9.78	9.76	9.765	2600.0
2021-09-16	ADIV	ETF	17.653	17.653	17.653	17.653	100.0
2021-09-16	ADME	ETF	40.9	41.02	40.74	40.96	23100.0
2021-09-16	ADRE	ETF	50.54	50.9225	50.49	50.865	10028.0
2021-09-16	AEMB	ETF	50.125	50.125	50.125	50.125	100.0
2021-09-16	AESR	ETF	14.11	14.18	14.04	14.14	17000.0
2021-09-16	AFIF	ETF	9.67	9.69	9.67	9.68	16616.0
2021-09-16	AFK	ETF	21.38	21.38	21.06	21.22	11133.0
2021-09-16	AFLG	ETF	26.395	26.395	26.395	26.395	100.0
2021-09-16	AFMC	ETF	25.667	25.667	25.667	25.667	100.0
2021-09-16	AFSM	ETF	26.201	26.201	26.201	26.201	600.0
2021-09-16	AFTY	ETF	20.04	20.14	20.04	20.08	2000.0
2021-09-16	AGG	ETF	115.95	116.11	115.91	115.97	4265500.0
2021-09-16	AGGY	ETF	52.655	52.743	52.643	52.695	66500.0
2021-09-16	AGNG	ETF	30.27	30.29	30.07	30.29	2500.0
2021-09-16	AGOV	ETF	100.675	100.675	100.675	100.675	3.0
2021-09-16	AGOX	ETF	26.72	29.69	26.35	26.47	32000.0
2021-09-16	AGQ	ETF	34.81	34.81	33.42	34.44	1948700.0
2021-09-16	AGZ	ETF	119.0	119.11	118.9	118.98	1256544.0
2021-09-16	AGZD	ETF	23.46	23.46	23.4	23.435	37200.0
2021-09-16	AIA	ETF	80.02	80.4756	79.84	80.35	69389.0
2021-09-16	AIEQ	ETF	42.87	43.02	42.59	43.02	11300.0
2021-09-16	AIQ	ETF	31.35	31.48	31.25	31.45	4623.0
2021-09-16	AIRR	ETF	41.38	41.38	40.681	40.97	11900.0
2021-09-16	AIVI	ETF	43.25	43.42	43.24	43.42	1900.0
2021-09-16	ALTL	ETF	42.83	43.17	42.64	42.8	16580.0
2021-09-16	ALTY	ETF	13.64	13.671	13.57	13.655	9400.0
2021-09-16	AMJ	ETF	17.86	18.04	17.69	17.97	615034.0

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

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