PREVIEW / etf_daily / 2013-10-01

all etf daily files

  file:    by_date/etf_daily/2013/2013-10-01.parquet
  size:    41 KB
  rows:    1,014

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-10-01	SPY	ETF	168.14	169.5	167.97	169.34	127160000.0
2013-10-01	QQQ	ETF	78.87	79.72	78.8456	79.68	33129746.0
2013-10-01	IWM	ETF	106.56	107.93	106.45	107.85	39344400.0
2013-10-01	DIA	ETF	151.0	151.77	150.77	151.62	8616300.0
2013-10-01	GLD	ETF	125.25	125.26	123.81	124.59	16721100.0
2013-10-01	TLT	ETF	105.9	106.03	105.53	105.8	7592500.0
2013-10-01	AAXJ	ETF	58.69	59.27	58.6	59.27	354100.0
2013-10-01	ACTV	ETF	14.39	14.41	14.33	14.37	17934744.0
2013-10-01	ACWI	ETF	53.92	54.4	53.92	54.36	1159200.0
2013-10-01	ACWV	ETF	61.88	62.22	61.88	62.22	71800.0
2013-10-01	ACWX	ETF	44.8	45.23	44.8	45.18	267617.0
2013-10-01	ADRE	ETF	37.06	37.51	37.06	37.51	16230.0
2013-10-01	AFK	ETF	29.9	30.0832	29.9	29.96	34850.0
2013-10-01	AGEM	ETF	22.49	22.49	22.49	22.49	222.0
2013-10-01	AGG	ETF	107.08	107.1	106.86	106.93	2278900.0
2013-10-01	AGQ	ETF	75.0	77.24	72.52	76.44	1180925.0
2013-10-01	AGZ	ETF	110.89	111.02	110.65	110.93	198456.0
2013-10-01	AIA	ETF	46.73	47.245	46.73	47.15	55178.0
2013-10-01	AIQ	ETF	27.67	29.65	27.5	29.14	99426.0
2013-10-01	AIVI	ETF	45.41	45.78	45.39	45.71	32700.0
2013-10-01	ALTL	ETF	30.24	30.31	30.12	30.31	630.0
2013-10-01	AMJ	ETF	44.44	45.16	44.2	45.05	427071.0
2013-10-01	AMLP	ETF	88.15	88.8	88.0	88.7	875360.0
2013-10-01	ANGL	ETF	26.6	26.6	26.28	26.28	200.0
2013-10-01	AOA	ETF	42.13	42.38	42.13	42.38	11500.0
2013-10-01	AOK	ETF	31.35	31.4456	31.35	31.41	10051.0
2013-10-01	AOM	ETF	33.36	33.49	33.3499	33.46	20952.0
2013-10-01	AOR	ETF	36.83	37.079	36.83	37.02	18058.0
2013-10-01	ARGT	ETF	20.0	20.0	20.0	20.0	400.0
2013-10-01	ASEA	ETF	16.43	16.68	16.43	16.68	11500.0
2013-10-01	ATMP	ETF	26.49	26.6	26.17	26.38	71100.0
2013-10-01	AVIV	ETF	22.87	23.35	22.85	23.35	97740.0
2013-10-01	AWAY	ETF	28.01	28.349	27.361	27.9	1238609.0
2013-10-01	BAB	ETF	27.24	27.37	27.23	27.26	114546.0
2013-10-01	BAL	ETF	55.21	55.74	54.76	55.3201	32003.0
2013-10-01	BALT	ETF	4.91	5.32	4.91	5.14	1028186.0
2013-10-01	BBH	ETF	82.91	84.05	82.64	84.03	59400.0
2013-10-01	BCM	ETF	39.5901	39.5901	39.59	39.59	222.0
2013-10-01	BFOR	ETF	6.8175	6.895	6.8125	6.8925	224000.0
2013-10-01	BIB	ETF	32.925	34.0	32.925	34.0	170440.0
2013-10-01	BICK	ETF	23.56	23.8099	23.56	23.8099	2908.0
2013-10-01	BIL	ETF	91.6	91.6	91.56	91.6	2340450.0
2013-10-01	BIS	ETF	1014.4	1014.4	980.4	986.0	127.5
2013-10-01	BIV	ETF	83.21	83.27	83.1	83.2	185300.0
2013-10-01	BIZD	ETF	20.17	20.35	20.17	20.3	6500.0
2013-10-01	BJK	ETF	47.44	47.97	47.44	47.96	4500.0
2013-10-01	BKF	ETF	37.34	37.78	37.34	37.78	91996.0
2013-10-01	BKLN	ETF	24.68	24.7	24.63	24.66	5427400.0
2013-10-01	BLV	ETF	82.53	82.6	82.42	82.52	38800.0
2013-10-01	BMVP	ETF	20.3127	20.38	20.3127	20.3434	733.0

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

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