PREVIEW / etf_daily / 2014-03-28

all etf daily files

  file:    by_date/etf_daily/2014/2014-03-28.parquet
  size:    44 KB
  rows:    1,080

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-03-28	SPY	ETF	185.11	186.42	185.0	185.49	101642000.0
2014-03-28	QQQ	ETF	87.15	88.01	86.81	87.05	39895065.0
2014-03-28	IWM	ETF	114.48	116.0	113.98	114.29	50558000.0
2014-03-28	DIA	ETF	162.61	163.82	162.32	162.85	4536000.0
2014-03-28	GLD	ETF	124.23	124.96	123.88	124.56	7253700.0
2014-03-28	TLT	ETF	109.86	109.89	109.02	109.37	6027000.0
2014-03-28	AADR	ETF	37.21	37.45	37.21	37.34	500.0
2014-03-28	AAXJ	ETF	58.6	59.24	58.38	58.89	246200.0
2014-03-28	ACWI	ETF	57.58	57.92	57.58	57.72	1341200.0
2014-03-28	ACWV	ETF	63.98	64.11	63.75	63.88	12600.0
2014-03-28	ACWX	ETF	46.28	46.45	46.25	46.28	393583.0
2014-03-28	ADRE	ETF	36.15	36.4153	36.13	36.13	18921.0
2014-03-28	AFK	ETF	31.57	31.57	31.15	31.27	29095.0
2014-03-28	AGG	ETF	108.1	108.1	107.84	107.9	865600.0
2014-03-28	AGQ	ETF	64.14	64.74	63.69	64.25	189400.0
2014-03-28	AGZ	ETF	111.56	111.612	111.47	111.522	10493.0
2014-03-28	AIA	ETF	45.72	46.0	45.7	45.77	10024.0
2014-03-28	AIQ	ETF	33.96	35.4	33.52	33.69	55841.0
2014-03-28	AIRR	ETF	19.44	19.5	19.23	19.26	37600.0
2014-03-28	AIVI	ETF	49.0	49.03	48.89	48.93	19400.0
2014-03-28	ALTL	ETF	33.64	33.64	33.55	33.55	1171.0
2014-03-28	AMJ	ETF	46.19	46.32	45.93	46.28	699468.0
2014-03-28	AMLP	ETF	87.5	87.95	87.3	87.95	351420.0
2014-03-28	ANGL	ETF	27.4	27.65	27.4	27.65	2000.0
2014-03-28	AOA	ETF	44.98	45.18	44.95	45.0	19700.0
2014-03-28	AOK	ETF	32.28	32.336	32.248	32.29	18925.0
2014-03-28	AOM	ETF	34.69	34.76	34.62	34.67	33876.0
2014-03-28	AOR	ETF	38.92	39.04	38.861	38.91	29710.0
2014-03-28	ARGT	ETF	19.6	19.62	19.6	19.62	1800.0
2014-03-28	ASEA	ETF	15.88	15.99	15.88	15.93	10000.0
2014-03-28	ASHR	ETF	21.83	22.0	21.83	21.98	259400.0
2014-03-28	ATMP	ETF	27.49	27.6	27.43	27.59	28800.0
2014-03-28	AVIV	ETF	24.08	24.42	23.97	24.08	103532.0
2014-03-28	AWAY	ETF	38.25	38.46	37.76	38.1	1402335.0
2014-03-28	BAB	ETF	28.88	28.88	28.7506	28.82	58934.0
2014-03-28	BAL	ETF	58.36	58.65	58.23	58.51	7410.0
2014-03-28	BALT	ETF	6.08	6.28	6.06	6.16	319157.0
2014-03-28	BBH	ETF	90.84	91.55	88.01	88.09	306100.0
2014-03-28	BCM	ETF	40.866	40.866	40.758	40.82	15170.0
2014-03-28	BFOR	ETF	7.4725	7.555	7.47	7.475	99200.0
2014-03-28	BIB	ETF	40.36	40.8	37.44	37.71	1002398.0
2014-03-28	BICK	ETF	24.28	24.473	24.28	24.33	3139.0
2014-03-28	BIL	ETF	91.54	91.56	91.54	91.54	195500.0
2014-03-28	BIS	ETF	722.0	764.0	701.6	759.2	14633.5
2014-03-28	BIV	ETF	83.46	83.5	83.23	83.26	144700.0
2014-03-28	BIZD	ETF	20.63	20.63	20.39	20.39	12700.0
2014-03-28	BJK	ETF	50.36	50.99	50.36	50.7	9000.0
2014-03-28	BKF	ETF	35.83	36.15	35.83	35.89	126244.0
2014-03-28	BKLN	ETF	24.81	24.82	24.81	24.82	1273500.0
2014-03-28	BLV	ETF	87.04	87.06	86.58	86.9	156600.0

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

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