PREVIEW / etf_daily / 2015-07-29

all etf daily files

  file:    by_date/etf_daily/2015/2015-07-29.parquet
  size:    48 KB
  rows:    1,196

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-07-29	SPY	ETF	209.48	211.04	209.31	210.77	105791300.0
2015-07-29	QQQ	ETF	111.37	111.79	110.94	111.55	26714068.0
2015-07-29	IWM	ETF	121.36	122.33	120.97	121.94	32411300.0
2015-07-29	DIA	ETF	176.33	177.56	176.17	177.26	4175900.0
2015-07-29	GLD	ETF	104.93	105.63	104.49	105.17	5616900.0
2015-07-29	TLT	ETF	121.02	121.17	120.42	120.7	6706400.0
2015-07-29	AAXJ	ETF	58.99	59.71	58.97	59.59	1413400.0
2015-07-29	ACTX	ETF	1.18	1.77	1.18	1.77	349.0
2015-07-29	ACWI	ETF	59.51	59.99	59.49	59.9	589300.0
2015-07-29	ACWV	ETF	70.5	71.07	70.5	71.04	77900.0
2015-07-29	ACWX	ETF	43.61	43.962	43.59	43.87	447750.0
2015-07-29	ADRE	ETF	32.5	32.78	32.49	32.7201	3728.0
2015-07-29	AFK	ETF	22.35	22.74	22.35	22.74	10592.0
2015-07-29	AFTY	ETF	18.74	18.9	18.64	18.84	20300.0
2015-07-29	AGG	ETF	109.09	109.12	108.94	109.06	2273500.0
2015-07-29	AGGY	ETF	49.91	49.91	49.91	49.91	9000.0
2015-07-29	AGQ	ETF	31.78	32.65	31.57	32.25	127100.0
2015-07-29	AGZ	ETF	113.4	113.4	113.11	113.25	12689.0
2015-07-29	AGZD	ETF	24.34	24.405	24.29	24.31	7200.0
2015-07-29	AIA	ETF	47.49	47.9	47.49	47.85	21450.0
2015-07-29	AIQ	ETF	15.68	15.68	14.73	14.76	43578.0
2015-07-29	AIRR	ETF	16.96	17.32	16.96	17.31	18300.0
2015-07-29	AIVI	ETF	42.78	43.12	42.76	42.97	20800.0
2015-07-29	ALTY	ETF	14.78	14.87	14.4	14.4	25100.0
2015-07-29	AMJ	ETF	38.28	39.32	38.1001	39.26	2481582.0
2015-07-29	AMLP	ETF	76.8	78.05	76.55	78.0	1182520.0
2015-07-29	AMZA	ETF	189.75	194.5	183.2	189.0	3380.0
2015-07-29	ANGL	ETF	27.19	27.19	27.01	27.16	18200.0
2015-07-29	AOA	ETF	47.08	47.38	47.03	47.33	62600.0
2015-07-29	AOK	ETF	32.4	32.5	32.39	32.48	13559.0
2015-07-29	AOM	ETF	35.0	35.1891	35.0	35.16	36763.0
2015-07-29	AOR	ETF	40.37	40.502	40.325	40.44	45399.0
2015-07-29	ARGT	ETF	18.58	18.71	18.58	18.71	85200.0
2015-07-29	ARKG	ETF	22.79	22.94	22.79	22.902	1400.0
2015-07-29	ARKK	ETF	21.82	21.82	21.82	21.82	200.0
2015-07-29	ARKQ	ETF	19.67	19.74	19.67	19.74	1100.0
2015-07-29	ARKW	ETF	23.89	23.89	23.61	23.85	3700.0
2015-07-29	ASEA	ETF	14.54	14.61	14.54	14.61	2900.0
2015-07-29	ASHR	ETF	40.82	41.28	40.75	41.05	2194400.0
2015-07-29	ASHS	ETF	50.46	51.13	50.45	50.86	86300.0
2015-07-29	ATMP	ETF	26.08	26.57	25.91	26.56	464100.0
2015-07-29	AWAY	ETF	29.29	29.47	28.72	29.05	1809525.0
2015-07-29	BAB	ETF	28.93	29.0228	28.8301	28.95	36220.0
2015-07-29	BAL	ETF	42.8	42.85	42.68	42.68	1680.0
2015-07-29	BBC	ETF	37.0	37.0	35.46	35.96	28433.0
2015-07-29	BBH	ETF	140.44	140.57	136.6	137.54	214600.0
2015-07-29	BBP	ETF	36.49	36.49	35.144	35.47	19800.0
2015-07-29	BCM	ETF	28.09	28.31	28.09	28.27	17282.0
2015-07-29	BFOR	ETF	8.125	8.2225	8.125	8.2225	30400.0
2015-07-29	BIB	ETF	97.92	97.99	92.46	93.99	976108.0

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

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