PREVIEW / etf_daily / 2012-08-13

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-13.parquet
  size:    38 KB
  rows:    932

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
2012-08-13	SPY	ETF	140.6	140.84	140.04	140.77	79426900.0
2012-08-13	QQQ	ETF	66.84	67.03	66.5	67.02	19890257.0
2012-08-13	IWM	ETF	79.8	80.01	78.89	79.79	31544800.0
2012-08-13	DIA	ETF	131.74	131.9	131.02	131.62	3986700.0
2012-08-13	GLD	ETF	157.05	157.45	155.9	155.99	4573300.0
2012-08-13	TLT	ETF	126.11	126.38	125.49	125.49	3543700.0
2012-08-13	AADR	ETF	29.0	29.0	29.0	29.0	300.0
2012-08-13	AAXJ	ETF	54.17	54.37	53.95	54.19	176000.0
2012-08-13	ACTV	ETF	11.25	11.26	11.03	11.22	199518.0
2012-08-13	ACWI	ETF	45.6	45.62	45.29	45.52	629800.0
2012-08-13	ACWV	ETF	55.97	56.26	55.51	55.63	8200.0
2012-08-13	ACWX	ETF	38.52	38.59	38.28	38.43	62642.0
2012-08-13	ADRE	ETF	39.16	39.31	38.93	39.06	54620.0
2012-08-13	AFK	ETF	29.218	29.29	29.081	29.26	38810.0
2012-08-13	AGEM	ETF	21.8936	22.57	21.86	22.0565	21397.0
2012-08-13	AGG	ETF	111.92	111.99	111.86	111.86	570500.0
2012-08-13	AGQ	ETF	156.6	157.2	153.6	154.12	170000.0
2012-08-13	AGZ	ETF	113.59	113.59	113.44	113.56	8820.0
2012-08-13	AIA	ETF	43.42	43.5624	43.27	43.43	20390.0
2012-08-13	AIQ	ETF	5.85	6.0	5.8	5.85	14918.0
2012-08-13	AIVI	ETF	39.29	39.36	39.03	39.17	28300.0
2012-08-13	AMJ	ETF	39.62	39.72	39.38	39.41	462819.0
2012-08-13	AMLP	ETF	81.1	81.4	81.0	81.1	259200.0
2012-08-13	ANGL	ETF	26.45	26.45	26.3	26.3	3300.0
2012-08-13	AOA	ETF	35.91	35.91	35.73	35.89	3100.0
2012-08-13	AOK	ETF	30.17	30.2	30.1508	30.1664	6360.0
2012-08-13	AOM	ETF	31.18	31.2046	31.13	31.17	8445.0
2012-08-13	AOR	ETF	33.09	33.208	33.04	33.105	23331.0
2012-08-13	ARB	ETF	36.0	36.17	35.08	36.14	149760.0
2012-08-13	ARGT	ETF	17.32	17.32	17.32	17.32	450.0
2012-08-13	ASEA	ETF	16.33	16.41	16.33	16.36	1000.0
2012-08-13	AWAY	ETF	23.84	24.01	23.4	23.84	176769.0
2012-08-13	BAB	ETF	30.15	30.28	30.15	30.19	155596.0
2012-08-13	BAL	ETF	47.98	48.33	47.38	47.95	23358.0
2012-08-13	BALT	ETF	3.41	3.43	3.33	3.33	63029.0
2012-08-13	BBH	ETF	49.89	49.89	49.28	49.59	16700.0
2012-08-13	BCM	ETF	44.22	44.22	44.12	44.12	929.0
2012-08-13	BIB	ETF	13.6788	13.6788	13.5775	13.5775	18992.0
2012-08-13	BICK	ETF	23.19	23.28	23.1073	23.168	4264.0
2012-08-13	BIL	ETF	91.64	91.64	91.62	91.62	1007900.0
2012-08-13	BIS	ETF	3014.4	3022.4	2976.0	2976.0	25.0
2012-08-13	BIV	ETF	89.36	89.46	89.31	89.31	221800.0
2012-08-13	BJK	ETF	30.73	30.76	30.72	30.73	2800.0
2012-08-13	BKF	ETF	37.04	37.15	36.76	36.98	131424.0
2012-08-13	BKLN	ETF	24.67	24.72	24.67	24.72	193600.0
2012-08-13	BLV	ETF	96.82	96.94	96.52	96.54	75400.0
2012-08-13	BMVP	ETF	15.847	15.853	15.743	15.85	1316.0
2012-08-13	BND	ETF	84.7	84.77	84.68	84.69	911800.0
2012-08-13	BNO	ETF	40.52	40.625	40.065	40.205	91200.0
2012-08-13	BOIL	ETF	866400.0	873000.0	844000.0	849800.0	7.6

> showing 50 of 932 rows — these rows as CSV

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