PREVIEW / etf_daily / 2018-11-28

all etf daily files

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

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-28	SPY	ETF	269.6	274.58	268.33	274.58	127629600.0
2018-11-28	QQQ	ETF	164.62	168.7	163.4719	168.7	70140986.0
2018-11-28	IWM	ETF	149.2	152.37	147.7	152.24	26125900.0
2018-11-28	DIA	ETF	249.12	253.84	248.59	253.84	5132500.0
2018-11-28	GLD	ETF	114.76	116.07	114.59	115.38	13788800.0
2018-11-28	TLT	ETF	114.85	115.02	114.36	114.45	7814000.0
2018-11-28	AAAU	ETF	12.23	12.25	12.19	12.2	6000.0
2018-11-28	AADR	ETF	43.73	44.5	43.65	44.46	36200.0
2018-11-28	AAXJ	ETF	66.39	67.42	66.01	67.41	1624500.0
2018-11-28	ACES	ETF	24.97	24.995	24.97	24.99	1700.0
2018-11-28	ACSI	ETF	32.3986	32.3986	32.3986	32.3986	1155.0
2018-11-28	ACTX	ETF	66.9656	66.9656	59.5905	60.1805	498.0
2018-11-28	ACWF	ETF	28.1	28.59	28.0469	28.572	7597.0
2018-11-28	ACWI	ETF	68.76	69.91	68.47	69.91	3695100.0
2018-11-28	ACWV	ETF	85.33	86.37	85.19	86.31	255600.0
2018-11-28	ACWX	ETF	44.29	44.92	44.07	44.89	3575841.0
2018-11-28	ADRE	ETF	38.05	38.45	37.74	38.45	19438.0
2018-11-28	AFIF	ETF	10.0216	10.0216	10.0	10.02	62304.0
2018-11-28	AFK	ETF	20.47	20.9151	20.47	20.87	5006.0
2018-11-28	AFTY	ETF	14.088	14.31	14.088	14.31	2200.0
2018-11-28	AGG	ETF	104.63	104.91	104.57	104.86	8513900.0
2018-11-28	AGGY	ETF	47.44	47.5	47.368	47.5	41800.0
2018-11-28	AGNG	ETF	20.0	20.15	20.0	20.15	500.0
2018-11-28	AGQ	ETF	22.32	23.02	22.2	22.75	75600.0
2018-11-28	AGZ	ETF	110.63	110.8301	110.63	110.8	10993.0
2018-11-28	AGZD	ETF	23.725	23.84	23.715	23.79	84200.0
2018-11-28	AIA	ETF	57.87	58.95	57.58	58.95	236731.0
2018-11-28	AIEQ	ETF	25.79	26.45	25.79	26.43	25300.0
2018-11-28	AIQ	ETF	13.87	14.12	13.71	14.07	80263.0
2018-11-28	AIRR	ETF	24.63	25.11	24.33	25.07	122200.0
2018-11-28	AIVI	ETF	39.55	40.16	39.5	40.16	58700.0
2018-11-28	ALTY	ETF	14.392	14.51	14.392	14.501	1400.0
2018-11-28	AMJ	ETF	24.24	24.52	24.03	24.48	2919224.0
2018-11-28	AMLP	ETF	47.1	47.75	46.65	47.65	5323140.0
2018-11-28	AMZA	ETF	59.7	61.1	59.1	61.0	116420.0
2018-11-28	ANGL	ETF	27.34	27.57	27.34	27.54	494300.0
2018-11-28	AOA	ETF	51.11	51.85	50.96	51.85	172400.0
2018-11-28	AOK	ETF	33.09	33.35	33.08	33.3	111579.0
2018-11-28	AOM	ETF	36.43	36.73	36.3615	36.72	876281.0
2018-11-28	AOR	ETF	42.73	43.27	42.66	43.21	124573.0
2018-11-28	ARGT	ETF	24.94	25.47	24.64	25.43	52500.0
2018-11-28	ARKG	ETF	28.78	29.579	28.46	29.579	62200.0
2018-11-28	ARKK	ETF	43.07	44.19	42.484	44.18	308400.0
2018-11-28	ARKQ	ETF	32.56	33.31	32.423	33.31	14900.0
2018-11-28	ARKW	ETF	52.19	53.68	51.55	53.615	131800.0
2018-11-28	ARVR	ETF	17.77	17.77	17.77	17.77	705.0
2018-11-28	ASEA	ETF	15.84	15.94	15.84	15.93	500.0
2018-11-28	ASET	ETF	26.93	27.26	26.93	27.26	1897.0
2018-11-28	ASHR	ETF	23.18	23.51	23.09	23.51	3240700.0
2018-11-28	ASHS	ETF	23.61	23.7	23.39	23.7	15000.0

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

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