PREVIEW / etf_daily / 2019-11-13

all etf daily files

  file:    by_date/etf_daily/2019/2019-11-13.parquet
  size:    72 KB
  rows:    1,882

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-13	SPY	ETF	307.91	309.54	307.66	309.1	53917700.0
2019-11-13	QQQ	ETF	200.84	201.775	200.71	201.59	16110341.0
2019-11-13	IWM	ETF	157.74	158.5	157.19	158.15	14514400.0
2019-11-13	DIA	ETF	276.34	278.4	276.17	278.05	2595600.0
2019-11-13	GLD	ETF	137.8	138.22	137.64	137.98	8776000.0
2019-11-13	TLT	ETF	136.81	136.96	136.17	136.5	6672400.0
2019-11-13	AAAU	ETF	14.6	14.63	14.59	14.61	13600.0
2019-11-13	AADR	ETF	49.59	49.97	49.59	49.95	3500.0
2019-11-13	AAXJ	ETF	69.67	69.92	69.59	69.8	652500.0
2019-11-13	ACES	ETF	31.585	31.585	31.44	31.517	8500.0
2019-11-13	ACIO	ETF	25.185	25.2	25.16	25.176	63900.0
2019-11-13	ACSI	ETF	34.53	34.67	34.53	34.6175	20395.0
2019-11-13	ACTX	ETF	8.8796	10.6791	8.8501	9.7646	339.0
2019-11-13	ACWF	ETF	30.27	30.285	30.163	30.2221	5063.0
2019-11-13	ACWI	ETF	76.57	76.94	76.46	76.87	936400.0
2019-11-13	ACWV	ETF	94.43	94.98	94.43	94.91	435900.0
2019-11-13	ACWX	ETF	47.79	47.98	47.75	47.92	1641627.0
2019-11-13	ADME	ETF	29.96	30.18	29.96	30.14	116200.0
2019-11-13	ADRE	ETF	40.87	40.87	40.7818	40.8	5443.0
2019-11-13	AFIF	ETF	9.82	9.82	9.8	9.8	5085.0
2019-11-13	AFK	ETF	20.75	20.81	20.5021	20.54	2860.0
2019-11-13	AFTY	ETF	17.5	17.553	17.49	17.512	1500.0
2019-11-13	AGG	ETF	112.2	112.23	112.08	112.15	2570200.0
2019-11-13	AGGY	ETF	51.97	51.97	51.89	51.95	109800.0
2019-11-13	AGNG	ETF	22.88	23.16	22.88	23.0	5900.0
2019-11-13	AGQ	ETF	28.68	29.01	28.51	28.81	190000.0
2019-11-13	AGZ	ETF	115.73	115.73	115.64	115.69	19656.0
2019-11-13	AGZD	ETF	23.96	24.005	23.955	24.005	3600.0
2019-11-13	AIA	ETF	61.58	61.93	61.41	61.83	18745.0
2019-11-13	AIEQ	ETF	26.85	27.05	26.85	27.05	22200.0
2019-11-13	AIQ	ETF	16.91	16.9499	16.85	16.8967	15428.0
2019-11-13	AIRR	ETF	28.71	28.71	28.602	28.65	3400.0
2019-11-13	AIVI	ETF	41.95	42.04	41.95	42.01	7100.0
2019-11-13	ALTY	ETF	14.71	14.73	14.67	14.68	124100.0
2019-11-13	AMJ	ETF	20.92	21.1	20.79	21.04	1862687.0
2019-11-13	AMLP	ETF	40.9	41.3	40.65	40.7	3721220.0
2019-11-13	AMUB	ETF	13.1557	13.1557	13.1557	13.1557	0.0
2019-11-13	AMZA	ETF	42.8	42.9	42.1	42.4	94870.0
2019-11-13	ANGL	ETF	29.18	29.19	29.16	29.19	220200.0
2019-11-13	AOA	ETF	56.43	56.51	56.3	56.49	28000.0
2019-11-13	AOK	ETF	35.76	35.82	35.7599	35.78	62212.0
2019-11-13	AOM	ETF	39.54	39.6074	39.52	39.59	88810.0
2019-11-13	AOR	ETF	46.77	46.9036	46.736	46.88	76296.0
2019-11-13	ARGT	ETF	21.71	21.86	21.71	21.8	16600.0
2019-11-13	ARKF	ETF	22.85	23.107	22.85	23.107	92900.0
2019-11-13	ARKG	ETF	30.96	31.455	30.85	31.38	91500.0
2019-11-13	ARKK	ETF	46.45	46.64	46.161	46.37	159300.0
2019-11-13	ARKQ	ETF	35.11	35.11	34.4	34.47	22000.0
2019-11-13	ARKW	ETF	53.4	53.54	53.15	53.42	50200.0
2019-11-13	ASEA	ETF	16.07	16.08	16.0	16.08	900.0

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

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