PREVIEW / etf_daily / 2012-11-30

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-30.parquet
  size:    39 KB
  rows:    939

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-11-30	SPY	ETF	142.14	142.42	141.66	142.15	136568300.0
2012-11-30	QQQ	ETF	65.92	65.97	65.61	65.8	33502042.0
2012-11-30	IWM	ETF	82.4	82.41	81.73	82.08	35722500.0
2012-11-30	DIA	ETF	130.25	130.46	129.78	130.1	4979600.0
2012-11-30	GLD	ETF	166.94	167.22	165.53	166.05	8412300.0
2012-11-30	TLT	ETF	125.48	125.54	124.71	124.79	3702300.0
2012-11-30	AADR	ETF	30.44	30.49	30.44	30.47	400.0
2012-11-30	AAXJ	ETF	58.36	58.36	58.02	58.2	193900.0
2012-11-30	ACTV	ETF	5.63	5.66	5.32	5.36	2134838.0
2012-11-30	ACWI	ETF	47.23	47.28	47.08	47.19	720000.0
2012-11-30	ACWV	ETF	56.64	56.71	56.41	56.68	5700.0
2012-11-30	ACWX	ETF	40.5	40.741	40.49	40.59	321956.0
2012-11-30	ADRE	ETF	38.51	38.5365	38.2901	38.4	21866.0
2012-11-30	AFK	ETF	30.16	30.23	30.03	30.23	34987.0
2012-11-30	AGEM	ETF	22.41	22.42	22.34	22.42	3192.0
2012-11-30	AGG	ETF	112.26	112.32	112.19	112.25	908600.0
2012-11-30	AGQ	ETF	224.2	226.2	211.84	215.36	418275.0
2012-11-30	AGZ	ETF	113.96	114.0099	113.65	113.65	28838.0
2012-11-30	AIA	ETF	46.11	46.34	46.11	46.2	61923.0
2012-11-30	AIQ	ETF	6.0	6.4	5.95	6.2	27942.0
2012-11-30	AIVI	ETF	40.62	40.65	40.44	40.56	37300.0
2012-11-30	AMJ	ETF	39.83	39.86	39.55	39.71	639751.0
2012-11-30	AMLP	ETF	81.7	81.75	81.25	81.7	372280.0
2012-11-30	ANGL	ETF	27.07	27.09	27.0	27.01	10000.0
2012-11-30	AOA	ETF	36.75	36.83	36.71	36.79	5300.0
2012-11-30	AOK	ETF	30.5639	30.59	30.5586	30.5696	7161.0
2012-11-30	AOM	ETF	31.66	31.71	31.63	31.71	28382.0
2012-11-30	AOR	ETF	33.63	33.81	33.63	33.7539	16314.0
2012-11-30	ARB	ETF	37.1	37.1	36.26	36.37	161905.0
2012-11-30	ARGT	ETF	16.14	16.14	16.14	16.14	50.0
2012-11-30	ASEA	ETF	16.63	16.75	16.63	16.74	1400.0
2012-11-30	AWAY	ETF	21.0	21.13	20.47	20.48	380331.0
2012-11-30	BAB	ETF	30.62	30.65	30.5	30.52	568168.0
2012-11-30	BAL	ETF	48.04	48.2	47.8401	48.1	5394.0
2012-11-30	BALT	ETF	3.0	3.0	2.85	2.89	415523.0
2012-11-30	BBH	ETF	55.06	55.06	54.3	54.45	26500.0
2012-11-30	BIB	ETF	15.155	15.155	14.79	14.87	43568.0
2012-11-30	BICK	ETF	23.88	23.88	23.8348	23.8348	534.0
2012-11-30	BIL	ETF	91.64	91.64	91.62	91.62	701350.0
2012-11-30	BIS	ETF	2576.4	2618.0	2568.8	2605.2	17.5
2012-11-30	BIV	ETF	90.6	90.67	90.55	90.63	330200.0
2012-11-30	BJK	ETF	35.78	35.84	35.72	35.8	3500.0
2012-11-30	BKF	ETF	38.33	38.38	38.18	38.27	159226.0
2012-11-30	BKLN	ETF	24.7	24.72	24.69	24.72	614200.0
2012-11-30	BLV	ETF	97.29	97.29	96.81	96.89	100000.0
2012-11-30	BMVP	ETF	15.93	16.0	15.92	16.0	7735.0
2012-11-30	BND	ETF	85.06	85.07	84.94	84.94	976300.0
2012-11-30	BNO	ETF	40.56	40.735	40.485	40.68	22400.0
2012-11-30	BOIL	ETF	959800.0	964400.0	897800.0	913400.0	19.8
2012-11-30	BOND	ETF	110.24	110.24	110.06	110.13	476043.0

> showing 50 of 939 rows — these rows as CSV

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