PREVIEW / etf_daily / 2020-10-27

all etf daily files

  file:    by_date/etf_daily/2020/2020-10-27.parquet
  size:    80 KB
  rows:    2,122

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-10-27	SPY	ETF	339.76	340.12	337.99	338.22	65994100.0
2020-10-27	QQQ	ETF	281.42	283.505	280.2	282.66	30559123.0
2020-10-27	IWM	ETF	159.45	160.06	157.94	158.18	20523000.0
2020-10-27	DIA	ETF	276.95	277.07	274.6	274.66	3029800.0
2020-10-27	GLD	ETF	178.71	179.43	178.51	179.02	5826900.0
2020-10-27	TLT	ETF	160.23	160.7	159.9	160.55	6062300.0
2020-10-27	AAA	ETF	24.96	24.96	24.955	24.955	129.0
2020-10-27	AAAU	ETF	18.97	19.04	18.95	19.01	417300.0
2020-10-27	AADR	ETF	55.43	55.43	55.33	55.33	2000.0
2020-10-27	AAXJ	ETF	80.11	80.55	79.88	80.45	761000.0
2020-10-27	ABEQ	ETF	23.48	23.509	23.38	23.389	2300.0
2020-10-27	ACES	ETF	57.0	57.41	56.53	56.639	61300.0
2020-10-27	ACIO	ETF	26.69	26.75	26.65	26.7	42800.0
2020-10-27	ACSI	ETF	38.9249	38.9249	38.9249	38.9249	106.0
2020-10-27	ACTV	ETF	24.97	24.97	24.7332	24.7332	200.0
2020-10-27	ACTX	ETF	2.22	2.22	2.16	2.16	398.0
2020-10-27	ACWF	ETF	30.23	30.23	30.0879	30.0879	629.0
2020-10-27	ACWI	ETF	81.08	81.15	80.69	80.78	3414200.0
2020-10-27	ACWV	ETF	92.25	92.47	91.93	91.97	137100.0
2020-10-27	ACWX	ETF	46.54	46.55	46.32	46.38	1265379.0
2020-10-27	ADME	ETF	33.89	33.98	33.89	33.932	28800.0
2020-10-27	ADRE	ETF	49.7401	50.245	49.7401	50.16	5175.0
2020-10-27	AESR	ETF	11.04	11.09	11.02	11.044	248500.0
2020-10-27	AFIF	ETF	9.795	9.8091	9.78	9.795	1494149.0
2020-10-27	AFK	ETF	18.01	18.2999	18.01	18.12	4345.0
2020-10-27	AFLG	ETF	20.56	20.56	20.368	20.368	4100.0
2020-10-27	AFSM	ETF	18.687	18.687	18.687	18.687	200.0
2020-10-27	AFTY	ETF	20.14	20.277	20.14	20.259	1800.0
2020-10-27	AGG	ETF	117.8	117.91	117.73	117.9	5694100.0
2020-10-27	AGGY	ETF	53.63	53.7	53.58	53.7	112600.0
2020-10-27	AGNG	ETF	25.694	25.694	25.565	25.565	9400.0
2020-10-27	AGQ	ETF	45.07	45.86	44.7	45.63	940100.0
2020-10-27	AGZ	ETF	120.94	120.96	120.83	120.94	65889.0
2020-10-27	AGZD	ETF	23.49	23.53	23.435	23.445	23000.0
2020-10-27	AIA	ETF	75.58	75.91	75.3621	75.9	86779.0
2020-10-27	AIEQ	ETF	31.28	31.52	31.25	31.33	15600.0
2020-10-27	AIQ	ETF	24.17	24.22	24.065	24.2	37473.0
2020-10-27	AIRR	ETF	27.87	27.87	27.125	27.125	1100.0
2020-10-27	AIVI	ETF	35.84	35.84	35.59	35.59	2700.0
2020-10-27	ALTL	ETF	25.34	25.3507	25.1856	25.1856	4926.0
2020-10-27	ALTY	ETF	10.67	10.67	10.57	10.59	11400.0
2020-10-27	AMJ	ETF	11.75	11.82	11.54	11.58	586177.0
2020-10-27	AMLP	ETF	21.87	21.97	21.41	21.51	4193100.0
2020-10-27	AMNA	ETF	21.75	21.88	21.71	21.7418	1600.0
2020-10-27	AMND	ETF	22.96	23.11	22.0	22.9992	1806.0
2020-10-27	AMOM	ETF	36.6	36.61	36.39	36.522	900.0
2020-10-27	AMTR	ETF	24.43	24.54	24.43	24.4572	1000.0
2020-10-27	AMUB	ETF	7.39	7.39	7.27	7.3083	15468.0
2020-10-27	AMZA	ETF	14.78	14.92	14.46	14.55	101600.0
2020-10-27	ANEW	ETF	38.96	38.96	38.77	38.87	4800.0

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

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