PREVIEW / etf_daily / 2020-10-06

all etf daily files

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

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-06	SPY	ETF	339.91	342.17	334.38	334.93	90128900.0
2020-10-06	QQQ	ETF	279.29	281.19	274.25	275.16	49704236.0
2020-10-06	IWM	ETF	158.5	161.01	156.34	156.62	36348000.0
2020-10-06	DIA	ETF	282.54	283.52	277.24	277.72	4364400.0
2020-10-06	GLD	ETF	180.16	180.37	177.05	177.3	8632800.0
2020-10-06	TLT	ETF	159.33	161.41	158.68	160.43	22419400.0
2020-10-06	AAA	ETF	24.89	24.91	24.89	24.9095	4037.0
2020-10-06	AAAU	ETF	19.13	19.14	18.78	18.81	896300.0
2020-10-06	AADR	ETF	56.1	56.1	55.56	55.71	900.0
2020-10-06	AAXJ	ETF	78.23	78.81	78.07	78.18	1587000.0
2020-10-06	ABEQ	ETF	23.57	23.65	23.46	23.46	14300.0
2020-10-06	ACES	ETF	58.71	59.93	58.01	58.76	62700.0
2020-10-06	ACIO	ETF	26.83	26.87	26.488	26.54	56100.0
2020-10-06	ACSI	ETF	37.731	37.731	37.731	37.731	106.0
2020-10-06	ACTX	ETF	0.9558	2.006	0.9558	1.77	1039.0
2020-10-06	ACWF	ETF	30.32	30.379	29.9824	29.9824	1498.0
2020-10-06	ACWI	ETF	81.33	81.68	80.17	80.36	3956000.0
2020-10-06	ACWV	ETF	93.15	93.43	92.25	92.41	214100.0
2020-10-06	ACWX	ETF	46.9	46.99	46.37	46.46	1587280.0
2020-10-06	ADME	ETF	34.17	34.17	33.58	33.58	36800.0
2020-10-06	ADRE	ETF	47.63	47.9311	47.364	47.364	3344.0
2020-10-06	AESR	ETF	10.95	11.06	10.89	10.9	43800.0
2020-10-06	AFIF	ETF	9.8087	9.83	9.79	9.8198	89893.0
2020-10-06	AFK	ETF	17.59	17.83	17.5585	17.62	12471.0
2020-10-06	AFLG	ETF	20.57	20.57	20.259	20.259	2800.0
2020-10-06	AFMC	ETF	18.43	18.43	18.43	18.43	100.0
2020-10-06	AFTY	ETF	19.7	19.72	19.623	19.667	2100.0
2020-10-06	AGG	ETF	117.6	117.84	117.49	117.62	4338600.0
2020-10-06	AGGY	ETF	53.61	53.73	53.55	53.71	211200.0
2020-10-06	AGNG	ETF	26.09	26.1	25.839	25.875	2800.0
2020-10-06	AGQ	ETF	45.68	46.06	41.56	42.0	2313800.0
2020-10-06	AGZ	ETF	120.81	120.9	120.72	120.86	17390.0
2020-10-06	AGZD	ETF	23.445	23.505	23.425	23.475	16000.0
2020-10-06	AIA	ETF	72.88	73.16	72.55	72.62	142408.0
2020-10-06	AIEQ	ETF	31.43	31.68	31.077	31.091	9000.0
2020-10-06	AIQ	ETF	23.88	24.11	23.7	23.73	22412.0
2020-10-06	AIRR	ETF	27.09	27.68	26.94	26.94	40100.0
2020-10-06	AIVI	ETF	36.66	36.67	36.2	36.23	7600.0
2020-10-06	ALTL	ETF	25.2835	25.3	25.05	25.0727	3524.0
2020-10-06	ALTY	ETF	10.7	10.77	10.665	10.665	17000.0
2020-10-06	AMJ	ETF	11.34	11.55	10.925	11.01	1378025.0
2020-10-06	AMLP	ETF	21.05	21.4	20.23	20.48	3385600.0
2020-10-06	AMNA	ETF	21.8353	21.8353	21.8353	21.8353	0.0
2020-10-06	AMND	ETF	23.35	23.35	22.9485	22.9485	428.0
2020-10-06	AMOM	ETF	35.99	35.99	35.646	35.646	200.0
2020-10-06	AMUB	ETF	7.1	7.1	6.9	6.9512	38104.0
2020-10-06	AMZA	ETF	14.45	14.57	13.63	13.86	80500.0
2020-10-06	ANGL	ETF	29.91	30.04	29.83	29.9	3329300.0
2020-10-06	AOA	ETF	58.68	58.89	58.06	58.14	35900.0
2020-10-06	AOK	ETF	37.33	37.41	37.17	37.2	93781.0

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

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