PREVIEW / etf_daily / 2013-05-20

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-20.parquet
  size:    41 KB
  rows:    996

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
2013-05-20	SPY	ETF	166.78	167.58	166.61	166.93	85071200.0
2013-05-20	QQQ	ETF	74.09	74.425	73.89	74.19	25135782.0
2013-05-20	IWM	ETF	98.76	99.6	98.75	99.21	25027400.0
2013-05-20	DIA	ETF	153.04	153.56	152.82	153.04	4464700.0
2013-05-20	GLD	ETF	130.88	135.32	130.85	135.12	21594000.0
2013-05-20	TLT	ETF	117.63	117.67	116.79	116.92	5839800.0
2013-05-20	AAXJ	ETF	61.17	61.28	61.02	61.28	329100.0
2013-05-20	ACTV	ETF	6.21	6.23	5.96	6.22	382770.0
2013-05-20	ACWI	ETF	53.77	54.0	53.72	53.91	626200.0
2013-05-20	ACWV	ETF	64.11	64.12	63.85	64.0	34600.0
2013-05-20	ACWX	ETF	44.92	45.236	44.92	45.22	102005.0
2013-05-20	ADRE	ETF	39.14	39.37	39.14	39.37	40243.0
2013-05-20	AFK	ETF	30.23	30.432	30.2001	30.43	50086.0
2013-05-20	AGEM	ETF	22.79	22.955	22.77	22.8223	5371.0
2013-05-20	AGG	ETF	110.32	110.38	110.11	110.2	1710100.0
2013-05-20	AGQ	ETF	83.64	97.04	83.56	95.08	975200.0
2013-05-20	AGZ	ETF	113.18	113.23	113.13	113.21	33001.0
2013-05-20	AIA	ETF	47.24	47.35	47.228	47.35	4517.0
2013-05-20	AIQ	ETF	12.41	12.5899	12.28	12.44	43868.0
2013-05-20	AIVI	ETF	44.1	44.52	44.1	44.46	24300.0
2013-05-20	AMJ	ETF	47.21	48.15	47.21	47.78	463851.0
2013-05-20	AMLP	ETF	89.0	89.15	88.7	89.1	515100.0
2013-05-20	ANGL	ETF	27.63	27.94	27.63	27.94	1800.0
2013-05-20	AOA	ETF	41.69	41.81	41.63	41.73	33800.0
2013-05-20	AOK	ETF	31.74	31.759	31.7	31.72	33657.0
2013-05-20	AOM	ETF	33.6	33.63	33.5401	33.6	21556.0
2013-05-20	AOR	ETF	36.89	36.9888	36.8717	36.93	46970.0
2013-05-20	ARB	ETF	46.85	46.898	46.75	46.81	276703.0
2013-05-20	ARGT	ETF	18.07	18.21	18.05	18.2	1500.0
2013-05-20	ASEA	ETF	18.9	18.94	18.87	18.89	19200.0
2013-05-20	ATMP	ETF	26.67	26.69	26.55	26.68	56000.0
2013-05-20	AVIV	ETF	30.3	31.1	29.34	29.85	593951.0
2013-05-20	AWAY	ETF	30.09	30.77	29.8	30.65	586061.0
2013-05-20	BAB	ETF	30.4	30.45	30.3	30.34	190650.0
2013-05-20	BAL	ETF	54.48	54.68	53.797	54.01	31596.0
2013-05-20	BALT	ETF	3.86	4.037	3.86	3.98	89731.0
2013-05-20	BBH	ETF	73.01	73.38	71.85	72.04	190600.0
2013-05-20	BCM	ETF	40.62	40.65	40.52	40.521	11872.0
2013-05-20	BIB	ETF	25.02	25.4073	24.3475	24.5525	249628.0
2013-05-20	BICK	ETF	24.41	24.52	24.4	24.481	2015.0
2013-05-20	BIL	ETF	91.6	91.62	91.6	91.6	239050.0
2013-05-20	BIS	ETF	1430.8	1467.6	1413.44	1467.6	462.5
2013-05-20	BIV	ETF	87.56	87.57	87.34	87.43	223000.0
2013-05-20	BIZD	ETF	20.57	20.75	20.56	20.73	2500.0
2013-05-20	BJK	ETF	43.49	43.91	43.49	43.82	9500.0
2013-05-20	BKF	ETF	39.87	40.1	39.82	40.1	59424.0
2013-05-20	BKLN	ETF	25.22	25.22	25.21	25.22	1703900.0
2013-05-20	BLV	ETF	91.59	91.71	91.29	91.3	187000.0
2013-05-20	BMVP	ETF	19.51	19.5833	19.51	19.5434	863.0
2013-05-20	BND	ETF	83.29	83.34	83.12	83.2	1911900.0

> showing 50 of 996 rows — these rows as CSV

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