PREVIEW / etf_daily / 2020-11-24

all etf daily files

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

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-24	SPY	ETF	360.21	363.81	359.29	363.22	62415900.0
2020-11-24	QQQ	ETF	291.49	294.98	289.63	294.47	24516791.0
2020-11-24	IWM	ETF	183.39	185.44	182.36	184.22	34945400.0
2020-11-24	DIA	ETF	298.94	301.11	298.3	300.43	4022700.0
2020-11-24	GLD	ETF	169.3	169.69	168.86	169.59	19504000.0
2020-11-24	TLT	ETF	159.99	160.02	159.01	159.17	10891700.0
2020-11-24	AAA	ETF	25.049	25.049	25.04	25.04	816.0
2020-11-24	AAAU	ETF	17.98	18.01	17.93	17.99	763800.0
2020-11-24	AADR	ETF	56.65	56.72	56.46	56.7	4500.0
2020-11-24	AAXJ	ETF	86.68	87.02	86.17	86.99	2530400.0
2020-11-24	ABEQ	ETF	24.79	24.913	24.79	24.903	4800.0
2020-11-24	ACES	ETF	69.97	70.6	68.17	69.77	143700.0
2020-11-24	ACIO	ETF	27.32	27.35	27.191	27.34	43000.0
2020-11-24	ACSI	ETF	42.0909	42.0909	42.0909	42.0909	112.0
2020-11-24	ACTV	ETF	29.565	29.9	29.565	29.6589	4940.0
2020-11-24	ACTX	ETF	2.75	2.8001	2.5	2.5	1566.0
2020-11-24	ACVF	ETF	26.63	26.92	26.63	26.888	1100.0
2020-11-24	ACWF	ETF	32.3763	32.395	32.3645	32.3874	2789.0
2020-11-24	ACWI	ETF	87.47	88.08	87.17	87.96	3358800.0
2020-11-24	ACWV	ETF	95.58	96.06	95.56	95.82	176700.0
2020-11-24	ACWX	ETF	51.24	51.605	51.165	51.55	1139187.0
2020-11-24	ADME	ETF	34.89	34.89	34.72	34.88	38700.0
2020-11-24	ADRE	ETF	54.51	54.7256	54.3	54.7256	11691.0
2020-11-24	AESR	ETF	11.53	11.56	11.52	11.555	9600.0
2020-11-24	AFIF	ETF	9.82	9.86	9.7716	9.775	192539.0
2020-11-24	AFK	ETF	19.83	19.9407	19.7	19.94	14088.0
2020-11-24	AFLG	ETF	21.57	21.585	21.55	21.585	5800.0
2020-11-24	AFTY	ETF	21.64	21.73	21.56	21.73	3500.0
2020-11-24	AGG	ETF	118.24	118.28	118.07	118.1	4696800.0
2020-11-24	AGGY	ETF	53.76	53.84	53.747	53.78	76700.0
2020-11-24	AGNG	ETF	26.52	26.6	26.478	26.495	2800.0
2020-11-24	AGQ	ETF	39.88	40.51	39.55	40.22	1210800.0
2020-11-24	AGZ	ETF	120.84	120.86	120.72	120.82	1095280.0
2020-11-24	AGZD	ETF	23.545	23.58	23.5	23.515	13400.0
2020-11-24	AIA	ETF	82.88	83.2	82.4723	83.2	109071.0
2020-11-24	AIEQ	ETF	33.0	33.09	32.698	33.09	17600.0
2020-11-24	AIQ	ETF	25.58	25.66	25.3805	25.6438	16289.0
2020-11-24	AIRR	ETF	31.96	32.85	31.96	32.637	52700.0
2020-11-24	AIVI	ETF	39.47	39.69	39.42	39.69	24800.0
2020-11-24	ALTL	ETF	31.06	31.48	30.94	31.48	7932.0
2020-11-24	ALTY	ETF	11.75	11.784	11.63	11.74	8700.0
2020-11-24	AMJ	ETF	14.61	15.13	14.61	14.84	2134675.0
2020-11-24	AMLP	ETF	26.53	27.44	26.51	26.84	4913000.0
2020-11-24	AMNA	ETF	26.3392	26.3392	26.3392	26.3392	0.0
2020-11-24	AMND	ETF	28.1442	28.1442	28.1442	28.1442	2.0
2020-11-24	AMOM	ETF	37.34	37.34	37.174	37.174	1200.0
2020-11-24	AMTR	ETF	29.74	29.93	29.66	29.7115	62534.0
2020-11-24	AMUB	ETF	9.23	9.47	9.23	9.33	13287.0
2020-11-24	AMZA	ETF	19.52	20.344	19.5	19.84	151500.0
2020-11-24	ANEW	ETF	39.39	39.497	39.21	39.45	5100.0

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

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