PREVIEW / etf_daily / 2012-11-27

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-27.parquet
  size:    39 KB
  rows:    950

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-27	SPY	ETF	140.91	141.39	140.24	140.33	128646200.0
2012-11-27	QQQ	ETF	65.16	65.4	64.85	64.96	25828579.0
2012-11-27	IWM	ETF	80.68	81.23	80.57	80.63	39942000.0
2012-11-27	DIA	ETF	129.18	129.65	128.51	128.68	4910000.0
2012-11-27	GLD	ETF	169.14	169.4	168.62	168.71	7314400.0
2012-11-27	TLT	ETF	124.94	125.39	124.7	125.29	2544400.0
2012-11-27	AADR	ETF	29.94	30.15	29.9	29.95	3000.0
2012-11-27	AAXJ	ETF	57.32	57.48	57.13	57.18	214700.0
2012-11-27	ACTV	ETF	4.8	4.8	4.69	4.71	488713.0
2012-11-27	ACWI	ETF	46.77	46.87	46.52	46.58	400600.0
2012-11-27	ACWV	ETF	56.17	56.25	56.0	56.0	11600.0
2012-11-27	ACWX	ETF	40.15	40.2	39.95	39.95	127851.0
2012-11-27	ADRE	ETF	38.39	38.46	37.975	38.03	29735.0
2012-11-27	AFK	ETF	30.62	30.62	30.3	30.31	27997.0
2012-11-27	AGEM	ETF	22.12	22.33	22.08	22.16	3776.0
2012-11-27	AGG	ETF	112.01	112.17	112.01	112.15	571900.0
2012-11-27	AGQ	ETF	223.72	225.28	222.2	223.48	216000.0
2012-11-27	AGZ	ETF	113.81	113.93	113.62	113.888	14746.0
2012-11-27	AIA	ETF	45.68	45.85	45.56	45.57	22280.0
2012-11-27	AIQ	ETF	6.1	6.2	5.9	5.9	1017.0
2012-11-27	AIVI	ETF	39.97	40.01	39.75	39.8	22300.0
2012-11-27	AMJ	ETF	39.13	39.4	39.02	39.36	585729.0
2012-11-27	AMLP	ETF	81.0	81.1	80.7	81.05	348120.0
2012-11-27	ANGL	ETF	26.86	26.93	26.74	26.85	127800.0
2012-11-27	AOA	ETF	36.46	36.56	36.38	36.38	8400.0
2012-11-27	AOK	ETF	30.4	30.47	30.4	30.4356	14319.0
2012-11-27	AOM	ETF	31.53	31.55	31.46	31.49	26235.0
2012-11-27	AOR	ETF	33.48	33.5952	33.45	33.5	31216.0
2012-11-27	ARB	ETF	36.26	36.74	36.21	36.36	86400.0
2012-11-27	ARGT	ETF	15.72	16.0	15.72	16.0	5950.0
2012-11-27	ASEA	ETF	16.64	16.65	16.51	16.58	6900.0
2012-11-27	AWAY	ETF	20.78	21.09	20.545	20.96	331480.0
2012-11-27	BAB	ETF	30.4	30.47	30.37	30.47	124050.0
2012-11-27	BAL	ETF	47.42	47.46	47.16	47.16	18350.0
2012-11-27	BALT	ETF	3.0	3.03	2.91	2.99	50837.0
2012-11-27	BBH	ETF	54.05	54.42	53.83	53.87	19900.0
2012-11-27	BCM	ETF	44.743	44.87	44.68	44.87	2588.0
2012-11-27	BIB	ETF	14.63	14.72	14.3878	14.4875	53348.0
2012-11-27	BICK	ETF	23.73	23.73	23.54	23.54	4266.0
2012-11-27	BIL	ETF	91.62	91.64	91.62	91.62	213150.0
2012-11-27	BIS	ETF	2686.4	2695.2	2664.8	2695.2	94.0
2012-11-27	BIV	ETF	90.27	90.4	90.25	90.4	299200.0
2012-11-27	BJK	ETF	35.23	35.5	35.23	35.5	8000.0
2012-11-27	BKF	ETF	37.96	38.1095	37.64	37.67	76011.0
2012-11-27	BKLN	ETF	24.65	24.66	24.64	24.66	712800.0
2012-11-27	BLV	ETF	97.02	97.19	96.84	97.19	46500.0
2012-11-27	BMVP	ETF	15.8348	15.8348	15.72	15.7267	2477.0
2012-11-27	BND	ETF	84.81	84.92	84.8	84.9	873200.0
2012-11-27	BNO	ETF	40.51	40.51	40.06	40.215	18800.0
2012-11-27	BOIL	ETF	1063000.0	1085200.0	1060000.0	1077200.0	3.8

> showing 50 of 950 rows — these rows as CSV

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