PREVIEW / etf_daily / 2021-12-02

all etf daily files

  file:    by_date/etf_daily/2021/2021-12-02.parquet
  size:    97 KB
  rows:    2,588

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-12-02	SPY	ETF	450.73	459.07	450.31	457.4	127637800.0
2021-12-02	QQQ	ETF	385.8	391.74	384.34	389.91	84416623.0
2021-12-02	IWM	ETF	214.37	219.94	213.82	219.21	64315700.0
2021-12-02	DIA	ETF	341.81	347.95	341.17	346.61	8326400.0
2021-12-02	GLD	ETF	165.89	165.94	164.63	165.24	9604100.0
2021-12-02	TLT	ETF	152.93	152.99	150.76	152.53	17754200.0
2021-12-02	AAA	ETF	25.0001	25.0199	25.0	25.0	983.0
2021-12-02	AAAU	ETF	17.65	17.66	17.52	17.58	278400.0
2021-12-02	AADR	ETF	62.14	62.49	62.09	62.36	4400.0
2021-12-02	AAXJ	ETF	84.37	84.85	83.85	84.28	1413000.0
2021-12-02	ABEQ	ETF	27.06	27.165	27.04	27.081	7400.0
2021-12-02	ACES	ETF	71.0	72.27	70.18	71.05	41000.0
2021-12-02	ACIO	ETF	31.337	31.49	31.28	31.36	111000.0
2021-12-02	ACSI	ETF	50.9535	50.9535	50.9535	50.9535	14.0
2021-12-02	ACT	ETF	21.0	21.64	20.725	21.36	230106.0
2021-12-02	ACTV	ETF	35.95	37.118	35.95	36.9792	3684.0
2021-12-02	ACTX	ETF	1.4	1.4	1.4	1.4	623.0
2021-12-02	ACVF	ETF	33.81	34.322	33.81	34.198	2400.0
2021-12-02	ACWF	ETF	37.71	37.88	37.52	37.73	5062.0
2021-12-02	ACWI	ETF	102.1	103.58	102.02	103.21	8715500.0
2021-12-02	ACWV	ETF	103.49	104.79	103.44	104.44	313600.0
2021-12-02	ACWX	ETF	54.81	55.29	54.788	55.1	6226640.0
2021-12-02	ADFI	ETF	9.6	9.615	9.59	9.615	2300.0
2021-12-02	ADIV	ETF	17.49	17.55	17.47	17.47	2600.0
2021-12-02	ADME	ETF	41.492	41.75	41.212	41.58	104600.0
2021-12-02	ADRE	ETF	47.28	47.675	46.7091	47.3	12314.0
2021-12-02	AEMB	ETF	48.205	48.205	48.205	48.205	100.0
2021-12-02	AESR	ETF	14.26	14.46	14.26	14.39	9100.0
2021-12-02	AFIF	ETF	9.5822	9.59	9.57	9.575	13936.0
2021-12-02	AFK	ETF	20.28	20.308	20.1	20.2	191950.0
2021-12-02	AFLG	ETF	26.65	27.05	26.65	26.97	3700.0
2021-12-02	AFMC	ETF	25.669	25.669	25.669	25.669	100.0
2021-12-02	AFTY	ETF	20.89	20.925	20.861	20.861	300.0
2021-12-02	AGG	ETF	114.67	114.79	114.4	114.61	7759700.0
2021-12-02	AGGY	ETF	52.0	52.0	51.85	51.95	111700.0
2021-12-02	AGNG	ETF	27.54	27.629	27.479	27.52	1900.0
2021-12-02	AGOV	ETF	98.09	98.09	98.025	98.025	185.0
2021-12-02	AGOX	ETF	24.7	25.11	24.7	25.07	30600.0
2021-12-02	AGQ	ETF	32.22	32.34	31.68	32.22	560400.0
2021-12-02	AGZ	ETF	117.8	117.8	117.5501	117.69	25178.0
2021-12-02	AGZD	ETF	23.46	23.46	23.31	23.37	72000.0
2021-12-02	AHHX	ETF	10.35	10.38	10.24	10.24	10036.0
2021-12-02	AIA	ETF	78.35	78.9085	78.03	78.18	49283.0
2021-12-02	AIEQ	ETF	41.02	41.91	41.02	41.706	27600.0
2021-12-02	AIQ	ETF	31.04	31.545	31.03	31.41	18948.0
2021-12-02	AIRR	ETF	43.59	44.9	43.59	44.79	15000.0
2021-12-02	AIVI	ETF	40.12	40.41	40.12	40.33	6200.0
2021-12-02	ALTL	ETF	43.6	44.89	43.55	44.58	162430.0
2021-12-02	ALTY	ETF	13.1	13.263	13.1	13.225	16300.0
2021-12-02	AMAX	ETF	9.53	9.58	9.483	9.498	4600.0

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

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