PREVIEW / etf_daily / 2011-12-07

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-07.parquet
  size:    37 KB
  rows:    890

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
2011-12-07	SPY	ETF	125.84	127.26	124.97	126.73	237802500.0
2011-12-07	QQQ	ETF	56.9	57.34	56.35	57.08	44576158.0
2011-12-07	IWM	ETF	74.28	75.06	73.13	74.68	55904400.0
2011-12-07	DIA	ETF	121.06	122.57	120.58	122.07	9026700.0
2011-12-07	GLD	ETF	168.79	169.52	167.76	169.4	10361300.0
2011-12-07	TLT	ETF	117.33	118.24	116.85	117.69	6588300.0
2011-12-07	AAXJ	ETF	52.22	52.52	51.8	52.37	481300.0
2011-12-07	ACTV	ETF	13.22	13.22	12.71	12.94	300060.0
2011-12-07	ACWI	ETF	43.01	43.61	42.73	43.47	679400.0
2011-12-07	ACWX	ETF	37.94	38.52	37.825	38.4	346327.0
2011-12-07	ADRE	ETF	40.34	40.52	40.08	40.36	34759.0
2011-12-07	AFK	ETF	27.31	27.5	27.17	27.5	16466.0
2011-12-07	AGEM	ETF	22.16	22.16	21.84	22.08	12027.0
2011-12-07	AGG	ETF	109.22	109.43	109.06	109.34	691000.0
2011-12-07	AGQ	ETF	239.16	240.76	232.56	236.04	402275.0
2011-12-07	AGZ	ETF	112.7493	112.7493	112.3535	112.5297	21216.0
2011-12-07	AIA	ETF	41.05	41.41	40.91	41.29	48390.0
2011-12-07	AIQ	ETF	5.65	5.75	5.55	5.75	7117.0
2011-12-07	AIS	ETF	2.83	2.83	2.7	2.78	2401820.0
2011-12-07	AIVI	ETF	40.38	40.88	40.08	40.78	283900.0
2011-12-07	AMJ	ETF	37.52	37.64	37.42	37.57	623122.0
2011-12-07	AMLP	ETF	80.9	81.2	80.7	80.95	274560.0
2011-12-07	AOA	ETF	33.26	33.41	33.08	33.41	5000.0
2011-12-07	AOK	ETF	29.33	29.37	29.251	29.32	18146.0
2011-12-07	AOM	ETF	29.97	30.13	29.92	30.11	21963.0
2011-12-07	AOR	ETF	31.25	31.5	31.16	31.45	28743.0
2011-12-07	ARB	ETF	37.84	38.38	37.03	38.22	127815.0
2011-12-07	ARGT	ETF	22.92	22.92	22.92	22.92	1750.0
2011-12-07	ASEA	ETF	14.86	15.08	14.86	14.99	8200.0
2011-12-07	AWAY	ETF	25.23	26.39	25.0	25.99	217175.0
2011-12-07	BAB	ETF	28.29	28.43	28.2206	28.36	133447.0
2011-12-07	BAL	ETF	57.62	57.62	56.84	57.48	11877.0
2011-12-07	BALT	ETF	5.09	5.24	5.0	5.13	76360.0
2011-12-07	BBH	ETF	34.91	35.1333	34.72	35.0233	128400.0
2011-12-07	BCM	ETF	44.39	44.4	44.288	44.329	5768.0
2011-12-07	BIB	ETF	8.1463	8.1937	8.0	8.1762	29880.0
2011-12-07	BICK	ETF	24.75	25.026	24.67	25.01	5622.0
2011-12-07	BIL	ETF	91.68	91.68	91.66	91.68	259950.0
2011-12-07	BIS	ETF	5705.6	5705.6	5649.6	5649.6	2.81
2011-12-07	BITS	ETF	21.4	21.6	21.4	21.598	5000.0
2011-12-07	BIV	ETF	87.27	87.4	87.14	87.34	925900.0
2011-12-07	BJK	ETF	30.93	31.54	30.93	31.54	9300.0
2011-12-07	BKF	ETF	38.44	38.71	38.205	38.65	76652.0
2011-12-07	BKLN	ETF	23.91	23.92	23.85	23.91	18500.0
2011-12-07	BLV	ETF	90.41	90.72	90.04	90.57	45600.0
2011-12-07	BMVP	ETF	13.57	13.76	13.57	13.76	4125.0
2011-12-07	BND	ETF	83.35	83.52	83.26	83.41	1397000.0
2011-12-07	BNO	ETF	38.235	38.235	37.865	37.96	27600.0
2011-12-07	BOIL	ETF	2769000.0	2771000.0	2711000.0	2734000.0	0.2
2011-12-07	BRF	ETF	44.35	44.51	44.0	44.37	180780.0

> showing 50 of 890 rows — these rows as CSV

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