PREVIEW / etf_daily / 2014-03-26

all etf daily files

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

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-26	SPY	ETF	187.04	187.34	184.92	184.97	119843000.0
2014-03-26	QQQ	ETF	88.96	89.15	87.36	87.37	40930442.0
2014-03-26	IWM	ETF	117.63	117.68	114.65	114.69	69052500.0
2014-03-26	DIA	ETF	164.07	164.33	162.32	162.33	6133800.0
2014-03-26	GLD	ETF	126.27	126.38	125.13	125.41	8575400.0
2014-03-26	TLT	ETF	108.55	109.48	108.48	109.44	7147200.0
2014-03-26	AADR	ETF	37.7	37.7	37.44	37.5	1300.0
2014-03-26	AAXJ	ETF	58.19	58.3	57.83	57.83	418700.0
2014-03-26	ACWI	ETF	57.65	57.74	57.16	57.16	764200.0
2014-03-26	ACWV	ETF	63.36	63.7	63.19	63.3	28800.0
2014-03-26	ACWX	ETF	45.94	46.04	45.65	45.65	458562.0
2014-03-26	ADRE	ETF	35.53	35.67	35.27	35.27	4546.0
2014-03-26	AFK	ETF	31.58	31.6	31.38	31.41	12630.0
2014-03-26	AGG	ETF	107.75	107.98	107.72	107.98	593900.0
2014-03-26	AGQ	ETF	65.43	65.64	63.44	63.85	466600.0
2014-03-26	AGZ	ETF	111.56	111.6298	111.4336	111.6298	8539.0
2014-03-26	AIA	ETF	45.07	45.12	44.87	44.87	15487.0
2014-03-26	AIQ	ETF	32.71	34.9	32.1001	33.58	72776.0
2014-03-26	AIRR	ETF	19.91	19.91	19.4	19.41	38600.0
2014-03-26	AIVI	ETF	48.7	48.7	48.41	48.47	21100.0
2014-03-26	ALTL	ETF	33.57	33.57	33.543	33.543	2600.0
2014-03-26	AMJ	ETF	45.71	46.0	45.64	45.76	409911.0
2014-03-26	AMLP	ETF	87.25	87.4	87.0	87.15	609020.0
2014-03-26	ANGL	ETF	27.6	27.6	27.56	27.6	2000.0
2014-03-26	AOA	ETF	45.2	45.2	44.74	44.76	18400.0
2014-03-26	AOK	ETF	32.27	32.32	32.2099	32.22	36781.0
2014-03-26	AOM	ETF	34.75	34.75	34.53	34.53	19607.0
2014-03-26	AOR	ETF	39.05	39.05	38.73	38.73	23801.0
2014-03-26	ARGT	ETF	19.52	19.53	19.14	19.15	21800.0
2014-03-26	ASEA	ETF	15.71	15.76	15.68	15.76	3200.0
2014-03-26	ASHR	ETF	22.17	22.17	22.05	22.05	190000.0
2014-03-26	ATMP	ETF	27.24	27.35	27.24	27.3	15600.0
2014-03-26	AVIV	ETF	24.45	24.45	23.94	24.06	405702.0
2014-03-26	AWAY	ETF	40.21	40.48	38.66	38.86	3741192.0
2014-03-26	BAB	ETF	28.66	28.7866	28.6537	28.7246	104641.0
2014-03-26	BAL	ETF	60.23	60.44	56.27	56.67	90282.0
2014-03-26	BALT	ETF	6.43	6.48	5.94	5.98	770529.0
2014-03-26	BBH	ETF	92.89	93.86	90.59	90.59	276700.0
2014-03-26	BCM	ETF	40.606	40.606	40.53	40.53	908.0
2014-03-26	BFOR	ETF	7.6025	7.6125	7.465	7.4725	206800.0
2014-03-26	BIB	ETF	42.22	42.65	39.625	39.625	1049024.0
2014-03-26	BICK	ETF	23.78	23.78	23.78	23.78	401.0
2014-03-26	BIL	ETF	91.56	91.56	91.54	91.54	874300.0
2014-03-26	BIS	ETF	688.8	725.96	672.4	725.6	15163.5
2014-03-26	BIV	ETF	83.24	83.43	83.19	83.39	242800.0
2014-03-26	BIZD	ETF	20.69	20.69	20.47	20.47	7000.0
2014-03-26	BJK	ETF	51.34	51.36	50.65	50.88	26400.0
2014-03-26	BKF	ETF	35.18	35.34	34.9301	34.97	43486.0
2014-03-26	BKLN	ETF	24.79	24.81	24.79	24.8	2231700.0
2014-03-26	BLV	ETF	86.29	86.8	86.2	86.8	197400.0

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

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