PREVIEW / etf_daily / 2013-05-23

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-23.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-23	SPY	ETF	164.16	165.91	163.94	165.45	211064400.0
2013-05-23	QQQ	ETF	72.95	73.7	72.83	73.45	48229437.0
2013-05-23	IWM	ETF	96.65	97.93	96.51	97.9	44524500.0
2013-05-23	DIA	ETF	151.67	153.24	151.55	152.77	10474400.0
2013-05-23	GLD	ETF	134.51	134.84	133.12	134.61	10267600.0
2013-05-23	TLT	ETF	117.15	117.24	115.77	116.64	9207100.0
2013-05-23	AADR	ETF	34.5	34.5	34.5	34.5	400.0
2013-05-23	AAXJ	ETF	59.47	59.76	59.06	59.74	457700.0
2013-05-23	ACTV	ETF	6.17	6.25	6.1	6.22	261096.0
2013-05-23	ACWI	ETF	52.7	53.21	52.49	53.17	837600.0
2013-05-23	ACWV	ETF	62.77	63.0	61.98	62.96	63000.0
2013-05-23	ACWX	ETF	44.0	44.37	43.67	44.35	309129.0
2013-05-23	ADRE	ETF	38.09	38.3879	37.87	38.38	28290.0
2013-05-23	AFK	ETF	30.14	30.32	30.044	30.32	164396.0
2013-05-23	AGEM	ETF	22.05	22.38	22.05	22.38	4536.0
2013-05-23	AGG	ETF	110.03	110.05	109.8	109.88	1107200.0
2013-05-23	AGQ	ETF	90.2	92.52	88.68	92.0	456650.0
2013-05-23	AGZ	ETF	114.1	114.41	113.0001	113.13	22091.0
2013-05-23	AIA	ETF	45.88	46.2606	45.78	46.26	16822.0
2013-05-23	AIQ	ETF	12.84	13.0899	12.63	12.8	14157.0
2013-05-23	AIVI	ETF	43.79	44.16	43.51	43.99	234800.0
2013-05-23	AMJ	ETF	47.7	48.12	47.33	48.12	616163.0
2013-05-23	AMLP	ETF	90.2	90.25	89.25	89.8	642980.0
2013-05-23	ANGL	ETF	27.84	27.96	27.71	27.8	11800.0
2013-05-23	AOA	ETF	40.87	41.21	40.86	41.18	46400.0
2013-05-23	AOK	ETF	31.48	31.5399	31.34	31.51	38019.0
2013-05-23	AOM	ETF	33.18	33.34	33.18	33.3	26629.0
2013-05-23	AOR	ETF	36.35	36.5536	35.02	36.54	61810.0
2013-05-23	ARB	ETF	46.75	46.88	46.75	46.75	466402.0
2013-05-23	ARGT	ETF	17.52	17.7	17.52	17.7	1700.0
2013-05-23	ASEA	ETF	18.49	18.53	18.32	18.48	53900.0
2013-05-23	ATMP	ETF	27.05	27.05	26.58	26.83	150700.0
2013-05-23	AVIV	ETF	28.66	28.97	28.0	28.81	353398.0
2013-05-23	AWAY	ETF	29.99	30.72	28.54	30.47	734375.0
2013-05-23	BAB	ETF	30.37	30.38	30.2035	30.25	233045.0
2013-05-23	BAL	ETF	52.37	52.51	51.24	51.25	61166.0
2013-05-23	BALT	ETF	3.73	3.75	3.6	3.74	180200.0
2013-05-23	BBH	ETF	71.61	73.3	69.73	72.97	226600.0
2013-05-23	BCM	ETF	40.219	40.2799	40.219	40.2799	3784.0
2013-05-23	BIB	ETF	24.25	25.25	23.295	24.9825	510424.0
2013-05-23	BICK	ETF	23.69	23.6932	23.69	23.69	380.0
2013-05-23	BIL	ETF	91.62	91.62	91.6	91.62	434350.0
2013-05-23	BIS	ETF	1472.4	1530.0	1442.0	1445.2	457.0
2013-05-23	BIV	ETF	87.19	87.3	86.96	87.06	243600.0
2013-05-23	BIZD	ETF	20.5	20.5	20.15	20.37	9100.0
2013-05-23	BJK	ETF	42.21	42.43	41.95	42.34	33200.0
2013-05-23	BKF	ETF	38.97	39.25	38.66	39.21	157211.0
2013-05-23	BKLN	ETF	25.21	25.23	25.2	25.21	5034700.0
2013-05-23	BLV	ETF	91.32	91.32	90.61	91.02	32700.0
2013-05-23	BMVP	ETF	19.14	19.3633	19.07	19.3552	7880.0

> showing 50 of 996 rows — these rows as CSV

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