PREVIEW / etf_daily / 2020-12-01

all etf daily files

  file:    by_date/etf_daily/2020/2020-12-01.parquet
  size:    82 KB
  rows:    2,154

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
2020-12-01	SPY	ETF	365.57	367.68	364.93	366.02	74231400.0
2020-12-01	QQQ	ETF	301.87	305.14	300.83	303.46	27642640.0
2020-12-01	IWM	ETF	183.6	184.22	181.02	182.7	30265000.0
2020-12-01	DIA	ETF	299.73	301.01	298.18	298.44	2841100.0
2020-12-01	GLD	ETF	169.76	170.48	169.3	170.18	13533300.0
2020-12-01	TLT	ETF	158.55	158.74	156.68	157.5	13662800.0
2020-12-01	AAA	ETF	25.039	25.039	25.035	25.035	273.0
2020-12-01	AAAU	ETF	18.02	18.09	17.97	18.06	270400.0
2020-12-01	AADR	ETF	58.61	58.91	58.46	58.91	105800.0
2020-12-01	AAXJ	ETF	86.32	86.54	85.83	86.2	1270100.0
2020-12-01	ABEQ	ETF	25.05	25.51	25.038	25.415	3600.0
2020-12-01	ACES	ETF	70.76	70.91	69.09	69.17	138100.0
2020-12-01	ACIO	ETF	27.5	27.62	27.485	27.545	24800.0
2020-12-01	ACSI	ETF	42.85	42.86	42.6726	42.6726	692.0
2020-12-01	ACTV	ETF	29.04	29.34	29.04	29.1234	8651.0
2020-12-01	ACTX	ETF	2.87	2.9	2.87	2.9	495.0
2020-12-01	ACVF	ETF	27.105	27.15	27.07	27.146	4900.0
2020-12-01	ACWF	ETF	32.63	32.65	32.6272	32.6332	2092.0
2020-12-01	ACWI	ETF	88.4	88.86	88.28	88.57	4099800.0
2020-12-01	ACWV	ETF	95.87	96.23	95.8	96.12	181100.0
2020-12-01	ACWX	ETF	51.49	51.82	51.46	51.74	2837570.0
2020-12-01	ADFI	ETF	9.98	9.98	9.98	9.98	100.0
2020-12-01	ADME	ETF	35.4	35.415	35.266	35.33	16600.0
2020-12-01	ADRE	ETF	54.06	54.6201	54.06	54.3098	54552.0
2020-12-01	AESR	ETF	11.69	11.77	11.69	11.74	46600.0
2020-12-01	AFIF	ETF	9.78	9.79	9.7643	9.765	128589.0
2020-12-01	AFK	ETF	20.1	20.15	19.78	20.1	12952.0
2020-12-01	AFLG	ETF	21.79	21.79	21.783	21.783	200.0
2020-12-01	AFTY	ETF	22.4	22.423	22.272	22.423	3700.0
2020-12-01	AGG	ETF	118.03	118.1	117.73	117.84	5190800.0
2020-12-01	AGGY	ETF	53.78	53.866	53.66	53.72	91600.0
2020-12-01	AGNG	ETF	27.04	27.05	26.953	26.953	1000.0
2020-12-01	AGQ	ETF	41.19	42.8	40.94	42.65	2161200.0
2020-12-01	AGZ	ETF	119.48	119.57	119.4	119.5	31862.0
2020-12-01	AGZD	ETF	23.435	23.63	23.435	23.555	83600.0
2020-12-01	AIA	ETF	82.7	83.18	82.38	82.87	427606.0
2020-12-01	AIEQ	ETF	34.26	34.34	33.971	34.09	30200.0
2020-12-01	AIQ	ETF	26.1	26.26	25.99	26.12	60324.0
2020-12-01	AIRR	ETF	31.78	31.97	31.628	31.669	12700.0
2020-12-01	AIVI	ETF	39.38	39.53	39.38	39.49	4100.0
2020-12-01	ALTL	ETF	30.696	30.77	30.3901	30.3901	2281.0
2020-12-01	ALTY	ETF	11.64	11.7	11.605	11.644	18500.0
2020-12-01	AMJ	ETF	13.71	13.95	13.565	13.64	1638187.0
2020-12-01	AMLP	ETF	25.48	25.81	25.12	25.25	2865900.0
2020-12-01	AMNA	ETF	25.2281	25.2281	25.2281	25.2281	18.0
2020-12-01	AMND	ETF	26.8326	26.8326	26.8326	26.8326	6.0
2020-12-01	AMOM	ETF	38.85	38.85	38.504	38.639	2300.0
2020-12-01	AMTR	ETF	28.83	28.83	28.3502	28.45	19051.0
2020-12-01	AMUB	ETF	8.57	8.74	8.53	8.57	31593.0
2020-12-01	AMZA	ETF	18.57	18.97	18.25	18.46	89700.0

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

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