PREVIEW / etf_daily / 2011-11-30

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-30.parquet
  size:    37 KB
  rows:    895

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-11-30	SPY	ETF	123.49	125.22	120.0	124.99	324439500.0
2011-11-30	QQQ	ETF	55.84	56.44	55.67	56.39	66918515.0
2011-11-30	IWM	ETF	72.56	73.79	69.65	73.73	93802900.0
2011-11-30	DIA	ETF	118.41	120.39	118.41	120.19	11581500.0
2011-11-30	GLD	ETF	169.7	170.3	169.06	170.13	11821600.0
2011-11-30	TLT	ETF	118.34	118.56	117.26	117.88	11806800.0
2011-11-30	AAXJ	ETF	51.96	52.58	51.88	52.47	411500.0
2011-11-30	ACTV	ETF	12.85	12.94	12.56	12.68	982786.0
2011-11-30	ACWI	ETF	42.63	43.1	42.41	43.05	435900.0
2011-11-30	ACWX	ETF	37.75	38.19	37.69	38.14	319969.0
2011-11-30	ADRE	ETF	39.58	39.89	39.42	39.89	37543.0
2011-11-30	AFK	ETF	27.12	27.66	27.12	27.6599	9986.0
2011-11-30	AGEM	ETF	21.59	22.0601	21.59	22.0601	2800.0
2011-11-30	AGG	ETF	109.59	109.61	109.27	109.38	1280300.0
2011-11-30	AGQ	ETF	234.56	243.44	234.0	242.44	691425.0
2011-11-30	AGZ	ETF	112.3	112.66	112.13	112.489	77066.0
2011-11-30	AIA	ETF	41.07	41.47	40.9	41.46	76210.0
2011-11-30	AIQ	ETF	5.95	6.15	5.85	6.1	175975.0
2011-11-30	AIS	ETF	2.64	2.65	2.56	2.62	5347102.0
2011-11-30	AIVI	ETF	40.6	41.05	40.48	41.03	81600.0
2011-11-30	AMJ	ETF	37.45	37.88	36.83	36.92	1294651.0
2011-11-30	AMLP	ETF	80.1	80.5	79.65	79.85	214980.0
2011-11-30	AOA	ETF	32.85	33.2	32.81	33.2	17200.0
2011-11-30	AOK	ETF	29.16	29.28	29.16	29.28	54292.0
2011-11-30	AOM	ETF	29.86	29.97	29.84	29.97	47865.0
2011-11-30	AOR	ETF	30.92	31.22	30.92	31.22	20636.0
2011-11-30	ARB	ETF	37.84	37.95	37.25	37.61	368535.0
2011-11-30	ARGT	ETF	22.96	22.98	22.92	22.92	2600.0
2011-11-30	ASEA	ETF	15.19	15.28	15.07	15.09	9600.0
2011-11-30	AWAY	ETF	26.34	26.71	25.57	26.16	1165749.0
2011-11-30	BAB	ETF	28.47	28.48	28.3	28.464	143006.0
2011-11-30	BAL	ETF	57.83	57.95	56.16	56.5	56956.0
2011-11-30	BALT	ETF	4.69	5.18	4.6601	5.14	220500.0
2011-11-30	BBH	ETF	34.6167	35.2567	34.24	35.2533	159300.0
2011-11-30	BCM	ETF	44.426	44.43	44.426	44.43	326.0
2011-11-30	BIB	ETF	8.1237	8.3112	8.1175	8.3112	68216.0
2011-11-30	BICK	ETF	24.42	24.67	24.3725	24.5699	23450.0
2011-11-30	BIL	ETF	91.68	91.68	91.66	91.68	1701850.0
2011-11-30	BIS	ETF	5601.6	5620.8	5526.4	5526.4	5.6
2011-11-30	BITS	ETF	21.6	21.8	21.2	21.8	6120.0
2011-11-30	BIV	ETF	86.99	87.18	86.82	86.89	199800.0
2011-11-30	BJK	ETF	31.34	31.85	31.34	31.85	26800.0
2011-11-30	BKF	ETF	38.03	38.48	37.96	38.43	228510.0
2011-11-30	BKLN	ETF	23.89	23.92	23.76	23.91	67400.0
2011-11-30	BLNG	ETF	52.99	52.99	52.99	52.99	200.0
2011-11-30	BLV	ETF	90.41	90.46	89.68	90.16	58600.0
2011-11-30	BMVP	ETF	13.44	13.51	13.44	13.48	4711.0
2011-11-30	BND	ETF	83.49	83.5	83.15	83.36	1965300.0
2011-11-30	BNO	ETF	38.61	38.73	38.2	38.225	164600.0
2011-11-30	BOIL	ETF	2986000.0	3100000.0	2922000.0	2970000.0	0.6

> showing 50 of 895 rows — these rows as CSV

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