PREVIEW / etf_daily / 2015-09-29

all etf daily files

  file:    by_date/etf_daily/2015/2015-09-29.parquet
  size:    49 KB
  rows:    1,217

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
2015-09-29	SPY	ETF	188.27	189.74	186.93	188.12	159045600.0
2015-09-29	QQQ	ETF	100.24	101.26	98.75	99.47	49315527.0
2015-09-29	IWM	ETF	108.25	109.11	106.99	107.53	49980700.0
2015-09-29	DIA	ETF	159.98	160.96	159.18	160.23	9906200.0
2015-09-29	GLD	ETF	108.24	108.69	107.88	107.98	4043600.0
2015-09-29	TLT	ETF	123.54	124.29	123.25	123.97	9006100.0
2015-09-29	AADR	ETF	35.41	35.41	35.19	35.19	1400.0
2015-09-29	AAXJ	ETF	51.17	51.59	50.99	51.34	1658500.0
2015-09-29	ACTX	ETF	16.8152	27.7302	16.5201	22.4202	9993.0
2015-09-29	ACWF	ETF	21.99	21.99	21.99	21.99	2234.0
2015-09-29	ACWI	ETF	52.85	53.17	52.56	52.83	2053200.0
2015-09-29	ACWV	ETF	65.92	66.07	65.64	65.94	88900.0
2015-09-29	ACWX	ETF	38.21	38.34	38.01	38.24	1421983.0
2015-09-29	ADRE	ETF	26.98	27.25	26.98	27.18	16674.0
2015-09-29	AFK	ETF	19.43	19.57	19.39	19.57	8289.0
2015-09-29	AFTY	ETF	14.85	14.95	14.8	14.82	9000.0
2015-09-29	AGG	ETF	109.44	109.6	109.37	109.54	1506800.0
2015-09-29	AGGY	ETF	49.74	49.81	49.65	49.66	2200.0
2015-09-29	AGQ	ETF	30.75	31.34	30.75	30.96	86300.0
2015-09-29	AGZ	ETF	114.1531	114.1531	113.86	113.92	19382.0
2015-09-29	AGZD	ETF	23.935	24.0	23.92	23.97	7800.0
2015-09-29	AIA	ETF	40.42	40.73	40.29	40.59	29829.0
2015-09-29	AIQ	ETF	10.07	10.36	9.8	9.9	34002.0
2015-09-29	AIRR	ETF	15.11	15.11	14.945	15.03	19100.0
2015-09-29	AIVI	ETF	37.35	37.5	37.18	37.4	30100.0
2015-09-29	ALTY	ETF	13.95	13.95	13.77	13.77	1700.0
2015-09-29	AMJ	ETF	29.63	29.96	27.79	27.94	6266040.0
2015-09-29	AMLP	ETF	61.4	62.1	57.4	57.55	3647560.0
2015-09-29	AMZA	ETF	130.9	134.1	120.0	120.0	12230.0
2015-09-29	ANGL	ETF	25.65	25.69	25.54	25.58	20900.0
2015-09-29	AOA	ETF	43.04	43.1	42.79	42.93	34500.0
2015-09-29	AOK	ETF	31.3	31.3948	31.25	31.32	18165.0
2015-09-29	AOM	ETF	33.5875	33.66	33.47	33.64	45804.0
2015-09-29	AOR	ETF	37.73	37.7914	37.6	37.77	113883.0
2015-09-29	ARGT	ETF	15.73	16.05	15.69	15.72	12100.0
2015-09-29	ARKG	ETF	18.41	18.85	18.2	18.2	16800.0
2015-09-29	ARKK	ETF	18.69	18.69	18.69	18.69	100.0
2015-09-29	ARKQ	ETF	17.11	17.33	17.07	17.07	2100.0
2015-09-29	ARKW	ETF	21.13	21.17	20.7	20.86	5400.0
2015-09-29	ASEA	ETF	11.76	11.85	11.76	11.82	2800.0
2015-09-29	ASHR	ETF	31.96	32.18	31.82	32.09	1349800.0
2015-09-29	ASHS	ETF	35.47	36.45	35.47	36.22	63700.0
2015-09-29	ATMP	ETF	20.44	21.24	19.04	19.09	206900.0
2015-09-29	AWAY	ETF	26.09	26.25	25.58	25.83	951700.0
2015-09-29	BAB	ETF	29.22	29.33	29.06	29.33	196399.0
2015-09-29	BAL	ETF	40.43	40.757	40.4	40.4	7662.0
2015-09-29	BBC	ETF	27.78	27.78	24.95	25.28	34644.0
2015-09-29	BBH	ETF	109.77	114.22	108.45	110.38	582300.0
2015-09-29	BBP	ETF	27.75	28.205	26.38	26.66	30900.0
2015-09-29	BCM	ETF	26.644	26.644	26.63	26.63	808.0

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

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