PREVIEW / etf_daily / 2015-12-07

all etf daily files

  file:    by_date/etf_daily/2015/2015-12-07.parquet
  size:    49 KB
  rows:    1,220

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-07	SPY	ETF	209.23	209.73	207.2	208.35	102027100.0
2015-12-07	QQQ	ETF	115.22	115.29	114.07	114.62	25892101.0
2015-12-07	IWM	ETF	117.64	117.67	115.51	116.01	29621400.0
2015-12-07	DIA	ETF	178.02	178.08	176.42	177.34	5647000.0
2015-12-07	GLD	ETF	103.32	103.37	102.5	102.67	4393500.0
2015-12-07	TLT	ETF	120.81	122.46	120.8	121.75	9016700.0
2015-12-07	AADR	ETF	38.74	39.08	38.74	39.08	800.0
2015-12-07	AAXJ	ETF	55.18	55.18	54.72	54.92	878400.0
2015-12-07	ACTX	ETF	8.5551	9.4401	8.1421	9.4401	883.0
2015-12-07	ACWI	ETF	57.63	57.71	57.2	57.42	2251300.0
2015-12-07	ACWV	ETF	70.35	70.42	69.94	70.24	136600.0
2015-12-07	ACWX	ETF	40.85	40.96	40.59	40.72	1357650.0
2015-12-07	ADRE	ETF	30.62	30.6499	30.27	30.342	9880.0
2015-12-07	AFK	ETF	18.81	18.81	18.43	18.5	18690.0
2015-12-07	AFTY	ETF	16.65	16.65	16.48	16.5	58100.0
2015-12-07	AGG	ETF	108.3	108.58	108.23	108.4	2143800.0
2015-12-07	AGGY	ETF	49.42	49.55	49.42	49.47	4500.0
2015-12-07	AGQ	ETF	29.86	29.95	28.94	29.04	262500.0
2015-12-07	AGZ	ETF	113.06	113.53	113.0001	113.31	76966.0
2015-12-07	AGZD	ETF	24.025	24.06	24.025	24.06	800.0
2015-12-07	AIA	ETF	44.25	44.256	43.91	44.1	13631.0
2015-12-07	AIQ	ETF	8.81	9.45	7.92	8.63	16209.0
2015-12-07	AIRR	ETF	17.524	17.524	17.35	17.363	3100.0
2015-12-07	AIVI	ETF	39.05	39.05	38.81	38.94	46000.0
2015-12-07	ALTY	ETF	13.89	13.95	13.89	13.948	2100.0
2015-12-07	AMJ	ETF	26.55	26.55	24.27	25.22	18160160.0
2015-12-07	AMLP	ETF	52.8	53.2	49.0	50.75	9214160.0
2015-12-07	AMZA	ETF	102.1	103.9	89.5	93.1	20750.0
2015-12-07	ANGL	ETF	25.5	25.5	25.16	25.16	16400.0
2015-12-07	AOA	ETF	45.98	45.98	45.66	45.84	154500.0
2015-12-07	AOK	ETF	31.97	32.025	31.94	31.98	89940.0
2015-12-07	AOM	ETF	34.61	34.61	34.51	34.59	214548.0
2015-12-07	AOR	ETF	39.65	39.69	39.41	39.55	860247.0
2015-12-07	ARGT	ETF	18.16	18.2	17.65	17.76	57900.0
2015-12-07	ARKG	ETF	19.67	19.687	19.67	19.687	900.0
2015-12-07	ARKK	ETF	21.14	21.14	20.77	20.79	1400.0
2015-12-07	ARKQ	ETF	19.49	19.49	19.49	19.49	1100.0
2015-12-07	ARKW	ETF	24.08	24.08	23.73	23.76	5700.0
2015-12-07	ASEA	ETF	12.88	12.88	12.76	12.76	4700.0
2015-12-07	ASET	ETF	24.56	24.58	24.56	24.58	1100.0
2015-12-07	ASHR	ETF	36.67	36.78	36.09	36.27	1475300.0
2015-12-07	ASHS	ETF	45.8	46.0	45.57	45.7	53300.0
2015-12-07	ASHX	ETF	25.8	25.87	25.77	25.78	2922.0
2015-12-07	ATMP	ETF	16.93	16.93	15.93	16.62	362500.0
2015-12-07	AWAY	ETF	35.8	36.05	35.53	35.73	2836889.0
2015-12-07	BAB	ETF	29.2	29.3072	29.17	29.17	102792.0
2015-12-07	BAL	ETF	43.03	43.1	42.67	42.96	9264.0
2015-12-07	BBC	ETF	30.18	30.18	29.2	29.2	20512.0
2015-12-07	BBH	ETF	123.59	123.59	121.23	121.62	75900.0
2015-12-07	BBP	ETF	30.66	30.66	30.09	30.15	24600.0

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

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