PREVIEW / etf_daily / 2014-05-07

all etf daily files

  file:    by_date/etf_daily/2014/2014-05-07.parquet
  size:    44 KB
  rows:    1,085

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-05-07	SPY	ETF	187.41	187.97	186.01	187.88	106500000.0
2014-05-07	QQQ	ETF	87.0	87.08	85.53	86.56	67489143.0
2014-05-07	IWM	ETF	110.23	110.45	108.43	110.14	64243800.0
2014-05-07	DIA	ETF	164.51	165.08	163.39	165.03	5576200.0
2014-05-07	GLD	ETF	125.52	125.57	123.92	124.17	8469900.0
2014-05-07	TLT	ETF	112.31	112.57	111.94	112.08	8199200.0
2014-05-07	AADR	ETF	37.6	37.6	37.22	37.42	1300.0
2014-05-07	AAXJ	ETF	59.44	59.59	59.18	59.58	240100.0
2014-05-07	ACWI	ETF	58.63	58.74	58.27	58.73	766800.0
2014-05-07	ACWV	ETF	65.29	65.49	64.97	65.42	37600.0
2014-05-07	ACWX	ETF	47.21	47.42	47.13	47.41	266670.0
2014-05-07	ADRE	ETF	37.82	37.9099	37.5539	37.9	11352.0
2014-05-07	AFK	ETF	33.02	33.25	32.6645	33.08	28622.0
2014-05-07	AGG	ETF	108.7	108.8	108.62	108.72	664900.0
2014-05-07	AGQ	ETF	61.96	62.05	60.43	60.53	241700.0
2014-05-07	AGZ	ETF	112.01	112.25	112.01	112.1542	7070.0
2014-05-07	AGZD	ETF	25.08	25.08	24.945	24.945	19600.0
2014-05-07	AIA	ETF	46.26	46.4765	46.217	46.452	14874.0
2014-05-07	AIQ	ETF	28.67	29.09	27.68	28.54	31910.0
2014-05-07	AIRR	ETF	18.85	18.85	18.559	18.719	21800.0
2014-05-07	AIVI	ETF	50.59	50.59	50.31	50.47	15900.0
2014-05-07	ALTL	ETF	33.7225	33.7225	33.7192	33.7192	540.0
2014-05-07	AMJ	ETF	49.17	49.7999	49.094	49.74	358590.0
2014-05-07	AMLP	ETF	90.7	91.2	90.25	91.2	483020.0
2014-05-07	ANGL	ETF	27.72	27.79	27.66	27.79	2600.0
2014-05-07	AOA	ETF	45.37	45.47	45.11	45.47	24600.0
2014-05-07	AOK	ETF	32.47	32.49	32.42	32.4719	10034.0
2014-05-07	AOM	ETF	34.83	34.91	34.73	34.91	10652.0
2014-05-07	AOR	ETF	39.08	39.25	38.981	39.25	22093.0
2014-05-07	ARGT	ETF	20.07	20.11	20.07	20.11	900.0
2014-05-07	ASEA	ETF	16.56	16.56	16.49	16.5	3100.0
2014-05-07	ASHR	ETF	21.82	21.92	21.82	21.88	43000.0
2014-05-07	ATMP	ETF	29.67	29.93	29.42	29.67	37900.0
2014-05-07	AVIV	ETF	26.76	27.13	26.58	26.96	251958.0
2014-05-07	AWAY	ETF	31.83	31.94	30.2	30.69	1856319.0
2014-05-07	BAB	ETF	29.28	29.28	29.1938	29.22	91631.0
2014-05-07	BAL	ETF	57.4864	57.55	57.014	57.09	8276.0
2014-05-07	BALT	ETF	6.01	6.05	5.67	5.85	911515.0
2014-05-07	BBH	ETF	87.63	87.65	85.2	86.75	105800.0
2014-05-07	BCHP	ETF	20.05	20.09	20.01	20.09	3150.0
2014-05-07	BCM	ETF	41.14	41.14	41.14	41.14	16072.0
2014-05-07	BFOR	ETF	7.41	7.4175	7.32	7.41	251200.0
2014-05-07	BIB	ETF	37.145	37.4	35.05	36.505	600814.0
2014-05-07	BICK	ETF	24.62	24.62	24.4619	24.51	2831.0
2014-05-07	BIL	ETF	91.52	91.54	91.52	91.52	75900.0
2014-05-07	BIS	ETF	718.8	766.0	718.4	737.2	19181.5
2014-05-07	BIV	ETF	83.99	84.12	83.88	84.08	135700.0
2014-05-07	BIZD	ETF	19.65	19.69	19.5	19.64	15800.0
2014-05-07	BJK	ETF	49.74	49.74	49.35	49.56	242200.0
2014-05-07	BKF	ETF	36.08	36.53	36.08	36.49	34473.0

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

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