PREVIEW / etf_daily / 2018-11-30

all etf daily files

  file:    by_date/etf_daily/2018/2018-11-30.parquet
  size:    64 KB
  rows:    1,685

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-30	SPY	ETF	273.81	276.28	273.45	275.65	98204200.0
2018-11-30	QQQ	ETF	168.38	169.47	167.54	169.37	36722760.0
2018-11-30	IWM	ETF	151.46	152.86	151.08	152.62	20304700.0
2018-11-30	DIA	ETF	253.1	255.84	252.83	255.51	2991800.0
2018-11-30	GLD	ETF	115.42	115.66	115.04	115.54	8169600.0
2018-11-30	TLT	ETF	115.31	115.42	114.98	115.33	9127800.0
2018-11-30	AAAU	ETF	12.17	12.21	12.17	12.21	2400.0
2018-11-30	AADR	ETF	44.2	44.21	43.98	44.21	13700.0
2018-11-30	AAXJ	ETF	66.45	66.78	66.21	66.77	1421600.0
2018-11-30	ACES	ETF	25.11	25.26	24.985	25.26	5800.0
2018-11-30	ACSI	ETF	32.96	32.96	32.86	32.86	960.0
2018-11-30	ACTX	ETF	59.0005	64.3106	59.0005	59.2955	963.0
2018-11-30	ACWF	ETF	28.34	28.5299	28.34	28.5299	10965.0
2018-11-30	ACWI	ETF	69.5	69.9	69.38	69.83	3109800.0
2018-11-30	ACWV	ETF	86.13	86.68	86.02	86.59	189600.0
2018-11-30	ACWX	ETF	44.44	44.55	44.31	44.52	3956661.0
2018-11-30	ADRE	ETF	38.25	38.46	38.25	38.45	4175.0
2018-11-30	AFIF	ETF	10.03	10.03	9.9901	9.9901	14874.0
2018-11-30	AFK	ETF	20.4254	20.4359	20.375	20.38	2277.0
2018-11-30	AFTY	ETF	14.07	14.19	14.07	14.19	4900.0
2018-11-30	AGG	ETF	104.93	104.96	104.82	104.88	6126200.0
2018-11-30	AGGY	ETF	47.45	47.5	47.419	47.44	29700.0
2018-11-30	AGQ	ETF	22.33	22.36	21.97	22.35	104000.0
2018-11-30	AGZ	ETF	110.88	110.93	110.8	110.8721	88539.0
2018-11-30	AGZD	ETF	23.745	23.805	23.745	23.77	28400.0
2018-11-30	AIA	ETF	57.67	57.82	57.44	57.82	24926.0
2018-11-30	AIEQ	ETF	26.34	26.674	26.26	26.64	36400.0
2018-11-30	AIQ	ETF	14.1	14.23	14.0	14.2	19311.0
2018-11-30	AIRR	ETF	24.81	25.21	24.81	25.21	13100.0
2018-11-30	AIVI	ETF	39.75	39.75	39.65	39.72	2800.0
2018-11-30	ALTY	ETF	14.519	14.55	14.49	14.55	11200.0
2018-11-30	AMJ	ETF	24.7	24.85	24.37	24.57	4231392.0
2018-11-30	AMLP	ETF	48.1	48.35	47.4	47.75	5007280.0
2018-11-30	AMZA	ETF	61.6	61.8	60.1	61.2	84690.0
2018-11-30	ANGL	ETF	27.45	27.51	27.35	27.47	392600.0
2018-11-30	AOA	ETF	51.56	51.8	51.52	51.8	154600.0
2018-11-30	AOK	ETF	33.24	33.411	33.24	33.35	104287.0
2018-11-30	AOM	ETF	36.63	36.7486	36.5517	36.74	375287.0
2018-11-30	AOR	ETF	43.12	43.25	43.0401	43.24	323567.0
2018-11-30	ARGT	ETF	25.77	25.83	25.54	25.7	37000.0
2018-11-30	ARKG	ETF	29.78	29.79	29.28	29.79	65900.0
2018-11-30	ARKK	ETF	44.06	44.47	43.62	44.45	118300.0
2018-11-30	ARKQ	ETF	32.75	33.313	32.75	33.28	12000.0
2018-11-30	ARKW	ETF	53.46	53.99	53.03	53.98	78100.0
2018-11-30	ARVR	ETF	17.8589	17.86	17.8589	17.86	636.0
2018-11-30	ASEA	ETF	15.79	15.82	15.75	15.82	1100.0
2018-11-30	ASET	ETF	27.1	27.2092	27.1	27.2092	1853.0
2018-11-30	ASHR	ETF	23.19	23.43	23.09	23.42	2863500.0
2018-11-30	ASHS	ETF	22.99	23.2	22.99	23.2	8400.0
2018-11-30	ASHX	ETF	16.5	16.57	16.49	16.57	1847.0

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

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