PREVIEW / etf_daily / 2019-12-20

all etf daily files

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

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-20	SPY	ETF	320.46	321.97	319.39	320.73	147142100.0
2019-12-20	QQQ	ETF	211.81	212.5186	211.27	211.71	27690934.0
2019-12-20	IWM	ETF	166.15	166.41	165.72	165.97	25449500.0
2019-12-20	DIA	ETF	284.76	285.06	284.32	284.46	3637000.0
2019-12-20	GLD	ETF	139.37	139.52	138.98	139.52	4463900.0
2019-12-20	TLT	ETF	136.13	136.69	135.93	136.65	5455700.0
2019-12-20	AAAU	ETF	14.77	14.77	14.74	14.74	25500.0
2019-12-20	AADR	ETF	53.4	53.6	53.39	53.59	6900.0
2019-12-20	AAXJ	ETF	72.98	73.13	72.89	73.0	575500.0
2019-12-20	ACES	ETF	33.66	33.67	33.594	33.641	8800.0
2019-12-20	ACIO	ETF	25.767	25.82	25.73	25.784	10200.0
2019-12-20	ACSI	ETF	35.936	35.99	35.9301	35.9838	1251.0
2019-12-20	ACTX	ETF	12.1482	12.9801	11.806	12.4562	1685.0
2019-12-20	ACWF	ETF	31.07	31.0961	31.0631	31.075	4979.0
2019-12-20	ACWI	ETF	79.01	79.08	78.87	78.87	2071800.0
2019-12-20	ACWV	ETF	95.51	95.69	95.41	95.54	195600.0
2019-12-20	ACWX	ETF	48.99	48.99	48.85	48.85	3191097.0
2019-12-20	ADME	ETF	30.816	30.94	30.816	30.922	3000.0
2019-12-20	ADRE	ETF	45.0	45.0	44.485	44.485	11460.0
2019-12-20	AESR	ETF	10.11	10.11	10.088	10.089	16200.0
2019-12-20	AFIF	ETF	9.7303	9.745	9.723	9.745	1429.0
2019-12-20	AFK	ETF	21.34	21.34	21.005	21.1	11932.0
2019-12-20	AFLG	ETF	20.476	20.476	20.476	20.476	100.0
2019-12-20	AFTY	ETF	17.09	17.196	17.09	17.196	5500.0
2019-12-20	AGG	ETF	112.21	112.33	112.15	112.32	8809200.0
2019-12-20	AGGY	ETF	52.23	52.3	52.23	52.3	157000.0
2019-12-20	AGNG	ETF	23.815	23.946	23.815	23.9	3800.0
2019-12-20	AGQ	ETF	29.42	29.6	29.06	29.3	185800.0
2019-12-20	AGZ	ETF	115.45	115.53	115.3916	115.44	16707.0
2019-12-20	AGZD	ETF	24.08	24.095	24.015	24.055	9400.0
2019-12-20	AIA	ETF	65.66	65.66	65.52	65.52	18649.0
2019-12-20	AIEQ	ETF	28.35	28.53	28.35	28.46	23700.0
2019-12-20	AIQ	ETF	17.9	17.9935	17.9	17.949	9667.0
2019-12-20	AIRR	ETF	29.18	29.28	29.18	29.236	7100.0
2019-12-20	AIVI	ETF	43.05	43.11	42.95	42.95	4200.0
2019-12-20	ALTY	ETF	15.0	15.0	14.95	14.97	11300.0
2019-12-20	AMJ	ETF	21.71	21.87	21.65	21.74	3090141.0
2019-12-20	AMLP	ETF	42.45	43.0	42.25	43.0	8856020.0
2019-12-20	AMOM	ETF	27.47	27.47	27.47	27.47	100.0
2019-12-20	AMUB	ETF	13.6851	13.6851	13.6851	13.6851	90.0
2019-12-20	AMZA	ETF	45.4	45.7	45.2	45.5	72240.0
2019-12-20	ANGL	ETF	29.96	29.97	29.83	29.97	692800.0
2019-12-20	AOA	ETF	58.32	58.43	58.27	58.31	80100.0
2019-12-20	AOK	ETF	36.33	36.38	36.27	36.36	72208.0
2019-12-20	AOM	ETF	40.33	40.3763	40.24	40.28	324946.0
2019-12-20	AOR	ETF	48.07	48.1399	48.03	48.09	136319.0
2019-12-20	ARCM	ETF	99.945	99.945	99.945	99.945	100.0
2019-12-20	ARGT	ETF	25.67	26.06	25.51	26.04	50200.0
2019-12-20	ARKF	ETF	24.249	24.27	24.205	24.213	8300.0
2019-12-20	ARKG	ETF	35.74	35.89	35.452	35.7	220100.0

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

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