PREVIEW / etf_daily / 2017-04-19

all etf daily files

  file:    by_date/etf_daily/2017/2017-04-19.parquet
  size:    55 KB
  rows:    1,380

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
2017-04-19	SPY	ETF	234.52	234.95	233.18	233.44	68699900.0
2017-04-19	QQQ	ETF	131.85	132.29	131.31	131.49	17764817.0
2017-04-19	IWM	ETF	135.69	136.96	135.54	135.79	34627600.0
2017-04-19	DIA	ETF	205.26	205.3	203.64	203.85	3606400.0
2017-04-19	GLD	ETF	122.25	122.26	121.28	121.73	8472700.0
2017-04-19	TLT	ETF	124.1	124.17	123.7	124.02	7344000.0
2017-04-19	AADR	ETF	46.33	47.21	45.79	45.82	16100.0
2017-04-19	AAXJ	ETF	62.45	62.45	61.97	62.07	1828600.0
2017-04-19	ACSI	ETF	27.94	27.94	27.94	27.94	237.0
2017-04-19	ACTX	ETF	100.8909	106.201	83.1908	90.8608	4151.0
2017-04-19	ACWI	ETF	62.95	63.0	62.53	62.61	976500.0
2017-04-19	ACWV	ETF	77.57	77.62	77.3	77.43	255800.0
2017-04-19	ACWX	ETF	43.37	43.4	43.06	43.11	600482.0
2017-04-19	ADRE	ETF	36.38	36.442	36.03	36.03	4079.0
2017-04-19	AFK	ETF	21.12	21.2499	21.1	21.1	6816.0
2017-04-19	AFTY	ETF	13.55	13.55	13.495	13.53	9200.0
2017-04-19	AGG	ETF	109.47	109.56	109.39	109.48	2148500.0
2017-04-19	AGGY	ETF	50.46	50.465	50.41	50.44	6200.0
2017-04-19	AGNG	ETF	16.91	16.95	16.9	16.95	900.0
2017-04-19	AGQ	ETF	41.3	41.3	40.61	40.73	126100.0
2017-04-19	AGZ	ETF	113.69	113.8155	113.65	113.79	12516.0
2017-04-19	AGZD	ETF	24.02	24.02	24.005	24.015	4200.0
2017-04-19	AIA	ETF	51.71	51.76	51.32	51.36	50146.0
2017-04-19	AIQ	ETF	12.95	13.05	12.95	13.05	39837.0
2017-04-19	AIRR	ETF	23.68	23.919	23.607	23.65	26000.0
2017-04-19	AIVI	ETF	39.03	39.04	38.78	38.86	9600.0
2017-04-19	ALTY	ETF	15.597	15.597	15.58	15.59	1900.0
2017-04-19	AMJ	ETF	32.05	32.11	31.76	31.78	1779832.0
2017-04-19	AMLP	ETF	63.25	63.45	62.85	62.9	1086060.0
2017-04-19	AMZA	ETF	105.5	105.7	104.5	104.5	49750.0
2017-04-19	ANGL	ETF	29.52	29.55	29.47	29.47	201100.0
2017-04-19	AOA	ETF	49.68	49.69	49.45	49.5	37200.0
2017-04-19	AOK	ETF	33.44	33.44	33.34	33.38	40290.0
2017-04-19	AOM	ETF	36.4	36.4	36.28	36.33	44706.0
2017-04-19	AOR	ETF	42.28	42.28	42.0801	42.1	75879.0
2017-04-19	ARCM	ETF	100.0	100.0	100.0	100.0	4000.0
2017-04-19	ARGT	ETF	28.93	28.93	28.55	28.62	24900.0
2017-04-19	ARKG	ETF	20.14	20.14	19.966	19.966	4100.0
2017-04-19	ARKK	ETF	24.39	24.4	24.265	24.3	15900.0
2017-04-19	ARKQ	ETF	25.15	25.25	25.07	25.097	35700.0
2017-04-19	ARKW	ETF	29.6	29.6	29.39	29.39	20700.0
2017-04-19	ASEA	ETF	14.62	14.62	14.02	14.06	55700.0
2017-04-19	ASET	ETF	26.89	26.89	26.7398	26.7398	2125.0
2017-04-19	ASHR	ETF	24.96	24.96	24.8	24.81	1151500.0
2017-04-19	ASHS	ETF	33.6	33.6	33.2	33.21	16800.0
2017-04-19	ASHX	ETF	19.324	19.324	19.22	19.235	565.0
2017-04-19	ATMP	ETF	23.59	23.6	23.41	23.46	16100.0
2017-04-19	BAB	ETF	29.68	29.7	29.62	29.67	148971.0
2017-04-19	BAL	ETF	50.02	50.22	49.4	49.8703	7807.0
2017-04-19	BBC	ETF	21.68	22.218	21.68	21.912	2825.0

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

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