PREVIEW / etf_daily / 2015-05-20

all etf daily files

  file:    by_date/etf_daily/2015/2015-05-20.parquet
  size:    47 KB
  rows:    1,172

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-05-20	SPY	ETF	213.15	213.78	212.5	212.88	76857500.0
2015-05-20	QQQ	ETF	110.02	110.67	109.425	110.01	21131892.0
2015-05-20	IWM	ETF	125.17	125.46	124.34	125.11	20838500.0
2015-05-20	DIA	ETF	183.23	183.35	182.56	182.71	5080800.0
2015-05-20	GLD	ETF	116.03	116.38	115.76	116.08	4432600.0
2015-05-20	TLT	ETF	118.77	119.45	118.18	118.69	7789700.0
2015-05-20	AAXJ	ETF	67.77	67.92	67.47	67.77	2168000.0
2015-05-20	ACTX	ETF	2.95	2.95	2.95	2.95	16.0
2015-05-20	ACWF	ETF	25.52	25.57	25.46	25.46	18588.0
2015-05-20	ACWI	ETF	62.7	63.0	62.63	62.74	452100.0
2015-05-20	ACWV	ETF	73.7	73.91	73.47	73.69	117100.0
2015-05-20	ACWX	ETF	47.29	47.58	47.25	47.41	537890.0
2015-05-20	ADRE	ETF	36.83	37.11	36.83	36.94	17465.0
2015-05-20	AFK	ETF	26.58	26.76	26.57	26.64	29712.0
2015-05-20	AFTY	ETF	22.08	22.18	22.025	22.12	54200.0
2015-05-20	AGG	ETF	109.58	109.69	109.46	109.57	1584100.0
2015-05-20	AGQ	ETF	43.97	44.41	43.44	43.55	168500.0
2015-05-20	AGZ	ETF	113.2	113.38	113.1301	113.36	10971.0
2015-05-20	AGZD	ETF	24.43	24.515	24.43	24.445	5600.0
2015-05-20	AIA	ETF	53.04	53.2436	53.04	53.13	41104.0
2015-05-20	AIQ	ETF	20.74	20.8	20.52	20.56	7716.0
2015-05-20	AIRR	ETF	18.33	18.61	18.33	18.61	17600.0
2015-05-20	AIVI	ETF	46.26	46.48	46.19	46.35	32500.0
2015-05-20	AMJ	ETF	45.0	45.05	44.74	44.83	442871.0
2015-05-20	AMLP	ETF	84.65	84.7	84.1	84.2	546840.0
2015-05-20	AMZA	ETF	224.0	224.65	223.7	224.55	1030.0
2015-05-20	ANGL	ETF	27.61	27.8	27.55	27.6	16800.0
2015-05-20	AOA	ETF	49.04	49.04	48.81	48.88	22400.0
2015-05-20	AOK	ETF	33.0	33.08	32.96	33.04	15044.0
2015-05-20	AOM	ETF	35.79	35.99	35.79	35.93	50738.0
2015-05-20	AOR	ETF	41.73	41.73	41.55	41.63	40462.0
2015-05-20	ARGT	ETF	22.0	22.0	21.89	21.9	3800.0
2015-05-20	ARKG	ETF	23.2	23.21	23.2	23.21	600.0
2015-05-20	ARKK	ETF	21.22	21.22	21.22	21.22	500.0
2015-05-20	ARKQ	ETF	20.02	20.02	19.891	19.895	3600.0
2015-05-20	ARKW	ETF	23.05	23.07	23.04	23.07	1800.0
2015-05-20	ASEA	ETF	15.94	15.96	15.91	15.95	1700.0
2015-05-20	ASHR	ETF	49.26	49.39	49.18	49.3	1099400.0
2015-05-20	ASHS	ETF	61.0	61.85	60.76	61.27	59900.0
2015-05-20	ATMP	ETF	30.53	30.53	30.38	30.51	20900.0
2015-05-20	AWAY	ETF	28.27	28.52	27.82	28.43	1250325.0
2015-05-20	BAB	ETF	28.84	28.97	28.81	28.82	127345.0
2015-05-20	BAL	ETF	43.39	43.8728	43.15	43.54	6044.0
2015-05-20	BALT	ETF	1.44	1.47	1.38	1.46	246578.0
2015-05-20	BAR	ETF	2.7805	2.7805	2.7805	2.7805	3110.0
2015-05-20	BBC	ETF	33.87	34.96	33.86	34.69	21905.0
2015-05-20	BBH	ETF	134.12	136.07	132.78	135.27	150600.0
2015-05-20	BBP	ETF	32.33	32.689	31.98	32.452	20300.0
2015-05-20	BCHP	ETF	20.64	20.64	20.64	20.64	1084.0
2015-05-20	BCM	ETF	31.952	31.952	31.952	31.952	317.0

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

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