PREVIEW / etf_daily / 2016-01-29

all etf daily files

  file:    by_date/etf_daily/2016/2016-01-29.parquet
  size:    50 KB
  rows:    1,240

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
2016-01-29	SPY	ETF	190.02	193.88	189.88	193.72	210529300.0
2016-01-29	QQQ	ETF	102.0	104.17	101.94	104.13	54245067.0
2016-01-29	IWM	ETF	100.04	102.98	99.96	102.96	42245300.0
2016-01-29	DIA	ETF	161.61	164.43	161.33	164.37	6182800.0
2016-01-29	GLD	ETF	106.61	107.0	106.26	106.95	8098700.0
2016-01-29	TLT	ETF	127.41	127.86	126.92	127.3	13170700.0
2016-01-29	AADR	ETF	36.15	36.17	35.66	36.08	10400.0
2016-01-29	AAXJ	ETF	49.18	49.79	49.16	49.75	1720300.0
2016-01-29	ACTX	ETF	5.9591	6.4901	4.72	5.9001	983.0
2016-01-29	ACWI	ETF	52.02	52.88	51.98	52.86	5317300.0
2016-01-29	ACWV	ETF	67.31	68.28	67.31	68.24	142200.0
2016-01-29	ACWX	ETF	36.88	37.43	36.88	37.41	1628350.0
2016-01-29	ADRE	ETF	26.64	27.0	26.6294	27.0	87868.0
2016-01-29	AFK	ETF	16.28	16.5843	16.2501	16.52	39111.0
2016-01-29	AFTY	ETF	11.73	11.79	11.72	11.79	16200.0
2016-01-29	AGG	ETF	109.41	109.48	109.25	109.35	8633000.0
2016-01-29	AGGY	ETF	49.55	49.747	49.53	49.54	4500.0
2016-01-29	AGQ	ETF	28.46	28.75	28.26	28.6	146900.0
2016-01-29	AGZ	ETF	114.11	114.21	113.83	113.83	20431.0
2016-01-29	AGZD	ETF	23.72	23.72	23.62	23.62	2400.0
2016-01-29	AIA	ETF	38.67	39.03	38.66	38.97	31668.0
2016-01-29	AIQ	ETF	7.08	7.49	7.02	7.48	12292.0
2016-01-29	AIRR	ETF	14.75	15.19	14.75	15.19	6700.0
2016-01-29	AIVI	ETF	36.54	36.98	36.54	36.98	37700.0
2016-01-29	AMJ	ETF	25.65	26.37	25.43	25.66	5480034.0
2016-01-29	AMLP	ETF	52.15	53.35	51.45	52.0	6720260.0
2016-01-29	AMZA	ETF	89.4	92.6	85.0	87.1	11400.0
2016-01-29	ANGL	ETF	23.97	23.97	23.88	23.91	19400.0
2016-01-29	AOA	ETF	42.4	42.98	42.36	42.98	307900.0
2016-01-29	AOK	ETF	31.18	31.3073	31.15	31.3	154603.0
2016-01-29	AOM	ETF	33.32	33.51	33.2701	33.51	302953.0
2016-01-29	AOR	ETF	37.31	37.68	37.31	37.66	909433.0
2016-01-29	ARGT	ETF	16.93	17.15	16.89	17.15	27500.0
2016-01-29	ARKG	ETF	16.6	16.6	16.6	16.6	800.0
2016-01-29	ARKK	ETF	16.69	16.74	16.666	16.74	1000.0
2016-01-29	ARKQ	ETF	15.94	16.075	15.94	16.075	400.0
2016-01-29	ARKW	ETF	18.52	19.015	18.52	19.003	1200.0
2016-01-29	ASEA	ETF	11.98	12.0	11.96	12.0	1600.0
2016-01-29	ASET	ETF	23.66	23.67	23.66	23.66	2505.0
2016-01-29	ASHR	ETF	21.87	22.23	21.82	22.17	2367100.0
2016-01-29	ASHS	ETF	29.68	30.19	29.57	29.91	67600.0
2016-01-29	ASHX	ETF	20.03	20.07	20.03	20.04	1500.0
2016-01-29	ATMP	ETF	16.92	17.18	16.79	17.08	29800.0
2016-01-29	BAB	ETF	29.88	29.88	29.735	29.8	231828.0
2016-01-29	BAL	ETF	40.6374	40.839	40.34	40.34	8421.0
2016-01-29	BBC	ETF	19.2068	19.31	18.5699	19.2	10293.0
2016-01-29	BBH	ETF	100.37	102.05	99.63	101.65	133300.0
2016-01-29	BBP	ETF	23.54	24.14	23.54	23.99	7800.0
2016-01-29	BCM	ETF	23.27	23.359	23.064	23.3554	15263.0
2016-01-29	BFOR	ETF	6.775	6.96	6.775	6.96	170800.0

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

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