PREVIEW / etf_daily / 2020-10-22

all etf daily files

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

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-22	SPY	ETF	342.96	345.24	340.65	344.61	55399300.0
2020-10-22	QQQ	ETF	285.05	285.98	280.82	284.18	32196162.0
2020-10-22	IWM	ETF	160.14	162.19	159.18	162.13	20673900.0
2020-10-22	DIA	ETF	282.1	284.16	280.3	283.65	2324200.0
2020-10-22	GLD	ETF	178.88	179.03	177.72	178.83	8377000.0
2020-10-22	TLT	ETF	158.29	158.63	156.97	157.05	12664900.0
2020-10-22	AAA	ETF	24.94	24.94	24.935	24.935	2063.0
2020-10-22	AAAU	ETF	19.0	19.0	18.88	18.98	536900.0
2020-10-22	AADR	ETF	56.72	56.72	55.87	56.2	6200.0
2020-10-22	AAXJ	ETF	80.51	80.74	80.01	80.32	602200.0
2020-10-22	ABEQ	ETF	23.78	23.807	23.78	23.807	11800.0
2020-10-22	ACES	ETF	58.05	58.18	56.9	58.11	85400.0
2020-10-22	ACIO	ETF	26.8	26.97	26.79	26.83	21200.0
2020-10-22	ACSI	ETF	39.11	39.2145	39.1099	39.2145	644.0
2020-10-22	ACTX	ETF	2.13	2.75	1.5101	2.16	1172.0
2020-10-22	ACWF	ETF	30.5835	30.74	30.5835	30.7215	1534.0
2020-10-22	ACWI	ETF	81.91	82.22	81.35	82.09	3429900.0
2020-10-22	ACWV	ETF	92.62	92.97	92.39	92.85	425900.0
2020-10-22	ACWX	ETF	47.06	47.14	46.78	47.06	8152556.0
2020-10-22	ADME	ETF	34.18	34.22	34.082	34.16	17500.0
2020-10-22	ADRE	ETF	50.5	50.5	50.0049	50.1616	5582.0
2020-10-22	AESR	ETF	11.09	11.179	11.08	11.179	9100.0
2020-10-22	AFIF	ETF	9.75	9.7659	9.75	9.765	24995.0
2020-10-22	AFK	ETF	18.2	18.2	18.03	18.13	2046.0
2020-10-22	AFTY	ETF	20.755	20.78	20.745	20.745	2000.0
2020-10-22	AGG	ETF	117.51	117.54	117.3	117.3	4801000.0
2020-10-22	AGGY	ETF	53.55	53.552	53.43	53.49	103800.0
2020-10-22	AGNG	ETF	25.8	25.9	25.8	25.9	3500.0
2020-10-22	AGQ	ETF	46.92	47.16	45.37	46.65	1304800.0
2020-10-22	AGZ	ETF	120.75	120.75	120.6134	120.68	111064.0
2020-10-22	AGZD	ETF	23.465	23.515	23.465	23.505	9400.0
2020-10-22	AIA	ETF	75.83	75.84	75.39	75.54	109597.0
2020-10-22	AIEQ	ETF	31.65	31.75	31.22	31.73	44300.0
2020-10-22	AIQ	ETF	24.51	24.51	24.1	24.3775	29986.0
2020-10-22	AIRR	ETF	28.0	28.29	28.0	28.243	11400.0
2020-10-22	AIVI	ETF	36.17	36.3	36.09	36.29	4000.0
2020-10-22	ALTL	ETF	25.3934	25.5021	25.3801	25.5021	3162.0
2020-10-22	ALTY	ETF	10.67	10.75	10.665	10.7	14800.0
2020-10-22	AMJ	ETF	11.67	12.25	11.63	12.19	1856191.0
2020-10-22	AMLP	ETF	21.57	22.77	21.57	22.71	4217300.0
2020-10-22	AMNA	ETF	22.65	22.73	22.63	22.7262	1303.0
2020-10-22	AMND	ETF	24.0607	24.0607	24.0607	24.0607	3.0
2020-10-22	AMTR	ETF	25.56	25.56	25.54	25.55	2100.0
2020-10-22	AMUB	ETF	7.3	7.68	7.3	7.67	71428.0
2020-10-22	AMZA	ETF	14.52	15.53	14.52	15.53	72100.0
2020-10-22	ANEW	ETF	39.08	39.27	38.96	39.16	7700.0
2020-10-22	ANGL	ETF	30.05	30.17	29.98	30.13	783300.0
2020-10-22	AOA	ETF	59.0	59.2	58.67	59.15	45400.0
2020-10-22	AOK	ETF	37.44	37.44	37.3	37.35	95056.0
2020-10-22	AOM	ETF	41.32	41.36	41.17	41.26	69910.0

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

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