PREVIEW / etf_daily / 2018-12-03

all etf daily files

  file:    by_date/etf_daily/2018/2018-12-03.parquet
  size:    64 KB
  rows:    1,687

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-12-03	SPY	ETF	280.28	280.4	277.51	279.3	103176300.0
2018-12-03	QQQ	ETF	173.1	173.31	169.5101	172.33	50771695.0
2018-12-03	IWM	ETF	154.39	154.48	152.02	154.08	23379800.0
2018-12-03	DIA	ETF	260.17	260.3	257.02	258.73	9544200.0
2018-12-03	GLD	ETF	116.6	116.77	116.3	116.41	8469500.0
2018-12-03	TLT	ETF	114.68	115.88	114.66	115.88	9763800.0
2018-12-03	AAAU	ETF	12.32	12.34	12.29	12.29	5900.0
2018-12-03	AADR	ETF	44.25	45.51	44.14	45.51	20800.0
2018-12-03	AAXJ	ETF	68.43	68.6	67.87	68.29	3513400.0
2018-12-03	ACES	ETF	25.29	25.5	25.29	25.5	1700.0
2018-12-03	ACSI	ETF	33.2129	33.2129	33.0	33.15	6096.0
2018-12-03	ACTX	ETF	62.5406	62.5406	59.0005	61.9506	415.0
2018-12-03	ACWF	ETF	28.99	28.99	28.6606	28.9	30749.0
2018-12-03	ACWI	ETF	70.98	71.03	70.4	70.73	3838500.0
2018-12-03	ACWV	ETF	87.21	87.21	86.39	86.94	266800.0
2018-12-03	ACWX	ETF	45.27	45.3	44.9936	45.18	4235989.0
2018-12-03	ADRE	ETF	39.2	39.6588	39.1462	39.1462	5448.0
2018-12-03	AFIF	ETF	10.01	10.03	9.99	9.99	19932.0
2018-12-03	AFK	ETF	20.61	20.9399	20.61	20.65	13429.0
2018-12-03	AFTY	ETF	14.73	14.73	14.64	14.72	18100.0
2018-12-03	AGG	ETF	104.69	104.86	104.63	104.8	14037900.0
2018-12-03	AGGY	ETF	47.49	47.61	47.49	47.61	49900.0
2018-12-03	AGNG	ETF	20.912	20.912	20.885	20.885	800.0
2018-12-03	AGQ	ETF	23.39	23.48	22.9	22.93	115500.0
2018-12-03	AGZ	ETF	110.71	110.84	110.6366	110.84	33576.0
2018-12-03	AGZD	ETF	23.765	23.8	23.745	23.8	34800.0
2018-12-03	AIA	ETF	59.66	59.728	59.0523	59.53	59059.0
2018-12-03	AIEQ	ETF	27.12	27.439	26.79	26.92	40400.0
2018-12-03	AIQ	ETF	14.53	14.5399	14.388	14.5	3981.0
2018-12-03	AIRR	ETF	25.63	25.63	24.91	25.12	12300.0
2018-12-03	AIVI	ETF	40.02	40.03	39.86	39.98	16300.0
2018-12-03	ALTY	ETF	14.8	14.8	14.574	14.65	10700.0
2018-12-03	AMJ	ETF	24.7	25.28	24.7	25.24	3969570.0
2018-12-03	AMLP	ETF	48.5	49.25	48.3	49.25	3345900.0
2018-12-03	AMZA	ETF	62.4	63.47	62.0	63.4	173810.0
2018-12-03	ANGL	ETF	27.41	27.5	27.4	27.48	309600.0
2018-12-03	AOA	ETF	52.31	52.51	52.13	52.29	207100.0
2018-12-03	AOK	ETF	33.47	33.56	33.3831	33.54	107030.0
2018-12-03	AOM	ETF	36.87	36.988	36.82	36.97	634767.0
2018-12-03	AOR	ETF	43.51	43.6516	43.43	43.61	391320.0
2018-12-03	ARGT	ETF	26.22	26.65	26.22	26.53	38000.0
2018-12-03	ARKG	ETF	30.5	30.7	30.25	30.66	127000.0
2018-12-03	ARKK	ETF	46.0	46.0	45.04	45.53	381100.0
2018-12-03	ARKQ	ETF	34.36	34.45	33.75	33.93	18200.0
2018-12-03	ARKW	ETF	55.46	55.88	54.955	55.37	190300.0
2018-12-03	ARVR	ETF	17.87	17.87	17.87	17.87	111.0
2018-12-03	ASEA	ETF	16.28	16.35	16.01	16.34	8500.0
2018-12-03	ASET	ETF	27.34	27.34	27.34	27.34	577.0
2018-12-03	ASHR	ETF	24.18	24.25	24.1	24.25	4028500.0
2018-12-03	ASHS	ETF	24.08	24.19	24.06	24.18	9100.0

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

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