PREVIEW / etf_daily / 2018-11-23

all etf daily files

  file:    by_date/etf_daily/2018/2018-11-23.parquet
  size:    61 KB
  rows:    1,623

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
2018-11-23	SPY	ETF	263.18	264.82	263.07	263.25	42807900.0
2018-11-23	QQQ	ETF	159.09	160.84	159.09	159.21	23503729.0
2018-11-23	IWM	ETF	146.82	149.3	146.81	147.89	11134800.0
2018-11-23	DIA	ETF	243.25	244.03	242.71	242.81	1928000.0
2018-11-23	GLD	ETF	115.76	115.88	115.59	115.77	3726600.0
2018-11-23	TLT	ETF	115.67	115.76	115.09	115.14	3027900.0
2018-11-23	AAAU	ETF	12.26	12.26	12.26	12.26	100.0
2018-11-23	AADR	ETF	43.63	43.63	43.3	43.42	1800.0
2018-11-23	AAXJ	ETF	64.45	64.85	64.31	64.45	405700.0
2018-11-23	ACES	ETF	24.26	24.54	24.26	24.361	1100.0
2018-11-23	ACSI	ETF	31.74	31.859	31.715	31.859	898.0
2018-11-23	ACTX	ETF	64.9006	69.0306	64.3106	66.6706	633.0
2018-11-23	ACWF	ETF	27.7	27.79	27.7	27.79	1349.0
2018-11-23	ACWI	ETF	67.37	67.71	67.27	67.45	1215300.0
2018-11-23	ACWV	ETF	84.28	84.69	84.25	84.38	52100.0
2018-11-23	ACWX	ETF	43.61	43.8	43.61	43.63	962097.0
2018-11-23	ADRE	ETF	36.85	36.955	36.85	36.955	1453.0
2018-11-23	AFIF	ETF	9.9935	10.02	9.9935	10.0027	1177.0
2018-11-23	AFK	ETF	20.57	21.05	20.3399	20.38	2518.0
2018-11-23	AFTY	ETF	14.0	14.11	13.99	14.08	18400.0
2018-11-23	AGG	ETF	104.84	104.84	104.65	104.65	1665900.0
2018-11-23	AGGY	ETF	47.5	47.5	47.411	47.43	16900.0
2018-11-23	AGNG	ETF	19.47	19.95	19.47	19.87	12300.0
2018-11-23	AGQ	ETF	22.74	22.83	22.66	22.69	33700.0
2018-11-23	AGZ	ETF	110.8077	110.8492	110.7407	110.7407	6277.0
2018-11-23	AGZD	ETF	23.715	23.8	23.71	23.755	35600.0
2018-11-23	AIA	ETF	55.7	56.01	55.7	55.7	9296.0
2018-11-23	AIEQ	ETF	25.37	25.5	25.35	25.35	12600.0
2018-11-23	AIQ	ETF	13.36	13.37	13.3214	13.37	1315.0
2018-11-23	AIRR	ETF	24.23	24.604	24.23	24.34	14000.0
2018-11-23	AIVI	ETF	39.25	39.25	39.22	39.22	1000.0
2018-11-23	ALTY	ETF	14.5	14.5	14.337	14.35	2600.0
2018-11-23	AMJ	ETF	24.7	24.9162	24.495	24.69	1145335.0
2018-11-23	AMLP	ETF	47.1	47.45	46.55	47.0	1956640.0
2018-11-23	AMZA	ETF	60.4	60.5	59.2	59.6	82130.0
2018-11-23	ANGL	ETF	27.35	27.37	27.21	27.23	182500.0
2018-11-23	AOA	ETF	50.37	50.6	50.36	50.38	120500.0
2018-11-23	AOK	ETF	32.95	33.06	32.8775	32.99	96389.0
2018-11-23	AOM	ETF	36.2	36.2743	36.18	36.19	208079.0
2018-11-23	AOR	ETF	42.31	42.47	42.3065	42.33	95012.0
2018-11-23	ARGT	ETF	25.01	25.11	24.74	24.92	5800.0
2018-11-23	ARKG	ETF	27.91	28.84	27.56	28.32	23100.0
2018-11-23	ARKK	ETF	41.25	42.202	41.25	41.71	42400.0
2018-11-23	ARKQ	ETF	32.03	32.1	31.845	31.95	6900.0
2018-11-23	ARKW	ETF	49.08	49.86	49.08	49.42	26000.0
2018-11-23	ARVR	ETF	17.62	17.655	17.3201	17.3201	876.0
2018-11-23	ASEA	ETF	15.43	15.53	15.43	15.53	400.0
2018-11-23	ASHR	ETF	22.97	23.09	22.96	22.98	2326500.0
2018-11-23	ASHS	ETF	23.39	23.39	23.21	23.34	15100.0
2018-11-23	ASHX	ETF	16.36	16.36	16.36	16.36	300.0

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

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