PREVIEW / etf_daily / 2020-10-26

all etf daily files

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

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-26	SPY	ETF	342.13	342.98	335.62	339.39	91473000.0
2020-10-26	QQQ	ETF	282.32	285.3	276.76	280.47	38421094.0
2020-10-26	IWM	ETF	160.92	161.37	157.38	159.55	26509900.0
2020-10-26	DIA	ETF	280.14	280.39	273.7	277.0	5140600.0
2020-10-26	GLD	ETF	178.75	179.14	178.22	178.55	5105100.0
2020-10-26	TLT	ETF	159.21	160.02	159.01	159.48	7227300.0
2020-10-26	AAA	ETF	24.96	24.96	24.94	24.95	702.0
2020-10-26	AAAU	ETF	18.98	19.0	18.92	18.94	440200.0
2020-10-26	AADR	ETF	56.01	56.01	55.03	55.28	1800.0
2020-10-26	AAXJ	ETF	79.85	80.38	79.25	79.89	725900.0
2020-10-26	ABEQ	ETF	23.633	23.633	23.47	23.525	8100.0
2020-10-26	ACES	ETF	57.27	57.65	55.95	57.04	105600.0
2020-10-26	ACIO	ETF	26.76	26.76	26.56	26.685	28200.0
2020-10-26	ACSI	ETF	38.8121	38.8121	38.8121	38.8121	181.0
2020-10-26	ACTX	ETF	2.19	2.19	2.19	2.19	305.0
2020-10-26	ACWF	ETF	30.4885	30.54	30.09	30.2539	3895.0
2020-10-26	ACWI	ETF	81.51	81.75	80.28	81.05	4996000.0
2020-10-26	ACWV	ETF	92.37	92.63	91.72	92.25	202300.0
2020-10-26	ACWX	ETF	46.82	46.83	46.225	46.53	1191272.0
2020-10-26	ADME	ETF	34.155	34.23	33.745	33.93	24900.0
2020-10-26	ADRE	ETF	50.05	50.2345	49.4543	49.7402	14640.0
2020-10-26	AESR	ETF	11.13	11.13	10.93	11.015	10600.0
2020-10-26	AFIF	ETF	9.7999	9.81	9.77	9.79	17767.0
2020-10-26	AFK	ETF	18.39	18.3999	18.12	18.1947	6981.0
2020-10-26	AFLG	ETF	20.42	20.42	20.419	20.419	100.0
2020-10-26	AFSM	ETF	18.806	18.806	18.806	18.806	100.0
2020-10-26	AFTY	ETF	20.29	20.315	20.21	20.249	5600.0
2020-10-26	AGG	ETF	117.65	117.72	117.59	117.63	4962500.0
2020-10-26	AGGY	ETF	53.56	53.65	53.56	53.62	67100.0
2020-10-26	AGNG	ETF	25.8	25.81	25.555	25.66	4800.0
2020-10-26	AGQ	ETF	45.31	46.0	44.8	45.24	921800.0
2020-10-26	AGZ	ETF	120.83	120.88	120.7993	120.83	48130.0
2020-10-26	AGZD	ETF	23.495	23.555	23.495	23.555	11000.0
2020-10-26	AIA	ETF	75.31	75.63	74.755	75.32	147579.0
2020-10-26	AIEQ	ETF	31.59	31.7	30.95	31.36	14900.0
2020-10-26	AIQ	ETF	24.39	24.455	23.78	24.0263	23202.0
2020-10-26	AIRR	ETF	28.16	28.16	27.69	27.878	3900.0
2020-10-26	AIVI	ETF	36.19	36.19	35.92	36.04	8400.0
2020-10-26	ALTL	ETF	25.1762	25.3099	25.1762	25.3099	2634.0
2020-10-26	ALTY	ETF	10.76	10.78	10.58	10.61	6300.0
2020-10-26	AMJ	ETF	12.09	12.09	11.6	11.65	1125986.0
2020-10-26	AMLP	ETF	22.37	22.44	21.54	21.93	2601600.0
2020-10-26	AMNA	ETF	21.92	21.92	21.7	21.9121	1500.0
2020-10-26	AMND	ETF	23.23	23.2673	23.23	23.2673	1100.0
2020-10-26	AMOM	ETF	36.92	36.92	36.07	36.36	1400.0
2020-10-26	AMTR	ETF	24.85	24.92	24.29	24.68	237302.0
2020-10-26	AMUB	ETF	7.37	7.56	7.33	7.41	29154.0
2020-10-26	AMZA	ETF	15.22	15.37	14.54	14.93	105300.0
2020-10-26	ANEW	ETF	39.0	39.05	38.34	38.62	14500.0
2020-10-26	ANGL	ETF	30.11	30.18	30.01	30.09	687400.0

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

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