PREVIEW / etf_daily / 2014-04-08

all etf daily files

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

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-08	SPY	ETF	184.26	185.4	183.59	185.1	112660000.0
2014-04-08	QQQ	ETF	85.65	86.46	85.35	86.34	51495650.0
2014-04-08	IWM	ETF	112.81	114.2	112.2	113.61	60087900.0
2014-04-08	DIA	ETF	162.1	162.73	161.55	162.33	5930000.0
2014-04-08	GLD	ETF	126.34	126.34	125.9	126.09	6939100.0
2014-04-08	TLT	ETF	109.03	109.47	108.72	109.37	4213800.0
2014-04-08	AADR	ETF	37.11	37.22	37.08	37.2	10400.0
2014-04-08	AAXJ	ETF	60.34	60.7	60.27	60.42	301400.0
2014-04-08	ACWI	ETF	57.68	58.07	57.59	57.94	689700.0
2014-04-08	ACWV	ETF	63.94	64.21	63.77	64.14	12100.0
2014-04-08	ACWX	ETF	46.66	46.85	46.58	46.74	244393.0
2014-04-08	ADRE	ETF	37.56	37.8165	37.3601	37.38	11868.0
2014-04-08	AFK	ETF	31.3	31.94	31.3	31.71	46244.0
2014-04-08	AGG	ETF	107.98	108.15	107.93	108.07	1435700.0
2014-04-08	AGQ	ETF	66.02	66.13	65.25	65.46	192700.0
2014-04-08	AGZ	ETF	111.66	111.91	111.66	111.76	7687.0
2014-04-08	AIA	ETF	47.18	47.43	47.16	47.1901	20206.0
2014-04-08	AIQ	ETF	32.78	33.5	31.79	32.88	23688.0
2014-04-08	AIRR	ETF	19.13	19.258	19.05	19.17	13000.0
2014-04-08	AIVI	ETF	48.98	49.17	48.92	49.09	10100.0
2014-04-08	AMJ	ETF	46.78	47.38	46.624	47.3	199542.0
2014-04-08	AMLP	ETF	89.1	89.35	88.7	89.15	538460.0
2014-04-08	ANGL	ETF	27.63	27.63	27.49	27.57	5200.0
2014-04-08	AOA	ETF	44.84	45.04	44.69	44.96	23700.0
2014-04-08	AOK	ETF	32.23	32.3	32.204	32.296	13937.0
2014-04-08	AOM	ETF	34.6	34.68	34.53	34.61	58508.0
2014-04-08	AOR	ETF	38.78	38.9	38.68	38.9	39704.0
2014-04-08	ARGT	ETF	20.0	20.18	20.0	20.0	7500.0
2014-04-08	ASEA	ETF	16.27	16.42	16.27	16.39	14600.0
2014-04-08	ASHR	ETF	22.81	23.0	22.81	22.89	485700.0
2014-04-08	ATMP	ETF	28.02	28.23	27.98	28.19	96500.0
2014-04-08	AVIV	ETF	24.94	25.239	24.75	24.97	94245.0
2014-04-08	AWAY	ETF	34.16	35.69	34.01	35.16	3715621.0
2014-04-08	BAB	ETF	28.81	28.84	28.7	28.84	71335.0
2014-04-08	BAL	ETF	56.6601	57.66	56.6475	57.24	9707.0
2014-04-08	BALT	ETF	6.24	6.24	6.0	6.13	1390555.0
2014-04-08	BBH	ETF	87.51	88.08	85.45	86.72	440900.0
2014-04-08	BFOR	ETF	7.44	7.455	7.37	7.445	163200.0
2014-04-08	BIB	ETF	37.07	37.22	34.79	36.35	900006.0
2014-04-08	BICK	ETF	25.13	25.2596	25.05	25.05	3555.0
2014-04-08	BIL	ETF	91.56	91.56	91.54	91.54	402050.0
2014-04-08	BIS	ETF	765.6	807.6	755.2	772.8	19482.0
2014-04-08	BIV	ETF	83.46	83.54	83.32	83.54	198500.0
2014-04-08	BIZD	ETF	20.31	20.31	20.08	20.1	72400.0
2014-04-08	BJK	ETF	50.59	50.84	50.15	50.55	99900.0
2014-04-08	BKF	ETF	37.14	37.32	36.7901	36.84	106355.0
2014-04-08	BKLN	ETF	24.79	24.82	24.77	24.78	4492000.0
2014-04-08	BLV	ETF	86.77	87.01	86.46	86.98	75400.0
2014-04-08	BMVP	ETF	23.17	23.28	23.02	23.28	3964.0
2014-04-08	BND	ETF	81.23	81.3	81.16	81.27	674200.0

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

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