PREVIEW / etf_daily / 2020-10-21

all etf daily files

  file:    by_date/etf_daily/2020/2020-10-21.parquet
  size:    79 KB
  rows:    2,084

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-21	SPY	ETF	343.33	345.67	342.4	342.73	63575000.0
2020-10-21	QQQ	ETF	284.67	287.32	283.69	284.19	29306137.0
2020-10-21	IWM	ETF	160.87	161.37	159.29	159.38	17504100.0
2020-10-21	DIA	ETF	282.54	284.47	281.83	281.97	2907100.0
2020-10-21	GLD	ETF	180.47	181.31	180.23	180.6	7548100.0
2020-10-21	TLT	ETF	158.79	159.37	158.37	158.7	10453700.0
2020-10-21	AAA	ETF	24.95	24.955	24.95	24.95	2717.0
2020-10-21	AAAU	ETF	19.14	19.24	19.13	19.17	342900.0
2020-10-21	AADR	ETF	58.0	58.0	57.13	57.38	2500.0
2020-10-21	AAXJ	ETF	80.36	80.87	80.32	80.47	1392400.0
2020-10-21	ABEQ	ETF	23.71	23.82	23.71	23.745	1200.0
2020-10-21	ACES	ETF	59.99	60.076	57.635	57.64	75000.0
2020-10-21	ACIO	ETF	26.83	27.0	26.83	26.905	26200.0
2020-10-21	ACSI	ETF	38.83	38.8947	38.83	38.8947	303.0
2020-10-21	ACTX	ETF	3.0	3.0	1.99	2.5925	2314.0
2020-10-21	ACWF	ETF	30.7	30.85	30.69	30.69	5296.0
2020-10-21	ACWI	ETF	82.0	82.49	81.82	81.83	1718100.0
2020-10-21	ACWV	ETF	92.67	93.22	92.67	92.82	505400.0
2020-10-21	ACWX	ETF	47.18	47.4	47.04	47.04	675004.0
2020-10-21	ADME	ETF	34.43	34.43	34.201	34.23	20400.0
2020-10-21	ADRE	ETF	50.2	50.63	50.01	50.2642	8252.0
2020-10-21	AESR	ETF	11.18	11.2	11.157	11.157	1400.0
2020-10-21	AFIF	ETF	9.76	9.78	9.75	9.76	8890.0
2020-10-21	AFK	ETF	18.09	18.17	18.09	18.165	2217.0
2020-10-21	AFTY	ETF	20.75	20.87	20.75	20.765	21300.0
2020-10-21	AGG	ETF	117.59	117.64	117.48	117.51	3688300.0
2020-10-21	AGGY	ETF	53.53	53.61	53.53	53.54	71000.0
2020-10-21	AGNG	ETF	25.569	25.635	25.569	25.635	800.0
2020-10-21	AGQ	ETF	48.25	49.05	47.59	48.04	1369700.0
2020-10-21	AGZ	ETF	120.78	120.83	120.7	120.82	89439.0
2020-10-21	AGZD	ETF	23.465	23.5	23.465	23.475	9400.0
2020-10-21	AIA	ETF	75.47	75.8579	75.46	75.49	61335.0
2020-10-21	AIEQ	ETF	32.05	32.05	31.474	31.6	36000.0
2020-10-21	AIQ	ETF	24.57	24.73	24.4	24.4272	18873.0
2020-10-21	AIRR	ETF	28.225	28.3	27.974	27.974	1100.0
2020-10-21	AIVI	ETF	36.36	36.45	36.33	36.36	1500.0
2020-10-21	ALTL	ETF	25.52	25.5349	25.42	25.4339	3420.0
2020-10-21	ALTY	ETF	10.69	10.69	10.62	10.65	5900.0
2020-10-21	AMJ	ETF	11.72	11.75	11.59	11.59	527375.0
2020-10-21	AMLP	ETF	21.73	21.82	21.53	21.56	2085300.0
2020-10-21	AMNA	ETF	22.03	22.04	21.9815	21.9815	1200.0
2020-10-21	AMND	ETF	23.1414	23.1414	23.1414	23.1414	0.0
2020-10-21	AMOM	ETF	37.012	37.012	36.54	36.574	600.0
2020-10-21	AMTR	ETF	24.9	24.9	24.7	24.7187	3400.0
2020-10-21	AMUB	ETF	7.34	7.37	7.29	7.3179	23818.0
2020-10-21	AMZA	ETF	14.63	14.704	14.5	14.51	30800.0
2020-10-21	ANEW	ETF	39.49	39.57	39.12	39.152	6500.0
2020-10-21	ANGL	ETF	30.06	30.11	29.97	30.05	559700.0
2020-10-21	AOA	ETF	59.08	59.35	58.95	58.95	27100.0
2020-10-21	AOK	ETF	37.46	37.55	37.41	37.43	248637.0

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

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