PREVIEW / etf_daily / 2020-10-19

all etf daily files

  file:    by_date/etf_daily/2020/2020-10-19.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-19	SPY	ETF	348.65	349.33	341.04	342.01	68425600.0
2020-10-19	QQQ	ETF	290.49	291.48	282.79	283.8	36756754.0
2020-10-19	IWM	ETF	162.88	164.03	160.03	160.41	18360600.0
2020-10-19	DIA	ETF	286.64	287.06	281.28	282.03	2837600.0
2020-10-19	GLD	ETF	179.41	179.48	178.37	178.39	6084400.0
2020-10-19	TLT	ETF	160.5	160.98	160.05	160.78	9286600.0
2020-10-19	AAA	ETF	24.9	24.91	24.9	24.905	6907.0
2020-10-19	AAAU	ETF	19.03	19.05	18.93	18.93	397200.0
2020-10-19	AADR	ETF	57.29	57.39	56.98	56.98	1300.0
2020-10-19	AAXJ	ETF	79.89	80.27	79.34	79.49	636400.0
2020-10-19	ABEQ	ETF	23.83	23.85	23.569	23.585	5400.0
2020-10-19	ACES	ETF	60.69	61.05	59.654	59.749	242800.0
2020-10-19	ACIO	ETF	27.15	27.15	26.855	26.91	27400.0
2020-10-19	ACSI	ETF	38.951	38.951	38.951	38.951	109.0
2020-10-19	ACTX	ETF	2.0	2.1	1.3	1.3	2946.0
2020-10-19	ACWF	ETF	31.0258	31.0291	30.5746	30.5746	5264.0
2020-10-19	ACWI	ETF	82.83	82.98	81.47	81.64	1936400.0
2020-10-19	ACWV	ETF	93.85	93.85	92.48	92.56	182500.0
2020-10-19	ACWX	ETF	47.33	47.36	46.815	46.88	1705045.0
2020-10-19	ADME	ETF	34.82	34.82	34.13	34.15	35600.0
2020-10-19	ADRE	ETF	50.2956	50.2956	49.3	49.4225	4665.0
2020-10-19	AESR	ETF	11.34	11.35	11.09	11.102	5100.0
2020-10-19	AFIF	ETF	9.8	9.8	9.77	9.7847	25629.0
2020-10-19	AFK	ETF	18.01	18.1916	18.01	18.01	12345.0
2020-10-19	AFTY	ETF	20.48	20.52	20.455	20.455	3400.0
2020-10-19	AGG	ETF	117.81	117.87	117.72	117.75	4685000.0
2020-10-19	AGGY	ETF	53.74	53.77	53.685	53.77	68800.0
2020-10-19	AGNG	ETF	26.22	26.22	25.699	25.699	1400.0
2020-10-19	AGQ	ETF	47.02	47.17	44.88	45.13	1208600.0
2020-10-19	AGZ	ETF	120.9	120.94	120.82	120.94	46192.0
2020-10-19	AGZD	ETF	23.49	23.5	23.435	23.5	7000.0
2020-10-19	AIA	ETF	74.94	75.1799	74.49	74.5777	79674.0
2020-10-19	AIEQ	ETF	32.44	32.7	31.918	31.918	8100.0
2020-10-19	AIQ	ETF	24.8	24.87	24.375	24.47	34476.0
2020-10-19	AIRR	ETF	28.31	28.4	27.917	27.917	3700.0
2020-10-19	AIVI	ETF	36.51	36.53	36.19	36.19	7800.0
2020-10-19	ALTL	ETF	25.675	25.71	25.404	25.404	1122.0
2020-10-19	ALTY	ETF	10.76	10.76	10.6	10.61	10200.0
2020-10-19	AMJ	ETF	11.79	11.89	11.55	11.55	661868.0
2020-10-19	AMLP	ETF	21.84	22.04	21.41	21.44	1931700.0
2020-10-19	AMNA	ETF	21.9635	21.9635	21.9635	21.9635	0.0
2020-10-19	AMND	ETF	23.1103	23.1103	23.1103	23.1103	0.0
2020-10-19	AMOM	ETF	36.98	36.98	36.418	36.418	500.0
2020-10-19	AMUB	ETF	7.2779	7.2779	7.2779	7.2779	30.0
2020-10-19	AMZA	ETF	15.02	15.2	14.61	14.65	164000.0
2020-10-19	ANEW	ETF	40.16	40.239	39.35	39.4	25200.0
2020-10-19	ANGL	ETF	30.02	30.08	29.86	29.94	960700.0
2020-10-19	AOA	ETF	59.45	59.61	58.76	58.82	31600.0
2020-10-19	AOK	ETF	37.63	37.63	37.4	37.43	75303.0
2020-10-19	AOM	ETF	41.6	41.6	41.2584	41.33	130032.0

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

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