PREVIEW / etf_daily / 2013-05-31

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-31.parquet
  size:    41 KB
  rows:    1,004

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-31	SPY	ETF	165.37	166.31	163.13	163.45	176850100.0
2013-05-31	QQQ	ETF	73.65	74.21	73.17	73.25	38354676.0
2013-05-31	IWM	ETF	98.38	99.02	97.77	97.8	38953700.0
2013-05-31	DIA	ETF	152.61	153.73	150.9	151.1	7424700.0
2013-05-31	GLD	ETF	135.71	136.05	133.89	133.92	9726600.0
2013-05-31	TLT	ETF	114.97	115.02	113.17	114.45	18158800.0
2013-05-31	AADR	ETF	33.87	33.87	33.87	33.87	400.0
2013-05-31	AAXJ	ETF	58.94	58.98	58.14	58.14	579700.0
2013-05-31	ACTV	ETF	6.71	6.85	6.67	6.69	499243.0
2013-05-31	ACWI	ETF	52.5	52.67	51.99	51.99	1482500.0
2013-05-31	ACWV	ETF	61.29	61.52	60.74	60.79	101200.0
2013-05-31	ACWX	ETF	43.31	43.41	42.96	43.0	213512.0
2013-05-31	ADRE	ETF	37.6	37.6	37.12	37.19	59633.0
2013-05-31	AFK	ETF	30.23	30.4099	30.03	30.12	30054.0
2013-05-31	AGEM	ETF	21.78	21.8	21.54	21.6	15401.0
2013-05-31	AGG	ETF	109.4	109.47	108.88	109.11	1616800.0
2013-05-31	AGQ	ETF	89.6	90.36	88.28	88.4	613525.0
2013-05-31	AGZ	ETF	112.9	112.9	112.47	112.571	20252.0
2013-05-31	AIA	ETF	45.83	45.94	45.4	45.4	76227.0
2013-05-31	AIQ	ETF	15.35	16.95	14.95	16.21	113762.0
2013-05-31	AIVI	ETF	43.21	43.28	42.79	42.79	43600.0
2013-05-31	AMJ	ETF	45.5	45.95	45.12	45.45	1262727.0
2013-05-31	AMLP	ETF	86.7	87.95	86.7	87.0	901000.0
2013-05-31	ANGL	ETF	27.49	27.68	27.48	27.54	4700.0
2013-05-31	AOA	ETF	41.16	41.16	40.56	40.56	27300.0
2013-05-31	AOK	ETF	31.25	31.35	31.23	31.24	25780.0
2013-05-31	AOM	ETF	33.05	33.16	32.911	32.95	82222.0
2013-05-31	AOR	ETF	36.23	36.402	36.14	36.22	11126.0
2013-05-31	ARB	ETF	46.89	47.045	46.86	46.91	133155.0
2013-05-31	ASEA	ETF	17.8	17.8	17.46	17.51	147100.0
2013-05-31	ATMP	ETF	25.69	25.69	25.35	25.35	8700.0
2013-05-31	AVIV	ETF	26.05	26.639	25.62	25.92	291712.0
2013-05-31	AWAY	ETF	31.3	31.74	30.42	30.58	1202518.0
2013-05-31	BAB	ETF	30.17	30.17	29.811	29.95	507678.0
2013-05-31	BAL	ETF	50.19	50.19	49.511	49.511	18496.0
2013-05-31	BALT	ETF	3.66	3.7	3.65	3.65	108078.0
2013-05-31	BBH	ETF	73.4	73.53	71.95	71.95	84400.0
2013-05-31	BCM	ETF	40.386	40.386	40.386	40.386	616.0
2013-05-31	BIB	ETF	25.2275	25.4217	24.39	24.39	110416.0
2013-05-31	BICK	ETF	23.41	23.41	23.2	23.22	2949.0
2013-05-31	BIL	ETF	91.6	91.62	91.6	91.62	1031050.0
2013-05-31	BIS	ETF	1433.6	1466.76	1404.4	1466.76	123.0
2013-05-31	BIV	ETF	86.48	86.49	85.76	86.05	327000.0
2013-05-31	BIZD	ETF	20.15	20.18	19.98	19.98	4600.0
2013-05-31	BJK	ETF	42.56	42.56	41.91	41.91	6500.0
2013-05-31	BKF	ETF	38.19	38.19	37.46	37.52	112532.0
2013-05-31	BKLN	ETF	25.09	25.09	25.01	25.08	4120200.0
2013-05-31	BLV	ETF	89.65	89.65	88.63	89.01	117700.0
2013-05-31	BMVP	ETF	19.4233	19.5721	19.35	19.35	6962.0
2013-05-31	BND	ETF	82.62	82.65	82.19	82.4	1391000.0

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

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