PREVIEW / etf_daily / 2011-12-08

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-08.parquet
  size:    37 KB
  rows:    891

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-08	SPY	ETF	125.9	126.18	123.65	123.95	240862800.0
2011-12-08	QQQ	ETF	56.74	57.15	56.01	56.12	51692562.0
2011-12-08	IWM	ETF	73.9	74.18	72.22	72.36	71486700.0
2011-12-08	DIA	ETF	121.5	121.81	119.64	119.94	9595600.0
2011-12-08	GLD	ETF	166.96	167.63	165.73	165.98	11734500.0
2011-12-08	TLT	ETF	117.72	119.33	117.41	119.16	8800500.0
2011-12-08	AADR	ETF	28.48	28.48	28.48	28.48	200.0
2011-12-08	AAXJ	ETF	51.55	51.82	50.61	50.83	424600.0
2011-12-08	ACTV	ETF	12.89	13.14	12.76	12.94	311605.0
2011-12-08	ACWI	ETF	43.0	43.06	42.2	42.3	494900.0
2011-12-08	ACWV	ETF	50.19	50.35	50.18	50.2	20100.0
2011-12-08	ACWX	ETF	37.8	37.922	37.2139	37.28	490190.0
2011-12-08	ADRE	ETF	39.81	39.948	39.041	39.16	35146.0
2011-12-08	AFK	ETF	27.16	27.27	26.5	26.77	10210.0
2011-12-08	AGEM	ETF	21.79	21.79	21.391	21.44	2851.0
2011-12-08	AGG	ETF	109.3	109.58	109.27	109.45	1228900.0
2011-12-08	AGQ	ETF	228.96	231.72	219.76	222.0	761275.0
2011-12-08	AGZ	ETF	112.6	112.8	112.4545	112.8	21003.0
2011-12-08	AIA	ETF	40.78	40.8029	40.0	40.07	41468.0
2011-12-08	AIQ	ETF	5.65	5.7	5.5	5.55	29449.0
2011-12-08	AIS	ETF	2.83	2.84	2.5	2.5	4077184.0
2011-12-08	AIVI	ETF	40.22	40.27	39.45	39.53	75500.0
2011-12-08	AMJ	ETF	37.48	37.54	37.02	37.09	919528.0
2011-12-08	AMLP	ETF	80.85	85.9	80.3	80.3	211500.0
2011-12-08	AOA	ETF	33.22	33.22	32.79	32.83	7600.0
2011-12-08	AOK	ETF	29.32	29.32	29.204	29.23	59018.0
2011-12-08	AOM	ETF	29.96	30.03	29.82	29.85	22621.0
2011-12-08	AOR	ETF	31.23	31.33	30.98	31.1	50497.0
2011-12-08	ARB	ETF	37.82	37.96	36.27	36.31	146196.0
2011-12-08	ARGT	ETF	22.52	22.52	22.36	22.36	5200.0
2011-12-08	ASEA	ETF	14.84	14.84	14.5	14.65	5900.0
2011-12-08	AWAY	ETF	25.84	26.47	25.589	25.74	228821.0
2011-12-08	BAB	ETF	28.37	28.6	28.24	28.59	123095.0
2011-12-08	BAL	ETF	57.0	57.13	56.76	57.09	16226.0
2011-12-08	BALT	ETF	5.08	5.2	4.8	4.82	81271.0
2011-12-08	BBH	ETF	34.9333	35.0667	34.5567	34.59	56100.0
2011-12-08	BCM	ETF	43.96	43.96	43.78	43.78	440.0
2011-12-08	BIB	ETF	8.0838	8.1402	7.9185	7.9185	17600.0
2011-12-08	BICK	ETF	24.49	24.49	24.012	24.012	7769.0
2011-12-08	BIL	ETF	91.68	91.68	91.66	91.68	248050.0
2011-12-08	BIS	ETF	5665.6	5729.6	5665.6	5729.6	2.81
2011-12-08	BITS	ETF	21.6	21.72	21.28	21.52	2975.0
2011-12-08	BIV	ETF	87.33	87.51	87.25	87.4	524400.0
2011-12-08	BJK	ETF	31.0	31.02	30.31	30.34	25900.0
2011-12-08	BKF	ETF	38.11	38.2	37.281	37.33	126131.0
2011-12-08	BKLN	ETF	23.88	23.9	23.78	23.87	62900.0
2011-12-08	BLV	ETF	90.55	91.22	90.38	91.06	64000.0
2011-12-08	BMVP	ETF	13.63	13.64	13.4	13.46	4045.0
2011-12-08	BND	ETF	83.4	83.66	83.4	83.6	1075900.0
2011-12-08	BNO	ETF	37.755	37.81	37.205	37.205	51400.0

> showing 50 of 891 rows — these rows as CSV

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