PREVIEW / etf_daily / 2019-11-12

all etf daily files

  file:    by_date/etf_daily/2019/2019-11-12.parquet
  size:    71 KB
  rows:    1,870

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-11-12	SPY	ETF	308.75	309.99	308.15	309.0	46484600.0
2019-11-12	QQQ	ETF	201.13	202.21	200.82	201.54	14778283.0
2019-11-12	IWM	ETF	158.93	159.88	158.49	158.83	14316900.0
2019-11-12	DIA	ETF	277.43	277.99	276.64	277.29	1694000.0
2019-11-12	GLD	ETF	137.03	137.59	136.19	137.43	6448600.0
2019-11-12	TLT	ETF	135.28	135.95	134.79	135.62	5772900.0
2019-11-12	AAAU	ETF	14.51	14.57	14.43	14.56	37300.0
2019-11-12	AADR	ETF	49.77	49.99	49.54	49.69	5300.0
2019-11-12	AAXJ	ETF	70.64	70.73	70.33	70.47	2759000.0
2019-11-12	ACES	ETF	31.71	31.79	31.59	31.632	6800.0
2019-11-12	ACIO	ETF	25.195	25.22	25.16	25.181	10300.0
2019-11-12	ACSI	ETF	34.71	34.775	34.6495	34.6495	1621.0
2019-11-12	ACTX	ETF	9.9829	10.0301	8.8501	8.8501	290.0
2019-11-12	ACWF	ETF	30.3816	30.3816	30.2996	30.3065	5523.0
2019-11-12	ACWI	ETF	76.97	77.19	76.81	76.94	1860600.0
2019-11-12	ACWV	ETF	94.84	94.94	94.68	94.71	152600.0
2019-11-12	ACWX	ETF	48.18	48.25	48.05	48.14	863573.0
2019-11-12	ADME	ETF	30.16	30.171	30.11	30.11	29100.0
2019-11-12	ADRE	ETF	41.33	41.35	41.3087	41.3087	2237.0
2019-11-12	AFIF	ETF	9.81	9.81	9.77	9.785	6446.0
2019-11-12	AFK	ETF	20.9	20.9	20.745	20.745	1822.0
2019-11-12	AFTY	ETF	18.0	18.0	17.52	17.57	10700.0
2019-11-12	AGG	ETF	111.92	112.03	111.8	111.95	2032800.0
2019-11-12	AGGY	ETF	51.85	51.89	51.778	51.84	111100.0
2019-11-12	AGNG	ETF	22.89	22.992	22.89	22.968	13400.0
2019-11-12	AGQ	ETF	28.3	28.41	27.83	28.37	205200.0
2019-11-12	AGZ	ETF	115.47	115.59	115.36	115.55	743310.0
2019-11-12	AGZD	ETF	23.99	24.035	23.95	24.035	8200.0
2019-11-12	AIA	ETF	62.6	62.67	62.3434	62.43	16372.0
2019-11-12	AIEQ	ETF	26.85	27.005	26.85	26.92	23200.0
2019-11-12	AIQ	ETF	16.92	17.0	16.92	16.92	10217.0
2019-11-12	AIRR	ETF	28.83	28.961	28.795	28.84	2700.0
2019-11-12	AIVI	ETF	42.16	42.25	42.12	42.14	5400.0
2019-11-12	ALTY	ETF	14.76	14.76	14.711	14.731	3800.0
2019-11-12	AMJ	ETF	21.15	21.375	20.98	21.02	1814126.0
2019-11-12	AMLP	ETF	41.25	41.75	41.0	41.0	4740040.0
2019-11-12	AMUB	ETF	13.2276	13.2276	13.2276	13.2276	0.0
2019-11-12	AMZA	ETF	43.2	43.7	42.7	42.9	67300.0
2019-11-12	ANGL	ETF	29.23	29.28	29.19	29.2	167400.0
2019-11-12	AOA	ETF	56.49	56.65	56.45	56.46	72100.0
2019-11-12	AOK	ETF	35.81	35.87	35.72	35.81	89605.0
2019-11-12	AOM	ETF	39.56	39.62	39.52	39.52	222200.0
2019-11-12	AOR	ETF	46.85	46.9684	46.85	46.87	75710.0
2019-11-12	ARGT	ETF	21.85	21.86	21.73	21.86	21000.0
2019-11-12	ARKF	ETF	22.98	22.995	22.805	22.88	8800.0
2019-11-12	ARKG	ETF	30.99	31.39	30.772	31.11	79600.0
2019-11-12	ARKK	ETF	46.47	46.9	46.3	46.65	140500.0
2019-11-12	ARKQ	ETF	35.13	35.4	35.075	35.24	5500.0
2019-11-12	ARKW	ETF	53.4	53.83	53.215	53.51	51200.0
2019-11-12	ASEA	ETF	16.15	16.28	16.14	16.27	45800.0

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

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