PREVIEW / etf_daily / 2020-11-05

all etf daily files

  file:    by_date/etf_daily/2020/2020-11-05.parquet
  size:    81 KB
  rows:    2,134

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-11-05	SPY	ETF	349.24	352.19	348.86	350.24	82039700.0
2020-11-05	QQQ	ETF	293.41	295.39	292.0	294.39	52054186.0
2020-11-05	IWM	ETF	162.01	165.58	161.91	164.91	31911000.0
2020-11-05	DIA	ETF	282.29	284.96	282.07	283.91	4316200.0
2020-11-05	GLD	ETF	181.0	183.29	180.97	182.93	16102800.0
2020-11-05	TLT	ETF	161.64	161.74	160.58	161.36	18537500.0
2020-11-05	AAA	ETF	24.87	24.87	24.87	24.87	1068.0
2020-11-05	AAAU	ETF	19.22	19.45	19.21	19.43	1126200.0
2020-11-05	AADR	ETF	58.49	59.33	58.49	59.33	8300.0
2020-11-05	AAXJ	ETF	83.9	84.0	83.03	83.69	2815900.0
2020-11-05	ABEQ	ETF	23.914	23.925	23.892	23.892	1300.0
2020-11-05	ACES	ETF	58.87	60.95	58.61	60.86	154800.0
2020-11-05	ACIO	ETF	27.64	27.64	27.22	27.27	43500.0
2020-11-05	ACSI	ETF	40.3715	40.3715	40.3715	40.3715	209.0
2020-11-05	ACTV	ETF	25.82	27.09	25.6427	26.065	11953.0
2020-11-05	ACTX	ETF	2.48	2.48	2.48	2.48	286.0
2020-11-05	ACVF	ETF	26.1	26.1	25.96	25.997	300.0
2020-11-05	ACWF	ETF	31.32	31.3926	31.09	31.2773	7921.0
2020-11-05	ACWI	ETF	83.65	84.11	83.41	83.82	3062400.0
2020-11-05	ACWV	ETF	94.04	94.56	93.78	94.01	228100.0
2020-11-05	ACWX	ETF	48.2	48.35	47.97	48.27	1513042.0
2020-11-05	ADME	ETF	35.33	35.33	34.94	35.0	31700.0
2020-11-05	ADRE	ETF	51.38	51.8	50.9293	51.61	51299.0
2020-11-05	AESR	ETF	11.35	11.43	11.35	11.377	29700.0
2020-11-05	AFIF	ETF	9.83	9.85	9.81	9.83	166028.0
2020-11-05	AFK	ETF	18.667	19.13	18.667	18.9835	10894.0
2020-11-05	AFLG	ETF	21.09	21.09	21.08	21.081	400.0
2020-11-05	AFTY	ETF	21.71	21.71	21.46	21.548	1500.0
2020-11-05	AGG	ETF	118.09	118.12	117.91	118.06	5293900.0
2020-11-05	AGGY	ETF	53.89	53.89	53.78	53.81	154600.0
2020-11-05	AGNG	ETF	26.451	26.451	26.361	26.43	2900.0
2020-11-05	AGQ	ETF	46.54	49.0	46.49	48.85	2138900.0
2020-11-05	AGZ	ETF	120.93	120.97	120.86	120.89	36312.0
2020-11-05	AGZD	ETF	23.455	23.465	23.43	23.44	10400.0
2020-11-05	AIA	ETF	80.23	80.4792	79.74	80.22	696292.0
2020-11-05	AIEQ	ETF	32.14	32.48	32.034	32.46	31600.0
2020-11-05	AIQ	ETF	25.26	25.385	25.158	25.33	48095.0
2020-11-05	AIRR	ETF	27.43	28.42	27.43	28.196	18000.0
2020-11-05	AIVI	ETF	36.55	36.55	36.34	36.49	2800.0
2020-11-05	ALTL	ETF	25.35	25.53	25.35	25.4447	4191.0
2020-11-05	ALTY	ETF	10.68	10.79	10.68	10.755	9600.0
2020-11-05	AMJ	ETF	11.69	11.865	11.61	11.79	727856.0
2020-11-05	AMLP	ETF	21.36	21.99	21.33	21.87	2437000.0
2020-11-05	AMNA	ETF	21.72	21.9	21.72	21.783	2105.0
2020-11-05	AMND	ETF	23.1	23.1257	23.1	23.1257	106.0
2020-11-05	AMOM	ETF	37.47	37.74	37.389	37.725	3700.0
2020-11-05	AMTR	ETF	24.57	24.87	24.45	24.48	134900.0
2020-11-05	AMUB	ETF	7.44	7.46	7.42	7.425	4322.0
2020-11-05	AMZA	ETF	14.3	14.69	14.201	14.64	121200.0
2020-11-05	ANEW	ETF	39.94	40.01	39.7	39.979	37300.0

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

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