PREVIEW / etf_daily / 2016-08-29

all etf daily files

  file:    by_date/etf_daily/2016/2016-08-29.parquet
  size:    51 KB
  rows:    1,285

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-08-29	SPY	ETF	217.44	218.67	217.4	218.36	70502200.0
2016-08-29	QQQ	ETF	116.81	117.251	116.79	116.94	11184872.0
2016-08-29	IWM	ETF	123.27	124.17	123.24	123.7	14013900.0
2016-08-29	DIA	ETF	183.83	185.04	183.83	184.83	2229800.0
2016-08-29	GLD	ETF	126.0	126.48	125.93	126.3	5562400.0
2016-08-29	TLT	ETF	139.38	140.35	139.21	140.21	7310400.0
2016-08-29	AADR	ETF	40.67	40.73	40.65	40.67	1000.0
2016-08-29	AAXJ	ETF	58.82	59.13	58.76	59.04	519700.0
2016-08-29	ACTX	ETF	3.54	3.54	3.54	3.54	2.0
2016-08-29	ACWF	ETF	23.954	24.0269	23.954	24.0269	2704.0
2016-08-29	ACWI	ETF	58.7	58.97	58.64	58.89	1090200.0
2016-08-29	ACWV	ETF	76.12	76.62	76.12	76.59	206900.0
2016-08-29	ACWX	ETF	40.95	41.14	40.89	41.115	158032.0
2016-08-29	ADRE	ETF	33.95	34.24	33.95	34.1945	15796.0
2016-08-29	AFK	ETF	20.4	20.6693	20.3	20.35	14849.0
2016-08-29	AFTY	ETF	13.51	13.51	13.5	13.5	1000.0
2016-08-29	AGG	ETF	112.55	112.68	112.46	112.65	2156400.0
2016-08-29	AGGY	ETF	52.09	52.27	52.03	52.21	9200.0
2016-08-29	AGNG	ETF	16.62	16.62	16.62	16.62	100.0
2016-08-29	AGQ	ETF	45.98	47.09	45.74	46.87	108200.0
2016-08-29	AGZ	ETF	115.6143	115.7	115.51	115.68	7728.0
2016-08-29	AGZD	ETF	23.93	23.93	23.84	23.925	3000.0
2016-08-29	AIA	ETF	48.43	48.6391	48.4	48.57	26734.0
2016-08-29	AIQ	ETF	6.33	6.39	6.31	6.31	13938.0
2016-08-29	AIRR	ETF	19.86	19.94	19.85	19.85	4600.0
2016-08-29	AIVI	ETF	38.79	39.07	38.79	39.0	13600.0
2016-08-29	ALTY	ETF	15.642	15.69	15.642	15.674	2500.0
2016-08-29	AMJ	ETF	31.09	31.22	30.91	31.17	1401578.0
2016-08-29	AMLP	ETF	62.7	63.05	62.6	63.05	640540.0
2016-08-29	AMZA	ETF	115.0	115.47	113.8	115.47	5370.0
2016-08-29	ANGL	ETF	28.79	28.85	28.74	28.83	123100.0
2016-08-29	AOA	ETF	47.1	47.44	47.1	47.39	16200.0
2016-08-29	AOK	ETF	33.27	33.4299	33.27	33.35	30857.0
2016-08-29	AOM	ETF	35.94	36.0699	35.9001	36.0199	41027.0
2016-08-29	AOR	ETF	40.8	41.06	40.8	41.04	25364.0
2016-08-29	ARGT	ETF	22.57	22.7	22.43	22.62	12300.0
2016-08-29	ARKG	ETF	18.435	18.435	18.435	18.435	200.0
2016-08-29	ARKK	ETF	21.06	21.06	21.037	21.039	400.0
2016-08-29	ARKQ	ETF	21.76	21.76	21.688	21.72	1100.0
2016-08-29	ARKW	ETF	24.518	24.518	24.518	24.518	200.0
2016-08-29	ASEA	ETF	14.11	14.13	14.11	14.13	800.0
2016-08-29	ASET	ETF	26.86	26.86	26.86	26.86	100.0
2016-08-29	ASHR	ETF	24.94	25.11	24.9	25.07	1366600.0
2016-08-29	ASHS	ETF	35.21	35.37	35.21	35.3	4600.0
2016-08-29	ATMP	ETF	22.59	22.69	22.53	22.69	25000.0
2016-08-29	BAB	ETF	31.6	31.74	31.5906	31.7	672756.0
2016-08-29	BAL	ETF	44.51	44.545	44.11	44.11	7423.0
2016-08-29	BBC	ETF	20.172	20.2	20.172	20.19	3078.0
2016-08-29	BBH	ETF	115.47	115.47	114.29	114.77	39600.0
2016-08-29	BBP	ETF	30.95	30.95	30.59	30.59	1400.0

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

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