PREVIEW / etf_daily / 2015-12-15

all etf daily files

  file:    by_date/etf_daily/2015/2015-12-15.parquet
  size:    50 KB
  rows:    1,235

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-12-15	SPY	ETF	204.7	206.11	202.87	205.03	154069600.0
2015-12-15	QQQ	ETF	112.6	113.28	112.17	112.31	48428014.0
2015-12-15	IWM	ETF	111.73	112.96	111.6	112.71	48273900.0
2015-12-15	DIA	ETF	174.91	176.45	174.91	175.46	8039800.0
2015-12-15	GLD	ETF	101.71	102.06	101.41	101.52	6831100.0
2015-12-15	TLT	ETF	121.02	121.6	120.83	121.44	8795500.0
2015-12-15	AADR	ETF	38.09	38.37	37.93	37.93	6200.0
2015-12-15	AAXJ	ETF	53.59	54.02	53.59	53.79	1494100.0
2015-12-15	ACTX	ETF	7.0801	8.9091	6.1951	8.8501	2616.0
2015-12-15	ACWF	ETF	23.2	23.26	23.19	23.19	4049.0
2015-12-15	ACWI	ETF	56.13	56.39	56.03	56.17	3852300.0
2015-12-15	ACWV	ETF	69.49	69.73	69.4	69.46	179100.0
2015-12-15	ACWX	ETF	39.5	39.67	39.429	39.52	2441003.0
2015-12-15	ADRE	ETF	29.38	29.86	29.38	29.6801	24396.0
2015-12-15	AFK	ETF	17.75	17.94	17.6301	17.74	148195.0
2015-12-15	AFTY	ETF	16.53	16.6	16.45	16.45	33600.0
2015-12-15	AGG	ETF	108.08	108.19	107.91	108.19	2955900.0
2015-12-15	AGGY	ETF	49.05	49.15	49.0	49.05	2300.0
2015-12-15	AGQ	ETF	26.81	27.2	26.71	26.9	94100.0
2015-12-15	AGZ	ETF	113.0	113.05	112.795	112.97	28243.0
2015-12-15	AGZD	ETF	23.975	24.015	23.975	24.0	8200.0
2015-12-15	AIA	ETF	43.01	43.27	42.99	43.15	112372.0
2015-12-15	AIQ	ETF	8.19	8.35	8.09	8.26	15646.0
2015-12-15	AIRR	ETF	16.56	16.591	16.56	16.591	5000.0
2015-12-15	AIVI	ETF	37.82	37.99	37.72	37.78	108500.0
2015-12-15	AMJ	ETF	25.09	25.39	24.54	25.04	5983784.0
2015-12-15	AMLP	ETF	50.55	51.4	49.55	50.9	4589380.0
2015-12-15	AMZA	ETF	91.3	92.5	89.34	91.5	2220.0
2015-12-15	ANGL	ETF	24.3	24.61	24.29	24.58	29100.0
2015-12-15	AOA	ETF	45.11	45.11	44.9	44.91	394200.0
2015-12-15	AOK	ETF	31.73	31.73	31.61	31.65	251786.0
2015-12-15	AOM	ETF	34.16	34.25	34.1201	34.16	665810.0
2015-12-15	AOR	ETF	38.9	39.0199	38.84	38.91	694392.0
2015-12-15	ARGT	ETF	17.56	17.83	17.56	17.81	5200.0
2015-12-15	ARKG	ETF	19.588	19.892	19.588	19.89	900.0
2015-12-15	ARKK	ETF	20.75	20.75	20.49	20.552	1200.0
2015-12-15	ARKQ	ETF	19.074	19.117	19.074	19.117	500.0
2015-12-15	ARKW	ETF	23.378	23.549	23.378	23.53	8400.0
2015-12-15	ASEA	ETF	12.39	12.52	12.39	12.47	7100.0
2015-12-15	ASET	ETF	24.16	24.23	24.15	24.2	4924.0
2015-12-15	ASHR	ETF	36.26	36.45	36.18	36.3	1755700.0
2015-12-15	ASHS	ETF	44.48	44.93	44.46	44.53	156100.0
2015-12-15	ATMP	ETF	16.72	16.72	16.36	16.71	322000.0
2015-12-15	BAB	ETF	28.99	29.12	28.99	29.12	209145.0
2015-12-15	BAL	ETF	42.04	42.07	41.94	41.99	8604.0
2015-12-15	BBC	ETF	28.22	28.553	28.22	28.3301	3175.0
2015-12-15	BBH	ETF	122.48	124.46	122.26	123.85	55700.0
2015-12-15	BBP	ETF	29.83	29.83	29.65	29.73	1700.0
2015-12-15	BCM	ETF	23.81	23.81	23.8037	23.8037	433.0
2015-12-15	BFOR	ETF	7.575	7.6	7.54	7.5825	27600.0

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

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