PREVIEW / etf_daily / 2019-12-03

all etf daily files

  file:    by_date/etf_daily/2019/2019-12-03.parquet
  size:    73 KB
  rows:    1,898

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
2019-12-03	SPY	ETF	308.65	309.64	307.13	309.55	73941700.0
2019-12-03	QQQ	ETF	200.32	201.49	193.785	201.41	31425404.0
2019-12-03	IWM	ETF	158.82	159.76	158.1	159.68	14884400.0
2019-12-03	DIA	ETF	275.43	275.64	273.62	275.51	3834300.0
2019-12-03	GLD	ETF	139.04	139.57	138.97	139.11	8481700.0
2019-12-03	TLT	ETF	140.04	141.77	139.93	141.21	13062400.0
2019-12-03	AAAU	ETF	14.72	14.78	14.72	14.74	57900.0
2019-12-03	AADR	ETF	50.34	50.6	50.27	50.6	12100.0
2019-12-03	AAXJ	ETF	68.72	69.03	68.46	69.0	907000.0
2019-12-03	ACES	ETF	31.96	32.162	31.91	32.162	19200.0
2019-12-03	ACIO	ETF	25.11	25.11	25.05	25.092	14500.0
2019-12-03	ACSI	ETF	34.69	34.6989	34.6476	34.6989	17295.0
2019-12-03	ACTX	ETF	5.9001	7.0801	5.9001	5.9001	364.0
2019-12-03	ACWF	ETF	30.06	30.1847	30.05	30.1845	5140.0
2019-12-03	ACWI	ETF	76.35	76.65	76.02	76.65	3252100.0
2019-12-03	ACWV	ETF	94.79	95.13	94.51	95.08	260400.0
2019-12-03	ACWX	ETF	47.32	47.53	47.165	47.51	2234133.0
2019-12-03	ADME	ETF	29.89	29.925	29.878	29.91	11900.0
2019-12-03	ADRE	ETF	40.85	41.19	40.85	41.145	55270.0
2019-12-03	AFIF	ETF	9.8097	9.8326	9.79	9.81	9371.0
2019-12-03	AFK	ETF	20.57	21.57	20.52	20.6	5518.0
2019-12-03	AFTY	ETF	16.9	16.99	16.85	16.97	2000.0
2019-12-03	AGG	ETF	112.8	113.13	112.76	113.0	5283800.0
2019-12-03	AGGY	ETF	52.3	52.41	52.25	52.39	191300.0
2019-12-03	AGNG	ETF	23.24	23.7	23.24	23.565	4800.0
2019-12-03	AGQ	ETF	29.39	29.55	29.28	29.46	326100.0
2019-12-03	AGZ	ETF	116.22	116.49	116.1901	116.41	32585.0
2019-12-03	AGZD	ETF	24.0	24.015	23.9	23.96	32600.0
2019-12-03	AIA	ETF	60.71	61.04	60.5001	61.04	51199.0
2019-12-03	AIEQ	ETF	27.27	27.37	27.149	27.33	24600.0
2019-12-03	AIQ	ETF	16.9	16.975	16.773	16.975	10303.0
2019-12-03	AIRR	ETF	28.29	28.29	28.066	28.22	3000.0
2019-12-03	AIVI	ETF	41.17	41.43	41.17	41.43	4500.0
2019-12-03	ALTY	ETF	14.59	14.65	14.56	14.634	4700.0
2019-12-03	AMJ	ETF	19.81	19.94	19.6501	19.81	3215467.0
2019-12-03	AMLP	ETF	38.6	38.8	38.25	38.4	7351560.0
2019-12-03	AMUB	ETF	12.457	12.457	12.457	12.457	6.0
2019-12-03	AMZA	ETF	40.0	40.2	39.6	39.8	103460.0
2019-12-03	ANGL	ETF	29.17	29.2	29.1	29.19	835700.0
2019-12-03	AOA	ETF	56.32	56.47	56.03	56.47	43900.0
2019-12-03	AOK	ETF	35.89	35.95	35.7912	35.89	139737.0
2019-12-03	AOM	ETF	39.63	39.74	39.515	39.74	154366.0
2019-12-03	AOR	ETF	46.8	46.87	46.69	46.87	131889.0
2019-12-03	ARGT	ETF	23.01	23.06	22.75	22.9	77000.0
2019-12-03	ARKF	ETF	23.19	23.545	23.09	23.51	20400.0
2019-12-03	ARKG	ETF	33.66	34.39	33.452	34.28	273600.0
2019-12-03	ARKK	ETF	48.32	49.09	48.13	49.09	187400.0
2019-12-03	ARKQ	ETF	34.0	34.2	33.861	34.2	8400.0
2019-12-03	ARKW	ETF	53.64	54.554	53.31	54.53	113400.0
2019-12-03	ASEA	ETF	15.56	15.58	15.56	15.58	500.0

> showing 50 of 1,898 rows — these rows as CSV

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