PREVIEW / etf_daily / 2021-12-03

all etf daily files

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

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-03	SPY	ETF	459.17	460.3	448.92	453.42	137331600.0
2021-12-03	QQQ	ETF	391.31	392.34	378.9	383.13	105349104.0
2021-12-03	IWM	ETF	220.29	220.38	212.71	214.71	64425200.0
2021-12-03	DIA	ETF	347.86	348.5	343.08	346.24	11365300.0
2021-12-03	GLD	ETF	165.49	166.93	165.0	166.63	9507900.0
2021-12-03	TLT	ETF	151.68	155.12	151.35	154.35	34427100.0
2021-12-03	AAA	ETF	25.0	25.0	25.0	25.0	380.0
2021-12-03	AAAU	ETF	17.62	17.76	17.57	17.72	152000.0
2021-12-03	AADR	ETF	62.49	62.49	61.37	61.5	1200.0
2021-12-03	AAXJ	ETF	84.08	84.13	82.67	83.01	1381400.0
2021-12-03	ABEQ	ETF	26.83	27.2	26.83	27.11	1500.0
2021-12-03	ACES	ETF	71.46	71.66	67.0	67.83	75900.0
2021-12-03	ACIO	ETF	31.29	31.48	31.1	31.32	17200.0
2021-12-03	ACSI	ETF	50.26	50.528	50.26	50.528	436.0
2021-12-03	ACT	ETF	21.51	21.6	20.8	21.17	197821.0
2021-12-03	ACTV	ETF	36.7	36.8026	36.4901	36.6939	3730.0
2021-12-03	ACTX	ETF	1.45	1.45	1.45	1.45	577.0
2021-12-03	ACVF	ETF	34.46	34.486	33.66	33.874	8400.0
2021-12-03	ACWF	ETF	37.95	37.96	37.36	37.63	35219.0
2021-12-03	ACWI	ETF	103.54	103.76	101.48	102.33	7075400.0
2021-12-03	ACWV	ETF	104.7	104.94	103.91	104.42	163100.0
2021-12-03	ACWX	ETF	55.23	55.28	54.4	54.71	3048668.0
2021-12-03	ADFI	ETF	9.62	9.648	9.62	9.648	1900.0
2021-12-03	ADIV	ETF	15.67	15.67	15.57	15.655	1200.0
2021-12-03	ADME	ETF	41.62	41.634	41.08	41.23	16400.0
2021-12-03	ADRE	ETF	46.8	46.8	45.33	45.48	17760.0
2021-12-03	AEMB	ETF	48.32	48.32	48.32	48.32	100.0
2021-12-03	AESR	ETF	14.505	14.505	14.14	14.262	7500.0
2021-12-03	AFIF	ETF	9.58	9.6285	9.58	9.62	60278.0
2021-12-03	AFK	ETF	20.29	20.39	20.0901	20.12	9719.0
2021-12-03	AFLG	ETF	27.0	27.0	26.63	26.785	4100.0
2021-12-03	AFMC	ETF	25.39	25.45	25.39	25.45	100.0
2021-12-03	AFTY	ETF	21.06	21.06	20.972	20.972	600.0
2021-12-03	AGG	ETF	114.5	115.24	114.46	115.07	7600800.0
2021-12-03	AGGY	ETF	51.88	52.2	51.88	52.15	48700.0
2021-12-03	AGNG	ETF	27.6	27.6	27.12	27.275	2800.0
2021-12-03	AGOV	ETF	97.965	97.965	97.965	97.965	72.0
2021-12-03	AGOX	ETF	25.04	25.05	24.51	24.74	51300.0
2021-12-03	AGQ	ETF	32.13	32.7	31.16	32.67	800200.0
2021-12-03	AGZ	ETF	117.6	118.0	117.54	117.93	15074.0
2021-12-03	AGZD	ETF	23.35	23.365	23.265	23.3	121800.0
2021-12-03	AHHX	ETF	10.3599	10.395	10.13	10.26	22520.0
2021-12-03	AIA	ETF	77.88	77.9	76.26	76.46	81362.0
2021-12-03	AIEQ	ETF	41.87	41.87	40.515	40.836	15400.0
2021-12-03	AIQ	ETF	31.48	31.48	30.41	30.78	22004.0
2021-12-03	AIRR	ETF	44.98	44.98	43.86	44.34	63500.0
2021-12-03	AIVI	ETF	40.37	40.38	40.03	40.22	5900.0
2021-12-03	ALTL	ETF	44.97	44.97	43.3256	43.77	76195.0
2021-12-03	ALTY	ETF	13.3	13.3	13.04	13.08	12300.0
2021-12-03	AMAX	ETF	9.44	9.56	9.39	9.454	25400.0

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

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