PREVIEW / etf_daily / 2014-04-23

all etf daily files

  file:    by_date/etf_daily/2014/2014-04-23.parquet
  size:    43 KB
  rows:    1,078

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
2014-04-23	SPY	ETF	187.82	187.92	187.3	187.45	73869000.0
2014-04-23	QQQ	ETF	87.55	87.56	86.71	86.76	34376729.0
2014-04-23	IWM	ETF	114.48	114.77	113.77	113.9	33859500.0
2014-04-23	DIA	ETF	164.94	164.99	164.45	164.64	3546100.0
2014-04-23	GLD	ETF	123.7	123.94	123.38	123.76	3736600.0
2014-04-23	TLT	ETF	110.6	111.05	110.53	110.96	5748600.0
2014-04-23	AADR	ETF	37.76	38.06	37.76	38.01	21400.0
2014-04-23	AAXJ	ETF	60.1	60.24	59.79	60.02	650100.0
2014-04-23	ACWI	ETF	58.64	58.64	58.41	58.48	418900.0
2014-04-23	ACWV	ETF	64.77	64.8	64.59	64.65	87700.0
2014-04-23	ACWX	ETF	47.15	47.15	46.95	47.03	190967.0
2014-04-23	ADRE	ETF	37.32	37.32	37.0701	37.24	7204.0
2014-04-23	AFK	ETF	32.41	32.4799	31.97	32.03	72050.0
2014-04-23	AGG	ETF	108.24	108.36	108.21	108.27	746000.0
2014-04-23	AGQ	ETF	61.7	62.03	61.44	61.6	124200.0
2014-04-23	AGZ	ETF	111.96	112.01	111.86	112.01	13526.0
2014-04-23	AIA	ETF	47.14	47.14	46.83	46.9501	27919.0
2014-04-23	AIQ	ETF	30.8	31.32	30.13	30.24	19488.0
2014-04-23	AIRR	ETF	19.72	19.72	19.46	19.5	19100.0
2014-04-23	AIVI	ETF	49.71	49.97	49.53	49.58	47400.0
2014-04-23	AMJ	ETF	48.5	48.7056	48.36	48.37	582102.0
2014-04-23	AMLP	ETF	90.75	91.0	90.55	90.65	432740.0
2014-04-23	ANGL	ETF	27.75	27.75	27.75	27.75	200.0
2014-04-23	AOA	ETF	45.31	45.38	45.23	45.31	14200.0
2014-04-23	AOK	ETF	32.4699	32.4699	32.414	32.45	11779.0
2014-04-23	AOM	ETF	34.85	34.85	34.77	34.81	22068.0
2014-04-23	AOR	ETF	39.1	39.152	39.0701	39.09	9948.0
2014-04-23	ARGT	ETF	19.7	19.96	19.7	19.87	2900.0
2014-04-23	ASEA	ETF	16.34	16.34	16.26	16.31	6700.0
2014-04-23	ASHR	ETF	22.13	22.19	22.1	22.17	69800.0
2014-04-23	ATMP	ETF	28.96	29.01	28.87	28.89	8400.0
2014-04-23	AVIV	ETF	25.62	26.3	25.45	26.15	424040.0
2014-04-23	AWAY	ETF	37.41	37.41	36.545	37.0	3086476.0
2014-04-23	BAB	ETF	28.84	28.91	28.78	28.8537	96789.0
2014-04-23	BAL	ETF	56.81	57.39	56.09	57.39	15689.0
2014-04-23	BALT	ETF	6.48	6.54	6.28	6.38	366457.0
2014-04-23	BBH	ETF	90.09	90.09	87.5	87.98	173300.0
2014-04-23	BCHP	ETF	20.12	20.26	20.09	20.104	10840.0
2014-04-23	BCM	ETF	41.44	41.47	41.42	41.42	6120.0
2014-04-23	BFOR	ETF	7.57	7.5825	7.5425	7.545	47600.0
2014-04-23	BIB	ETF	39.45	39.45	37.1501	37.74	1026396.0
2014-04-23	BICK	ETF	24.94	24.94	24.68	24.73	473.0
2014-04-23	BIL	ETF	91.54	91.54	91.52	91.54	188500.0
2014-04-23	BIS	ETF	690.4	732.0	690.0	722.4	15934.0
2014-04-23	BIV	ETF	83.67	83.77	83.56	83.67	830600.0
2014-04-23	BIZD	ETF	20.18	20.18	20.07	20.14	10900.0
2014-04-23	BJK	ETF	51.51	51.57	51.07	51.26	14900.0
2014-04-23	BKF	ETF	36.32	36.32	36.07	36.28	51194.0
2014-04-23	BKLN	ETF	24.67	24.68	24.66	24.67	1977100.0
2014-04-23	BLNG	ETF	35.78	35.79	35.74	35.75	16200.0

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

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