PREVIEW / etf_daily / 2019-10-08

all etf daily files

  file:    by_date/etf_daily/2019/2019-10-08.parquet
  size:    70 KB
  rows:    1,844

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-10-08	SPY	ETF	291.04	291.85	288.49	288.53	95708100.0
2019-10-08	QQQ	ETF	187.01	187.8562	185.27	185.42	33201939.0
2019-10-08	IWM	ETF	147.42	147.93	146.11	146.46	18110600.0
2019-10-08	DIA	ETF	262.64	264.21	261.35	261.58	3505200.0
2019-10-08	GLD	ETF	142.03	142.29	141.17	141.92	10428900.0
2019-10-08	TLT	ETF	145.82	145.93	144.62	145.17	14529700.0
2019-10-08	AAAU	ETF	15.04	15.05	14.95	15.02	41300.0
2019-10-08	AADR	ETF	47.59	47.63	47.23	47.31	3400.0
2019-10-08	AAXJ	ETF	65.87	65.94	65.54	65.64	854900.0
2019-10-08	ACES	ETF	30.59	30.658	30.5	30.532	3900.0
2019-10-08	ACIO	ETF	24.23	24.24	24.17	24.19	11800.0
2019-10-08	ACSI	ETF	33.2068	33.2068	33.0321	33.0321	883.0
2019-10-08	ACTX	ETF	14.248	14.7501	11.8237	14.7501	217.0
2019-10-08	ACWF	ETF	28.33	28.34	28.0886	28.0886	19666.0
2019-10-08	ACWI	ETF	72.35	72.45	71.79	71.79	2588000.0
2019-10-08	ACWV	ETF	94.26	94.37	93.77	93.8	320700.0
2019-10-08	ACWX	ETF	45.17	45.2	44.92	44.92	1290070.0
2019-10-08	ADRE	ETF	38.29	38.29	37.9943	37.9943	6352.0
2019-10-08	AFIF	ETF	9.79	9.801	9.79	9.801	440.0
2019-10-08	AFK	ETF	19.788	19.86	19.76	19.81	12854.0
2019-10-08	AFTY	ETF	16.73	16.79	16.7	16.715	1500.0
2019-10-08	AGG	ETF	113.82	113.82	113.49	113.55	3055700.0
2019-10-08	AGGY	ETF	52.61	52.65	52.55	52.59	231500.0
2019-10-08	AGNG	ETF	21.16	21.16	21.033	21.033	14700.0
2019-10-08	AGQ	ETF	31.96	32.21	31.59	31.99	314000.0
2019-10-08	AGZ	ETF	117.09	117.09	116.84	116.88	676884.0
2019-10-08	AGZD	ETF	23.875	23.915	23.825	23.825	6400.0
2019-10-08	AIA	ETF	58.56	58.64	58.38	58.38	18596.0
2019-10-08	AIEQ	ETF	25.78	25.8	25.58	25.639	22500.0
2019-10-08	AIQ	ETF	15.85	15.85	15.68	15.69	51336.0
2019-10-08	AIRR	ETF	25.73	25.79	25.6	25.6	6300.0
2019-10-08	AIVI	ETF	39.59	39.62	39.43	39.43	5800.0
2019-10-08	ALTY	ETF	14.64	14.64	14.57	14.585	3500.0
2019-10-08	AMJ	ETF	22.57	22.64	22.35	22.47	1575505.0
2019-10-08	AMLP	ETF	44.45	44.45	44.0	44.2	3930100.0
2019-10-08	AMOM	ETF	25.7	25.79	25.65	25.65	1100.0
2019-10-08	AMUB	ETF	14.1493	14.1493	14.1493	14.1493	0.0
2019-10-08	AMZA	ETF	47.5	47.5	46.6	46.9	74750.0
2019-10-08	ANGL	ETF	29.0	29.06	28.9	28.93	312900.0
2019-10-08	AOA	ETF	54.06	54.06	53.62	53.68	66200.0
2019-10-08	AOK	ETF	35.51	35.549	35.4	35.43	65123.0
2019-10-08	AOM	ETF	38.92	38.9251	38.75	38.75	121472.0
2019-10-08	AOR	ETF	45.45	45.4783	45.16	45.22	77514.0
2019-10-08	ARGT	ETF	23.08	23.08	22.33	22.34	40400.0
2019-10-08	ARKF	ETF	21.3	21.3	21.061	21.061	7800.0
2019-10-08	ARKG	ETF	28.81	28.98	27.93	27.95	91400.0
2019-10-08	ARKK	ETF	41.64	41.64	40.61	40.62	287400.0
2019-10-08	ARKQ	ETF	31.0	31.0	30.66	30.66	9500.0
2019-10-08	ARKW	ETF	47.95	48.15	47.47	47.47	54400.0
2019-10-08	ASEA	ETF	15.58	15.66	15.35	15.39	131900.0

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

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